AndyCoolPrice Deep Reaction
Updated 2022-05-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT sum(swap_from_amount) AS volume, count(distinct swapper) AS wallet, count(swap_to_amount) AS count,
date_trunc('day', block_timestamp) as DATE,
(CASE
WHEN swap_from_asset_id = '0' THEN 'algo'
WHEN swap_from_asset_id = '312769' THEN 'usdt'
WHEN swap_from_asset_id = '31566704' THEN 'usdc'
WHEN swap_from_asset_id = '226701642' THEN 'yldy'
WHEN swap_from_asset_id = '386192725' THEN 'goBTC'
WHEN swap_from_asset_id = '386195940' THEN 'goETH'
WHEN swap_from_asset_id = '465865291' THEN 'stbl'
ELSE 'others' END) AS asset
FROM algorand.swaps
WHERE block_timestamp >= '2022-04-01'
AND asset != 'others'
group by asset, DATE
Run a query to Download Data