flipside

    Daily Transactions per Swap Program (Solana) in last month
    angel09-SK3z3aDaily Transactions per Swap Program (Solana) in last month
    Updated 2022-09-19
    select count(distinct TX_ID), SWAP_PROGRAM , date_trunc('day', block_timestamp) as days from solana.core.fact_swaps
    where days > current_date - interval '1 month'
    group by SWAP_PROGRAM,days



    Run a query to Download Data