WITH all_usdc_deposits AS (
SELECT
block_timestamp::date AS date,
CAST(event_inputs:amount as INT)/pow(10, 6) AS usd_amount,
origin_from_address AS depositor
FROM ethereum.core.fact_event_logs
WHERE origin_to_address = '0xd89a09084555a7d0abe7b111b1f78dfeddd638be'
AND event_name = 'Deposit'
AND tx_status = 'SUCCESS'
AND block_timestamp > CURRENT_DATE - 30
)
SELECT
sum(usd_amount) as total_usdc, COUNT(DISTINCT depositor) AS total_users
FROM all_usdc_deposits