kingneduhourly trend
    Updated 2025-03-05
    --Monadverse chapter 3
    SELECT
    DATE_TRUNC('hour', e.Block_timestamp) AS hour,
    COUNT(DISTINCT e.tx_hash) AS total_nfts_minted,
    COUNT(DISTINCT e.origin_from_address) AS minters,
    SUM(t.value) AS amount_spent,
    SUM(t.tx_fee) AS total_gas_fees,
    FROM monad.testnet.fact_event_logs e
    JOIN monad.testnet.fact_transactions t
    ON e.tx_hash = t.tx_hash
    WHERE e.contract_address = lower('0xCaB08943346761701EC9757befe79eA88dD67670')
    AND e.origin_to_address = lower('0xCaB08943346761701EC9757befe79eA88dD67670')
    AND e.topic_0 = '0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62';
    GROUP BY 1
    ORDER BY 1 DESC


    Last run: 14 days ago
    HOUR
    TOTAL_NFTS_MINTED
    MINTERS
    AMOUNT_SPENT
    TOTAL_GAS_FEES
    1
    2025-03-05 08:00:00.0004400.02496
    2
    2025-03-05 07:00:00.0001100.003096548
    3
    2025-03-05 06:00:00.0006600.014160456
    4
    2025-03-05 05:00:00.0001100.0032739
    5
    2025-03-05 04:00:00.000252500.1488701
    6
    2025-03-05 03:00:00.000404000.170399944
    7
    2025-03-05 01:00:00.0002200.0065504
    8
    2025-03-04 21:00:00.0004400.01406355
    9
    2025-03-04 20:00:00.000989800.24735924
    10
    2025-03-04 19:00:00.00038738700.9870380197
    11
    2025-03-04 18:00:00.00012312300.370532729
    12
    2025-03-04 17:00:00.000167921678428475.86525146.357433933
    13
    2025-03-04 16:00:00.000563415632995606.26699438.999635601
    14
    2025-03-04 15:00:00.0009005290026152766.33484554.218408767
    15
    2025-03-04 14:00:00.000450945097651.3671930.655047022
    16
    2025-03-04 13:00:00.000111.696910.004943016
    17
    2025-03-04 11:00:00.000111.750.00523822
    18
    2025-03-04 09:00:00.000446.787640.03744
    19
    2025-03-04 01:00:00.000333.460.16355202
    20
    2025-03-04 00:00:00.000161627.921.54342932
    26
    1KB
    105s