Query editor
-- consider overlaps or other logic for full hoursWITH all_traces as (SELECT block_time, to, tx_success, tx_hash, error, input, 'ethereum' as chain, output, gas, gas_usedFROM ethereum.tracesWHERE (to = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE OR"from" = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE)AND block_time >= DATE_TRUNC('hour', CURRENT_TIMESTAMP) - INTERVAL '{{hour}}' HOURAND block_time < DATE_TRUNC('hour', CURRENT_TIMESTAMP)UNION ALLSELECT block_time, to, tx_success, tx_hash, error, input, 'arbitrum' as chain, output, gas, gas_usedFROM arbitrum.tracesWHERE (to = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE OR"from" = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE)AND block_time >= DATE_TRUNC('hour', CURRENT_TIMESTAMP) - INTERVAL '{{hour}}' HOURAND block_time < DATE_TRUNC('hour', CURRENT_TIMESTAMP)UNION ALLSELECT block_time, to, tx_success, tx_hash, error, input, 'optimism' as chain, output, gas, gas_usedFROM optimism.tracesWHERE (to = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE OR"from" = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE)AND block_time >= DATE_TRUNC('hour', CURRENT_TIMESTAMP) - INTERVAL '{{hour}}' HOURAND block_time < DATE_TRUNC('hour', CURRENT_TIMESTAMP)UNION ALLSELECT block_time, to, tx_success, tx_hash, error, input, 'base' as chain, output, gas, gas_usedFROM base.tracesWHERE (to = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE OR"from" = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE)AND block_time >= DATE_TRUNC('hour', CURRENT_TIMESTAMP) - INTERVAL '{{hour}}' HOURAND block_time < DATE_TRUNC('hour', CURRENT_TIMESTAMP)UNION ALLSELECT block_time, to, tx_success, tx_hash, error, input, 'avalanche_c' as chain, output, gas, gas_usedFROM avalanche_c.tracesWHERE (to = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE OR"from" = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE)AND block_time >= DATE_TRUNC('hour', CURRENT_TIMESTAMP) - INTERVAL '{{hour}}' HOURAND block_time < DATE_TRUNC('hour', CURRENT_TIMESTAMP)UNION ALLSELECT block_time, to, tx_success, tx_hash, error, input, 'polygon' as chain, output, gas, gas_usedFROM polygon.tracesWHERE (to = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE OR"from" = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE)AND block_time >= DATE_TRUNC('hour', CURRENT_TIMESTAMP) - INTERVAL '{{hour}}' HOURAND block_time < DATE_TRUNC('hour', CURRENT_TIMESTAMP)UNION ALLSELECT block_time, to, tx_success, tx_hash, error, input, 'bnb' as chain, output, gas, gas_usedFROM bnb.tracesWHERE (to = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE OR"from" = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE)AND block_time >= DATE_TRUNC('hour', CURRENT_TIMESTAMP) - INTERVAL '{{hour}}' HOURAND block_time < DATE_TRUNC('hour', CURRENT_TIMESTAMP)UNION ALLSELECT block_time, to, tx_success, tx_hash, error, input, 'gnosis' as chain, output, gas, gas_usedFROM gnosis.tracesWHERE (to = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE OR"from" = 0x1231DEB6f5749EF6cE6943a275A1D3E7486F4EaE)AND block_time >= DATE_TRUNC('hour', CURRENT_TIMESTAMP) - INTERVAL '{{hour}}' HOURAND block_time < DATE_TRUNC('hour', CURRENT_TIMESTAMP)UNION ALLSELECT block_time, to, tx_success, tx_hash, error, input, 'blast' as chain, output, gas, gas_usedFROM blast.traces