0-MIDwhale and ordinary
Updated 2023-05-06
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select BLOCK_TIMESTAMP::date as date
,case
when AMOUNT_OUT_USD>10000 then 'Whales' else 'ordinary' end as buyer_type
,count(distinct ORIGIN_FROM_ADDRESS) as buyers
from ethereum.core.ez_dex_swaps
where date>='2023-04-17'
and TOKEN_OUT='0x6982508145454ce325ddbe47a25d4ec3d2311933'
and AMOUNT_OUT_USD is not null
and buyer_type is not null
group by 1,2
order by 3 desc
Run a query to Download Data