with tenk_all as (sELECT DISTINCT tx_hash as hash0

from external.tokenflow_starknet.decoded_traces

where --tx_hash = '0x01bf50086c4668e9a375efd0d84d5708246b1ad20b52c34a486c6ba63564d481' --and

caller = '0x028c858a586fa12123a1ccb337a0a3b369281f91ea00544d0c086524b759f627' and

FUNCTION = 'transferFrom'

and chain_id = 'mainnet'),

sith_all as

(SELECT timestamp::date as date, contract as user

from external.tokenflow_starknet.decoded_transactions join tenk_all on tx_hash =hash0

and chain_id = 'mainnet')

SELECT count(DISTINCT user) as "toal users",

count(DISTINCT user)/count(DISTINCT date_trunc('day',date)) as "avg daily users",

count(DISTINCT user)/count(DISTINCT date_trunc('week',date)) as "avg weekly users",

count(DISTINCT user)/count(DISTINCT date_trunc('month',date)) as "avg monhtly users"

from sith_all