AndyCoolPrice Deep Reaction
    Updated 2022-05-18
    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