SELECT

'Blast' as blockchain,

DATE_TRUNC('day', block_timestamp) AS date,

COUNT(DISTINCT from_address) AS total_users

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 from_address) AS total_users

FROM

Base.core.fact_transactions

where BLOCK_TIMESTAMP::date>='2023-07-20'

GROUP BY

blockchain,

DATE_TRUNC('day', block_timestamp)

union all

SELECT

'Arbitrum' as blockchain,

DATE_TRUNC('day', block_timestamp) AS date,

COUNT(DISTINCT from_address) AS total_users

FROM

Arbitrum.core.fact_transactions

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

GROUP BY

blockchain,

DATE_TRUNC('day', block_timestamp)

union all

SELECT

'Optimism' as blockchain,