m3jiWeekly Active Wallets
    Updated 4 days ago
    select
    date_trunc('week', BLOCK_TIMESTAMP) :: date AS date,
    --monthname(BLOCK_TIMESTAMP) AS Month,
    count(TX_id) AS "transactions ",
    count(distinct TX_FROM) AS "active addresses"
    from
    axelar.core.fact_transactions
    where
    TX_SUCCEEDED = 'TRUE'
    and BLOCK_TIMESTAMP >= '2024-01-01'
    group by
    1
    Last run: 4 days agoAuto-refreshes every 12 hours
    DATE
    transactions
    active addresses
    1
    2024-07-08 00:00:00.00033823417961
    2
    2024-09-16 00:00:00.00023536866110
    3
    2024-09-23 00:00:00.00025854686762
    4
    2024-11-25 00:00:00.00029941858387
    5
    2024-12-09 00:00:00.00029656806853
    6
    2024-12-30 00:00:00.00025977415619
    7
    2025-04-21 00:00:00.00018010584454
    8
    2025-05-12 00:00:00.00019045684452
    9
    2024-01-29 00:00:00.00030715668338
    10
    2024-03-18 00:00:00.000391309213688
    11
    2024-05-27 00:00:00.000347803410557
    12
    2024-07-01 00:00:00.00030201206802
    13
    2024-08-12 00:00:00.00025456156131
    14
    2024-08-26 00:00:00.00021530915603
    15
    2025-01-20 00:00:00.00026690805942
    16
    2025-02-03 00:00:00.00025271174863
    17
    2025-03-03 00:00:00.00019189234808
    18
    2025-03-31 00:00:00.00021334504478
    19
    2024-11-18 00:00:00.00028403998556
    20
    2024-01-22 00:00:00.00031349878497
    80
    3KB
    71s