with zk_import as ( select * from ( SELECT livequery.live.udf_api ( 'https://api.dune.com/api/v1/query/3145263/results?api_key=nPlMJ4JjTsMZcIo0C6kGSt5rpbcoXujU') as resp) , table(FLATTEN(parse_json(resp:data:"result":"rows")))) select TO_TIMESTAMP(value:"date") as date, 'Zksync' as chain, value:"total_tx" as total_tx, total_tx/86400 as tps from zk_import where date >= '2023-12-01' and date < '2024-02-01' UNION select date(block_timestamp) as date, 'Sei' as chain, count(DISTINCT tx_id) as total_tx, total_tx/86400 as tps from sei.core.fact_transactions where block_timestamp::date >= '2023-12-01' and block_timestamp < '2024-02-01' and TX_SUCCEEDED = 'true' group by 1,2 UNION select date(block_timestamp) as date, 'Arbitrum' as chain, count(DISTINCT tx_hash) as total_tx, total_tx/86400 as tps from arbitrum.core.fact_transactions where block_timestamp::date >= '2023-12-01' and block_timestamp < '2024-02-01' and STATUS = 'SUCCESS' group by 1,2 UNION select date(block_timestamp) as date, 'Optimism' as chain, count(DISTINCT tx_hash) as total_tx, total_tx/86400 as tps from optimism.core.fact_transactions where block_timestamp::date >= '2023-12-01' and block_timestamp < '2024-02-01' and STATUS = 'SUCCESS' group by 1,2 UNION select date(block_timestamp) as date, 'Polygon' as chain, count(DISTINCT tx_hash) as total_tx, total_tx/86400 as tps from polygon.core.fact_transactions where block_timestamp::date >= '2023-12-01' and block_timestamp < '2024-02-01' and STATUS = 'SUCCESS' group by 1,2 UNION select date(block_timestamp) as date, 'Avalanche' as chain, count(DISTINCT tx_hash) as total_tx, total_tx/86400 as tps from avalanche.core.fact_transactions where block_timestamp::date >= '2023-12-01' and block_timestamp < '2024-02-01' and STATUS = 'SUCCESS' group by 1,2 UNION select date(block_timestamp) as date, 'BSC' as chain, count(DISTINCT tx_hash) as total_tx, total_tx/86400 as tps from bsc.core.fact_transactions where block_timestamp::date >= '2023-12-01' and block_timestamp < '2024-02-01' and STATUS = 'SUCCESS' group by 1,2 UNION select date(block_timestamp) as date, 'Base' as chain, count(DISTINCT tx_hash) as total_tx, total_tx/86400 as tps from base.core.fact_transactions where block_timestamp::date >= '2023-12-01' and block_timestamp < '2024-02-01' and STATUS = 'SUCCESS' group by 1,2 UNION select date(block_timestamp) as date, 'Ethereum' as chain, count(DISTINCT tx_hash) as total_tx, total_tx/86400 as tps from ethereum.core.fact_transactions where block_timestamp::date >= '2023-12-01' and block_timestamp < '2024-02-01' and STATUS = 'SUCCESS' group by 1,2 UNION select date(block_timestamp) as date, 'Near' as chain, count(DISTINCT tx_hash) as total_tx, total_tx/86400 as tps from near.core.fact_transactions where block_timestamp::date >= '2023-12-01' and block_timestamp < '2024-02-01' and TX_STATUS = 'Success' group by 1,2 UNION select date(block_timestamp) as date, 'Flow' as chain, count(DISTINCT tx_id) as total_tx, total_tx/86400 as tps from flow.core.fact_transactions where block_timestamp::date >= '2023-12-01' and block_timestamp < '2024-02-01' and TX_SUCCEEDED = 'true' group by 1,2 UNION select date(block_timestamp) as date, 'Solana' as chain, count(DISTINCT tx_id) as total_tx, total_tx/86400 as tps from solana.core.fact_transactions where block_timestamp::date >= '2023-12-01' and block_timestamp < '2024-02-01' and SUCCEEDED = 'true' group by 1,2 UNION select date(block_timestamp) as date, 'Osmosis' as chain, count(DISTINCT tx_id) as total_tx, total_tx/86400 as tps from osmosis.core.fact_transactions where block_timestamp::date >= '2023-12-01' and block_timestamp < '2024-02-01' and TX_SUCCEEDED = 'true' group by 1,2 UNION select date(block_timestamp) as date, 'Atom' as chain, count(DISTINCT tx_id) as total_tx, total_tx/86400 as tps from cosmos.core.fact_transactions where block_timestamp::date >= '2023-12-01' and block_timestamp < '2024-02-01' and TX_SUCCEEDED = 'true' group by 1,2 UNION select date(block_timestamp) as date, 'Aptos' as chain, count(DISTINCT tx_hash) as total_tx, total_tx/86400 as tps from aptos.core.fact_transactions where block_timestamp::date >= '2023-12-01' and block_timestamp < '2024-02-01' and SUCCESS = 'true' group by 1,2

Query	Creator	Created
2023-09-06 09:39 AM	kathie005	Sep 6, 2023
Getting Started	kathie005	Aug 30, 2023
2023-09-06 09:40 AM	kathie005	Sep 6, 2023
Daily STPS cosmos flow aptos near bsc	kathie005	Jan 20, 2024
2023-08-31 03:17 PM ethereum nft evm	kathie005	Aug 31, 2023

kathie005