freemartianComparing Stats
Updated 2022-04-06
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT sum(swap_to_amount) AS volume, COUNT(swapper) AS number_transaction, date_trunc('month', block_timestamp::date) AS DATE,
(CASE
WHEN swap_to_asset_id = '31566704' THEN 'USDC'
WHEN swap_to_asset_id = '312769' THEN 'USDT'
WHEN swap_to_asset_id = '465865291' THEN 'STBL'
END) AS stable_coin
FROM algorand.swaps
WHERE swap_to_asset_id IN ('31566704','312769', '465865291')
AND DATE >= '2022-03-01' AND DATE <= '2022-03-31'
GROUP BY stable_coin, DATE
Run a query to Download Data