PapasotAlgorand sales dex volume
    Updated 2023-01-03
    select
    date_trunc('day',block_timestamp) as date,
    swap_program as Dex,
    --count(distinct(swapper)) as Swapppers
    sum(swap_from_amount) as Algo_sales
    from algorand.swaps


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