keshanprimary POEPLE
    Updated 2022-11-28
    select to_address as address, sum(amount) as amount_primary, sum(usd_value) as usd_primary
    from
    (select to_address, amount,
    case
    when amount_usd is null then (0.00436 * amount)
    else amount_usd
    end as usd_value
    from ethereum.udm_events
    where contract_address = '0x7a58c0be72be218b41c608b7fe7c5bb630736c71'
    and from_address = '0x0000000000000000000000000000000000000000'
    and event_name = 'transfer')
    group by 1
    Run a query to Download Data