Hadisehtop volume 30
Updated 2022-08-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with t1 as ( select address
from ethereum.core.dim_labels
where label like '%tornado%')
,
t2 as ( select address, amount_usd
from ethereum.core.ez_eth_transfers a join t1 b on a.ETH_TO_ADDRESS = b.address
where block_timestamp::date >= CURRENT_DATE - 30
UNION
select
address,amount_usd
from ethereum.core.ez_token_transfers a join t1 b on a.TO_ADDRESS = b.address
where block_timestamp::date >= CURRENT_DATE - 30
)
select address , sum(amount_usd) as usd_volume
from t2
where amount_usd is not null
group by 1
order by 2 desc
limit 5
Run a query to Download Data