Query editor
-- Hourly prices for held DeFi portfolio tokens (parameterized).-- Date range comes from {{start_ts}} / {{end_ts}} so the same query handles-- both bulk backfill and incremental hourly deltas.WITH ranked AS (SELECTtimestamp,symbol,blockchain,price,contract_address_varchar AS contract_address,source,ROW_NUMBER() OVER (PARTITION BY symbol, timestampORDER BYCASE blockchainWHEN 'ethereum' THEN 0WHEN 'base' THEN 1WHEN 'arbitrum' THEN 2WHEN 'optimism' THEN 3WHEN 'polygon' THEN 4ELSE 5END,source) AS rkFROM prices.hourWHERE timestamp >= TRY_CAST('{{start_ts}}' AS TIMESTAMP)AND timestamp < TRY_CAST('{{end_ts}}' AS TIMESTAMP)AND blockchain IN ('ethereum','base','arbitrum','optimism','polygon')AND UPPER(symbol) IN (-- ETH-correlated (revalues linearly with ETH spot)'ETH','WETH','WSTETH','WEETH','CBETH','RETH','SWETH',-- BTC-correlated'BTC','WBTC','CBBTC','TBTC',-- Held alts'LINK','RENDER','RNDR','ETHFI','HYPE','DRV','FET','AAVE','UNI','OP','ARB','PUMP','MORPHO','PENDLE','POL','MNT','PUFFER','RESOLV','SWELL','VVV','AERO','VIRTUAL','KERNEL','REZ','ORBIT','SOLV','SUP','USUAL',-- Stables'USDC','USDT','DAI','FRAX','USDE','SUSDE','SUSDS','GHO','CRVUSD',-- Commodities'PAXG','XAUT'))SELECTtimestamp,symbol,blockchain,price,contract_address,sourceFROM rankedWHERE rk = 1ORDER BY symbol, timestamp DESC