count(distinct ORIGIN_FROM_ADDRESS) as no_users,

count(distinct tx_hash) as no_txn,

sum(RAW_AMOUNT / 1e6) as total_amount,

avg(RAW_AMOUNT / 1e6) as avg_amount,

median(RAW_AMOUNT / 1e6) as median_amount,

no_txn/count(distinct date_trunc(day, block_timestamp)) as average_txn_per_day,

total_amount/count(distinct date_trunc(day, block_timestamp)) as volume_per_day

from optimism.core.fact_token_transfers

where BLOCK_TIMESTAMP >= CURRENT_DATE - {{Time_period_days}}

and contract_address = lower('0x62BB4fc73094c83B5e952C2180B23fA7054954c4')

and FROM_ADDRESS= lower('0x722e9BFC008358aC2d445a8d892cF7b62B550F3F')