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 < CURRENT_DATE 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 < CURRENT_DATE 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 < CURRENT_DATE 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 < CURRENT_DATE 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 < CURRENT_DATE 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 < CURRENT_DATE 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 < CURRENT_DATE 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 < CURRENT_DATE 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 < CURRENT_DATE 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 < CURRENT_DATE 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 < CURRENT_DATE 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 < CURRENT_DATE 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 < CURRENT_DATE 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 < CURRENT_DATE 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 < CURRENT_DATE and SUCCESS = 'true' group by 1,2

Query	Creator	Created
Getting Started	izzuddin8803	Dec 15, 2023
Daily STPS cosmos flow aptos near bsc	izzuddin8803	Jan 12, 2024

izzuddin8803