Query editor
-- =================================================================-- ANALISI: dbo.hyperoute_USD₮0_Strategy-TVL-- =================================================================-- DESCRIZIONE: Calcola il saldo storico cumulativo per ciascuna strategia,-- utilizzando la vista unificata `vw.hyperoute_transactions_unified` come fonte.-- =================================================================SELECTT.block_time,T.strategy_name,T.amount,-- Calcolo del totale progressivo (saldo cumulativo) in modo efficienteSUM(T.amount) OVER (PARTITION BY T.strategy_name ORDER BY T.block_time ASC, T.tx_hash ASC) AS cumulative_balanceFROM query_5741394 AS TWHERE strategy_name = 'USD₮0 Strategy'ORDER BYT.strategy_name,T.block_time;