freemartianUntitled Query
Updated 2022-04-14
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT sum(swap_from_amount) AS weekly_number, date_trunc('day', block_timestamp) AS DATE,
(CASE
WHEN swap_to_asset_id = '444035862' THEN 'zone'
Else 'others'
END) AS asset
FROM algorand.swaps
WHERE swap_from_asset_id = '0'
AND block_timestamp >= '2022-01-01'
AND asset != 'others'
GROUP BY asset, DATE
Run a query to Download Data