Ali3NWhales vs NonWhales
Updated 2022-11-17Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with Maintable as (
select tx_from,
sum (amount) as Volume
from solana.core.fact_transfers t1 join solana.core.dim_labels t2 on t1.tx_to = t2.address
where label != 'solana'
and mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
and label_type not in ('nft','token')
and block_timestamp >= CURRENT_DATE - 93
group by 1)
select case when Volume > 100000 then 'Whales'
else 'Non-Whales' end as type,
count (distinct tx_from)
from Maintable
group by 1
order by 2 desc
Run a query to Download Data