mz0111nft data
Updated 2022-09-29
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
25
26
27
›
⌄
SELECT
days,
case when days >= '2022-08-31' and days < '2022-09-15' then '15 days before Merge'
else '15 days after Merge'
end as "period",
"number of unique sellers count",
"number of unique buyers count",
"number of nft sales",
"ETH volume"
from
(select
block_timestamp::date as days,
count (distinct SELLER_ADDRESS ) as "number of unique sellers count",
count (distinct BUYER_ADDRESS ) as "number of unique buyers count",
count (distinct tx_hash) as "number of nft sales",
sum(PRICE) as "ETH volume"
from ethereum.core.ez_nft_sales
where block_timestamp::date > '2022-08-30'
and CURRENCY_SYMBOL = 'ETH'
group by 1
)
group by 1 , 2 , 3 , 4 , 5 , 6
order by 1
Run a query to Download Data