SocioCryptoActual Squid Data
    Updated 2024-02-26
    SELECT *
    FROM (
    SELECT
    a.source_chain as network_in,
    a.destination_chain as network_out,
    b.symbol_in,
    b.symbol_out,
    b.platform,
    a.amount,
    c.gas_used
    FROM axelar.defi.ez_bridge_squid a
    INNER JOIN arbitrum.defi.ez_dex_swaps b using(a.tx_hash)
    LEFT JOIN arbitrum.core.fact_transactions c using(a.tx_hash)
    WHERE source_chain = 'arbitrum'
    UNION
    SELECT
    a.source_chain as network_in,
    a.destination_chain as network_out,
    b.symbol_in,
    b.symbol_out,
    b.platform,
    a.amount,
    c.gas_used
    FROM axelar.defi.ez_bridge_squid a
    INNER JOIN ethereum.defi.ez_dex_swaps b using(a.tx_hash)
    LEFT JOIN ethereum.core.fact_transactions c using(a.tx_hash)
    WHERE source_chain = 'ethereum'
    UNION
    SELECT
    a.source_chain as network_in,
    a.destination_chain as network_out,
    b.symbol_in,
    b.symbol_out,
    b.platform,
    a.amount,
    c.gas_used
    QueryRunArchived: QueryRun has been archived