Query editor
SELECTa.date, a.eth_plus_tvl-b.eth_plus_tvl AS "ETH+ Mainnet TVL", --updateb.eth_plus_tvl AS "ETH+ Arbitrum TVL",c.usd3_tvl-d.usd3_tvl AS "USD3 Mainnet TVL", --updated.usd3_tvl AS "USD3 Base TVL",e.eusd_tvl AS "eUSD Base TVL",f.eusd_tvl-g.eusd_tvl-e.eusd_tvl AS "eUSD Mainnet TVL", --updateg.eusd_tvl AS "eUSD Arbitrum TVL",h.bsdeth_tvl AS "bsdETH Base TVL",i.dgneth_tvl AS "dgnETH Mainnet TVL",j.hyusd_tvl-k.hyusd_tvl AS "hyUSD Mainnet TVL", --updatek.hyusd_tvl AS "hyUSD Base TVL",--All RToken TVLCOALESCE(a.eth_plus_tvl-b.eth_plus_tvl,0) + COALESCE(b.eth_plus_tvl, 0) + COALESCE(c.usd3_tvl-d.usd3_tvl, 0) + COALESCE(d.usd3_tvl, 0) +COALESCE(e.eusd_tvl, 0) + COALESCE(f.eusd_tvl-g.eusd_tvl-e.eusd_tvl, 0) + COALESCE(g.eusd_tvl, 0) + COALESCE(h.bsdeth_tvl, 0) +COALESCE(i.dgneth_tvl, 0) + COALESCE(j.hyusd_tvl-k.hyusd_tvl, 0) + COALESCE(k.hyusd_tvl, 0) AS "Total RToken TVL",--RTokens Broken Down by TokenCOALESCE(a.eth_plus_tvl-b.eth_plus_tvl,0) + COALESCE(b.eth_plus_tvl, 0) AS "ETH+ TVL",COALESCE(c.usd3_tvl-d.usd3_tvl, 0) + COALESCE(d.usd3_tvl, 0) AS "USD3 TVL",COALESCE(e.eusd_tvl, 0) + COALESCE(f.eusd_tvl-g.eusd_tvl-e.eusd_tvl, 0) + COALESCE(g.eusd_tvl, 0) AS "eUSD TVL",COALESCE(j.hyusd_tvl-k.hyusd_tvl, 0) + COALESCE(k.hyusd_tvl, 0) AS "hyUSD TVL",--RTokens Broken Down by ChainCOALESCE(a.eth_plus_tvl-b.eth_plus_tvl,0) + COALESCE(c.usd3_tvl-d.usd3_tvl, 0) + COALESCE(f.eusd_tvl-g.eusd_tvl-e.eusd_tvl, 0) + COALESCE(i.dgneth_tvl, 0) + COALESCE(j.hyusd_tvl-k.hyusd_tvl, 0) AS "Mainnet TVL",COALESCE(d.usd3_tvl, 0) + COALESCE(e.eusd_tvl, 0) + COALESCE(h.bsdeth_tvl, 0) + COALESCE(k.hyusd_tvl, 0) AS "Base TVL",COALESCE(b.eth_plus_tvl, 0) + COALESCE(g.eusd_tvl, 0) AS "Arbitrum TVL"from query_4399431 a -- ETH+ MainnetLEFT JOIN query_4399461 b ON a.date = b.date --ETH+ ArbitrumLEFT JOIN query_4399552 c ON a.date = c.date --USD3 MainnetLEFT JOIN query_4416472 d ON a.date = d.date --USD3 BaseLEFT JOIN query_4416830 e ON a.date = e.date --eUSD BaseLEFT JOIN query_4416870 f ON a.date = f.date --eUSD MainnetLEFT JOIN query_4416921 g ON a.date = g.date --eUSD ArbitrumLEFT JOIN query_4416942 h ON a.date = h.date --bsdETH BaseLEFT JOIN query_4417189 i ON a.date = i.date --dgnETH MainnetLEFT JOIN query_4417379 j ON a.date = j.last_update_time --hyUSD MainnetLEFT JOIN query_4417515 k ON a.date = k.last_update_time --hyUSD BaseORDER BY a.date DESC;