KaskoazulSolport vs Magic Eden
    Updated 2022-04-04
    with SOLPORT as (
    select block_timestamp::date as fecha,
    sum(sales_amount) as total_sales,
    sum(total_sales) over (order by fecha) as cum_sales,
    count(distinct purchaser) as unique_buyers,
    sum(unique_buyers) over (order by fecha) as cum_buyers
    from solana.fact_nft_sales
    where program_id = 'SPf5WqNywtPrRXSU5enq5z9bPPhREaSYf2LhN5fUxcj'
    and succeeded = 'TRUE'
    and fecha >= '2022-03-12'
    and fecha < CURRENT_DATE - 1
    group by 1
    ),

    MAGIC_EDEN as (
    select block_timestamp::date as fecha,
    sum(sales_amount) as total_sales,
    count(distinct purchaser) as unique_buyers,
    sum(unique_buyers) over (order by fecha) as cum_buyers
    from solana.fact_nft_sales
    where program_id = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K'
    and succeeded = 'TRUE'
    and fecha >= '2022-03-12'
    and fecha < CURRENT_DATE - 1
    group by 1
    )
    select SOLPORT.fecha,
    SOLPORT.total_sales as Solport,
    SOLPORT.cum_sales as Solport_volume,
    SOLPORT.unique_buyers as SP_buyers,
    SOLPORT.cum_buyers as SP_cum_buyers,
    MAGIC_EDEN.total_sales as Magic_Eden,
    MAGIC_EDEN.unique_buyers as ME_buyers,
    MAGIC_EDEN.cum_buyers as ME_cum_buyers
    from SOLPORT
    Run a query to Download Data