datavortexfastest speed and slowest speeed
    Updated 2025-05-27
    WITH swap_users AS (
    SELECT
    trader AS user_address,
    'swap' AS activity_type
    FROM $query('9ae0a10f-37db-4b83-b062-af1aabf8d865')
    WHERE trader IS NOT NULL
    ),

    bridge_users AS (
    SELECT
    source_address AS user_address,
    'bridge' AS activity_type
    FROM $query('a76acafa-4323-49d7-97fa-547fd5ed7635')
    WHERE source_address IS NOT NULL
    ),

    lending_users AS (
    SELECT
    sender_id AS user_address,
    'lending' AS activity_type
    FROM $query('8575b071-59e0-4f3b-8588-df5395c49b71')
    WHERE sender_id IS NOT NULL
    ),

    staking_users AS (
    SELECT
    signer_id AS user_address,
    'staking' AS activity_type
    FROM $query('db0bfc72-0b35-47b4-8f59-54056d2bcbbf')
    WHERE signer_id IS NOT NULL
    ),

    nft_users AS (
    SELECT
    user_address,
    'nft_sales' AS activity_type
    Last run: 13 days ago
    ROUNDED_SCORE
    USER_COUNT
    TOTAL_TRANSACTIONS_PER_SCORE
    1
    13.5118443
    2
    12.5915454
    3
    1257673
    4
    11.527170
    5
    1167763
    6
    10.5971882
    7
    10114161557
    8
    9.5209142743
    9
    93857450
    10
    8.5171198296
    11
    8320348811
    12
    7.5794435261
    13
    749221192890
    14
    6.59552924515
    15
    613871459176
    16
    5.590261935173
    17
    5112125547545
    18
    4.53950562400
    19
    411748450202
    20
    3.51232617556
    25
    389B
    4s