bachiUntitled Query
Updated 2022-04-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select day, type_swap, sum(swap_VOLUME_USD), avg(swap_VOLUME_USD), count(*) from (
select date(BLOCK_TIMESTAMP) AS day,
CASE WHEN SWAP_FROM_ASSET_ID =312769 OR SWAP_TO_ASSET_ID =312769 THEN 'USDT'
WHEN SWAP_FROM_ASSET_ID =31566704 OR SWAP_TO_ASSET_ID =31566704 THEN 'USDC'
WHEN SWAP_FROM_ASSET_ID =465865291 OR SWAP_TO_ASSET_ID =465865291 THEN 'STBL'
END as type_swap,
CASE WHEN SWAP_FROM_ASSET_ID IN (312769,31566704,465865291) THEN SWAP_FROM_AMOUNT
WHEN SWAP_TO_ASSET_ID IN (312769,31566704,465865291) THEN SWAP_TO_AMOUNT
END AS swap_VOLUME_USD
from algorand.swaps
where (SWAP_FROM_ASSET_ID IN (312769,31566704,465865291) OR SWAP_TO_ASSET_ID IN (312769,31566704,465865291))
--and block_timestamp >= '2022-03-01' and block_timestamp < '2022-03-31'
) group by day, type_Swap
Run a query to Download Data