SELECT date_trunc('d', block_timestamp) as date,

sum(value) as value_add

FROM (

SELECT

block_timestamp,

amount_usd as value

FROM polygon.core.ez_token_transfers

WHERE

to_address = '0x7043e4e1c4045424858ecbced80989feafc11b36'

AND block_timestamp::date >= '2023-04-16'

AND block_number >= 41594860

UNION

SELECT

block_timestamp,

DECODED_LOG:wad/1e18 as value

FROM gnosis.core.ez_decoded_event_logs

WHERE

DECODED_LOG:dst = '0x204e7371ade792c5c006fb52711c50a7efc843ed'

AND event_name IN ('Transfer','Deposit')

GROUP BY 1

,

remove_liquidity as (

SELECT date_trunc('d', block_timestamp) as date,

sum(value) as value_remove

FROM (

SELECT

block_timestamp,

-1 * DECODED_LOG:wad/1e18 as value

FROM gnosis.core.ez_decoded_event_logs

WHERE

DECODED_LOG:src = '0x204e7371ade792c5c006fb52711c50a7efc843ed'

AND event_name IN ('Transfer','Withdrawal')

UNION