SELECT
tx.block_timestamp::date as fecha,
sum(array_size (tx_to)) as Paid_bounties_per_day,
sum(Paid_bounties_per_day) over (order by fecha) as Acc_paid_bounties,
--tx.tx_id,
--event_amount,
sum(event_amount_usd) as Bounties_USD_per_day,
sum(Bounties_USD_per_day) over (order by fecha) as Acc_bounties_USD
--event_currency
FROM
terra.transactions tx
INNER JOIN terra.transfers tf
ON tx.tx_id = tf.tx_id
WHERE CONTAINS (tx_from,'terra13v8hmfld6747h7fx9gzzqvv80qwz24uvcqwrap')
GROUP BY 1