Query editor
with categories as (SELECT SPLIT_PART(labels, ',', 1) as category, CAST(token0 AS VARCHAR) as token FROM dune.opinionlabs.opinion_markets_metadata_56 aINNER JOIN opinion_bnb.ctfexecutionengine_evt_tokenregistered bON ('0x' || a.condition_Id) = CAST(b.conditionId AS VARCHAR))SELECT "Day", SUM("Volume") as "Notional Volume", category as "Category" FROM (SELECT DATE_TRUNC('day', evt_block_time) as "Day",CASEWHEN CAST(makerAssetId AS VARCHAR) = '0' THEN CAST(takerAmountFilled/2 AS DOUBLE) / 1e18WHEN CAST(takerAssetId AS VARCHAR) = '0' THEN CAST(makerAmountFilled/2 AS DOUBLE) / 1e18END AS "Volume",categoryFROM opinion_bnb.ctfexecutionengine_evt_orderfilled aINNER JOIN categories c ON CAST(a.makerAssetId AS VARCHAR) = c.tokenUNION ALLSELECT DATE_TRUNC('day', evt_block_time) as "Day",CASEWHEN CAST(makerAssetId AS VARCHAR) = '0' THEN CAST(takerAmountFilled/2 AS DOUBLE) / 1e18WHEN CAST(takerAssetId AS VARCHAR) = '0' THEN CAST(makerAmountFilled/2 AS DOUBLE) / 1e18END AS "Volume",categoryFROM opinion_bnb.ctfexecutionengine_evt_orderfilled aINNER JOIN categories c ON CAST(a.takerAssetId AS VARCHAR) = c.token)GROUP BY 1,3