SELECT date_trunc(DAY, BLOCK_TIMESTAMP::DATE) AS DAY, SUM(AMOUNT) AS diposit_amount FROM flipside_prod_db.ethereum.udm_events

WHERE TO_ADDRESS = '0xd89a09084555a7d0abe7b111b1f78dfeddd638be'

AND CONTRACT_ADDRESS = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'

AND BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 30

GROUP BY 1

),

withdraws AS (

SELECT date_trunc(DAY, BLOCK_TIMESTAMP::DATE) AS DAY, SUM(AMOUNT) AS withdraw_amount FROM flipside_prod_db.ethereum.udm_events

WHERE FROM_ADDRESS = '0xd89a09084555a7d0abe7b111b1f78dfeddd638be'

AND ORIGIN_FUNCTION_NAME = 'withdrawFrom'

AND EVENT_NAME = 'transfer'

AND SYMBOL = 'USDC'

AND BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - 30

GROUP BY 1

),

final AS (

SELECT DAY, diposit_amount AS amount, 'deposit' AS label

FROM deposits

UNION

SELECT DAY, -withdraw_amount AS amount, 'withdraw' AS label

FROM withdraws

SELECT DAY, SUM(amount) AS "Total Deposit", label

FROM final

GROUP BY 1,3

ORDER BY 1