majidshiri171monthly tot
    Updated 2022-09-13
    select 'Solana Network' as lbl , count(*) as number_of_mint
    ,sum(MINT_PRICE) as mint_amount
    ,count(distinct PURCHASER) as number_of_buyer
    , trunc(block_timestamp, 'MONTH')
    from solana.core.fact_nft_mints
    where year(BLOCK_TIMESTAMP)=2022
    group by trunc(block_timestamp, 'MONTH')


    union all


    select 'Ethereum Network' as lbl , count(*) as number_of_mint
    ,sum(MINT_PRICE_ETH)
    ,count(distinct NFT_TO_ADDRESS) as number_of_buyer
    ,trunc(block_timestamp, 'MONTH')
    from ethereum.core.ez_nft_mints
    where year(BLOCK_TIMESTAMP)=2022
    group by trunc(block_timestamp, 'MONTH')
    Run a query to Download Data