select
--date_trunc('day', block_timestamp) as date1,
sum(raw_amount) / 1e6 as USDC_Volume
from polygon.core.fact_token_transfers left outer join polygon.core.dim_labels
on contract_address = address
where address_name like 'hop protocol: usdc l2canonicalbridge'
and to_address like lower('0xF715bEb51EC8F63317d66f491E37e7BB048fCc2d')
--group by 1
--