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