SELECT

livequery.live.udf_api (

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

,

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

,

chains as ( select TO_TIMESTAMP(value:"date") as date,

'Zksync' as chain,

'WETH' as symbol,

value:"avg_fee"::string as tx_fee

from zk_import a join ethereum.core.dim_dates b on a.value:"date" = b.date_day

and date >= current_date - 2

select date(block_timestamp) as date,

'Sei' as chain,

'SEI' as symbol,

(split(fee,'usei')[0]/pow(10,6)) as tx_fee

from sei.core.fact_transactions

where block_timestamp >= current_date - 2

and TX_SUCCEEDED = 'true'

and split(fee,'usei')[0]/pow(10,6) > 0

select date(block_timestamp) as date,

'Arbitrum' as chain,

'WETH' as symbol,

from arbitrum.core.fact_transactions

where block_timestamp >= current_date - 2

and status = 'SUCCESS'