nitsWhich DEX's are whales using
Updated 2022-05-21
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with whales as (SELECT * from algorand.account
where balance >= 50000 and closed_at is NULL )
SELECT date(block_timestamp) as day,swap_program, count(DISTINCT swapper) as number_of_wallets_swapping,
avg(number_of_wallets_swapping) over (partition by swap_program order by day) as avg_number_of_wallets_swapping
from algorand.swaps
where block_timestamp >= '2022-04-01'
and swapper in (SELECT address from whales )
GROUP by 1,2
limit 1000
Run a query to Download Data