freemartianTop 10 + Avg - mahta
    Updated 2022-04-12
    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