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 NameData TypeDescription
idlongUnique identifier for the bid
tx_hashbinaryTransaction hash of the bid submission
proverbinaryAddress of the prover submitting the bid
request_idbinaryUnique identifier for the proof request
amountbigintAmount of PROVE tokens bid for the proof generation
created_attimestampTimestamp when the bid was submitted
stakedecimal(38,0)Amount of PROVE tokens staked by the prover
datedateDate when the bid was submitted
_updated_attimestampLast update timestamp
_ingested_attimestampIngestion timestamp

​
Sample Query

-- 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;