count(DISTINCT tx_hash) as txs,

min(TIMESTAMP::date) as "First transaction" ,

max(TIMESTAMP::date) "Last transaction",

datediff('day', MIN(TIMESTAMP::date) , max(TIMESTAMP::date) ) as "Wallet Age(days)",

count(DISTINCT TIMESTAMP::date) as "Active Days",

count(distinct date_trunc('day', TIMESTAMP)) as days,

count(distinct date_trunc('month', TIMESTAMP)) as months

from external.tokenflow_starknet.decoded_transactions

where contract = lower('{{Account_address}}')

and CHAIN_ID = 'mainnet'

and TIMESTAMP::date <= '2023-11-15'