SELECT b.PROJECT_NAME AS project_name, SUM(event_inputs:value/1e18) as OP_volume
FROM optimism.core.fact_event_logs AS a
JOIN optimism.core.dim_labels AS b ON a.origin_to_address = b.address
WHERE tx_status = 'SUCCESS' AND contract_address = '0x4200000000000000000000000000000000000042'
AND event_name = 'Transfer'
AND event_inputs:value/1e18 < 1e8
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10