Query editor
WITHsource_mapping AS (SELECT * FROM query_4899866),woofi_source_mapping AS (SELECT * FROM query_4968407),_window AS (SELECTdate_trunc('day', current_date) - INTERVAL '1' month - INTERVAL '1' day AS start_ts,current_timestamp AS end_ts),wooswap_src AS (SELECT evt_block_time, evt_tx_hash, evt_tx_to, rebateTo, 'arb' AS chain, swapVolFROM woofi_arbitrum.wooppv2_evt_wooswapUNION ALLSELECT evt_block_time, evt_tx_hash, evt_tx_to, rebateTo, 'base' AS chain, swapVolFROM woofi_base.wooppv2_evt_wooswapUNION ALLSELECT evt_block_time, evt_tx_hash, evt_tx_to, rebateTo, chain, swapVolFROM woofi_multichain.wooppv2_evt_wooswap),chain_map AS (SELECT * FROM (VALUES('arbitrum','arb'),('base','base'),('bsc','bnb'),('sonic','sonic'),('avalanche_c','avalanche_c'),('linea','linea'),('mantle','mantle'),('polygon','polygon'),('berachain','berachain'),('optimism','optimism'),('hyperevm','hyperevm'),('monad', 'monad')) AS t(src, dst)),builders_tx AS (SELECT DISTINCTcm.dst AS chain,e.evt_tx_hash AS tx_hashFROM woofi_multichain.woofiwidgetrouter_evt_brokerswap eJOIN chain_map cmON cm.src = e.chainJOIN _window wON e.evt_block_time BETWEEN w.start_ts AND w.end_tsWHERE ( cm.dst = lower('{{chain}}') OR lower('{{chain}}') = 'all' )),builders_swaps AS (SELECTdate_trunc('day', w.evt_block_time) AS evt_date,'builders' AS source,SUM(w.swapVol /CASE WHEN w.chain='bnb' THEN 1e18 ELSE 1e6 END) AS swapVol_sumFROM wooswap_src wJOIN builders_tx btON bt.tx_hash = w.evt_tx_hashAND bt.chain = w.chain