Query editor
WITH raw AS (SELECTCASEWHEN "from" = 0x0000000000000000000000000000000000000000 THEN value/1e18WHEN "to" = 0x0000000000000000000000000000000000000000 THEN -value/1e18ELSE 0END AS value_change,evt_block_time,evt_tx_hash,DATE(evt_block_time) AS staking_dayFROM erc20_hyperevm.evt_TransferWHERE contract_address = 0xdAbB040c428436d41CECd0Fb06bCFDBAaD3a9AA8AND ("from" = 0x0000000000000000000000000000000000000000 OR "to" = 0x0000000000000000000000000000000000000000)),daily_net_staked AS (SELECTstaking_day,SUM(value_change) AS daily_net_stakedFROM rawGROUP BY staking_day),total_net_staked AS (SELECTstaking_day,SUM(daily_net_staked) OVER (ORDER BY staking_day) AS total_net_stakedFROM daily_net_staked),price AS (SELECTMAX_BY(price, timestamp) AS price_usd,MAX(timestamp) AS price_tsFROM prices.hourWHERE blockchain = 'hyperevm'AND symbol = 'HYPE'AND price > 0AND timestamp >= (NOW() - INTERVAL '1' DAY))SELECTd.staking_day,d.daily_net_staked,t.total_net_staked,d.daily_net_staked *p.price_usd as daily_net_staked_usd,t.total_net_staked*p.price_usd as TVL_USDFROM daily_net_staked dJOIN total_net_staked t ON d.staking_day = t.staking_dayJOIN price p on 1=1ORDER BY d.staking_day DESC;