SELECT

livequery.live.udf_api (

'https://api.dune.com/api/v1/query/3145198/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,

value:"status"::string as status,

value:"total_tx" as total_tx,

total_tx/86400 as tps

from zk_import

where date >= '2024-04-01' and date < '2024-05-01'

select date(block_timestamp) as date,

'Sei' as chain,

case when TX_SUCCEEDED = 'true' then 'SUCCESS' else 'FAIL' end as status,

count(DISTINCT tx_id) as total_tx,

total_tx/86400 as tps

from sei.core.fact_transactions

where block_timestamp::date >= '2024-04-01' and block_timestamp < '2024-05-01'

group by 1,2,3

select date(block_timestamp) as date,

'Arbitrum' as chain,

status,

count(DISTINCT tx_hash) as total_tx,

total_tx/86400 as tps

from arbitrum.core.fact_transactions

where block_timestamp::date >= '2024-04-01' and block_timestamp < '2024-05-01'

group by 1,2,3

select date(block_timestamp) as date,

'Optimism' as chain,

status,