nitsMagiceEden vs Solport
    Updated 2022-04-09
    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