Query editor
WITH safe_txs AS (SELECT blockchain, block_date, address, tx_hashFROM safe_arbitrum.transactionsWHERE block_date >= DATE '2024-01-01'UNION ALLSELECT blockchain, block_date, address, tx_hashFROM safe_avalanche_c.transactionsWHERE block_date >= DATE '2024-01-01'UNION ALLSELECT blockchain, block_date, address, tx_hashFROM safe_base.transactionsWHERE block_date >= DATE '2024-01-01'UNION ALLSELECT blockchain, block_date, address, tx_hashFROM safe_blast.transactionsWHERE block_date >= DATE '2024-01-01'UNION ALLSELECT blockchain, block_date, address, tx_hashFROM safe_bnb.transactionsWHERE block_date >= DATE '2024-01-01'UNION ALLSELECT blockchain, block_date, cast(address as varbinary), cast(tx_hash as varbinary)FROM safe_celo.transactionsWHERE block_date >= DATE '2024-01-01'UNION ALLSELECT blockchain, block_date, address, tx_hashFROM safe_ethereum.transactionsWHERE block_date >= DATE '2024-01-01'UNION ALLSELECT blockchain, block_date, address, tx_hashFROM safe_fantom.transactionsWHERE block_date >= DATE '2024-01-01'UNION ALLSELECT blockchain, block_date, address, tx_hashFROM safe_gnosis.transactionsWHERE block_date >= DATE '2024-01-01'UNION ALLSELECT blockchain, block_date, address, tx_hashFROM safe.transactionsWHERE block_date >= DATE '2024-01-01'UNION ALLSELECT blockchain, block_date, address, tx_hashFROM safe_linea.transactionsWHERE block_date >= DATE '2024-01-01'UNION ALLSELECT blockchain, block_date, address, tx_hashFROM safe_mantle.transactionsWHERE block_date >= DATE '2024-01-01'UNION ALLSELECT blockchain, block_date, address, tx_hashFROM safe_optimism.transactionsWHERE block_date >= DATE '2024-01-01'UNION ALLSELECT blockchain, block_date, address, tx_hashFROM safe_polygon.transactionsWHERE block_date >= DATE '2024-01-01'UNION ALLSELECT blockchain, block_date, address, tx_hashFROM safe_scroll.transactionsWHERE block_date >= DATE '2024-01-01'