PapasotgAlgo3 daily swaps
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
›
⌄
-- Show the number of trades to gALGO3 and from gALGO3 by day? Also chart the volume of trades to gALGO3 and from gALGO3 by day?
-- What DEXes are users swapping gALGO3 on? Show the breakout of number of gALGO3 swaps(to or from) by day for each dex.
select
date_trunc('day',block_timestamp) as block_day,
count(swap_from_asset_id) as Swaps_from_gAlgo3,
sum(swap_from_amount) as Swaps_from_gAlgo3_volume,
count(swap_to_asset_id) as Swaps_to_gAlgo3,
sum(swap_to_amount) as Swaps_to_gAlgo3_volume,
swap_program
from algorand.swaps
where block_timestamp >= '2022-01-01' AND
(swap_to_asset_id = 694432641 OR
swap_from_asset_id = 694432641)
group by block_day, swap_program
order by block_day
Run a query to Download Data