freemartianTime-Serie Chart - Kimia
Updated 2022-04-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT count(swap_from_amount) AS Daily_number, date_trunc('day', block_timestamp) AS TIME,
(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 ask
FROM algorand.swaps
WHERE swap_from_asset_id = 0
AND block_timestamp >= current_date - 145
AND ask != 'others'
GROUP BY ask, TIME
Run a query to Download Data