SELECT block_timestamp, contract_address as pool_address, pool_name,

CASE WHEN amount_in_usd > 1.5 * COALESCE(amount_out_usd, 0) THEN 0

ELSE amount_in_usd

END as amount_usd

FROM ethereum.core.ez_dex_swaps

WHERE platform = 'uniswap-v2'

AND pool_name IS NOT NULL

AND amount_in_usd IS NOT NULL

),

vol_num_trades AS (

SELECT DATE_TRUNC('DAY', block_timestamp) as day, SUM(amount_usd) as vol_usd,

COUNT(*) as num_trades

FROM swaps_filtered

GROUP BY day

),

cumulative_vol_num_trades AS (

SELECT day, vol_usd, SUM(vol_usd) OVER (ORDER BY day) as vol_usd_cumulative,

num_trades, SUM(num_trades) OVER (ORDER BY day) as num_trades_cumulative

FROM vol_num_trades

),

fees AS (

SELECT DATE_TRUNC('DAY', block_timestamp) as day, SUM(amount_usd) * .003 as fees_usd

FROM swaps_filtered

GROUP BY day

),

cumulative_fees AS (

SELECT day, fees_usd, SUM(fees_usd) OVER (ORDER BY day) as fees_usd_cumulative

FROM fees

),

cumulative_join AS (