mlhRaceDay NFTs1 monthly
Updated 2022-10-22
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT date_trunc('month', block_timestamp) as month,
sum(price) as volume,
avg(price) as avg_price,
median(price) as median_price,
count(DISTINCT tx_id) as sales,
count(DISTINCT buyer) as buyers,
(sum(price))/(count(DISTINCT buyer)) as avg_vol_per_buyer
FROM flow.core.ez_nft_sales
WHERE NFT_COLLECTION LIKE '%RaceDay%'
GROUP BY 1
Run a query to Download Data