sum(case when EVENT_RESOURCE = 'DepositEvent' then event_data : deposit_amount end) / pow(10,6) as deposit,

sum(case when EVENT_RESOURCE = 'DepositEvent' then event_data : deposit_fee end) / pow(10,6) as deposit_fee,

sum(case when EVENT_RESOURCE = 'WithdrawEvent' then event_data : withdraw_amount end ) / pow(10,6) as withdraw,

sum(case when event_resource = 'FeeEvent' then event_data : amount end) / pow(10, 6) as fee_event,

sum(case when EVENT_RESOURCE = 'WithdrawEvent' then event_data : withdraw_fee end ) / pow(10,6) as withdraw_fee,

deposit - withdraw as tvl

from aptos.core.fact_events

where event_address = '0x5ae6789dd2fec1a9ec9cccfb3acaf12e93d432f0a3a42c92fe1a9d490b7bbc06'

and event_module = 'house_lp'

and block_timestamp::date >= '2023-08-01'

and success = 'TRUE'