flipside

    Dexalot Transaction to DAU Ratio
    cloudr3nDexalot Transaction to DAU Ratio
    Updated 2025-04-17
    with
    raw_tx_count as (
    SELECT
    livequery.live.udf_api(
    concat(
    'https://metrics.avax.network/v1/tx_count/432204?from=',
    to_char(
    DATE_PART(epoch_second, current_timestamp()) - 31536000
    ),
    '&to=',
    DATE_PART(epoch_second, current_timestamp()) :: string,
    '&interval=day'
    )
    ) as raw_response
    ),
    tx_count as (
    select
    value:timestamp as timestamp,
    to_timestamp(timestamp) as date_time,
    value:value as transaction_count
    from
    raw_tx_count,
    LATERAL FLATTEN (input => raw_response:data:results)
    ),

    raw_address_count as (
    SELECT
    livequery.live.udf_api(
    concat(
    'https://metrics.avax.network/v1/active_addresses/432204?from=',
    to_char(
    DATE_PART(epoch_second, current_timestamp()) - 31536000
    ),
    '&to=',
    DATE_PART(epoch_second, current_timestamp()) :: string,
    '&interval=day'
    Last run: about 2 months ago
    DATE_TIME
    ADDRESS_COUNT
    TRANSACTION_COUNT
    RATIO
    1
    		2025-02-04 00:00:00.000
    210
    885801
    		4218.1
    2
    		2025-02-03 00:00:00.000
    222
    863913
    		3891.5
    3
    		2025-02-02 00:00:00.000
    238
    969594
    		4073.924369748
    4
    		2025-02-01 00:00:00.000
    227
    765357
    		3371.616740088
    5
    		2025-01-31 00:00:00.000
    213
    661437
    		3105.338028169
    6
    		2025-01-30 00:00:00.000
    210
    775421
    		3692.480952381
    7
    		2025-01-29 00:00:00.000
    203
    803964
    		3960.413793103
    8
    		2025-01-28 00:00:00.000
    206
    840894
    		4082.009708738
    9
    		2025-01-27 00:00:00.000
    189
    1007328
    		5329.777777778
    10
    		2025-01-26 00:00:00.000
    192
    657048
    		3422.125
    11
    		2025-01-25 00:00:00.000
    209
    708422
    		3389.578947368
    12
    		2025-01-24 00:00:00.000
    185
    849374
    		4591.210810811
    13
    		2025-01-23 00:00:00.000
    190
    880777
    		4635.668421053
    14
    		2025-01-22 00:00:00.000
    191
    833911
    		4366.02617801
    15
    		2025-01-21 00:00:00.000
    220
    917276
    		4169.436363636
    16
    		2025-01-20 00:00:00.000
    197
    872308
    		4427.959390863
    17
    		2025-01-19 00:00:00.000
    182
    924110
    		5077.527472527
    18
    		2025-01-18 00:00:00.000
    169
    913870
    		5407.514792899
    19
    		2025-01-17 00:00:00.000
    203
    665900
    		3280.295566502
    20
    		2025-01-16 00:00:00.000
    232
    731375
    		3152.478448276
    ...
    293
    15KB
    2s