select date_trunc('day',block_timestamp) as dt,

sum(event_attributes:withdrawn_share/1e6) as terraswap_with

FROM terra.msg_events

WHERE event_attributes:"0_contract_address" = 'terra1nuy34nwnsh53ygpc4xprlj263cztw7vc99leh2'

AND event_attributes:"1_action" = 'withdraw_liquidity'

and dt > '2021-12-28'

group by 1

),

ad as (

select date_trunc('day',block_timestamp) as dt,

sum(event_attributes:share/1e6) as astroport_liq_provide

FROM terra.msg_events

WHERE event_attributes:"0_contract_address" = 'terra1j66jatn3k50hjtg2xemnjm8s7y8dws9xqa5y8w'

AND event_attributes:"0_action" = 'provide_liquidity'

and dt > '2021-12-28'

group by 1

)

SELECT

sum (terraswap_with) as total_withdrawal_terraswap,

sum(astroport_liq_provide) as total_liq_provide_astroport

from tw,ad