mooolmUntitled Query
Updated 2022-12-09
9
1
2
3
4
5
6
7
8
›
⌄
SELECT COUNT(events.tx_id) as transaction_count, labels.label_type
FROM solana.core.fact_events events
JOIN solana.core.dim_labels labels
ON events.PROGRAM_ID = labels.address
WHERE events.block_timestamp >= CURRENT_DATE - INTERVAL '1 week'
GROUP BY labels.label_type
ORDER BY transaction_count DESC
LIMIT 5
Run a query to Download Data