keshanprimary POEPLE
Updated 2022-11-28
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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