SPLIT(payload_function, '::')[1] as part_1,

SPLIT(payload_function, '::')[2] as part_2,

concat(part_1,'::',part_2) as function

from movement.core.fact_events

select *,

SPLIT(EVENT_TYPE, '::')[1] as part_1,

SPLIT(EVENT_TYPE, '::')[2] as part_2,

concat(part_1,'::',part_2) as function

from movement.core.fact_events)

,

unverfied as ( select min(block_timestamp::Date) as date,

from movement.core.fact_changes

where CHANGE_MODULE = 'fungible_asset'

and tx_type = 'user_transaction'

and INNER_CHANGE_TYPE = '0x1::fungible_asset::Metadata'

group by 2)

,

base_2 as (select block_timestamp::date as date,

tx_hash as address

from base

where function in ('fa_coin::mint','oft_fa::initialize','a_token_factory::Initialized')

select date,

from unverfied

count(distinct address) as "New Coin"

from base_2