LTirrellSolana Swaps DEFI copy
    Updated 2024-01-15

    select
    date(block_timestamp) as date,
    swap_program,
    count(distinct tx_id) as daily_txs,
    count(distinct swapper) as swapper
    from solana.defi.fact_swaps
    where
    date between current_date()-60 and current_date()-1
    and succeeded = 'TRUE'
    group by 1,2
    QueryRunArchived: QueryRun has been archived