SELECT block_timestamp::date as date, tx_id, nft_id, buyer, seller, price

FROM flow.core.fact_nft_sales

WHERE marketplace IN ('A.c1e4f4f4c4257510.TopShotMarketV3', 'A.c1e4f4f4c4257510.Market') and TX_SUCCEEDED = 'TRUE'

SELECT date, COUNT(DISTINCT tx_id) as "Daily Sales Transactions", SUM("Daily Sales Transactions") OVER (ORDER BY date ASC) as "Total Sales Transactions",

SUM(price) as "Daily Sales Volume (USD)", SUM("Daily Sales Volume (USD)") OVER (ORDER BY date ASC) as "Total Sales Volume (USD)"

FROM tx

WHERE date > '2022-05-09'

GROUP BY 1

ORDER BY 1 DESC