WITH op_usdc_data AS
(SELECT *,raw_amount*1e-6 AS amount
FROM optimism.core.fact_token_transfers
WHERE contract_address = '0x7f5c764cbc14f9669b88837ca1490cca17c31607'
AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '2 months'
)
SELECT DATE_TRUNC ('days', block_timestamp) AS "Days",
COUNT(tx_hash) AS "Transfer Volume"
FROM op_usdc_data
GROUP BY "Days"