mz0111easy Q 1
Updated 2023-09-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
'ETH' as name,
count( distinct TX_HASH) as "sales count",
count(distinct SELLER_ADDRESS ) as "unique sellers num",
count(distinct BUYER_ADDRESS ) as "unique buyers num",
sum(PRICE_USD) as "USD amount",
count( TX_HASH) /DATEDIFF(day, '2023-04-07', CURRENT_DATE) AS "AVG TX COUNT/DAY",
count(DISTINCT BUYER_ADDRESS) / DATEDIFF(day, '2023-04-07', CURRENT_DATE) AS "AVG Unique buyer/DAY",
count(DISTINCT SELLER_ADDRESS)/ DATEDIFF(day, '2023-04-07', CURRENT_DATE) AS "AVG Unique seller/DAY",
sum(PRICE_USD) / DATEDIFF(day, '2023-04-07', CURRENT_DATE) AS "AVG USD Sales amount/DAY",
"unique buyers num" / "unique sellers num" AS "unique buyers num / unique sellers num",
"USD amount" / "sales count" AS "USD amount / sales count"
from ethereum.core.ez_nft_sales
where BLOCK_TIMESTAMP >= current_date - {{period}}
and 1=1
and EVENT_TYPE = 'sale'
Run a query to Download Data