count(distinct from_address) AS addresses

FROM arbitrum.core.fact_transactions

where date_ > '2022-12-31'

GROUP BY 1

ORDER BY 1),

optimism as (SELECT trunc(block_timestamp,'day') AS date_,

count(distinct from_address) AS addresses

FROM optimism.core.fact_transactions

where date_ > '2022-12-31'

GROUP BY 1

ORDER BY 1),

eth as (SELECT trunc(block_timestamp,'day') AS date_,

count(distinct from_address) AS addresses

FROM ethereum.core.fact_transactions

where date_ > '2022-12-31'

GROUP BY 1

ORDER BY 1),

part_one as (Select arbitrum.date_,

arbitrum.addresses as arbitrum ,

optimism.addresses as optimism

from arbitrum

inner join optimism

on arbitrum.date_ = optimism.date_),

part_two as (select part_one.date_,

part_one.arbitrum,

part_one.optimism,

eth.addresses as ETH

from part_one

inner join eth

on part_one.date_ = eth.date_)

select *

from part_two

order by date_ desc