mz0111NFT sales
Updated 2022-10-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
BLOCK_TIMESTAMP:: date as date,
case
when block_number < '15537351' then 'Pre-Merge'
when block_number >= '15537351' then 'Post-Merge'
end as "Period",
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",
sum ("USD amount") over (order by block_timestamp :: date) as "Cumulative USD amount",
sum ("sales count") over (order by block_timestamp :: date) as "Cumulative sales count"
from ethereum.core.ez_nft_sales
where BLOCK_TIMESTAMP >= CURRENT_DATE-34
and EVENT_TYPE = 'sale'
group by 1 , 2
Run a query to Download Data