MLDZMNEPA5
Updated 2023-05-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
PROJECT_NAME as NFT_project,
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,
min(PRICE_USD) as floor_price,
max(PRICE_USD) as highest_price
from ethereum.core.ez_nft_sales
where BLOCK_TIMESTAMP>=current_date-30
group by 1 having NFT_project is not NULL
order by 6 desc limit 5
Run a query to Download Data