Query editor
WITH binance AS (SELECT 0x28C6c06298d514Db089934071355E5743bf21d60 AS addressUNION ALLSELECT 0x21a31Ee1afC51d94C2eFcCAa2092aD1028285549UNION ALLSELECT 0x56EDdB7aa87536c09CCc2793473599fD21A8b17F),eth_price AS (SELECTDATE_TRUNC('hour', minute) AS hour_utc,AVG(price) AS eth_price_usdFROM prices.usdWHERE symbol = 'ETH'AND minute >= NOW() - INTERVAL '7' dayGROUP BY 1),flows AS (SELECTDATE_TRUNC('hour',block_time + INTERVAL '9' hour) AS hour_jst,DATE_TRUNC('hour',block_time) AS hour_utc,SUM(CASEWHEN "to" IN (SELECT address FROM binance)THEN value / 1e18ELSE 0END) AS inflow_eth,SUM(CASEWHEN "from" IN (SELECT address FROM binance)THEN value / 1e18ELSE 0END) AS outflow_ethFROM ethereum.transactions