siavashjUntitled Query
    Updated 2023-01-04
    select
    date_trunc('month',block_timestamp) as date,
    count(distinct tx_hash) as number_mint,
    sum(mint_price_usd) as mint_amount,
    project_name
    from ethereum.core.ez_nft_mints
    where block_timestamp between '2022-01-01' and '2022-12-29'
    and event_type = 'nft_mint'
    group by 1,4