Query editor
SELECTDATE_TRUNC('day', block_time) AS day,SUM(value / 1e18) AS bnb_received /* BNB values are typically in wei, so divide by 1e18 to get BNB */FROM bnb.transactionsWHEREto = 0xDe4632C0EdbC3f4E7645c0Bb58A6777ee06896DDAND value > 0 /* Only include positive balance changes (incoming BNB) */AND block_time >= CURRENT_DATE - INTERVAL '30' dayGROUP BY1ORDER BYday