Query editor
-- Binance Volume CalculationWITH binance_tickers AS (SELECT * FROM (VALUES-- ('BTCFDUSD'),('BNBFDUSD'),('FDUSDUSDT'),('SOLFDUSD'),('DOGEFDUSD'),('XRPFDUSD'),('ETHFDUSD'),('PEPEUSDT'),('SHIBUSDT'),('XRPTRY'),-- ('USDTTRY'), ('ETHBTC'), ('THETRY'),('WBTCBTC'),('SOLBTC'), ('DOGEBTC'),('BTCUSDC'), ('XRPBTC'),('BONKUSDT'),('FLOKIUSDT'),-- ('ADAUSDC'),('GFTUSDT'),('XRPUSDT'), ('ETHUSDT'), ('BTCUSDT'),('DOGEUSDT'), ('USDCUSDT'), ('SOLUSDT'), ('ENSUSDT'),('ADAUSDT'), ('ACTUSDT'), ('XLMUSDT'),('WLDUSDT'), ('BNBUSDT'), ('THEUSDT'), ('ALGOUSDT'),('PNUTUSDT'), ('FETUSDT'), ('HBARUSDT'),('DOTUSDT'), ('FILUSDT'), ('ETHUSDC'),('THETAUSDT'), ('SUIUSDT'), ('XRPUSDC'),('AVAXUSDT'), ('ARBUSDT'), ('NEARUSDT'), ('SANDUSDT'),('FIDAUSDT'), ('ORDIUSDT'), ('TIAUSDT'), ('CRVUSDT'), ('NEIROUSDT'),('ENAUSDT'), ('LINKUSDT'), ('UNIUSDT'), ('FTMUSDT'), ('TAOUSDT'),('DGBUSDT'), ('LTCUSDT'), ('RUNEUSDT'), ('GALAUSDT'), ('WIFUSDT'),('1000SATSUSDT'), ('ARUSDT'), ('SEIUSDT'), ('XTZUSDT'), ('ETCUSDT'),('BCHUSDT'), ('APTUSDT'), ('ETHFIUSDT'),('EOSUSDT'), ('TONUSDT'), ('OPUSDT'), ('BOMEUSDT'),('TRXUSDT'), ('POLUSDT'), ('SSVUSDT'), ('RENDERUSDT'),('LUNAUSDT'), ('ICPUSDT'), ('ARKMUSDT'), ('AAVEUSDT'), ('EIGENUSDT'),('STRKUSDT'), ('TRBUSDT'), ('RENUSDT'), ('OMUSDT'), ('DOGSUSDT'),('VETUSDT'), ('HOTUSDT'),('IOUSDT'), ('NOTUSDT'), ('ONEUSDT'),('DEGOUSDT'), ('GRTUSDT'), ('INJUSDT'), ('SOLUSDC'), ('ATOMUSDT')) AS t(symbol)),binance_api_responses AS (SELECTsymbol,json_parse(http_get(concat('https://fapi.binance.com/fapi/v1/klines?symbol=', symbol, '&interval=1d&limit=1000'))) AS klines_dataFROM binance_tickers),binance_data AS (SELECTDATE_TRUNC('week', from_unixtime(CAST(json_extract_scalar(kline, '$[0]') AS bigint) / 1000)) AS week,SUM(CAST(json_extract_scalar(kline, '$[5]') AS double) * CAST(json_extract_scalar(kline, '$[1]') AS double)) AS weekly_volumeFROM binance_api_responsesCROSS JOIN UNNEST(CAST(klines_data AS array(json))) AS t(kline)WHERE EXTRACT(YEAR FROM from_unixtime(CAST(json_extract_scalar(kline, '$[0]') AS bigint) / 1000)) IN (2024, 2025)GROUP BY DATE_TRUNC('week', from_unixtime(CAST(json_extract_scalar(kline, '$[0]') AS bigint) / 1000))),-- Hyperliquid Volume Calculationjson_data AS (SELECT json_parse(http_get('https://api.llama.fi/overview/derivatives')) AS parsed_data),total_data_chart_breakdown AS (SELECT json_extract(parsed_data, '$.totalDataChartBreakdown') AS breakdown_arrayFROM json_data),unnested_data AS (SELECTfrom_unixtime(CAST(json_extract_scalar(item, '$[0]') AS bigint)) AS day,json_extract(item, '$[1]') AS product_volumes_jsonFROM total_data_chart_breakdownCROSS JOIN UNNEST(CAST(json_extract(breakdown_array, '$') AS array(json))) AS t(item)),expanded_data AS (SELECT