10Blockchain3. Nombre d'Intentions par Jour
    Updated 2025-03-02
    SELECT DATE(BLOCK_TIMESTAMP) AS date, COUNT(*) AS daily_intents
    FROM near.defi.fact_intents
    GROUP BY DATE(BLOCK_TIMESTAMP)
    ORDER BY date;

    Last run: about 2 months ago
    DATE
    DAILY_INTENTS
    1
    2024-11-05 00:00:00.00039
    2
    2024-11-06 00:00:00.000197
    3
    2024-11-07 00:00:00.0001991
    4
    2024-11-08 00:00:00.0002001
    5
    2024-11-09 00:00:00.000284
    6
    2024-11-10 00:00:00.000472
    7
    2024-11-11 00:00:00.000271
    8
    2024-11-12 00:00:00.000342
    9
    2024-11-13 00:00:00.00080
    10
    2024-11-14 00:00:00.000282
    11
    2024-11-15 00:00:00.000362
    12
    2024-11-16 00:00:00.00090
    13
    2024-11-17 00:00:00.00026
    14
    2024-11-18 00:00:00.000162
    15
    2024-11-19 00:00:00.000176
    16
    2024-11-20 00:00:00.000222
    17
    2024-11-21 00:00:00.00094
    18
    2024-11-22 00:00:00.000240
    19
    2024-11-23 00:00:00.000378
    20
    2024-11-24 00:00:00.00088
    ...
    118
    4KB
    2s