Updated 2022-06-23
    select
    date( block_timestamp )as date,
    count(distinct nft_to_address) as minters,
    sum(mint_price_eth) as mint_volume_eth,
    sum(mint_price_usd) as mint_volume_usd,
    case when nft_address = '0x90b3832e2f2ade2fe382a911805b6933c056d6ed' then 'Supporter Token -- Pooly 1'
    when nft_address = '0x3545192b340f50d77403dc0a64cf2b32f03d00a9' then 'Lawyer Token -- Pooly 2'
    when nft_address = '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523' then 'JUDGE Token -- Pooly 3'
    end as nft_type,
    count(nft_count) as nft
    from ethereum.core.ez_nft_mints
    where nft_address = '0x90b3832e2f2ade2fe382a911805b6933c056d6ed' or nft_address ='0x3545192b340f50d77403dc0a64cf2b32f03d00a9' or nft_address ='0x5663e3e096f1743e77b8f71b5de0cf9dfd058523'
    and nft_from_address = '0x0000000000000000000000000000000000000000'
    and event_type = 'nft_mint'
    group by date ,nft_type

    Run a query to Download Data