ez_stats_cte as (

select

block_timestamp_hour

, 'ez_core_metrics_hourly' as table_name

, transaction_count

, block_count

, unique_signers_count

from

eclipse.stats.ez_core_metrics_hourly

where

block_timestamp_hour :: date = '2024-09-28'

, fact_cte as (

select

date_trunc(hour, block_timestamp) as hour

, 'fact_transactions' as table_name

, count(tx_id) as txs

, count(distinct block_id) as blocks

, count(distinct signers[0]) as unique_Signers

from

eclipse.core.fact_transactions

where

block_timestamp :: date = '2024-09-28'

group by

1, 2

, fact_vote as (

select

date_trunc(hour, block_timestamp) as hour

, 'fact_votes' as table_name

, count(tx_id) as txs

, count(distinct block_id) as blocks

, count(distinct signers[0]) as unique_Signers