DATE_TRUNC('day', t.block_timestamp) AS date,

COUNT(t.tx_hash) AS n_tx,

SUM(t.tx_fee) AS tx_fees_eth

FROM arbitrum.core.fact_transactions t

INNER JOIN arbitrum.core.dim_labels l

ON t.from_address = l.address

WHERE

origin_function_signature <>'0x6bf6a42d' --not system txns

AND date >= '2024-02-01'

AND label_type = 'cex'

AND project_name LIKE '%okx%'

GROUP BY date