Query editor
WITH Stats1 AS (SELECTDATE_TRUNC('day',block_time) AS Days, COUNT(DISTINCT "from") AS Ethereum_Users, COUNT(DISTINCT hash) AS Ethereum_TxnFROM ethereum.transactionsWHERE block_time > CAST('2025-09-01 00:00' AS TIMESTAMP)GROUP BY 1),Silo_ AS (SELECTDATE_TRUNC('day', Date) AS Day, COUNT(DISTINCT Owner) AS Users, COUNT(DISTINCT Hash) AS TxnsFROM query_5494012WHERE Date > CAST('2025-09-01 00:00' AS TIMESTAMP)GROUP BY 1)SELECTa.Day, a.Users, a.Txns, b.Ethereum_Users, b.Ethereum_Users - a.Users AS non_Silo_Users, b.Ethereum_Txn, b.Ethereum_Txn - a.Txns AS non_Silo_TxnFROM Silo_ aLEFT JOIN Stats1 b ON a.Day = b.Days