sssstatisticOff-Chain DAU
    Updated 2024-12-23
    SELECT
    value ['time'] AS time,
    value ['DAU'] AS "Daily Active Users",
    value ['New'] AS "New Users"
    from
    table(
    flatten(
    PARSE_JSON(
    '
    [
    {"time":45403,"DAU":12038, "New":842},
    {"time":45404,"DAU":17336, "New":764},
    {"time":45405,"DAU":16186, "New":408},
    {"time":45406,"DAU":15602, "New":423},
    {"time":45407,"DAU":15345, "New":264},
    {"time":45408,"DAU":13825, "New":220},
    {"time":45409,"DAU":13441, "New":195},
    {"time":45410,"DAU":12942, "New":205},
    {"time":45411,"DAU":12345, "New":156},
    {"time":45412,"DAU":12615, "New":144},
    {"time":45413,"DAU":12030, "New":169},
    {"time":45414,"DAU":11595, "New":81},
    {"time":45415,"DAU":11843, "New":106},
    {"time":45416,"DAU":11437, "New":131},
    {"time":45417,"DAU":11462, "New":103},
    {"time":45418,"DAU":11166, "New":88},
    {"time":45419,"DAU":10830, "New":124},
    {"time":45420,"DAU":10628, "New":125},
    {"time":45421,"DAU":10831, "New":84},
    {"time":45422,"DAU":10930, "New":88},
    {"time":45423,"DAU":10336, "New":74},
    {"time":45424,"DAU":10395, "New":187},
    {"time":45425,"DAU":10278, "New":211},
    {"time":45426,"DAU":10432, "New":181},
    {"time":45427,"DAU":10054, "New":139},
    {"time":45428,"DAU":9930, "New":150},
    Last run: about 2 months ago
    TIME
    Daily Active Users
    New Users
    1
    45403
    12038
    842
    2
    45404
    17336
    764
    3
    45405
    16186
    408
    4
    45406
    15602
    423
    5
    45407
    15345
    264
    6
    45408
    13825
    220
    7
    45409
    13441
    195
    8
    45410
    12942
    205
    9
    45411
    12345
    156
    10
    45412
    12615
    144
    11
    45413
    12030
    169
    12
    45414
    11595
    81
    13
    45415
    11843
    106
    14
    45416
    11437
    131
    15
    45417
    11462
    103
    16
    45418
    11166
    88
    17
    45419
    10830
    124
    18
    45420
    10628
    125
    19
    45421
    10831
    84
    20
    45422
    10930
    88
    ...
    227
    4KB
    1s