Bera TeamDaily Number of New Addresses
    Updated 5 days ago
    -- Daily New Users Based on the first Transaction date

    with new as ( select min(block_timestamp::date) as day,
    from_address
    from berachain.testnet.fact_transactions
    group by 2)

    select day,
    count(DISTINCT from_address) as "New Users",
    sum("New Users") over (order by day asc) as "Cumulative New Users"
    from new
    group by 1
    Last run: 5 days ago
    DAY
    New Users
    Cumulative New Users
    1
    2024-06-22 00:00:00.00056791706568
    2
    2024-06-13 00:00:00.0001692156890
    3
    2024-07-03 00:00:00.000426471329607
    4
    2024-10-04 00:00:00.00089965217659253
    5
    2024-08-22 00:00:00.000259543209612
    6
    2024-11-08 00:00:00.000348930227476
    7
    2024-11-04 00:00:00.000189930212505
    8
    2024-07-08 00:00:00.000242101551679
    9
    2024-07-17 00:00:00.000421171849082
    10
    2024-09-29 00:00:00.000127367912195094
    11
    2024-09-04 00:00:00.000113183319706
    12
    2024-12-30 00:00:00.00029188131822584
    13
    2024-11-14 00:00:00.000122430238166
    14
    2024-12-09 00:00:00.000166630309276
    15
    2024-06-24 00:00:00.00079941843650
    16
    2024-09-03 00:00:00.000125163308388
    17
    2024-10-19 00:00:00.000475230143843
    18
    2025-01-31 00:00:00.0008791734081811
    19
    2024-07-05 00:00:00.000704561458806
    20
    2024-09-22 00:00:00.0002634464271373
    ...
    246
    10KB
    23s