pimi1356-HdnUm3daily hubble metrics
    Updated 2022-10-09
    select
    date_trunc('{{date_range}}',block_timestamp) as DATE,
    count (distinct tx_id) as TX_Count,
    count (distinct BLOCK_ID) as totalblocks,
    count (distinct signers[0]) as Users_Count,
    sum (FEE/1e9) as Totalfees,
    sum(TX_Count) over (order by date) as cumulative_count_tx,
    sum(totalblocks) over (order by date) as cumulative_ccccblock,
    sum(Users_Count) over (order by date) as ccccumulative_ccccuser,
    sum(Totalfees) over (order by date) as cumulative_fee
    from solana.core.fact_transactions
    where instructions[0]:programId = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
    and succeeded = 'TRUE'
    GROUP BY DATE
    Run a query to Download Data