rackhaelAxellar source chain info
    Updated 2023-04-20
    WITH satellite_bridge AS (
    SELECT block_timestamp,
    tx_hash,
    source_chain,
    sender,
    destination_chain,
    token_symbol,
    amount
    FROM axelar.core.ez_satellite
    ),
    prices AS (
    SELECT trunc(recorded_hour, 'day') AS day,
    symbol,
    avg(price) AS price_USD
    FROM osmosis.core.ez_prices
    GROUP BY 1, 2
    ),
    both AS (
    SELECT trunc(block_timestamp, 'day') as date,
    source_chain,
    count(DISTINCT tx_hash) AS txns,
    count(DISTINCT sender) AS users,
    sum(amount * price_USD) AS USD_vol
    FROM satellite_bridge
    JOIN prices p ON trunc(satellite_bridge.block_timestamp, 'day') = p.day
    AND satellite_bridge.token_symbol = p.symbol
    WHERE amount * price_USD < 1e6
    GROUP BY 1, 2
    )
    SELECT * FROM both;

    Run a query to Download Data