PapasotgAlgo3 daily swaps
    Updated 2023-01-03
    -- Show the number of trades to gALGO3 and from gALGO3 by day? Also chart the volume of trades to gALGO3 and from gALGO3 by day?
    -- What DEXes are users swapping gALGO3 on? Show the breakout of number of gALGO3 swaps(to or from) by day for each dex.

    select
    date_trunc('day',block_timestamp) as block_day,
    count(swap_from_asset_id) as Swaps_from_gAlgo3,
    sum(swap_from_amount) as Swaps_from_gAlgo3_volume,
    count(swap_to_asset_id) as Swaps_to_gAlgo3,
    sum(swap_to_amount) as Swaps_to_gAlgo3_volume,
    swap_program
    from algorand.swaps

    where block_timestamp >= '2022-01-01' AND
    (swap_to_asset_id = 694432641 OR
    swap_from_asset_id = 694432641)
    group by block_day, swap_program
    order by block_day

    Run a query to Download Data