drone-mostafaAlgorand Daily Swap
    Updated 2022-06-12
    select
    date_trunc('day', block_timestamp) as date,
    swap_program as Dexs,
    count(SWAP_TO_AMOUNT) as swaps
    from algorand.swaps
    where swap_program in ('algofi','pactfi','tinyman')
    and swap_from_amount > 0
    AND date>= '2022-02-09' and date <'2022-06-09'
    group by date, Dexs






    Run a query to Download Data