mohamadreza221166Compare Daily Nft Sales on Genopets vs StepN
Updated 2022-07-14
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
›
⌄
-- SELECT * FROM solana.core.dim_labels WHERE label_type = 'nft' AND lower(LABEL) like 'genopets' limit 100
-- SELECT * FROM solana.core.dim_labels WHERE label_type = 'nft' AND lower(LABEL) like 'stepn' limit 100
WITH swaps AS(
SELECT BLOCK_TIMESTAMP, 'StepN' AS project, SALES_AMOUNT
FROM solana.core.fact_nft_sales mnt
JOIN solana.core.dim_labels lb ON lb.ADDRESS = mnt.MINT
WHERE label_type = 'nft'
AND lower(LABEL) like '%stepn%'
-- AND BLOCK_TIMESTAMP::DATE >= '2022-01-01'
UNION
SELECT BLOCK_TIMESTAMP, 'Genopets' AS project, SALES_AMOUNT
FROM solana.core.fact_nft_sales mnt
JOIN solana.core.dim_labels lb ON lb.ADDRESS = mnt.MINT
WHERE label_type = 'nft'
AND lower(LABEL) like '%genopets%'
-- AND BLOCK_TIMESTAMP::DATE >= '2022-01-01'
)
SELECT date_trunc('day', BLOCK_TIMESTAMP) as days, project, sum(SALES_AMOUNT) SALES_AMOUNT
FROM swaps
GROUP BY days, project
Run a query to Download Data