date_trunc('day',block_timestamp) as day,

sum(pre_balances[0] - post_balances[0])/power(10,9) as withdraw_sol

FROM

WHERE

block_timestamp >= CURRENT_DATE - 30

-- AND size(account_keys) = 3

AND account_keys[0]:pubkey = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK'

-- AND error is NULL

GROUP BY

block_timestamp