Pine AnalyticsSquid Activity by Path
    Updated 2025-04-10
    with tab0 as (
    SELECT
    date(recorded_hour) as date1,
    median(price) as token_price
    FROM osmosis.price.ez_prices
    WHERE symbol LIKE 'AXL'
    GROUP BY 1
    ), tab1 as (
    SELECT
    created_at,
    id,
    amount,
    data,
    fees,
    data:call:receipt:from as user,
    data:call:chain as source_chain,
    data:call:returnValues:destinationChain as destination_chain,
    fees:token:token_price:usd as token_price1,
    case when NOT token_price1 is NULL
    then token_price1
    when data:approved:returnValues:symbol LIKE '%USDC%' then 1
    when data:approved:returnValues:symbol LIKE '%USDT%' then 1
    when data:approved:returnValues:symbol LIKE '%DAI%' then 1
    when data:approved:returnValues:symbol LIKE '%MAI%' then 1
    when call:returnValues:symbol LIKE '%USDC%' then 1
    when call:returnValues:symbol LIKE '%USDT%' then 1
    when call:returnValues:symbol LIKE '%DAI%' then 1
    when call:returnValues:symbol LIKE '%MAI%' then 1
    when call:returnValues:symbol LIKE 'AXL' then token_price
    end as token_price2

    FROM axelar.axelscan.fact_gmp
    LEFT outer JOIN tab0
    on date1 = date(created_at)
    WHERE not amount is NULL
    AND SIMPLIFIED_STATUS LIKE 'received'
    Last run: 13 days agoAuto-refreshes every 3 hours
    DESTINATION_CHAIN
    SOURCE_CHAIN
    VOLUME
    USERS
    1
    Polygon
    binance
    33392682.617235749468
    2
    Polygon
    arbitrum
    21472633.507102638967
    3
    osmosis
    arbitrum
    58471126.649152933548
    4
    celo
    polygon
    4468313.8739025531850
    5
    Arbitrum
    base
    41747085.811189628775
    6
    binance
    ethereum
    167324775.99367825958
    7
    binance
    polygon
    40617815.661414925102
    8
    celo
    arbitrum
    6482819.5071125523744
    9
    Arbitrum
    polygon
    20348858.238907520283
    10
    Polygon
    base
    15662837.861594720199
    11
    base
    arbitrum
    44812537.542366719392
    12
    Arbitrum
    binance
    37296039.771755919317
    13
    Ethereum
    binance
    149106713.67672718870
    14
    base
    binance
    32968340.782415117761
    15
    optimism
    base
    18840664.424341116084
    16
    optimism
    arbitrum
    18178867.180620715939
    17
    celo
    base
    4962448.9553466115311
    18
    celo
    binance
    10011010.871372815101
    19
    Fantom
    binance
    49904464.50789715074
    20
    osmosis
    binance
    74828567.502911314629
    ...
    896
    34KB
    38s