MadiMAU Buyers, Sellers
Updated 2022-09-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH nft_allday AS (
SELECT
date_trunc('month', b.block_timestamp) AS date,
b.NFT_ID as nft_id,
b.BUYER as BUYER,
b.SELLER as SELLER
FROM flow.core.dim_allday_metadata a
LEFT JOIN flow.core.ez_nft_sales b
ON a.NFT_ID = b.NFT_ID
)
SELECT
date,
COUNT(DISTINCT BUYER) as unique_buyers,
COUNT(DISTINCT SELLER) as unique_sellers
FROM nft_allday
GROUP BY date
ORDER BY date ASC
Run a query to Download Data