ErsvanF - Genopets Staking - Trends Genopets NFT collection
Updated 2022-06-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
--What trends are you seeing with the Genopets NFT collection?
WITH RECURSIVE w_address_nft (address) AS (
SELECT
flipside_prod_db.solana.dim_labels.address AS address
FROM
flipside_prod_db.solana.dim_labels
WHERE
flipside_prod_db.solana.dim_labels.address_name='genopets token'
AND flipside_prod_db.solana.dim_labels.label='genopets'
GROUP BY flipside_prod_db.solana.dim_labels.address
)
SELECT
DATE_TRUNC('day', block_timestamp) AS DATE_DAY
,COUNT (*) AS Total_sales
FROM
flipside_prod_db.solana.fact_nft_sales
JOIN w_address_nft ON solana.fact_nft_sales.mint = w_address_nft.address
WHERE PROGRAM_ID = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K' OR PROGRAM_ID = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8'
GROUP BY DATE_DAY ORDER BY DATE_DAY
Run a query to Download Data