DATE_TRUNC('day', block_timestamp) AS _day,

project_name AS _project_OP,

label_type AS _label_OP,

COUNT(*) AS _TXs_OP

FROM optimism.core.fact_token_transfers

LEFT OUTER JOIN optimism.core.dim_labels ON contract_address = address

WHERE label_type IN ('dex', 'defi', 'dapp', 'nft', 'layer2', 'flotsam', 'cex', 'operator', 'chadmin')

GROUP BY _day, _project_OP, _label_OP

ORDER BY _day