flipside

    Transaction Growth
    permaryTransaction Growth
    Updated 2025-04-03
    WITH daily_metrics AS (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS date,
    CASE
    WHEN to_address = '0x02790f32ad7e7eaaecfb0ad21950829932f1a2ee' THEN 'Game Daily Log'
    WHEN to_address = '0xf083289535052e8449d69e6dc41c0ae064d8e3f6' THEN 'Pixels Farmland'
    WHEN to_address = '0x7ac8de4b2d37ac6136be285ee7060e8676c9644f' THEN 'Guild Membership'
    WHEN to_address = '0xb806028b6ebc35926442770a8a8a7aeab6e2ce5c' THEN 'Pixel Pets'
    -- WHEN to_address = '0x7eae20d11ef8c779433eb24503def900b9d28ad7' THEN 'Pixel Tokens'
    WHEN to_address = '0x0e6bce8f215c52b53fad009e3bfacbb3be3774a6' THEN 'Pixel Dungeons Rewards'
    WHEN to_address = '0x36278457936460c0e7429aebf1bccd5061e1d0c1' THEN 'Pixel Dungeons Shop'
    WHEN to_address = '0x263eebee6ced9ff47fc9208cd461114e79a03f27' THEN 'Multi Send'
    END AS contract_type,
    COUNT(*) AS daily_transactions
    FROM ronin.core.fact_transactions
    WHERE-- block_timestamp >= DATEADD(day, -30, CURRENT_DATE)
    tx_succeeded = TRUE
    AND to_address IN (
    '0x02790f32ad7e7eaaecfb0ad21950829932f1a2ee',
    '0xf083289535052e8449d69e6dc41c0ae064d8e3f6',
    '0x7ac8de4b2d37ac6136be285ee7060e8676c9644f',
    '0xb806028b6ebc35926442770a8a8a7aeab6e2ce5c',
    -- '0x7eae20d11ef8c779433eb24503def900b9d28ad7',
    '0x0e6bce8f215c52b53fad009e3bfacbb3be3774a6',
    '0x36278457936460c0e7429aebf1bccd5061e1d0c1',
    '0x263eebee6ced9ff47fc9208cd461114e79a03f27'
    ) -- This ensures we only count relevant transactions
    GROUP BY 1, 2
    )
    SELECT
    date,
    contract_type,
    daily_transactions,
    LAG(daily_transactions) OVER (PARTITION BY contract_type ORDER BY date) AS prev_day_transactions,
    (
    (daily_transactions - LAG(daily_transactions) OVER (PARTITION BY contract_type ORDER BY date)) /
    Last run: 2 months ago
    DATE
    CONTRACT_TYPE
    DAILY_TRANSACTIONS
    PREV_DAY_TRANSACTIONS
    DAILY_GROWTH_RATE
    1
    		2025-04-03 00:00:00.000Game Daily Log172641179451-3.7949
    2
    		2025-04-03 00:00:00.000Guild Membership22712331-2.574
    3
    		2025-04-03 00:00:00.000Multi Send118151-21.8543
    4
    		2025-04-03 00:00:00.000Pixel Dungeons Rewards91989620-4.3867
    5
    		2025-04-03 00:00:00.000Pixel Dungeons Shop101158-36.0759
    6
    		2025-04-03 00:00:00.000Pixel Pets13011810.1695
    7
    		2025-04-03 00:00:00.000Pixels Farmland229272-15.8088
    8
    		2025-04-02 00:00:00.000Game Daily Log179451186223-3.6365
    9
    		2025-04-02 00:00:00.000Guild Membership2331814186.3636
    10
    		2025-04-02 00:00:00.000Multi Send151171-11.6959
    11
    		2025-04-02 00:00:00.000Pixel Dungeons Rewards96209963-3.4427
    12
    		2025-04-02 00:00:00.000Pixel Dungeons Shop158243-34.9794
    13
    		2025-04-02 00:00:00.000Pixel Pets118131-9.9237
    14
    		2025-04-02 00:00:00.000Pixels Farmland272304-10.5263
    15
    		2025-04-01 00:00:00.000Game Daily Log1862231854450.4195
    16
    		2025-04-01 00:00:00.000Guild Membership81446276.1905
    17
    		2025-04-01 00:00:00.000Multi Send171221-22.6244
    18
    		2025-04-01 00:00:00.000Pixel Dungeons Rewards996395124.7414
    19
    		2025-04-01 00:00:00.000Pixel Dungeons Shop243118105.9322
    20
    		2025-04-01 00:00:00.000Pixel Pets13110722.4299
    ...
    1128
    69KB
    3s