Hessishzink - mints tot
    Updated 22 hours ago
    with all_txs as (SELECT BLOCK_TIMESTAMP ,
    topics[3] as mints,
    topics[2] as minter,
    from ink.core.fact_event_logs
    WHERE
    CONTRACT_ADDRESS = lower('0xFb2Cd41a8aeC89EFBb19575C6c48d872cE97A0A5') and
    TOPICS[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
    and ORIGIN_FUNCTION_SIGNATURE = '0x3a99d4eb'
    and TX_SUCCEEDED = 'TRUE'
    ),


    final as (select
    count(distinct mints) as "# of minted domains", count(distinct minter) as minters, 'All time' as period
    from all_txs


    --union

    --select
    -- count(distinct mints) as "# of minted domains", count(distinct minter) as minters,'Last 30 days' as period
    --from all_txs
    --WHERE BLOCK_TIMESTAMP >= current_timestamp - INTERVAL '30 day'
    --group by 3

    union


    select
    count(distinct mints) as "# of minted domains", count(distinct minter) as minters,'Last 7 days' as period
    from all_txs
    WHERE BLOCK_TIMESTAMP >= CURRENT_TIMESTAMP() - INTERVAL '7 day'
    group by 3

    union
    Last run: about 22 hours agoAuto-refreshes every 24 hours
    PERIOD
    Number of minted domains
    Number of minter addresses
    # of minted domains
    MINTERS
    1
    All time 6,431 6,22764316227
    2
    Last 7 days 3,371 3,34733713347
    3
    Last 24 hours 278 276278276
    4
    Last 6 hours 21 212121
    5
    Last 1 hour 1 111
    5
    309B
    2s