Updated 2025-01-29
    SELECT BLOCK_TIMESTAMP::date as day, count (DISTINCT TX_HASH) as number_of_TX
    from ink.core.fact_transactions
    GROUP by 1 order by 1
    Last run: 27 days ago
    DAY
    NUMBER_OF_TX
    1
    2024-12-06 00:00:00.00031188
    2
    2024-12-07 00:00:00.00086402
    3
    2024-12-08 00:00:00.00086402
    4
    2024-12-09 00:00:00.00086475
    5
    2024-12-10 00:00:00.00086430
    6
    2024-12-11 00:00:00.00086596
    7
    2024-12-12 00:00:00.00086686
    8
    2024-12-13 00:00:00.00086637
    9
    2024-12-14 00:00:00.00086537
    10
    2024-12-15 00:00:00.00086508
    11
    2024-12-16 00:00:00.00087083
    12
    2024-12-17 00:00:00.000102672
    13
    2024-12-18 00:00:00.000120546
    14
    2024-12-19 00:00:00.000114781
    15
    2024-12-20 00:00:00.000103046
    16
    2024-12-21 00:00:00.00099087
    17
    2024-12-22 00:00:00.00099128
    18
    2024-12-23 00:00:00.000103033
    19
    2024-12-24 00:00:00.000114504
    20
    2024-12-25 00:00:00.000115239
    55
    2KB
    7s