flipside

    Unique Swapper Address Per Month
    0xaimanUnique Swapper Address Per Month
    Updated 2023-01-02
    select date_trunc('month',BLOCK_TIMESTAMP) as month, swap_program, count(distinct SWAPPER) as n_swapper, count(distinct TX_GROUP_ID) as n_Swap_txn from algorand.defi.fact_swap
    where block_timestamp>='2020-01-01'
    group by 1,2 order by 1
    limit 1000
    Run a query to Download Data