LI.FI1Month Comparison Time Series
    Updated 2025-06-23
    -- Rango tx_hash sample = '0x34e7e70271abe0087d70f786927521967730eaa33053b48b45ae8df39a1e5945'
    -- event_name = 'RangoBridgeInitiated'

    WITH decodedTXN AS (
    SELECT tx_hash, src_chain, decoded_log, block_timestamp, event_name
    FROM (
    SELECT tx_hash, decoded_log, block_timestamp, event_name, 'Ethereum' AS src_chain FROM ethereum.core.ez_decoded_event_logs
    WHERE block_timestamp >= current_date - {{past_days}}
    UNION
    SELECT tx_hash, decoded_log, block_timestamp, event_name, 'Polygon' AS src_chain FROM polygon.core.ez_decoded_event_logs
    WHERE block_timestamp >= current_date - {{past_days}}
    UNION
    SELECT tx_hash, decoded_log, block_timestamp, event_name, 'BSC' AS src_chain FROM bsc.core.ez_decoded_event_logs
    WHERE block_timestamp >= current_date - {{past_days}}
    UNION
    SELECT tx_hash, decoded_log, block_timestamp, event_name, 'BASE' AS src_chain FROM base.core.ez_decoded_event_logs
    WHERE block_timestamp >=current_date - {{past_days}}
    UNION
    SELECT tx_hash, decoded_log, block_timestamp, event_name, 'Arbitrum' AS src_chain FROM arbitrum.core.ez_decoded_event_logs
    WHERE block_timestamp >= current_date - {{past_days}}
    UNION
    SELECT tx_hash, decoded_log, block_timestamp, event_name, 'OP' AS src_chain FROM optimism.core.ez_decoded_event_logs
    WHERE block_timestamp >= current_date - {{past_days}}
    UNION
    SELECT tx_hash, decoded_log, block_timestamp, event_name, 'Avalanche' AS src_chain FROM avalanche.core.ez_decoded_event_logs
    WHERE block_timestamp >= current_date - {{past_days}}
    UNION
    SELECT tx_hash, decoded_log, block_timestamp, event_name, 'Gnosis' AS src_chain FROM gnosis.core.ez_decoded_event_logs
    WHERE block_timestamp >= current_date - {{past_days}}

    )),
    prices as (
    SELECT hour, price, decimals, symbol, iff(is_native,'0x0000000000000000000000000000000000000000', token_address) as token_address, 'Arbitrum' AS chain FROM arbitrum.price.ez_prices_hourly
    UNION
    SELECT hour, price, decimals, symbol, iff(is_native,'0x0000000000000000000000000000000000000000', token_address) as token_address, 'OP' AS chain FROM optimism.price.ez_prices_hourly
    UNION
    Last run: 12 days ago
    DATE
    AGGREGATOR
    SRC_CHAIN
    N_TXNS
    VOL
    1
    2025-06-22 00:00:00.000lifiEthereum9712513.361866231
    2
    2025-06-03 00:00:00.000rangoAvalanche1115.172146121
    3
    2025-06-03 00:00:00.000lifiOP1176.830142191
    4
    2025-06-06 00:00:00.000lifiOP699.421743443
    5
    2025-06-19 00:00:00.000rangoArbitrum11186.254290482
    6
    2025-06-06 00:00:00.000lifiAvalanche1175.196336566
    7
    2025-06-02 00:00:00.000rangoPolygon331836.416300494
    8
    2025-06-09 00:00:00.000rangoBASE18464.015714308
    9
    2025-06-11 00:00:00.000rangoOP24729.928962825
    10
    2025-06-20 00:00:00.000lifiEthereum15223697.694953824
    11
    2025-06-21 00:00:00.000lifiOP9438.080215782
    12
    2025-05-25 00:00:00.000rangoAvalanche2045.797104158
    13
    2025-06-20 00:00:00.000rangoPolygon9201.424793569
    14
    2025-05-29 00:00:00.000rangoAvalanche1518.028911799
    15
    2025-06-07 00:00:00.000rangoBASE92468.774603781
    16
    2025-06-07 00:00:00.000rangoPolygon297024.895293635
    17
    2025-06-16 00:00:00.000lifiPolygon282529.239069993
    18
    2025-06-18 00:00:00.000rangoAvalanche108.669772285
    19
    2025-06-09 00:00:00.000rangoEthereum3115176.272761647
    20
    2025-06-18 00:00:00.000lifiArbitrum312997.814715898
    ...
    364
    22KB
    361s