PROJECT_NAME,

count(distinct tx_hash) as no_sent,

count(distinct TO_ADDRESS) as no_holders,

sum(RAW_AMOUNT/1e18) as volume_OP,

avg(RAW_AMOUNT/1e18) as avg_volume,

no_holders/count(distinct date_trunc(day, block_timestamp)) as average_buyer_day,

volume_OP/count(distinct date_trunc(day, block_timestamp)) as average_volume_day

from optimism.core.fact_token_transfers x join optimism.core.dim_labels y on x.ORIGIN_FROM_ADDRESS= y.address

where label_subtype != 'token_contract'

-- and LABEL_TYPE not in ('chadmin','operator','token')

-- and STATUS = 'SUCCESS'

and contract_address = '0x4200000000000000000000000000000000000042'

and LABEL_TYPE='cex'

group by 1

order by 4 desc limit 10