data as (

select

tx_id,block_timestamp,

event_data:id as id,

event_data:to as account

from flow.core.fact_events

where event_contract='A.483f0fe77f0d59fb.Flowmap'

and event_type='Deposit'

),

data2 as (

distinct event_data:to as user,

min(block_timestamp) as debut

from flow.core.fact_events

where event_contract='A.483f0fe77f0d59fb.Flowmap'

and event_type='Deposit'

group by 1

select

date_trunc ('day',x.block_timestamp) as date,

count(distinct id) as flowmap_inscriptions,

sum(flowmap_inscriptions) over (order by date) as total_flowmap_inscriptions,

count(distinct account) as active_wallets,

count(distinct z.user) as new_wallets,

sum(new_wallets) over (order by date) as total_unique_wallets,

flowmap_inscriptions*0.025 as volume,

total_flowmap_inscriptions*0.025 as total_volume

from data x

join data2 z on date_trunc ('day',x.block_timestamp)=date_trunc ('day',debut)

group by 1 order by 1 asc