SleepyTop 10 tokens of total inflow volume
Updated 2023-04-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with cex_address as
(
select address, project_name from avalanche.core.dim_labels
where label_type='cex'
and label_subtype = 'deposit_wallet'
)
--inflow token volume
select
contract_address,
symbol,
count(distinct tx_hash) total_tx,
sum(coalesce(amount_usd, 0)) inflow_token_volume,
median(amount_usd) median_inflow_transfer
from avalanche.core.ez_token_transfers transfers
join cex_address
on transfers.to_address = cex_address.address
where block_timestamp::date >= current_date - 365
and amount_usd > 0
group by contract_address, symbol
order by inflow_token_volume desc
limit 10
Run a query to Download Data