mehrancrypto-dxoepqBlur 1
Updated 2022-12-07
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT BLOCK_TIMESTAMP::date as daily , PLATFORM_NAME , COUNT(DISTINCT tx_hash) as number ,
sum( PRICE_USD) as USD , sum( PLATFORM_FEE_USD) as PLATFORM_FEE_USD_total ,
sum( CREATOR_FEE_USD) as CREATOR_FEE_USD_total ,
100*CREATOR_FEE_USD_total/USD as CREATOR_FEE_percent, 100*PLATFORM_FEE_USD_total/USD as PLATFORM_FEE_percent ,
count(DISTINCT BUYER_ADDRESS) as users
from ethereum.core.ez_nft_sales
where daily > '2022-10-15'
and EVENT_TYPE = 'sale'
GROUP by 1 ,2
Run a query to Download Data