itsxenuxTrades count of Magic Eden
    Updated 2022-05-04
    with query_table1 as
    (select solana.fact_events.instruction:parsed:info:mint
    as mint
    from solana.fact_events
    join solana.fact_transfers
    on solana.fact_transfers.tx_id = solana.fact_events.tx_id
    where solana.fact_events.instruction:programId = 'TokenkegQfeZyiNwAJbNbGKPFXCWuBvf9Ss623VQ5DA'
    and solana.fact_transfers.index = 1
    and solana.fact_events.index = 3
    and solana.fact_transfers.mint = 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey'
    and solana.fact_events.block_timestamp::date >= '2022-04-04')
    select count(distinct tx_id)
    as total_sales,
    block_timestamp::date
    as date_time
    from solana.fact_nft_sales
    join query_table1
    where fact_nft_sales.block_timestamp >= '2022-04-04'
    and fact_nft_sales.mint = query_table1.mint
    and fact_nft_sales.succeeded = 'true'
    and fact_nft_sales.marketplace like 'magic%'
    group by date_time
    order by date_time
    Run a query to Download Data