project_name

,datediff(day,min(block_timestamp),max(block_timestamp)) as Activity_days

,count(DISTINCT tx_hash) as tx_count

,count(DISTINCT TO_ADDRESS) as wallets

,sum(RAW_AMOUNT/pow(10,18)) as volume

,avg(RAW_AMOUNT/pow(10,18)) as avg_volume

,wallets/Activity_days as "Number of wallets per day"

,volume/Activity_days as "Volume per day"

from optimism.core.fact_token_transfers

join optimism.core.dim_labels on ORIGIN_FROM_ADDRESS= address

where LABEL_TYPE='cex'

and label_subtype != 'token_contract'

and contract_address = '0x4200000000000000000000000000000000000042'

group by 1