superflyUntitled Query
Updated 2022-10-17Copy Reference Fork
9
1
2
3
4
5
6
7
8
›
⌄
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