drone-mostafaEasy 2 NFT
Updated 2023-05-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
SELECT
PROJECT_NAME as PLATFORM_NAME,
--date_trunc ('week',BLOCK_TIMESTAMP) as date,
count (DISTINCT TX_HASH) as TXN,
count (DISTINCT BUYER_ADDRESS) as Buyer,
count (DISTINCT SELLER_ADDRESS) as Seller,
sum (PRICE_USD) as USD,
avg (PRICE_USD) as AVG_USD,
Median (PRICE_USD) as Median_USD,
sum (TOTAL_FEES_USD) as Total_fee,
sum (CREATOR_FEE_USD) as Creator_fee,
sum (PLATFORM_FEE_USD) as Platform_fee
FROM ethereum.core.ez_nft_sales
WHERE EVENT_TYPE = 'sale'
and BLOCK_TIMESTAMP >= current_date -30
and PROJECT_NAME IS NOT NULL
GROUP BY 1 ORDER BY TXN DESC limit 5
Run a query to Download Data