Moesquid comp 1
    Updated 2024-07-06
    with squid as (
    SELECT
    block_timestamp,
    tx_hash,
    source_chain,
    sender,
    destination_chain,
    token_symbol,
    amount
    from
    axelar.defi.ez_bridge_squid
    ),
    debut as (
    select
    min(block_timestamp) as debut
    from
    axelar.defi.ez_bridge_squid
    ),
    total as (
    select
    'Squid' as bridge,
    *
    from
    squid
    ),
    prices as (
    select
    trunc(recorded_hour, 'day') as day,
    symbol,
    avg(price) as price_usd
    from
    osmosis.price.ez_prices
    group by
    1,
    2
    ),
    QueryRunArchived: QueryRun has been archived