superflyUntitled Query
    Updated 2022-11-21
    select
    date_trunc('day', w.block_timestamp) as day,
    initcap(label) as program,
    count(distinct(w.tx_id)) as number_of_transactions,
    count(distinct(swapper)) as number_of_users
    from solana.core.fact_events w join solana.core.dim_labels m on w.program_id = m.address
    join solana.core.fact_swaps q on w.tx_id = q.tx_id
    where w.block_timestamp >= '2022-10-01'
    and w.succeeded = 'TRUE'
    and label_type IN ('defi','dex')
    group by 1,2
    order by 1 desc
    Run a query to Download Data