Query editor
WITHtotal_eth AS (SELECTDATE_TRUNC('day', block_time) AS day,"to" AS address,value AS valueFROMethereum.tracesWHERENOT "to" IS NULLAND tx_success = TRUEAND (NOT call_type IN ('delegatecall', 'callcode', 'staticcall')OR call_type IS NULL)AND "to" IN (0x12D66f87A04A9E220743712cE6d9bB1B5616B8Fc,0x47CE0C6eD5B0Ce3d3A51fdb1C52DC66a7c3c2936,0x910Cbd523D972eb0a6f4cAe4618aD62622b39DbF,0xA160cdAB225685dA1d56aa342Ad8841c3b53f291)UNION ALLSELECTDATE_TRUNC('day', block_time) AS day,"from" AS address,- value AS valueFROMethereum.tracesWHERENOT "from" IS NULLAND tx_success = TRUEAND (NOT call_type IN ('delegatecall', 'callcode', 'staticcall')OR call_type IS NULL)AND "from" IN (0x12D66f87A04A9E220743712cE6d9bB1B5616B8Fc,0x47CE0C6eD5B0Ce3d3A51fdb1C52DC66a7c3c2936,0x910Cbd523D972eb0a6f4cAe4618aD62622b39DbF,0xA160cdAB225685dA1d56aa342Ad8841c3b53f291)UNION ALLSELECTDATE_TRUNC('day', block_time) AS day,"from" AS address,- (TRY_CAST(gas_limit AS DECIMAL) * TRY_CAST(gas_price AS DECIMAL)) AS valueFROMethereum.transactionsWHERE"from" IN (0x12D66f87A04A9E220743712cE6d9bB1B5616B8Fc,0x47CE0C6eD5B0Ce3d3A51fdb1C52DC66a7c3c2936,0x910Cbd523D972eb0a6f4cAe4618aD62622b39DbF,0xA160cdAB225685dA1d56aa342Ad8841c3b53f291)),daily AS (SELECT