misaghlbWhat's All The Hubbub for Hubble Protocol?
    Updated 2022-10-09
    select date_trunc('day', block_timestamp) as date,
    COUNT(DISTINCT tx_id) as tx_count,
    COUNT(DISTINCT signers[0]) as wallets
    from solana.core.fact_transactions
    where instructions[0]:programId = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'
    and succeeded = TRUE
    and date >= CURRENT_DATE - 30
    group by date
    Run a query to Download Data