freemartianTop 10 + Avg - mahta
Updated 2022-04-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT sum(swap_from_amount) AS algo_amount, sum(swap_from_amount)/count(swap_from_amount) AS average,
(CASE
WHEN swap_to_asset_id = '31566704' THEN 'usdc'
WHEN swap_to_asset_id = '226701642' THEN 'yldy'
WHEN swap_to_asset_id = '470842789' THEN 'defly'
WHEN swap_to_asset_id = '27165954' THEN 'planets'
WHEN swap_to_asset_id = '511484048' THEN 'stke'
WHEN swap_to_asset_id = '137594422' THEN 'hdl'
WHEN swap_to_asset_id = '287867876' THEN 'opul'
WHEN swap_to_asset_id = '523683256' THEN 'akta'
WHEN swap_to_asset_id = '444035862' THEN 'zone'
WHEN swap_to_asset_id = '465865291' THEN 'stbl'
Else 'others'
END) AS asset
FROM algorand.swaps
WHERE swap_from_asset_id = '0'
AND block_timestamp >= '2022-01-01'
GROUP BY asset
ORDER BY algo_amount DESC
LIMIT 10
Run a query to Download Data