adriaparcerisasflow bridges in 2025 platforms
    Updated 4 hours ago
    WITH token_info AS (
    SELECT
    '0xf1815bd50389c46847f0bda824ec8da914045d14' as token_address, 'USDC' as token_name, 6 as decimals
    UNION ALL
    SELECT '0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590', 'WETH', 18
    UNION ALL
    SELECT '0x2aabea2058b5ac2d339b163c6ab6f2b6d53aabed', 'USDF', 6
    UNION ALL
    SELECT '0x674843c06ff83502ddb4d37c2e09c01cda38cbc8', 'USDT', 6
    UNION ALL
    SELECT '0xfa0e06b54986ad96de87a8c56fea76fbd8d493f8', 'USDF', 6
    UNION ALL
    SELECT '0xea3910f1c6e687b59835885904a2fd1944b51ec6', 'TRUMP', 18
    UNION ALL
    SELECT '0xd3bf53dac106a0290b0483ecbc89d40fcc961f3e', 'FLOW', 18
    ),

    bridge_transfers AS (
    SELECT
    block_timestamp::Date as date,
    tx_hash,
    contract_address as token_address,
    '0x' || substr(TOPIC_1,27) as from_address,
    '0x' || substr(TOPIC_2,27) as user_address,
    TRY_TO_NUMBER(livequery.utils.udf_hex_to_int(DATA)) as amount_raw,
    t.token_name,
    t.decimals,
    CASE
    WHEN amount_raw IS NOT NULL THEN amount_raw/pow(10,decimals)
    ELSE TRY_TO_NUMBER(data, 16)/pow(10,decimals)
    END as amount
    FROM flow.core_evm.fact_event_logs e
    JOIN token_info t ON e.contract_address = t.token_address
    WHERE origin_to_address = '0xa20db4ffe74a31d17fc24bd32a7dd7555441058e'
    AND topic_0 = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
    AND tx_succeeded = 'TRUE'
    Last run: about 4 hours ago
    DATE
    PLATFORM
    BRIDGES
    ACTIVE_USERS
    VOLUME_USD
    AVG_VOLUME_USD
    1
    2025-06-01 00:00:00.000Relay90554849.11348944352.141005263
    2
    2025-06-01 00:00:00.000Stargate18946611.8038350872330.590191754
    3
    2025-05-31 00:00:00.000Relay185944556.80254767523.733346602
    4
    2025-05-31 00:00:00.000Stargate131132505.749635042500.442279618
    5
    2025-05-31 00:00:00.000blocto110.58915490310.5891549031
    6
    2025-05-31 00:00:00.000deBridge1151.35644851.356448
    7
    2025-05-30 00:00:00.000Relay2471496712.6484133526.958427363
    8
    2025-05-30 00:00:00.000Stargate9822710.4693610972523.385484566
    9
    2025-05-30 00:00:00.000deBridge2141.20597720.6029885
    10
    2025-05-29 00:00:00.000Relay3913295936.64181745515.144494432
    11
    2025-05-29 00:00:00.000Stargate1513267262.4933992516703.905837453
    12
    2025-05-29 00:00:00.000deBridge52100.32950608220.065901216
    13
    2025-05-28 00:00:00.000Relay24611924982.936246763101.145490878
    14
    2025-05-28 00:00:00.000Stargate242046230.2331201461926.259713339
    15
    2025-05-28 00:00:00.000deBridge117.8500306347.850030634
    16
    2025-05-27 00:00:00.000Relay2511694938.8632249919.676745916
    17
    2025-05-27 00:00:00.000Stargate9783665.9525074959296.216945277
    18
    2025-05-27 00:00:00.000blocto110.5009203790.500920379
    19
    2025-05-27 00:00:00.000deBridge1110.02238868510.022388685
    20
    2025-05-26 00:00:00.000Relay104304458.15646759742.866889112
    ...
    412
    28KB
    28s