barbodhead to head 2
Updated 2022-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with Top10DAI as ( select user_address,
amount_usd,
labels.label as label,
labels.label_type as type
from ethereum.erc20_balances join ethereum.labels
on lower (user_address) = lower (address)
where balance_date = (select max(balance_date) from ethereum.erc20_balances )
and contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f' --DAI
order by 2 desc limit 10
)
select case when label is not null then concat(label , '(type : ',type,' )')
else user_address
end as name ,
amount_usd as amount
from Top10DAI
order by 2 desc
Run a query to Download Data