MLDZMNBNM3
Updated 2023-01-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select --2022-10-19 launch of blur
distinct PROJECT_NAME as NFT_collections,
count(distinct tx_hash) as sale_no,
count(distinct BUYER_ADDRESS) as buyer_no,
count(distinct seller_ADDRESS) as seller_no,
count(distinct TOKENID) as no_NFTs,
sum(PRICE_USD) as volume_usd,
avg(PRICE_USD) as average_volume,
Median(PRICE_USD) as median_volume,
row_number() over (order by volume_usd desc) as rank1
from ethereum.core.ez_nft_sales
where PLATFORM_NAME ='blur'
and PRICE_USD::float > 0
and price>0
and BLOCK_TIMESTAMP>='2022-10-19'
group by 1 having NFT_collections is not NULL
order by 6 desc limit 10
Run a query to Download Data