shadilSolport vs. Magic Eden - Taiyo Robotics
    Updated 2022-04-03
    with ogs as (
    select contract_address from solana.dim_nft_metadata
    where project_name = 'Taiyo Robotics'
    ),
    magic_eden AS (
    SELECT
    date(block_timestamp) as date,
    sum(sales_amount) as total_sales,
    COUNT(DISTINCT purchaser) as total_purchasers,
    'Magic Eden' as type
    FROM solana.fact_nft_sales
    WHERE date(block_timestamp) BETWEEN '2022-03-12' and CURRENT_DATE - 2
    and(program_id = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K'
    or program_id = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8')
    and succeeded = 'TRUE'
    and mint::string in (SELECT * from ogs)

    GROUP by date
    ),
    solport AS (
    SELECT
    date(block_timestamp) as date,
    sum(sales_amount) as total_sales,
    COUNT(DISTINCT purchaser) as total_purchasers,
    'Solport' as type

    FROM solana.fact_nft_sales
    WHERE date(block_timestamp) BETWEEN '2022-03-12' and CURRENT_DATE - 2
    and program_id = 'SPf5WqNywtPrRXSU5enq5z9bPPhREaSYf2LhN5fUxcj'
    and succeeded = 'TRUE'
    and mint::string in (SELECT * from ogs)
    GROUP by date
    )

    SELECT * FROM magic_eden
    Run a query to Download Data