msafadoostNew Projects VS Old Projects
Updated 2022-07-18
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
25
26
27
28
29
›
⌄
WITH new_coll AS (
SELECT min(BLOCK_TIMESTAMP) as min_date,
NFT_COLLECTION
FROM flow.core.fact_nft_sales
GROUP by 2
),
newc as (
SELECT NFT_COLLECTION FROM new_coll
WHERE min_date >= CURRENT_DATE -30
),
oldc AS (
SELECT NFT_COLLECTION FROM new_coll
WHERE min_date < CURRENT_DATE -30
)
SELECT COUNT(TX_ID),
'New Projects' as label
FROM flow.core.fact_nft_sales
WHERE NFT_COLLECTION IN (
SELECT NFT_COLLECTION FROM newc
)
AND BLOCK_TIMESTAMP >= CURRENT_DATE - 30
UNION
SELECT COUNT(TX_ID),
'Old Projects' as label
FROM flow.core.fact_nft_sales
WHERE NFT_COLLECTION IN (
SELECT NFT_COLLECTION FROM oldc
)
AND BLOCK_TIMESTAMP >= CURRENT_DATE - 30
Run a query to Download Data