PapasotAlgorand purchases dex volume
    Updated 2023-01-02
    select
    date_trunc('day',block_timestamp) as date,
    swap_program as Dex,
    --count(distinct(swapper)) as Swapppers
    sum(swap_to_amount) as Algo_buys
    from algorand.swaps


    where
    date >= '2022-04-01' AND
    swap_program != 'wagmiswap'
    AND
    swap_to_asset_id = 0
    group by date,swap_program
    order by date
    Run a query to Download Data