kakamoraHourly Metrics
    Updated 2023-04-27
    with metrics as (
    SELECT
    date_trunc(hour, block_timestamp) as date,
    count(nft_count) as nfts_minted,
    avg(tx_fee) as nft_mint_fee_avg,
    sum(tx_fee) as nft_mint_fee_sum,
    count(distinct nft_to_address) as minters,
    nfts_minted / minters as avg_mints_per_minter
    from ethereum.core.ez_nft_mints
    where nft_address='0xdfb57b6e16ddb97aeb8847386989f4dca7202146'
    and nft_from_address='0x0000000000000000000000000000000000000000'
    and event_type ='nft_mint'
    GROUP BY date
    ),
    new_minters as (
    SELECT
    block_timestamp,
    nft_to_address as minter
    from ethereum.core.ez_nft_mints
    where nft_address='0xdfb57b6e16ddb97aeb8847386989f4dca7202146'
    and nft_from_address='0x0000000000000000000000000000000000000000'
    and event_type ='nft_mint'
    QUALIFY row_number() over(partition by minter order by block_timestamp asc) = 1
    ),
    new_minters_growth as (
    select
    date_trunc(hour, block_timestamp) as date,
    count(minter) as first_time_minters
    from new_minters
    group by date
    )
    SELECT *
    FROM metrics
    LEFT JOIN new_minters_growth USING (DATE)

    Run a query to Download Data