(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'

),

op_daily_transfer AS

(SELECT DATE_TRUNC ('days', block_timestamp) AS "Days",

COUNT(tx_hash) AS "Transfer Volume"

FROM op_usdc_data

GROUP BY "Days"),

op_daily_price AS

(SELECT DATE_TRUNC ('days', block_timestamp) AS "Days",

SUM(amount) AS "Price Volume in USD"

FROM op_usdc_data

GROUP BY "Days")

SELECT transfer.*, price."Price Volume in USD"

FROM op_daily_transfer transfer

FULL JOIN op_daily_price price

ON transfer."Days" = price."Days"