PapasotAlgo whales swap into 2022
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
With whales AS
(select address,balance,wallet_type
from algorand.account
where balance > '100000'
order by balance DESC)
SELECT
date_trunc('day',block_timestamp) as block_day,
swap_to_asset_id as ASA,
asset_name as ASA_name,
count(swap_to_asset_id) as swaps
FROM algorand.swaps
LEFT JOIN whales ON swapper = whales.address
left join algorand.asset b on b.asset_id = swap_to_asset_id
WHERE block_day >= '2022-01-01' AND
whales.balance > '100000'
GROUP BY block_day, swap_to_asset_id,asset_name
ORDER BY block_day
Run a query to Download Data