BigQuery
BigQuery: why we keep three copies of every reward and stake table
Same rows, three physical layouts — one for epoch lookups, one for stake-address lookups, one for pool lookups. The reasoning, and the bytes-billed numbers behind it.
How Many Users Were Active on Cardano Last Epoch? An AI-Assisted Query in Under a Second
On Cardano on BigQuery, we pointed an AI agent to work out a query estimating the number of active users on Cardano. It scanned the schema, wrote the query, and returned the answer in under one second. A schema optimisation led to a 28× cost reduction. Start querying the Cardano chain today.
Cardano Staking 101 - Where the stakes are high
In this post we’ll break down what staking on Cardano is, how it works under the hood, how you can do it, how to pick the right pool, and what you can earn $.
Documentation: Cardano on BigQuery
Documentation of our product Cardano on BigQuery.
The Cardano epoch time
Let's have a look at how to calculate the epoch number from dates.
Querying rewards
Example query to summarise the earned rewards on a Cardano staking address.