2844number of gALGO3 swaps from for each DEX
    Updated 2022-04-29

    select date_trunc('day',block_timestamp) as DATE2, count (swap_from_asset_id) as "pactfi"
    from algorand.swaps
    where swap_from_asset_id = '694432641'
    AND SWAP_PROGRAM LIKE 'pact%'
    and block_timestamp >= '2022-01-01'
    group by DATE2
    order by date2 desc


    Run a query to Download Data