Query editor
WITH-- 获取Hyperliquid代币的每日收盘价price_data_raw AS (SELECT json_parse(http_get('https://api.coingecko.com/api/v3/coins/hyperliquid/market_chart/range?vs_currency=usd&from=1730313600&to=1763462399')) AS data),price_data AS (SELECTCAST(json_extract_scalar(price_item, '$[0]') AS bigint) AS timestamp_ms,CAST(json_extract_scalar(price_item, '$[1]') AS double) AS hype_price_usdFROM price_data_raw,UNNEST(CAST(json_extract(data, '$.prices') AS array(json))) AS t(price_item)),daily_closing_prices AS (SELECTCAST(from_unixtime(timestamp_ms / 1000) AS date) AS price_date,hype_price_usd,ROW_NUMBER() OVER (PARTITION BY CAST(from_unixtime(timestamp_ms / 1000) AS date) ORDER BY timestamp_ms DESC) AS rnFROM price_data),closing_prices AS (SELECTprice_date,hype_price_usdFROM daily_closing_pricesWHERE rn = 1),-- 资金流动数据daily_flows AS (SELECTDATE_TRUNC('day', evt_block_time) AS date,-- 每日净转入(正值)SUM(CASE WHEN "to" = 0x2Df1c51E09aECF9cacB7bc98cB1742757f163dF7THEN value / 1e6 ELSE 0 END) AS daily_inflow,-- 每日净转出(负值)-SUM(CASE WHEN "from" = 0x2Df1c51E09aECF9cacB7bc98cB1742757f163dF7THEN value / 1e6 ELSE 0 END) AS daily_outflow,-- 每日净流量(转入 + 转出)SUM(CASE WHEN "to" = 0x2Df1c51E09aECF9cacB7bc98cB1742757f163dF7THEN value / 1e6WHEN "from" = 0x2Df1c51E09aECF9cacB7bc98cB1742757f163dF7THEN -value / 1e6ELSE 0 END) AS daily_net_flow,-- 累计净流入总量SUM(SUM(CASE WHEN "to" = 0x2Df1c51E09aECF9cacB7bc98cB1742757f163dF7THEN value / 1e6WHEN "from" = 0x2Df1c51E09aECF9cacB7bc98cB1742757f163dF7THEN -value / 1e6ELSE 0 END))OVER (ORDER BY DATE_TRUNC('day', evt_block_time)) AS cumulative_amountFROM erc20_arbitrum.evt_transferWHEREcontract_address = 0xaf88d065e77c8cC2239327C5EDb3A432268e5831