mondov2023-06-02 10:59 PM
Updated 2023-06-02
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
›
⌄
with sales as (
SELECT marketplace, date_trunc('day', block_timestamp) as day, purchaser, seller, mint, sales_amount
FROM solana.core.fact_nft_sales
WHERE mint in (SELECT address
FROM solana.core.dim_labels
WHERE label = 'mad lads') AND succeeded = TRUE
AND sales_amount IS NOT NULL)
SELECT
day,
COUNT(*) AS "Number of Sales",
COUNT(DISTINCT sales.purchaser) AS "Number of Buyers"
FROM
sales
INNER JOIN solana.core.dim_labels labels ON sales.mint = labels.address
WHERE labels.label = 'mad lads'
AND sales.sales_amount IS NOT NULL
GROUP BY day
ORDER BY day ASC
Run a query to Download Data