sherwanxUntitled Query
Updated 2022-09-30
9
1
2
3
4
5
6
7
8
›
⌄
SELECT 'Solana' as token,
case when SUCCEEDED='TRUE' then 'SUCCESSFUL TRANSACTIONS ' when SUCCEEDED='FALSE' THEN 'Failed transactions' end as period,
date_trunc('day', BLOCK_TIMESTAMP) AS date,
count(*) as TRANSACTIONS
FROM solana.core.fact_transactions
WHERE BLOCK_TIMESTAMP>=CURRENT_DATE-90
GROUP BY 2,3
Run a query to Download Data