MoDeFiblur part2-1-1
Updated 2022-12-09
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select PLATFORM_NAME, count(*) as sales, sum(ifnull(PRICE_USD,0)) as volume, avg(PRICE_USD) as avg_price,
count(distinct NFT_ADDRESS) as collections, count(distinct NFT_ADDRESS||TOKENID) as nfts, nfts/collections as "NFT Per Collection",
count(distinct SELLER_ADDRESS) as sellers, count(distinct BUYER_ADDRESS) as buyers, sum(PLATFORM_FEE_USD) as PLATFORM_FEE_USD, sum(CREATOR_FEE_USD) as CREATOR_FEE_USD,
avg(PLATFORM_FEE_USD) as "Average Platform Fee", avg(CREATOR_FEE_USD) as "Average Royalty Fee"
from ethereum.core.ez_nft_sales
where BLOCK_TIMESTAMP::date>='{{Starting_Date}}'
group by 1
order by PLATFORM_NAME
Run a query to Download Data