Query editor
WITHtxs AS (SELECTblock_time as time,(gas_price * gas_used) / 1e18 as eth_paid_per_tx,block_number,indexFROMethereum.transactionsWHEREto = 0x840C8122433A5AA7ad60C1Bcdc36AB9DcCF761a5 -- validator serviceOR to = 0xbAec960713a6c41d391C93AE42128d72C916965f -- walletsOR to = 0xBC896522b1649dc2e43bC093d08665822529d087 -- sync managerOR (to = 0x13fD1622F0E7e50A87B79cb296cbAf18362631C0 AND "from" != 0xE74ad5437C6CFB0cCD6bADda1F6b57b6E542E75e) -- skale network multisig without skale network deployer txsOR "from" = 0xE74ad5437C6CFB0cCD6bADda1F6b57b6E542E75e -- skale network deployerORDER BYblock_number, index),combined_txs AS (SELECT SUM(eth_paid_per_tx) over (ORDER BY block_number, index) as eth_amount, SUM(eth_paid_per_tx * price) over (ORDER BY block_number, index) as usd_amount FROM txsLEFT JOIN (SELECT minute, price FROM prices.usdWHERE symbol = 'WETH' AND blockchain = 'ethereum'GROUP BY minute, price) as pricesON date_trunc('minute', time) = minuteGROUP BY block_number, index, time, eth_paid_per_tx, eth_paid_per_tx * priceORDER BY time DESCLIMIT 1)SELECT SUM(eth_amount) as eth_amount, SUM(usd_amount) as usd_amount FROM (SELECT * FROM query_2652019 -- delegation controllerUNION ALL SELECT * FROM query_2652020 -- skale managerUNION ALL SELECT * FROM query_2652022 -- skale DKGUNION ALL SELECT * FROM query_2652024 -- distributorUNION ALL SELECT * FROM query_2652025 -- nodesUNION ALL SELECT * FROM query_2652027 -- schainsUNION ALL SELECT * FROM query_2652028 -- skale tokenUNION ALL SELECT * FROM query_2652041 -- token launch managerUNION ALL SELECT * FROM combined_txs -- the rest)