pietrektNew Addresses daily and cumulative
    Updated 16 hours ago
    WITH
    transactions AS (
    SELECT
    to_address as address,
    to_date(block_timestamp) as date
    FROM
    thorchain.core.fact_transfer_events
    UNION ALL
    SELECT
    from_address as address,
    to_date(block_timestamp) as date
    FROM
    thorchain.core.fact_transfer_events
    ),
    address_first_day AS (
    SELECT
    address,
    MIN(date) as date
    FROM
    transactions
    GROUP BY
    address
    ORDER BY
    date,
    address
    ),
    dates AS (
    SELECT DISTINCT
    date,
    0 as address_count_change
    FROM
    transactions
    ),
    address_count_per_day AS (
    SELECT
    date,
    Last run: about 16 hours agoAuto-refreshes every 24 hours
    DAY
    NEW_ADDRESSES
    NEW_ADDRESSES_CUMULATIVE
    1
    2025-05-22 00:00:00.0005136762
    2
    2025-05-21 00:00:00.00098136757
    3
    2025-05-20 00:00:00.00097136659
    4
    2025-05-19 00:00:00.00083136562
    5
    2025-05-18 00:00:00.00089136479
    6
    2025-05-17 00:00:00.00078136390
    7
    2025-05-16 00:00:00.00072136312
    8
    2025-05-15 00:00:00.000103136240
    9
    2025-05-14 00:00:00.000108136137
    10
    2025-05-13 00:00:00.000122136029
    11
    2025-05-12 00:00:00.000156135907
    12
    2025-05-11 00:00:00.000145135751
    13
    2025-05-10 00:00:00.000144135606
    14
    2025-05-09 00:00:00.000200135462
    15
    2025-05-08 00:00:00.000247135262
    16
    2025-05-07 00:00:00.000120135015
    17
    2025-05-06 00:00:00.000314134895
    18
    2025-05-05 00:00:00.000297134581
    19
    2025-05-04 00:00:00.000404134284
    20
    2025-05-03 00:00:00.000200133880
    ...
    1481
    54KB
    5s