takamoriSolana Volume by Marketplace
Updated 2023-12-22
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
›
⌄
⌄
select
date(a.block_timestamp) as date,
count(distinct purchaser),
sum(sales_amount) as total,
sum(case when a.marketplace in ('magic eden v2', 'magic eden v1') then sales_amount end) as magic_eden,
sum(case when a.marketplace in ('solanart') then (sales_amount) end) as solanart,
sum(case when a.marketplace in ('tensorswap') then (sales_amount) end) as tensorswap,
sum(case when a.marketplace in ('hadeswap') then (sales_amount) end) as hadeswap,
sum(case when a.marketplace not in ('magic eden v1', 'magic eden v2', 'solanart', 'yawww','tensorswap','hadeswap') then (sales_amount) end) as other,
'below are counts, above are sums',
count(case when a.marketplace in ('magic eden v2', 'magic eden v1') then sales_amount end) as magic_eden_count,
count(case when a.marketplace in ('solanart') then (sales_amount) end) as solanart_count,
count(case when a.marketplace in ('tensorswap') then (sales_amount) end) as tensor_count,
count(case when a.marketplace in ('hadeswap') then (sales_amount) end) as hadeswap_count,
count(case when a.marketplace not in ('magic eden v1', 'magic eden v2', 'solanart', 'yawww','tensorswap','hadeswap') then (sales_amount) end) as other_count,
'below are magic eden share stats',
sum(case when a.marketplace in ('magic eden v2', 'magic eden v1') then sales_amount end)/sum(sales_amount) as Magic_Eden_Share,
count(case when a.marketplace in ('magic eden v2', 'magic eden v1') then sales_amount end)/count(sales_amount) as Magic_Eden_count_share
from solana.nft.fact_nft_sales a
/*inner join solana.core.dim_labels b
on address = mint
where address_name in ('degods')
where SUCCEEDED*/
group by 1
order by 1 desc
QueryRunArchived: QueryRun has been archived