Query editor
WITH prediction AS (SELECT * FROM (VALUES('polymarket', 'Polymarket'),('opinion', 'Opinion'),('kalshi', 'Kalshi'),('football.fun', 'Football.Fun'),('limitless-exchange', 'Limitless Exchange'),('sx-bet', 'SX Bet'),('pancakeswap-prediction', 'PancakeSwap Prediction'),('myriad-markets', 'Myriad Markets'),('alpha-arcade', 'Alpha Arcade'),('ninja-blaze', 'Ninja Blaze'),('gacha', 'Gacha'),('x3x', 'X3X'),('predict-fun', 'Predict Fun'),('probable', 'Probable'),('rain', 'Rain'),('dflow-prediction-market', 'DFlow Prediction Market'),('seer', 'Seer'),('truemarkets', 'Truemarkets')) AS t(slug, Protocol)),raw AS (SELECTslug,Protocol,json_parse(http_get(format('https://api.llama.fi/summary/dexs/%s?excludeTotalDataChart=false&excludeTotalDataChartBreakdown=true&dataType=dailyVolume',slug))) AS jFROM prediction),daily AS (SELECTr.Protocol AS Protocol,CAST(FROM_UNIXTIME(CAST(json_extract_scalar(x, '$[0]') AS bigint)) AS DATE) AS day,CAST(json_extract_scalar(x, '$[1]') AS double) AS volumeFROM raw rCROSS JOIN UNNEST(CAST(json_extract(r.j, '$.totalDataChart') AS array(json))) AS t(x)),monthly AS (SELECTDATE_TRUNC('month', day) AS month,Protocol,SUM(volume) AS volumeFROM daily