> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# succinct.bids

> Succinct prover bids — bid amounts, prover addresses, and auction outcomes.

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

The `succinct.bids` table contains all proof generation bids submitted by provers in the Succinct Network. Each bid represents a prover's offer to generate a ZK proof for a specific request at a given price, participating in the auction-based proof contest mechanism.

## Table Schema

| Column Name    | Data Type     | Description                                         |
| -------------- | ------------- | --------------------------------------------------- |
| id             | long          | Unique identifier for the bid                       |
| tx\_hash       | binary        | Transaction hash of the bid submission              |
| prover         | binary        | Address of the prover submitting the bid            |
| request\_id    | binary        | Unique identifier for the proof request             |
| amount         | bigint        | Amount of PROVE tokens bid for the proof generation |
| created\_at    | timestamp     | Timestamp when the bid was submitted                |
| stake          | decimal(38,0) | Amount of PROVE tokens staked by the prover         |
| date           | date          | Date when the bid was submitted                     |
| \_updated\_at  | timestamp     | Last update timestamp                               |
| \_ingested\_at | timestamp     | Ingestion timestamp                                 |

## Sample Query

```sql theme={null}
-- Get the total number of bids and total amount bid per prover
SELECT 
    prover,
    COUNT(*) as bid_count,
    SUM(amount) as total_bid_amount
FROM succinct.bids
WHERE created_at >= NOW() - INTERVAL '7' DAY
GROUP BY prover
ORDER BY total_bid_amount DESC
LIMIT 10;
```
