2844algofi swaps in 2022
    Updated 2022-03-20
    select
    date_trunc('day', block_timestamp) as day,
    count(*) as algofi_swaps
    from algorand.swaps
    WHERE date_trunc('day', block_timestamp) >= '2022-01-01'
    AND swap_program ILIKE '%algofi%'
    and swap_from_amount > 0
    group by day
    ORDER BY day DESC;
    Run a query to Download Data