flow tx vs l2

Updated 4 days ago

WITH

flow_1 as (

select distinct tx_id as tx_hash, block_timestamp, tx_succeeded

from flow.core.fact_transactions

UNION

select distinct tx_hash as tx_id, block_timestamp, tx_succeeded

from flow.core_evm.fact_transactions

all_chains AS (

-- Arbitrum transactions

SELECT

DATE_TRUNC('day', block_timestamp) as date,

'Arbitrum' as chain,

COUNT(DISTINCT tx_hash) as total_transactions

FROM arbitrum.core.fact_transactions

WHERE date < CURRENT_DATE

AND date >= '2025-01-01'

AND status = 'SUCCESS'

-- Exclude system transactions for Arbitrum

AND origin_function_signature <> '0x6bf6a42d'

GROUP BY 1,2

UNION ALL

-- Base transactions

SELECT

DATE_TRUNC('day', block_timestamp) as date,

'Base' as chain,

COUNT(DISTINCT tx_hash) as total_transactions

FROM base.core.fact_transactions

WHERE date < CURRENT_DATE

AND date >= '2025-01-01'

AND status = 'SUCCESS'

GROUP BY 1,2

UNION ALL

Last run: 4 days ago

...

445

19KB

201s

flipside