primo_datasolana_nfts
Updated 2023-05-02
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
›
⌄
-- Choose a NFT project from the following list and create a dashboard with the new Flipside dashboard layout that can refresh once a day highlighting at least 4 metrics of
-- your choosing that helps show the "health" of the project. Note any noticeable trends or current events for the project. Highlight how liquidity is flowing in and out of
-- the project and what types of buyers and sellers are interacting with the project.
with md as (
select distinct mint, project_name project
from solana.core.dim_nft_metadata
where project_name in ('Degods','Solana Monkey Business','Shadowy Super Coders','Okay Bears','Degen Ape Academy','Aurory','Cets on Creck',
'Taiyo Robotics','Blocksmith Labs','Famous Fox Federation','Communi3: Mad Scientists','Portals','Primates','Catalina Whales',
'Bubblegoose Ballers','Trippin Ape Tribe','SolGods','Stoned Ape Crew','Boryoku Dragonz','Galactic Geckos','Atadians',
'Thugbirdz','Pesky Penguins','Genopets','Nyan Heroes')
),
sales as (
select date(s.block_timestamp) as dt
,md.project
,count(distinct s.purchaser) as total_purchasers_cts
,count(distinct s.seller) as total_seller_cts
,count(distinct s.tx_id) as total_sale_txns
,sum(s.sales_amount) as total_sale_volume_sol
,sum(s.sales_amount * cast({{Comission_Rate}} as float)) as total_commission_volume_sol
,median(s.sales_amount) as median_sale_price_sol
,sum(total_commission_volume_sol) over (order by dt asc) as cum_comission_txns
from solana.core.fact_nft_sales s
inner join md
on s.mint = md.mint
group by 1,2
),
minter_sellers as (
select date(s.block_timestamp) as dt
,md.project
,count(distinct mp.minter) minter_sellers_ct
,count(distinct s.seller) total_sellers_ct
from solana.core.fact_nft_sales s
inner join md
on s.mint = md.mint
left join
Run a query to Download Data