flipside

    Magic Eden : Number of sales of each project
    headitmanagerMagic Eden : Number of sales of each project
    Updated 2022-05-17
    select count(*),PROJECT_NAME from solana.fact_nft_sales inner join solana.dim_nft_metadata
    on solana.fact_nft_sales.mint=solana.dim_nft_metadata.mint
    where year(BLOCK_TIMESTAMP)=2022 and MARKETPLACE in ('magic eden v2', 'magic eden v1')
    group by 2
    Run a query to Download Data