sherwanxUntitled Query
    Updated 2022-09-30
    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