SELECT date(block_timestamp) as day, sum(amount_usd) as total_amt, sum(total_amt) over ( order by day) as cumulative_amt, avg(total_amt) over (order by day) as cumulative_amt_avg
from ethereum.udm_events
where from_address ilike '0xf92cd566ea4864356c5491c177a430c222d7e678' and amount_usd is not NULL and day >= CURRENT_DATE -365
GROUP by 1