parisaaTop 10 Active CrossChain Pair by Txn Activity [ Axelar ] copy copy
    -- forked from Top 10 Active CrossChain Pair by Txn Activity [ Axelar ] copy @ https://flipsidecrypto.xyz/edit/queries/85e0b901-80dd-48c5-8175-7eea3e759503
    -- forked from CryptoGowda / Top 10 Active CrossChain Pair by Txn Activity [ Axelar ] @ https://flipsidecrypto.xyz/CryptoGowda/q/uiwyPgRE9Vgg/top-10-active-crosschain-pair-by-txn-activity-axelar-]
    WITH hourly_token_prices AS (
    SELECT
    date_trunc('day', hour) AS day,
    symbol,
    avg(price) AS price_usd
    FROM
    crosschain.core.ez_hourly_prices
    GROUP BY
    1,
    2
    ),
    squid_txns as (
    select
    block_number,
    block_timestamp,
    tx_hash,
    source_chain,
    destination_chain,
    sender,
    amount,
    amount * price_usd as amount_usd,
    token_address,
    token_symbol,
    'Squid' as router,
    CONCAT(source_chain, '-', destination_chain) AS crosschain_pair
    from
    axelar.core.ez_squid
    left join hourly_token_prices htp on date_trunc('day', block_timestamp) = htp.day
    and token_symbol = htp.symbol
    ),
    satellite_txns as (
    select
    block_number,
    block_timestamp,
    Run a query to Download Data