SELECT SUM(DECODED_LOG:amount/POW(10,18)) AS total_withdrawn

FROM avalanche.core.ez_decoded_event_logs

WHERE CONTRACT_NAME = 'GoGoPool Liquid Staking Token'

AND DECODED_LOG:from = '0x2ddfdd8e1bec473f07815fa3cfea3bba4d39f37e'

AND EVENT_NAME = 'Transfer'),

ggAVAX_deposits AS (

SELECT SUM(DECODED_LOG:amount/POW(10,18)) AS total_deposited

FROM avalanche.core.ez_decoded_event_logs

WHERE CONTRACT_NAME = 'GoGoPool Liquid Staking Token'

AND DECODED_LOG:to = '0x2ddfdd8e1bec473f07815fa3cfea3bba4d39f37e'

AND EVENT_NAME = 'Transfer'),

wrapped_AVAX_withdrawals AS (

SELECT SUM(DECODED_LOG:wad/POW(10,18)) AS total_withdrawn

FROM avalanche.core.ez_decoded_event_logs

WHERE CONTRACT_NAME = 'Wrapped AVAX'

AND DECODED_LOG:src = '0x960c66dda302f4a496d936f693e083b1e9ace306'

AND EVENT_NAME = 'Transfer'),

wrapped_AVAX_deposits AS (

SELECT SUM(DECODED_LOG:wad/POW(10,18)) AS total_deposited

FROM avalanche.core.ez_decoded_event_logs

WHERE CONTRACT_NAME = 'Wrapped AVAX'

AND DECODED_LOG:dst = '0x960c66dda302f4a496d936f693e083b1e9ace306'

AND EVENT_NAME = 'Transfer')

SELECT

'ggAVAX' AS token,

gw.total_withdrawn AS "withdrawals",

gd.total_deposited AS "deposits",

gd.total_deposited - gw.total_withdrawn AS "net flow"

FROM ggAVAX_withdrawals gw

CROSS JOIN ggAVAX_deposits gd

UNION ALL

SELECT