piperBase - NFT sales users
Updated 2023-08-26
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
TO_CHAR(BLOCK_TIMESTAMP, 'YYYY-MM-DD') AS "Date",
COUNT(DISTINCT(seller_address)) AS "Number of Sellers",
COUNT(DISTINCT(buyer_address)) AS "Number of Buyers",
SUM("Number of Sellers") OVER (ORDER BY "Date") AS "Cumulative Number of Sellers",
SUM("Number of Buyers") OVER (ORDER BY "Date") AS "Cumulative Number of Buyers"
FROM
base.nft.ez_nft_sales
WHERE
"Date" >= '2023-08-03' -- opensea starts on base
GROUP BY 1
ORDER BY 1 DESC