KaskoazulTaiyo Robotics - Solport vs Magic Eden
    Updated 2022-04-04
    select block_timestamp::date as fecha,
    marketplace,
    sum(sales_amount) as daily_sales,
    sum(daily_sales) over (partition by marketplace order by fecha) as cum_sales,
    count(distinct purchaser) as u_buyers,
    sum(u_buyers) over (partition by marketplace order by fecha) as cum_buyers
    from solana.dim_nft_metadata nm
    inner join solana.fact_nft_sales ns
    on ns.mint = nm.mint
    where project_name = 'Taiyo Robotics'
    and succeeded = 'TRUE'
    and program_id in ('SPf5WqNywtPrRXSU5enq5z9bPPhREaSYf2LhN5fUxcj', 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
    and fecha >= '2022-03-22'
    and fecha < CURRENT_DATE - 1
    group by 1,2
    order by 1
    Run a query to Download Data