SELECT

day,

daily_tvl AS OP_daily_TVL,

SUM(daily_tvl) OVER (ORDER BY day ASC) AS OP_cumulative_TVL

FROM (

SELECT

DATE_TRUNC('day', block_timestamp) AS day,

COALESCE(SUM(value),0) AS daily_tvl

FROM

optimism.core.fact_transactions

WHERE

to_address = '0xaaa687e218f9b53183a6aa9639fbd9d6e69ecb73'

AND status = 'SUCCESS'

GROUP BY

day

)

ORDER BY

day DESC

),

arbitrum_tvl AS (

SELECT

day,

daily_tvl AS ARB_daily_TVL,

SUM(daily_tvl) OVER (ORDER BY day ASC) AS ARB_cumulative_TVL

FROM (

SELECT

DATE_TRUNC('day', block_timestamp) AS day,

SUM(value) AS daily_tvl

FROM

arbitrum.core.fact_transactions

WHERE

to_address = '0x376a7564af88242d6b8598a5cfdd2e9759711b61'

AND status = 'SUCCESS'

GROUP BY

day