flipside

    Active Addresses Breakdown
    dannyamahActive Addresses Breakdown
    Updated 2025-04-08
    with transactions as (
    select *
    from ronin.core.fact_transactions rt
    inner join ronin.core.dim_contracts ct
    on ct.address = rt.to_address
    where block_timestamp >= current_date - interval '60 days'
    ),
    raw_table_1d as (
    select
    name,
    address,
    count(distinct from_address) as num_of_accounts_1d
    from transactions
    where block_timestamp >= current_date - interval '1 day'
    group by 1, 2
    ),
    raw_table_2d as (
    select
    name,
    address,
    count(distinct from_address) as num_of_accounts_2d
    from transactions
    where block_timestamp >= current_date - interval '2 days'
    and block_timestamp < current_date - interval '1 days'
    group by 1, 2
    ),
    raw_table_7d as (
    select
    name,
    address,
    count(distinct from_address) as num_of_accounts_7d
    from transactions
    where block_timestamp >= current_date - interval '7 days'
    group by 1, 2
    ),
    raw_table_14d as (
    Last run: 2 months ago
    NAME
    ADDRESS
    NUM_OF_ACCOUNTS_1D
    DIFF_1D
    NUM_OF_ACCOUNTS_7D
    DIFF_7D
    NUM_OF_ACCOUNTS_30D
    DIFF_30D
    1
    		Seaport0x0000000000000068f116a894984e2db1123eb395115200.538873774764.58305181708
    2
    		Axie Infinity Shard0x97a9107c1793bc407d6f527b77e7fff4d812bece69920.3851031164300.0066492295500.330293
    3
    		Axie Infinity Shard0x97a9107c1793bc407d6f527b77e7fff4d812bece69920.3851031164300.006649229550229549
    4
    		0xcd4f1cd738cf862995239b5b7d9ff09cffc223996866
    5
    		0x215296d71f9111cc69fe06d378ecb06f4cd5086b6716
    6
    		0x5f0acdd3ec767514ff1bf7e79949640bf94576bd5841
    7
    		PIXEL0x7eae20d11ef8c779433eb24503def900b9d28ad749660.57700923947-0.00758489754-0.384019
    8
    		Axie0x32950db2a7164ae833121501c797d79e7b79d74c45010.610376452141.097319940870.880236
    9
    		Ronin Wrapped Ether0xc99a6a985ed2cac1ef41640596c5a5f9f4e19ef537820.620394101450.15810524863-0.065898
    10
    		Ronin Wrapped Ether0xc99a6a985ed2cac1ef41640596c5a5f9f4e19ef537820.620394101450.1581052486324862
    11
    		USD Coin0x0b7007c13325c48911f73a2dad5fa5dcbf808adc32160.503506191660.231432417980.135753
    12
    		Smooth Love Potion0xa8754b9fa15fc18bb59458815510e40a12cd201428461.041607125150.384096314340.13558
    13
    		0xe377e13256002ab260e8ab59478652710a79ac5c2040
    14
    		Wrapped Ronin0xe514d9deb7966c8be0ca922de8a064264ea6bcd419940.086649168642.032548218101.267859
    15
    		Axie Material0x12b707c3d2786570cfdc3a998a085b62acdba4b315881.02551120212.806523167523.191143
    16
    		Yield Guild Games Token0x1c306872bc82525d72bf3562e8f0aa3f8f26e85714902.89033935970.3898767284-0.606632
    17
    		PHZM0x0e268edc8750d50c440d715c935eba2e7c6ae77510590.4915493565-0.1584048277-0.359514
    18
    		RuniverseItem0x578b65568b7a6a081a477748590774a64d8a492310211.05846880932.4205411060226.9
    19
    		0xd9164a660c335c64a76e4023866e58b45c00deea744
    20
    		0x00005ea00ac477b1030ce78506496e8c2de24bf5720
    ...
    1509
    126KB
    8s