avg(event_amount_usd) as average_usd,

sum(event_amount_usd) as vol_usd, event_currency,

SUM(vol_usd) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as cumulative_volume_usd,

count(tx_id) as tx_count,

count(distinct event_from) as daily_active_senders,

count(distinct event_to) as daily_recepients,

SUM(daily_active_senders) OVER(ORDER BY dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as cumulative_senders

from terra.transfers

where event_to_address_label = 'chai' and tx_status = 'SUCCEEDED' and dt >= '2021-01-01'

group by 1,4