from thorchain.transfers

group by 1),

price as (select date_trunc('day', block_timestamp) as dt, avg(rune_usd) as rune_price

from thorchain.prices

group by 1)

select a.dt, count (distinct a.from_address) as new_wallet_count, sum(new_wallet_count) over (order by a.dt ROWS BETWEEN unbounded preceding and current row) as cumulative_address, b.rune_price

from first_tx a

left outer join price b on a.dt = b.dt

group by 1,4