iboo-jbj2MVopen sea vs magic eden sale amount
    Updated 2022-04-17
    with os as(
    select
    'OpenSea' as marketplace,
    sum(INNER_INSTRUCTION:instructions[0]:parsed:info:lamports/pow(10,9)) as volume,
    count(distinct INNER_INSTRUCTION:instructions[0]:parsed:info:source) as users
    from solana.fact_events where INSTRUCTION:programId='hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk' -- opensea on Solana
    and block_timestamp>='2022-04-06'
    and index=0
    ),

    me as (select
    'Magic Eden' as marketplace,
    sum(sales_amount) as volume,
    count(distinct purchaser) as users
    from solana.fact_nft_sales where MARKETPLACE='magic eden v2' ---magic eden
    and block_timestamp>='2022-04-06'
    and SUCCEEDED='TRUE'
    )

    select * from os
    union all
    select * from me
    Run a query to Download Data