mehdimarjanHyperspace Transactions Status
    Updated 2022-10-31
    SELECT block_timestamp::date AS DAY,
    (CASE
    WHEN succeeded = 'false' THEN 'Failed'
    WHEN succeeded = 'true' THEN 'Successful'
    END) AS status,
    COUNT(tx_id) AS number_of_tx
    FROM solana.core.fact_nft_sales
    WHERE marketplace = 'hyperspace'
    GROUP BY 1,2
    ORDER BY 1