lagandispenserOverview over time
    Updated 2024-03-29
    select date_trunc('day', block_timestamp) as date ,count(distinct TX_HASH) as Number_of_Stakes,
    count(distinct SIGNER_ID) as Number_of_validator , count(distinct ADDRESS) as Number_of_stake_pool ,
    'Near' as Name_of_Blockchain from near.gov.fact_staking_actions
    WHERE date >= CURRENT_DATE - 7 group by date

    QueryRunArchived: QueryRun has been archived