count(*) as transactions_count,

sum(eth_value) as total_tx_amount,

avg(eth_value) as tx_amount_avg,

median(eth_value) as tx_amount_median,

max(eth_value) as tx_amount_max,

sum(tx_fee) as txns_fee,

min(tx_fee) as tx_fee_min,

avg(tx_fee) as avg_tx_fee,

median(tx_fee) as median_tx_fee,

max(tx_fee) as tx_fee_max,

count (distinct (from_address)) as unique_senders_num,

count (distinct (to_address)) as unique_receivers_num,

count (distinct (block_number)) as blocks_number,

count (case when status = 'SUCCESS' then 1 else null end) as tx_success_number,

count (case when status = 'FAIL' then 1 else null end) as tx_fail_number

from ethereum.core.fact_transactions where block_timestamp::date between '2022-09-15' and '2022-09-22'