MilesFinchUntitled Query
Updated 2022-05-24
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
secondary_sales as (
SELECT
block_timestamp::date as date,
n.mint,
m.label
FROM flipside_prod_db.solana.fact_nft_sales n
LEFT OUTER JOIN flipside_prod_db.solana.dim_labels m ON n.mint = m.address
WHERE (program_ID = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K' or program_ID = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8')
and SUCCEEDED = 'TRUE'
),
mind as (
SELECT
label,
min(date) as min_date
FROM secondary_sales
GROUP BY 1
)
SELECT min_date, COUNT(DISTINCT label) as new_collections
from mind
WHERE min_date >= '2022-01-01'
GROUP BY 1
Run a query to Download Data