count(DISTINCT tx_id) as total_transaction,

count(DISTINCT buyer) as total_buyer,

count(DISTINCT seller) as total_seller,

sum(price) as volume,

avg(price) as avg_price

FROM flow.core.ez_nft_sales

WHERE NFT_COLLECTION LIKE '%RaceDay%'

and block_timestamp::date >= CURRENT_DATE - 90