a.block_timestamp,

a.tx_hash,

a.origin_from_address as buyers,

regexp_substr_all(SUBSTR(a.DATA, 3, len(a.DATA)), '.{64}') AS segmented_data,

ethereum.public.udf_hex_to_int(

segmented_data [1] :: STRING

) as raw_volume,

raw_volume / pow(10,18) as volume,

b.contract_address

FROM optimism.core.fact_event_logs a INNER JOIN optimism.core.fact_event_logs b ON a.tx_hash = b.tx_hash

WHERE a.DATA != '0x'

AND a.tx_status = 'SUCCESS'

AND a.origin_to_address IN ('0x3f9da045b0f77d707ea4061110339c4ea8ecfa70')

AND b.event_name = 'Transfer'

)

sum(volume) as eth_volume,

contract_address,

FROM stats a INNER JOIN optimism.core.dim_labels b ON a.contract_address = b.address

GROUP BY 2,3

ORDER BY eth_volume DESC

LIMIT 10