select

from_address,

first_value(block_timestamp) over (partition by from_address order by block_timestamp asc) as day

from ethereum.transactions

where to_label = 'uniswap'

select

date_trunc('month',day) as month,

count(distinct users.from_address),

count(distinct ethereum.transactions.tx_id)

from users,ethereum.transactions

where month=date_trunc('month',block_timestamp) and users.from_address=ethereum.transactions.from_address and month > CURRENT_DATE - interval '365 days'

group by month