----------------------- Aave ------------------------- with Aave_Deposited as ( select BLOCK_TIMESTAMP::date as date, sum(ISSUED_TOKENS) as ETH_Deposited, sum(ETH_Deposited) over(order by date) as Cum_ETH_Deposited from ethereum.aave.ez_deposits where BLOCK_TIMESTAMP >= '2022-09-01' and BLOCK_TIMESTAMP < '2022-09-25' and symbol = 'WETH' and ISSUED_TOKENS > 0 group by 1 ), Aave_Withdrawn as ( select BLOCK_TIMESTAMP::date as date, sum(WITHDRAWN_TOKENS) as ETH_Withdrawn, sum(ETH_Withdrawn) over(order by date) as Cum_ETH_Withdrawn from ethereum.aave.ez_withdraws where BLOCK_TIMESTAMP >= '2022-09-01' and BLOCK_TIMESTAMP < '2022-09-25' and symbol = 'WETH' and WITHDRAWN_TOKENS > 0 group by 1 ), Aave as ( select *, ETH_Deposited - ETH_Withdrawn as Net_ETH_Deposit, avg(Net_ETH_Deposit) over(order by d.date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as Seven_D_Moving_Average, sum(Net_ETH_Deposit) over(order by d.date) as Cum_Net_ETH_Deposited, 'Aave' as Porotocol, case when d.date < '2022-09-15' and d.date >= '2022-09-01' then 'Before Merge' when d.date = '2022-09-15' then 'Merge Day' when d.date > '2022-09-15' and d.date <= '2022-09-25' then 'After Merge' end as status from Aave_Deposited d join Aave_Withdrawn w on d.date = w.date ), ----------------------- Maker ------------------------- Maker_Deposited as ( select BLOCK_TIMESTAMP::date as date, sum(AMOUNT_DEPOSITED) as ETH_Deposited, sum(ETH_Deposited) over(order by date) as Cum_ETH_Deposited from ethereum.maker.ez_deposits where BLOCK_TIMESTAMP >= '2022-09-01' and BLOCK_TIMESTAMP < '2022-09-25' and symbol = 'WETH' and TX_STATUS = 'SUCCESS' and AMOUNT_DEPOSITED > 0 group by 1 ), Maker_Withdrawn as ( select BLOCK_TIMESTAMP::date as date, sum(AMOUNT_WITHDRAWN) as ETH_Withdrawn, sum(ETH_Withdrawn) over(order by date) as Cum_ETH_Withdrawn from ethereum.maker.ez_withdrawals where BLOCK_TIMESTAMP >= '2022-09-01' and BLOCK_TIMESTAMP < '2022-09-25' and symbol = 'WETH' and TX_STATUS = 'SUCCESS' and AMOUNT_WITHDRAWN > 0 group by 1 ), Maker as ( select *, ETH_Deposited - ETH_Withdrawn as Net_ETH_Deposit, avg(Net_ETH_Deposit) over(order by d.date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as Seven_D_Moving_Average, sum(Net_ETH_Deposit) over(order by d.date) as Cum_Net_ETH_Deposited, 'Maker' as Porotocol, case when d.date < '2022-09-15' and d.date >= '2022-09-01' then 'Before Merge' when d.date = '2022-09-15' then 'Merge Day' when d.date > '2022-09-15' and d.date <= '2022-09-25' then 'After Merge' end as status from Maker_Deposited d join Maker_Withdrawn w on d.date = w.date ), ----------------------- Uniswap v3 ------------------------- Uniswap_tab_1 as ( select BLOCK_TIMESTAMP, TX_HASH, ACTION, LIQUIDITY_PROVIDER, POOL_NAME, case when TOKEN0_SYMBOL = 'WETH' then AMOUNT0_ADJUSTED when TOKEN1_SYMBOL = 'WETH' then AMOUNT1_ADJUSTED end as ETH from ethereum.uniswapv3.ez_lp_actions where (TOKEN0_SYMBOL = 'WETH' or TOKEN1_SYMBOL = 'WETH') and BLOCK_TIMESTAMP >= '2022-09-01' and BLOCK_TIMESTAMP < '2022-09-25' and ETH > 0 ), Uniswap_Deposited as ( select BLOCK_TIMESTAMP::date as date, sum(ETH) as ETH_Deposited, sum(ETH_Deposited) over(order by date) as Cum_ETH__Deposited from Uniswap_tab_1 where ACTION = 'INCREASE_LIQUIDITY' group by 1 ), Uniswap_Withdrawn as ( select BLOCK_TIMESTAMP::date as date, sum(ETH) as ETH_withdrawn, sum(ETH_withdrawn) over(order by date) as Cum_ETH_withdrawn from Uniswap_tab_1 where ACTION = 'DECREASE_LIQUIDITY' group by 1 ), Uniswap as ( select *, ETH_Deposited - ETH_withdrawn as Net_ETH_Deposit, avg(Net_ETH_Deposit) over(order by d.date ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as Seven_D_Moving_Average, sum(Net_ETH_Deposit) over(order by d.date) as Cum_Net_ETH_Deposited, 'Uniswapv3' as Porotocol, case when d.date < '2022-09-15' and d.date >= '2022-09-01' then 'Before Merge' when d.date = '2022-09-15' then 'Merge Day' when d.date > '2022-09-15' and d.date <= '2022-09-25' then 'After Merge' end as status from Uniswap_Deposited d join Uniswap_Withdrawn w on d.date = w.date ) /*select Maker.date as date_, Uniswap.Net_ETH_Deposit + Maker.Net_ETH_Deposit + Aave.Net_ETH_Deposit as "Net ETH Deposited", avg("Net ETH Deposited") over(order by date_ ROWS BETWEEN 7 PRECEDING AND CURRENT ROW) as "7D Moving Average", Uniswap.ETH_Deposited + Maker.ETH_Deposited + Aave.ETH_Deposited as Deposition, Uniswap.ETH_withdrawn + Maker.ETH_withdrawn + Aave.ETH_withdrawn as withdrawal from Uniswap u join Maker m on u.date = m.date join Aave a on u.date = a.date */ select * from Aave union ALL select * from Maker union ALL select * from Uniswap

Flash Bounty: Post Merge Behavior