Query editor
-- Derivatives Sector: Hyperliquid + Pendle-- Phase 3 fix: Pendle now uses RouterV4 decoded events + prices.usd for USD conversion-- Tables: routerv4_evt_swapptandtoken (PT swaps) + routerv4_evt_swapytandtoken (YT swaps)-- Chains: ethereum, arbitrum, base, bnbWITH hyperliquid AS (SELECTdt AS block_date,'Hyperliquid' AS protocol,SUM(max_day_vol) AS volume_usd,SUM(max_day_vol) * 0.0002 AS estimated_fees_usd,COUNT(DISTINCT coin) AS active_marketsFROM (SELECTCAST(time AS date) AS dt,coin,MAX(day_ntl_vlm) AS max_day_volFROM hyperliquid.market_dataWHERE coin IN ('BTC','ETH','SOL','ARB','DOGE','WIF','PEPE','SUI','AVAX','LINK','OP','MATIC','APT','SEI','TIA','JUP','WLD','ONDO','NEAR','FTM')AND time >= CURRENT_TIMESTAMP - INTERVAL '90' DAYGROUP BY 1, 2) daily_coinsGROUP BY 1),-- Union all Pendle RouterV4 swap events across chainspendle_raw AS (SELECT evt_block_date AS dt, 'ethereum' AS chain,CAST(evt_tx_from AS varchar) AS user_addr, token,ABS(CAST(netTokenToAccount AS double)) AS raw_amountFROM pendle_ethereum.routerv4_evt_swapptandtokenWHERE evt_block_time >= CURRENT_TIMESTAMP - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'ethereum', CAST(evt_tx_from AS varchar), token,ABS(CAST(netTokenToAccount AS double))FROM pendle_ethereum.routerv4_evt_swapytandtokenWHERE evt_block_time >= CURRENT_TIMESTAMP - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'arbitrum', CAST(evt_tx_from AS varchar), token,ABS(CAST(netTokenToAccount AS double))FROM pendle_arbitrum.routerv4_evt_swapptandtokenWHERE evt_block_time >= CURRENT_TIMESTAMP - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'arbitrum', CAST(evt_tx_from AS varchar), token,ABS(CAST(netTokenToAccount AS double))FROM pendle_arbitrum.routerv4_evt_swapytandtokenWHERE evt_block_time >= CURRENT_TIMESTAMP - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'base', CAST(evt_tx_from AS varchar), token,ABS(CAST(netTokenToAccount AS double))FROM pendle_base.routerv4_evt_swapptandtokenWHERE evt_block_time >= CURRENT_TIMESTAMP - INTERVAL '90' DAYUNION ALLSELECT evt_block_date, 'base', CAST(evt_tx_from AS varchar), token,