with dune_table as

(SELECT live.udf_api(

'https://api.dune.com/api/v1/query/3889258/results?api_key=y9IjkzucOrPXHWOWluAnCyeBHixk9LGE'

) as response),

data_table as

(select list:"data":"result":"rows" as c

from

(select PARSE_JSON(response) as list

from dune_table))

,

ethereum as

(select date(block_timestamp) as date,

'Ethereum' as label,

address,

sum(amount) as netflow

(select

block_timestamp,

origin_from_address as address,

amount as amount

from ethereum.core.ez_token_transfers

where to_address = lower('0x14C5a9007FDC5eE4De1581C892b5fd4623D8cdBf')

and symbol = 'weETH'

union all

select

block_timestamp,

origin_to_address,

-amount as amount

from ethereum.core.ez_token_transfers

where from_address = lower('0x14C5a9007FDC5eE4De1581C892b5fd4623D8cdBf')

and symbol = 'weETH')

group by 1,2,3