flipside

    Algorand bounty 3 (Q1)
    MrftiAlgorand bounty 3 (Q1)
    Updated 2023-01-03
    select block_timestamp::date as date,
    swap_program, count(*)
    from algorand.swaps
    where block_timestamp::date BETWEEN '2022-03-01' AND '2022-03-31'
    and swap_from_asset_id = 0 and swap_from_amount > 0
    group by date, swap_program
    Run a query to Download Data