superflyUntitled Query
    Updated 2022-10-17
    SELECT trunc (block_timestamp,'day') as date,label,
    case when block_timestamp < '2022-10-11' then 'Previous to hack' else 'After the hack' end as type,
    count(distinct tx_id) as transactions,
    count(distinct INSTRUCTION:accounts[1]) as active_user
    from solana.core.fact_events join solana.core.dim_labels on program_id = address
    WHERE label_type IN ('dex', 'defi') AND block_timestamp >= '2022-09-01'
    GROUP BY 1, 2,3 order by 1 asc

    Run a query to Download Data