aPrioriFaucet tx by minute
    Updated 7 days ago
    select
    date_trunc('minute',BLOCK_TIMESTAMP) as stat_date
    ,FROM_ADDRESS
    ,count(distinct TO_ADDRESS) as calim_wallet_count
    ,count(distinct TX_HASH) as calim_tx_count
    ,sum(VALUE) as VALUE
    from monad.testnet.fact_transactions
    where FROM_ADDRESS=lower('0xD7a24d1F1435CD314E86736E139f8431D4498D4e')
    and BLOCK_TIMESTAMP>'2025-03-10'
    and TX_SUCCEEDED
    group by 1,2
    order by STAT_DATE
    Last run: 7 days ago
    STAT_DATE
    FROM_ADDRESS
    CALIM_WALLET_COUNT
    CALIM_TX_COUNT
    VALUE
    1
    2025-03-10 03:00:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e131326
    2
    2025-03-10 03:01:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e171734
    3
    2025-03-10 03:02:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e434386
    4
    2025-03-10 03:03:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e111122
    5
    2025-03-10 03:04:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e333366
    6
    2025-03-10 03:05:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e383876
    7
    2025-03-10 03:06:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e373774
    8
    2025-03-10 03:07:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e262652
    9
    2025-03-10 03:08:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e233233466
    10
    2025-03-10 03:09:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e5645641128
    11
    2025-03-10 03:10:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e6868136
    12
    2025-03-10 03:11:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e191938
    13
    2025-03-10 03:12:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e292958
    14
    2025-03-10 03:13:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e171734
    15
    2025-03-10 03:14:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e282856
    16
    2025-03-10 03:15:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e424284
    17
    2025-03-10 03:16:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e383876
    18
    2025-03-10 03:17:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e363672
    19
    2025-03-10 03:18:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e292958
    20
    2025-03-10 03:19:00.0000xd7a24d1f1435cd314e86736e139f8431d4498d4e333366
    40
    3KB
    3s