SELECT

swaps.token0_symbol AS asset_symbol,

SUM(swaps.amount0_adjusted) AS total_asset_quantity_traded,

AVG(prices.price) AS avg_market_price,

AVG(swaps.price_1_0) AS avg_amm_price,

SUM(swaps.amount0_adjusted * (prices.price - swaps.price_1_0)) AS total_LVR

FROM

ethereum.uniswapv3.ez_swaps swaps

JOIN

crosschain.price.ez_prices_hourly AS prices

ON

swaps.token0_address = prices.token_address

AND swaps.blockchain = prices.blockchain

AND DATE_TRUNC('hour', swaps.block_timestamp) = prices.hour

GROUP BY

swaps.token0_symbol

LIMIT 100;