mucryptoEthereum, top 100 holdings
Updated 2023-04-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with addresses as (select
distinct user_address,
sum(current_bal) as balance
from ethereum.core.ez_balance_deltas
where block_timestamp::date = current_date
and symbol = 'ETH'
and token_name = 'Native Ether'
group by 1),
label as (select
distinct label,
address
from ethereum.core.dim_labels)
select
addresses.user_address,
addresses.balance,
label.label
from addresses
join label
on addresses.user_address = label.address
order by addresses.balance desc
limit 100
Run a query to Download Data