Updated 2022-12-12
    select
    date_trunc('day',block_timestamp::date) as "Date" ,
    count(distinct tx_id) as "Number of Daily Transactions",
    count(distinct PROPOSER) as "Number of Daily Users",
    ("Number of Daily Transactions"/1440) as "Transactions per Minute", ("Number of Daily Transactions"/86400) as "Transactions per second",
    ("Number of Daily Transactions"/"Number of Daily Users") as "Tx/User"
    from flow.core.fact_transactions
    where block_timestamp >= '2022-01-01'
    and TX_SUCCEEDED = true
    group by 1
    order by 1
    Run a query to Download Data