mz0111easy Q 2
Updated 2023-09-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
DATE_TRUNC('WEEK' , BLOCK_TIMESTAMP) as date,
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",
"unique buyers num" / "unique sellers num" AS "unique buyers num / unique sellers num",
"USD amount" / "sales count" AS "USD amount / sales count",
avg(PRICE_USD) as "AVG Volume",
sum ("USD amount") over (order by date) as "Cumulative USD amount",
sum ("sales count") over (order by date) as "Cumulative sales count",
sum ("unique sellers num") over (order by date) as "Cumulative sellers count",
sum ("unique buyers num") over (order by date) as "Cumulative buyers count"
from ethereum.core.ez_nft_sales
where BLOCK_TIMESTAMP >= current_date - {{period}}
and 1=1
and EVENT_TYPE = 'sale'
group by 1
Run a query to Download Data