sum(RAW_AMOUNT/1e6) as volume_usdc,

count(distinct FROM_ADDRESS) as depositors,

volume_usdc/depositors as usdc_per_user

from ethereum.core.fact_token_transfers

where TO_ADDRESS='0xd89a09084555a7d0abe7b111b1f78dfeddd638be'

and CONTRACT_ADDRESS='0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'

and BLOCK_TIMESTAMP>=CURRENT_DATE-30