LI.FI1Month Comparison Time Series copy
    Updated 2025-06-23
    -- forked from 1Month Comparison Time Series @ https://flipsidecrypto.xyz/studio/queries/5931e7ad-5eec-46ff-bd53-2ec9a48ce2a3

    -- Rango on Base: 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-30
    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 - 30
    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 - 30
    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 - 30
    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 - 30
    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 - 30
    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 - 30
    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 - 30

    )),
    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
    Last run: 10 days ago
    DATE
    AGGREGATOR
    BRIDGENAME
    N_TXNS
    VOL
    1
    2025-06-11 00:00:00.000lifisymbiosis3398.17098436
    2
    2025-06-10 00:00:00.000lifiacross18977.048104396
    3
    2025-06-17 00:00:00.000rangoacross8216.374950856
    4
    2025-06-15 00:00:00.000lifimayan142283.46830837
    5
    2025-06-09 00:00:00.000lifisymbiosis21592.47553465
    6
    2025-06-09 00:00:00.000lifimayan11575.390655897
    7
    2025-06-22 00:00:00.000rangoacross9146.17643687
    8
    2025-06-03 00:00:00.000lifimayan71556.324042171
    9
    2025-06-03 00:00:00.000rangoacross82580.055107602
    10
    2025-06-07 00:00:00.000lificbridge41719.326757078
    11
    2025-06-23 00:00:00.000lifistargateV21698.8199943
    12
    2025-06-08 00:00:00.000lifistargateV227.906976156
    13
    2025-06-10 00:00:00.000lifistargateV2Bus693.051933901
    14
    2025-06-18 00:00:00.000lifimayan101308.920673987
    15
    2025-06-07 00:00:00.000lifistargateV22232.300358
    16
    2025-06-18 00:00:00.000lifistargateV2Bus845.868254117
    17
    2025-06-04 00:00:00.000lifisymbiosis1169.80637
    18
    2025-06-04 00:00:00.000lifiacross17228.312361864
    19
    2025-06-08 00:00:00.000lifimayan4147.178701193
    20
    2025-06-15 00:00:00.000lificbridge5383.911769038
    ...
    200
    12KB
    300s