DATE_TRUNC('day', BLOCK_TIMESTAMP) AS dt,

SUM(GAS_USED) AS GAS_USED

ethereum.core.fact_transactions

TO_ADDRESS = '0x4c6f947Ae67F572afa4ae0730947DE7C874F95Ef' -- Arbitrum: Sequencer Inbox

OR TO_ADDRESS = '0x51de512aa5dfb02143a91c6f772261623ae64564' -- Arbitrum: Validator1

OR TO_ADDRESS = '0x1c479675ad559DC151F6Ec7ed3FbF8ceE79582B6' -- Arbitrum: Sequencer Inbox NITRO

OR TO_ADDRESS = '0x72Ce9c846789fdB6fC1f34aC4AD25Dd9ef7031ef' -- Arbitrum: Gateway Router

OR TO_ADDRESS = '0x4BF681894abEc828B212C906082B444Ceb2f6cf6' -- Optimism: OVM Canonical Transaction Chain OLD

OR TO_ADDRESS = '0x5E4e65926BA27467555EB562121fac00D24E9dD2' -- Optimism: OVM Canonical Transaction Chain NEW

OR TO_ADDRESS = '0xBe5dAb4A2e9cd0F27300dB4aB94BeE3A233AEB19' -- Optimism: OVM State Commitment Chain New

OR TO_ADDRESS = '0x0d62bac5c346c78DC1b27107CAbC5F4DE057a830' -- dydx: Merkle Statement

OR TO_ADDRESS = '0xD54f502e184B6B739d7D27a6410a67dc462D69c8' -- dYdX: L2 Perpetual Smart Contract

OR TO_ADDRESS = '0xC8c212f11f6ACca77A7afeB7282dEBa5530eb46C' -- dydx: GPS Statement Verifier

OR TO_ADDRESS = '0xEfbCcE4659db72eC6897F46783303708cf9ACef8' -- dYdX: Memory Page Fact Registry

OR TO_ADDRESS = '0xf6b83CcaDeee478FC372AF6ca7069b14FBc5E1B1' -- dydx: FRI Statement

Or TO_ADDRESS = '0x2cAbD63F6f28b493f33D13E34060f0959F3570aE' -- Sorare: Statement contract

Or TO_ADDRESS = '0x6dE5bDC580f55Bc9dAcaFCB67b91674040A247e3' -- ZkSwap: ZkSwap Bridge

OR TO_ADDRESS = '0x5CDAF83E077DBaC2692b5864CA18b61d67453Be8' -- ZkSwap: ZkSwap Space Contract

Or TO_ADDRESS = '0x5d22045DAcEAB03B158031eCB7D9d06Fad24609b' -- DiversiFi: Bridge Contract

Or TO_ADDRESS = '0x737901bea3eeb88459df9ef1BE8fF3Ae1B42A2ba' -- Aztec : Private Bridge

Or TO_ADDRESS = '0xA68D85dF56E733A06443306A095646317B5Fa633' -- PolygonHermez : Polygon Hermez Contract

Or TO_ADDRESS = '0xabea9132b05a70803a4e85094fd0e1800777fbef' -- ZkSync: ZkSync Contract

OR TO_ADDRESS = '0x18c208921F7a741510a7fc0CfA51E941735DAE54' -- ZkSync: ZkSync New Operetor

OR TO_ADDRESS = '0xda7357bBCe5e8C616Bc7B0C3C86f0C71c5b4EaBb' -- ZkSync: ZkSync Old Operator

Or TO_ADDRESS = '0x153CdDD727e407Cb951f728F24bEB9A5FaaA8512' -- Loopring: Attestation contract (+withdrawal)

Or TO_ADDRESS = '0x5FDCCA53617f4d2b9134B29090C87D01058e27e9' -- ImmutableX: Bridge (update state + deposit +withdrawal)

Or TO_ADDRESS = '0x17834b754e2f09946CE48D7B5beB4D7D94D98aB6' -- Boba Network: OVM_StateCommitmentChain (Old)

Or TO_ADDRESS = '0xfBd2541e316948B259264c02f370eD088E04c3Db' -- Boba Network: OVM Sequencer

Or TO_ADDRESS = '0x56a76bcC92361f6DF8D75476feD8843EdC70e1C9' -- Metis Andromeda: OVM Canonical Transaction Chain

OR TO_ADDRESS = '0xf209815E595Cdf3ed0aAF9665b1772e608AB9380' -- Metis Andromeda: OVM State Commitment Chain

OR TO_ADDRESS = '0x2C169DFe5fBbA12957Bdd0Ba47d9CEDbFE260CA7' -- StarkNet: Operator

OR TO_ADDRESS = '0xc662c410C0ECf747543f5bA90660f6ABeBD9C8c4' -- StarkNet: Core Contract

OR TO_ADDRESS = '0x96375087b2F6eFc59e5e0dd5111B4d090EBFDD8B' -- StarkNet: Memory Page Fact Registry