adriaparcerisassquid avalanche sources
    Updated 2023-08-20

    SELECT
    trunc(block_timestamp,'day') as date,
    source_chain,
    count(distinct tx_hash) as actions,
    count(distinct sender) as active_users--,
    --sum(amount) as volume
    from axelar.core.ez_squid x
    where destination_chain='avalanche' and source_chain!='avalanche'
    --join osmosis.core.ez_prices y on x.token_symbol=y.symbol and trunc(x.block_timestamp,'hour')=y.recorded_hour
    group by 1,2
    order by 1 asc


    Run a query to Download Data