Try Quests to earn crypto2023-08-22 01:52 AM
SELECT marketplace, block_timestamp::date AS date, COUNT(1) AS n_sales FROM solana.core.fact_nft_sales WHERE block_timestamp::date >= CURRENT_DATE - 30 GROUP BY 1, 2
SELECT marketplace, block_timestamp::date AS date, COUNT(1) AS n_sales FROM solana.core.fact_nft_sales WHERE block_timestamp::date >= CURRENT_DATE - 30 GROUP BY 1, 2