rajsOverall Stats
Updated 2023-01-27
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
›
⌄
SELECT
-- *
-- date_trunc('week', block_timestamp) as date,
sum(case when marketplace = 'exchange art' then sales_amount end) as exchange_art_volume,
avg(case when marketplace = 'exchange art' then sales_amount end) as exchange_art_avg_price,
count(case when marketplace = 'exchange art' then tx_id end) as exchange_art_sales_count,
count(distinct case when marketplace = 'exchange art' then purchaser end) as exchange_art_purchaser_count,
count(distinct case when marketplace = 'exchange art' then seller end) as exchange_art_seller_count,
count(distinct case when marketplace = 'exchange art' then mint end) as exchange_art_collection_count,
sum(sales_amount) as volume,
avg(sales_amount) as avg_price,
count(*) as sales_count,
count(distinct purchaser) as purchaser_count,
count(distinct seller) as seller_count,
count(distinct mint) as collection_count,
exchange_art_volume / volume * 100 as volume_share,
exchange_art_avg_price / avg_price * 100 as avg_price_share,
exchange_art_sales_count / sales_count * 100 as sales_count_share,
exchange_art_purchaser_count / purchaser_count * 100 as purchaser_count_share,
exchange_art_seller_count / seller_count * 100 as seller_count_share,
exchange_art_collection_count / collection_count * 100 as collection_count_share
from solana.core.fact_nft_sales
where succeeded
-- and marketplace = 'exchange art'
and block_timestamp >= '2021-11-01'
-- group by 1
-- order by 1
-- limit 3
Run a query to Download Data