flipside

    axelar 5
    mamad-5XN3k3axelar 5
    Updated 2023-10-02
    -- forked from 2023-07-07 03:46 PM @ https://flipsidecrypto.xyz/edit/queries/f875a656-e0e1-4b31-a988-333943b8a0cf

    with pricet as (
    select
    trunc(recorded_hour,'day') as day,
    symbol,
    avg(price) as price_usd
    from osmosis.price.ez_prices
    group by 1,2
    ),

    bridget as (
    SELECT
    block_timestamp,
    tx_hash,
    source_chain,
    sender,
    destination_chain,
    token_symbol,amount
    from axelar.defi.ez_bridge_satellite

    UNION

    SELECT
    block_timestamp,
    tx_hash,
    source_chain,
    sender,
    destination_chain,
    token_symbol,
    amount
    from axelar.defi.ez_bridge_squid)

    SELECT
    trunc(block_timestamp,'day') as date,
    token_symbol,
    Run a query to Download Data