from terra.msgs

where msg_value:from_address::string = 'terra1zxtczmxtw8mk8xncvr8lcq2qmvk4dz88ek6f79'

group by 1,3),

price as (select date_trunc('day', block_timestamp) as dt, avg(price_usd) as price, currency

from terra.oracle_prices

group by 1,3)

select a.dt, a.donation, a.currency, b.price, (a.donation*b.price) as donation_vol, SUM(donation_vol) OVER(ORDER BY a.dt asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_donation

from raw a

left join price b on a.dt = b.dt and a.currency = b.currency