Updated 2022-12-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
27
28
29
30
31
32
33
34
35
›
⌄
select
project_name as collection,
date_trunc('month',block_timestamp) as DATE,
sum(sales_amount) as volume,
count(DISTINCT(TX_ID)) as sales_count,
sum(volume) over (partition by collection order by date) as cumulative_volume,
sum(sales_count) over (partition by collection order by date) as cumulative_sales
from solana.core.fact_nft_sales s left join solana.core.dim_nft_metadata m
on s.mint=m.mint
where marketplace='coral cube' and project_name is not null and SUCCEEDED = 'TRUE' and block_timestamp BETWEEN '2022-01-01' and '2022-11-01'
and project_name in
('Trippin',
'Ape Tribe',
'Communi3: Mad Scientists',
'Great Goats',
'Just Ape.',
'Kings of Da Street',
'Bubblegoose Ballers',
'Okay Bears',
'Primates',
'Vandal City',
'Yeah Tigers',
'Contra Chimps',
'Oak Paradise',
'Just Bear',
'Space Warlock',
'Gothic Degens',
'Grimzdao',
'Sengoku Degens',
'Archaic Degens'
)
group by project_name,date
order by date desc
Run a query to Download Data