Query editor
WITH safe_txs AS (SELECTblockchain,block_date,address,tx_hashFROM safe.transactions_allunion allselect'polygon' as blockchain,date_trunc('day', block_time) as block_date,address,tx_hashfrom dune.safe.result_partner_transactionswhere partner = 'polymarket')SELECTblockchain,TRY_CAST (DATE_TRUNC('week', block_date) AS DATE) AS week,count(distinct address) as active_safes,COUNT(*) AS num_txsFROM safe_txsWHERE block_date >= (CURRENT_DATE - INTERVAL '12' month)GROUP BY 1, 2ORDER BY 1, 2