nitsAlgorand Swap Asset Names
Updated 2022-04-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with top10assets as
(SELECT swap_to_asset_id, sum(swap_from_amount) as total_amt, avg(swap_from_amount) as avg_swap_amount from algorand.swaps
where swap_from_asset_id = '0' and date(block_timestamp) >= '2022-01-01'
GROUP by 1
ORDER by 2 desc
LIMIT 10)
-- SELECT asset_name, total_amt, avg_swap_amount from algorand.asset
-- INNER join top10assets
-- on swap_to_asset_id = asset_id
-- ORDER by total_amt desc
SELECT day, asset_name , total_swaps, cumulative_swaps from
(SELECT date(block_timestamp) as day,swap_to_asset_id, count(*) as total_swaps, sum(total_swaps) over (partition by swap_to_asset_id ORDER by day) as cumulative_swaps
from algorand.swaps
where swap_from_asset_id = '0' and date(block_timestamp) >= '2022-01-01' and swap_to_asset_id in (SELECT swap_to_asset_id from top10assets)
GROUP by 1 , 2 )
inner join algorand.asset
on swap_to_asset_id = asset_id
Run a query to Download Data