alleriaPooly NFT - Hour
    Updated 2023-04-13
    SELECT
    hour(block_timestamp) as hours,
    COUNT(1) as "No. of Mints",
    SUM(mint_price_eth) as "ETH Spent"
    FROM ethereum.core.ez_nft_mints
    WHERE nft_address = lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed')
    OR nft_address = lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9')
    OR nft_address = lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523')
    GROUP BY hours
    ORDER BY hours ASC

    Run a query to Download Data