keshanCopy of Redeemers in Top 100 Contributors
Updated 2022-01-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
/*select count(distinct from_address) as count
from ethereum.udm_events
where contract_address = '0x7a58c0be72be218b41c608b7fe7c5bb630736c71'
and to_address = '0x0000000000000000000000000000000000000000'
and event_name = 'transfer'
and from_address in
(select distinct 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'
limit 100) */
select DISTINCT to_address_name from ethereum.udm_events
Run a query to Download Data