shreexComprasions
Updated 2023-03-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
split_part(nft_collection, '.', -1) as nft_collection,
sum(price) as sales_volume,
max(price) as max_sale_price,
min(price) as min_sale_price,
avg(price) as avg_sale_price,
median(price) as median_sale_price,
count(distinct buyer) as unique_buyers,
count(distinct seller) as unique_sellers,
count(tx_id) as total_sales
from flow.core.ez_nft_sales
where nft_collection in ('A.e4cf4bdc1751c65d.AllDay','A.0b2a3299cc857e29.TopShot') and currency='A.ead892083b3e2c6c.DapperUtilityCoin' and block_timestamp>='2022-01-01' and tx_succeeded='TRUE'
GROUP BY nft_collection
ORDER BY sales_volume
Run a query to Download Data