blockchain,

avg(Daily_Active_User) as "Average Daily # of Txs",

median(Daily_Active_User) as "Median Daily # of Txs"

(

SELECT

'Blast' as blockchain,

block_timestamp :: date as date,

count(DISTINCT from_address) as Daily_Active_User,

count(tx_hash) as "Daily # of TXs"

FROM

blast.core.fact_transactions

where

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

group by

1,

2

union

all

SELECT

'Base' as blockchain,

block_timestamp :: date as date,

count(DISTINCT from_address) as Daily_Active_User,

count(tx_hash) as "Daily # of TXs"

FROM

Base.core.fact_transactions

group by

1,

2

union

all

SELECT

'Optimism' as blockchain,

block_timestamp :: date as date,

count(DISTINCT from_address) as Daily_Active_User,