nickpayiatis_swaps
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select block_timestamp::date as date, swap_program as dex, asset.asset_name as SWAP_FROM_ASSET_NAME, asset2.asset_name as SWAP_TO_ASSET_NAME,
COUNT(
case when swap_from_amount > 0 then 1
else 0
end)
as swaps, sum(swap_from_amount), sum(swap_to_amount)
from algorand.swaps swaps
left join algorand.asset asset on swaps.swap_from_asset_id = asset.asset_id
left join algorand.asset asset2 on swaps.swap_to_asset_id = asset2.asset_id
where
swaps.block_timestamp::Date > '2022-01-01'
group by date, dex, SWAP_FROM_ASSET_NAME, SWAP_TO_ASSET_NAME
Run a query to Download Data