Select date_trunc('day',block_timestamp),
Count (tx_id) as transactions,
SUM(Price) as FlowToken,
NFT_COLLECTION
From flow.core.fact_nft_sales
WHERE NFT_COLLECTION ILIKE'A.0b2a3299cc857e29.TopShot'
AND TX_SUCCEEDED = 'true'
AND BLOCK_TIMESTAMP BETWEEN '2022-05-01' AND '2022-06-01'
AND CURRENCY ILIKE 'A.1654653399040a61.FlowToken'
GROUP BY 1,4