MLDZMNmp.8
Updated 2022-09-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
case
when
INNER_INSTRUCTIONS[1]:instructions[0]:parsed:info:lamports/pow(10, 9)
+INNER_INSTRUCTIONS[1]:instructions[1]:parsed:info:lamports/pow(10, 9)
+INNER_INSTRUCTIONS[1]:instructions[2]:parsed:info:lamports/pow(10, 9) = s.sales_amount then 'With Royalty fee'
else 'Without Royalty fee'
end as gp,
count(distinct purchaser) as buyers,
count(s.tx_id) as no_sale,
sum(sales_amount) as volume
from solana.core.fact_nft_sales s left join solana.core.fact_transactions b on s.tx_id=b.tx_id
where MARKETPLACE ilike '%solanart%' and s.BLOCK_TIMESTAMP>='2022-07-01'
group by 1
Run a query to Download Data