Query editor
WITH tt (tx_day, tx_hash, gas_used, gas_price, user, network) AS (SELECTDATE_TRUNC('day', txs.block_time) AS tx_day,txs.hash,txs.gas_used,txs.gas_price,txs."from",contracts.networkFROM polygon.transactions AS txs, query_3203439 AS contractsWHEREcontracts.network = 'polygon' ANDtxs.to = contracts.address ANDtxs.successUNIONSELECTDATE_TRUNC('day', txs.block_time) AS tx_day,txs.hash,txs.gas_used,txs.gas_price,txs."from",contracts.networkFROM arbitrum.transactions AS txs, query_3203439 AS contractsWHEREcontracts.network = 'arbitrum' ANDtxs.to = contracts.address ANDtxs.success),ss (tx_day, dau, tx_count, tx_fee) AS (SELECT *FROM (SELECTtx_day,COUNT(DISTINCT user) AS dau,SUM(1) AS tx_count,SUM(gas_used / pow(10,18) * gas_price) AS tx_feeFROM ttWHERE network = 'arbitrum'GROUP BY tx_day)),data AS (SELECTtx_day AS "timestamp",SUM(dau) AS dau,SUM(tx_count) AS tx_count,SUM(tx_fee) AS tx_fee,SUM(incentive_usd) AS incentive_usdFROM (SELECT"day" AS tx_day,0 AS dau,0 AS tx_count,0 AS tx_fee,0 AS incentive_usdFROM query_3093463 AS time_seriesUNIONSELECTtx_day,dau,tx_count,