amirozapactfi swaps
    Updated 2022-07-06
    with DEX_swaps as (
    select date_trunc('day',block_timestamp) date,count(*) pactfi_count
    from Algorand.Swaps
    where date >='2022-01-01 00:00:00.000'
    and lower(swap_program)='pactfi'
    and swap_from_amount> 0
    group by 1
    )
    select *
    from DEX_swaps t1
    Run a query to Download Data