ATTRIBUTE | MAX_SALE | MIN_SALE | AVG_SALE | MDN_SALE | NUM_SALES | RK | LABEL | |
|---|---|---|---|---|---|---|---|---|
1 | Skull | 212.4 | 87 | 155.3 | 166.4 | 3 | 1 | 01. Skull |
2 | Light | 100 | 41.9 | 59.3 | 54.2 | 1047 | 4 | 04. Light |
3 | Galaxy | 100.4 | 51.5 | 72.3 | 72.5 | 28 | 2 | 02. Galaxy |
4 | Android | 111 | 45 | 58.2 | 54.2 | 182 | 3 | 03. Android |
5 | Dark | 95.1 | 41.3 | 59 | 54 | 617 | 5 | 05. Dark |
Flipside CommunitySales by Trait
Updated 2025-04-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
›
⌄
-- Collection token lists CTE
WITH collection_tokens AS (
SELECT DISTINCT
mint,
metadata[1]:value::string as type
FROM
solana.nft.dim_nft_metadata
WHERE
(nft_collection_name like 'Mad Lads%'
or nft_name like 'Mad Lads%')
and type in ('Dark','Light','Android','Galaxy','Skull')
), sales AS (
SELECT
a.sales_amount,
a.marketplace,
a.mint
FROM
solana.nft.fact_nft_sales a
inner join collection_tokens b on a.mint = b.mint
WHERE
block_timestamp >= DATEADD(day, - 90 , CURRENT_DATE)
AND succeeded
), summary AS (
SELECT
type as Attribute,
ROUND(max(sales_amount),1) as max_sale,
ROUND(min(sales_amount),1) as min_sale,
ROUND(avg(sales_amount),1) as avg_sale,
ROUND(median(sales_amount),1) as mdn_sale,
COUNT(a.mint) as num_sales
from
collection_tokens a
inner join sales b on a.mint = b.mint
GROUP BY 1
)
Last run: 23 days ago
5
237B
16s