Query editor
SELECTdate_trunc('day', block_time) AS day,SUM(input_value / 1e8) AS total_btcFROM bitcoin.transactionsWHERE block_time > now() - interval '7' dayGROUP BY date_trunc('day', block_time) -- 用完整表达式,不用别名ORDER BY date_trunc('day', block_time);