hess2. Total Volume
    Updated 2023-03-10
    select 'Arbitrum' as chain, count(DISTINCT(tx_hash)) as total_tx, count(DISTINCT(origin_from_address)) as total_user,
    sum(amount_in_usd) as volume, avg(amount_in_usd) as avg_usd
    from arbitrum.sushi.ez_swaps
    where block_timestamp >= CURRENT_DATE - 180
    and (AMOUNT_IN_USD between AMOUNT_OUT_USD - 1000 and AMOUNT_OUT_USD + 1000)

    group by 1
    UNION
    select 'Polygon' as chain,count(DISTINCT(tx_hash)) as total_tx, count(DISTINCT(origin_from_address)) as total_user,
    sum(amount_in_usd) as volume, avg(amount_in_usd) as avg_usd
    from polygon.sushi.ez_swaps
    where block_timestamp >= CURRENT_DATE - 180
    and (AMOUNT_IN_USD between AMOUNT_OUT_USD - 1000 and AMOUNT_OUT_USD + 1000)

    group by 1
    UNION
    select 'Avalanche' as chain, count(DISTINCT(tx_hash)) as total_tx, count(DISTINCT(origin_from_address)) as total_user,
    sum(amount_in_usd) as volume, avg(amount_in_usd) as avg_usd
    from Avalanche.sushi.ez_swaps
    where block_timestamp >= CURRENT_DATE - 180
    and (AMOUNT_IN_USD between AMOUNT_OUT_USD - 1000 and AMOUNT_OUT_USD + 1000)

    group by 1
    UNION
    select 'Optimism' as chain, count(DISTINCT(tx_hash)) as total_tx, count(DISTINCT(origin_from_address)) as total_user,
    sum(amount_in_usd) as volume, avg(amount_in_usd) as avg_usd
    from optimism.sushi.ez_swaps
    where block_timestamp >= CURRENT_DATE - 180
    and (AMOUNT_IN_USD between AMOUNT_OUT_USD - 1000 and AMOUNT_OUT_USD + 1000)

    group by 1
    UNION
    select 'Ethereum' as chain, count(DISTINCT(tx_hash)) as total_tx, count(DISTINCT(origin_from_address)) as total_user,
    sum(amount_in_usd) as volume, avg(amount_in_usd) as avg_usd
    from ethereum.sushi.ez_swaps
    where block_timestamp >= CURRENT_DATE - 180
    Run a query to Download Data