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 >= '2024-01-01' and date < '2024-01-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 >= '2024-01-01' and block_timestamp::date < current_date::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 >= '2024-01-01' and block_timestamp::date < current_date::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 >= '2024-01-01' and block_timestamp::date < current_date::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 >= '2024-01-01' and block_timestamp::date < current_date::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 >= '2024-01-01' and block_timestamp::date < current_date::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 >= '2024-01-01' and block_timestamp::date < current_date::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 >= '2024-01-01' and block_timestamp::date < current_date::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 >= '2024-01-01' and block_timestamp::date < current_date::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 >= '2024-01-01' and block_timestamp::date < current_date::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 >= '2024-01-01' and block_timestamp::date < current_date::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 >= '2024-01-01' and block_timestamp::date < current_date::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 >= '2024-01-01' and block_timestamp::date < current_date::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 >= '2024-01-01' and block_timestamp::date < current_date::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 >= '2024-01-01' and block_timestamp::date < current_date::date and SUCCESS = 'true' group by 1,2

Lordking