PapasotAlgo whales swaps
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
With whales AS
(select address,balance,wallet_type
from algorand.account
where balance > '10000000'
order by balance DESC)
SELECT
date_trunc('day',block_timestamp) as block_day,
swap_to_asset_id as ASA_id,
count(swap_to_asset_id) as Swaps
FROM algorand.swaps
LEFT JOIN whales ON swapper = whales.address
WHERE block_timestamp >= '2022-01-01'
GROUP BY block_day,ASA_id
ORDER BY 1
Run a query to Download Data