Query editor
with myriad as (with trades as (SELECT evt_block_time, evt_tx_hash, contract_address, action, marketId, shares, 'abstract' as chain FROM myriad_abstract.predictionmarketv3_evt_marketactiontxWHERE action IN (0,1)UNION ALLSELECT evt_block_time, evt_tx_hash, contract_address, action, marketId, shares, chain FROM myriad_multichain.predictionmarketv3_4_evt_marketactiontxWHERE action IN (0,1)UNION ALLSELECT evt_block_time, evt_tx_hash, contract_address, action, marketId, shares, 'abstract' as chain FROM myriad_abstract.predictionmarketv3_3_points_evt_marketactiontxWHERE action IN (0,1)UNION ALLSELECT evt_block_time, evt_tx_hash, contract_address, action, marketId, shares, 'abstract' as chain FROM myriad_abstract.predictionmarketv4_evt_marketactiontxWHERE action IN (0,1)),markets as (SELECT * FROM query_5971135)SELECT date_trunc('month', evt_block_time) as month,SUM(shares*price/POW(10, decimals)) as "Notional Volume"FROM trades tRIGHT JOIN markets m ON t.contract_address = m.contract_address AND t.marketId = m.marketIdLEFT JOIN prices.usd p ON m.token = CAST(p.contract_address AS VARCHAR) AND t.chain = p.blockchain AND DATE_TRUNC('minute', t.evt_block_time) = p.minuteWHERE p.blockchain IN ('abstract', 'linea', 'bnb')GROUP BY 1),limitless as (with amm as (WITH markets as (SELECTfixedProductMarketMaker AS market_address, collateralToken AS collateralFROM limitless_base.FixedProductMarketMakerFactory_evt_FixedProductMarketMakerCreationUNION ALLSELECTfixedProductMarketMaker AS market_address, collateralToken AS collateralFROM limitless_exchange_prod_hanson_v0_1_base.FixedProductMarketMakerFactory_evt_FixedProductMarketMakerCreation),collaterals AS (SELECT minute, contract_address, decimals, AVG(price) as priceFROM prices.usdWHERE blockchain = 'base'and contract_address IN (SELECT collateral FROM markets)GROUP BY 1,2,3),dexprices as (SELECT block_date, AVG(price) as price, address,CASEWHEN address = 0xcd2f22236dd9dfe2356d7c543161d4d260fd9bcb THEN 18WHEN address = 0x490a4b510d0ea9f835d2df29eb73b4fca5071937 THEN 18WHEN address = 0xfef2d7b013b88fec2bfe4d2fee0aeb719af73481 THEN 18WHEN address = 0x4e65fe4dba92790696d040ac24aa414708f5c0ab THEN 6END AS decimalsFROM (SELECT block_date, amount_usd/token_bought_amount as price, token_bought_address as address FROM dex.tradesWHERE token_bought_address IN (0xfef2d7b013b88fec2bfe4d2fee0aeb719af73481, 0x4e65fe4dba92790696d040ac24aa414708f5c0ab, 0xcd2f22236dd9dfe2356d7c543161d4d260fd9bcb, 0x490a4b510d0ea9f835d2df29eb73b4fca5071937)AND blockchain = 'base'