nitsMagiceEden vs Solport
Updated 2022-04-09
9
1
2
3
4
5
6
7
›
⌄
with transactions as (
select block_timestamp, marketplace, tx_id, purchaser, sales_amount from solana.fact_nft_sales where block_timestamp >= '2022-03-12' and marketplace in ('magic eden v2','solport'))
select date(block_timestamp) as date, marketplace, count(distinct tx_id) as sales, count(distinct purchaser) as buyers, sum(sales_amount) as volume
from transactions
group by 1,2
order by 1 asc, 2 desc
Run a query to Download Data