2844SOL opensea vs magic eden
    Updated 2022-04-14
    select marketplace, count(purchaser) as N_sales, sum(sales_amount) as V_sales_sol, count(distinct purchaser) as N_buyers
    from Solana.fact_nft_sales
    where marketplace like 'magic%'
    and block_timestamp >= '2022-04-06'
    and SUCCEEDED = 'TRUE'
    group by marketplace
    UNION

    select 'Opensea' as Marketplace,
    count(INNER_INSTRUCTIONS[0]:instructions[0]:parsed:info:source) as N_sales,
    count(distinct INNER_INSTRUCTIONS[0]:instructions[0]:parsed:info:source) as N_buyers,
    sum(INNER_INSTRUCTIONS[0]:instructions[0]:parsed:info:lamports / pow(10,9)) as V_sales_sol
    FROM solana.fact_transactions
    where INSTRUCTIONS[0]:programId = 'hausS13jsjafwWwGqZTUQRmWyvyxn9EQpqMwV1PBBmk'
    and block_timestamp >= '2022-04-06'
    and instructions[0]:accounts[0] = inner_instructions[0]:instructions[0]:parsed:info:source
    group by marketplace
    Run a query to Download Data