SELECT

'Blast' as blockchain,

DATE_TRUNC('day', block_timestamp) AS date,

COUNT(DISTINCT TX_hash) AS total_tx

FROM

blast.core.fact_transactions

where

BLOCK_TIMESTAMP :: date >= '2024-02-29'

GROUP BY

blockchain,

DATE_TRUNC('day', block_timestamp)

union

all

SELECT

'Base' as blockchain,

DATE_TRUNC('day', block_timestamp) AS date,

COUNT(DISTINCT tx_hash) AS total_tx

FROM

Base.core.fact_transactions

where

BLOCK_TIMESTAMP :: date >= '2023-07-15'

GROUP BY

blockchain,

DATE_TRUNC('day', block_timestamp)

union

all

SELECT

'Arbitrum' as blockchain,

DATE_TRUNC('day', block_timestamp) AS date,

COUNT(DISTINCT tx_hash) AS total_tx

FROM

Arbitrum.core.fact_transactions

where

BLOCK_TIMESTAMP :: date >= '2021-08-31'

GROUP BY