ArioFTX - Top token inflow
Updated 2022-11-16Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with FTX_address as (
select address from ethereum.core.dim_labels where label = 'ftx'
)
select Top 20 symbol,
sum(AMOUNT_USD) as USD_Volume,
row_number() over(order by usd_volume desc) as rank
from ethereum.core.ez_token_transfers
where 1=1
and BLOCK_TIMESTAMP >= current_date - 10
and AMOUNT_USD is not NULL
and from_address not in (select address from FTX_address) -- Not inner transactions
and to_address in (select address from FTX_address)
group by 1
order by USD_Volume desc
Run a query to Download Data