select

date_trunc('day', block_timestamp) as registration_date,

count(distinct unit_id) as new_units,

count(distinct owner_address) as unique_owners,

unit_type,

count(*) as total_registrations

from crosschain.olas.ez_unit_registrations

group by 1, 4

order by 1 DESC

select

registration_date,

unit_type,

new_units,

unique_owners,

total_registrations,

sum(new_units) over (partition by unit_type order by registration_date) as cumulative_units

from daily_units;