trunc(block_timestamp,'day') as date,

count(distinct tx_hash) as actions,

sum(counts) over (order by date) as total_actions,

count(distinct origin_from_address) as active_users

from base.core.ez_decoded_event_logs

where contract_name = 'Uniswap V2'

group by 1 order by 1 asc

with news as (

select

distinct origin_from_address as user,

min(block_timestamp) as debut

from base.core.ez_decoded_event_logs

where contract_name = 'Uniswap V2'

group by 1

select trunc(debut,'day') as date,

count(distinct user) as new_users,

sum(new_users) over (order by date) as total_unique_users

from news

group by 1 order by 1 asc

select

distinct origin_function_signature, count(distinct tx_hash) as counts

from base.core.ez_decoded_event_logs

where contract_name = 'Uniswap V2'

group by 1 order by 2 desc