freemartianComparing Stats
    Updated 2022-04-06
    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