SELECT

livequery.live.udf_api (

'https://api.dune.com/api/v1/query/3786391/results?api_key=LelNLIOCx6bVJ7QVazHiYO3cbVA18hRw') as resp)

,

table(FLATTEN(parse_json(resp:data:"result":"rows"))))

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

'Ethereum' as chain,

sum(amount) as weeth

from ethereum.core.ez_token_transfers

where to_address = lower('0x14C5a9007FDC5eE4De1581C892b5fd4623D8cdBf')

and symbol = 'weETH'

group by 1,2

union all

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

'Optimism' as chain,

sum(amount) as weeth

from optimism.core.ez_token_transfers

where to_address = lower('0xea8eDdb19a980B6D9D77167ca08a70a692DA0DD7')

and symbol = 'weETH'

group by 1,2

union all

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

'Arbitrum' as chain,

sum(amount) as weeth

from arbitrum.core.ez_token_transfers

where to_address = '0x3c09fb9630b8f89f73871506f445f5dbedbeb0df'

and symbol = 'weETH'

group by 1,2

union all