winnie-fsSales Trending copy
Updated 2023-03-03
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
30
31
32
33
34
35
36
›
⌄
-- forked from 69e9f080-bdd0-4d57-b955-398ed7dca83c
-- Collection token lists CTE
WITH
collection_tokens AS (
SELECT DISTINCT
mint
FROM
SOLANA.CORE.DIM_NFT_METADATA
WHERE
PROJECT_NAME IN ('GGSG: Galactic Geckos', 'Galactic Geckos')
),
-- Sales CTE
sales AS (
SELECT
a.sales_amount,
a.marketplace,
a.block_timestamp,
b.mint
FROM
solana.core.fact_nft_sales a
inner join collection_tokens b on a.mint = b.mint
WHERE
block_timestamp >= DATEADD(day, - {{days}}, CURRENT_DATE)
AND succeeded
)
-- Main Query
SELECT
TO_DATE(block_timestamp) AS day,
ROUND(max(sales_amount), 0) as max_sale,
ROUND(min(sales_amount), 0) as min_sale,
ROUND(avg(sales_amount), 0) as avg_sale,
ROUND(median(sales_amount), 0) as mdn_sale,
COUNT(a.mint) as sales_count
from
collection_tokens a
Run a query to Download Data