Posts
Listing of posts
Deep comparison epoch 642
Back validation of the exported data from Db-sync to BigQuery.
Deep comparison epoch 641
Back validation of the exported data from Db-sync to BigQuery.
Deep comparison epoch 640
Back validation of the exported data from Db-sync to BigQuery.
Deep comparison epoch 639
Back validation of the exported data from Db-sync to BigQuery.
Deep comparison epoch 638
Back validation of the exported data from Db-sync to BigQuery.
State of Transactions epoch 638
State of Tx report for epoch 638 - summarising transactions and counting metadata by type.
State of Tokens epoch 638
State of Tokens report for epoch 638 - showing minting/burning of tokens and the most actively traded tokens.
State of Scripts epoch 638
State of Scripts report for epoch 638 - showing number of new scripts by type.
State of Pools epoch 638
State of Pools report for epoch 638 - listing new and retiring pools.
Deep comparison epoch 637
Back validation of the exported data from Db-sync to BigQuery.
State of Transactions epoch 637
State of Tx report for epoch 637 - summarising transactions and counting metadata by type.
State of Tokens epoch 637
State of Tokens report for epoch 637 - showing minting/burning of tokens and the most actively traded tokens.
State of Scripts epoch 637
State of Scripts report for epoch 637 - showing number of new scripts by type.
State of Pools epoch 637
State of Pools report for epoch 637 - listing new and retiring pools.
Estimating active users on Cardano
Measuring on-chain activity via distinct stake addresses — a new free dashboard. Dashboard -> One of the harder qu
Deep comparison epoch 636
Back validation of the exported data from Db-sync to BigQuery.
State of Transactions epoch 636
State of Tx report for epoch 636 - summarising transactions and counting metadata by type.
State of Tokens epoch 636
State of Tokens report for epoch 636 - showing minting/burning of tokens and the most actively traded tokens.
State of Scripts epoch 636
State of Scripts report for epoch 636 - showing number of new scripts by type.
State of Pools epoch 636
State of Pools report for epoch 636 - listing new and retiring pools.
Deep comparison epoch 635
Back validation of the exported data from Db-sync to BigQuery.
State of Transactions epoch 635
State of Tx report for epoch 635 - summarising transactions and counting metadata by type.
State of Tokens epoch 635
State of Tokens report for epoch 635 - showing minting/burning of tokens and the most actively traded tokens.
State of Scripts epoch 635
State of Scripts report for epoch 635 - showing number of new scripts by type.
State of Pools epoch 635
State of Pools report for epoch 635 - listing new and retiring pools.
Deep comparison epoch 634
Back validation of the exported data from Db-sync to BigQuery.
State of Transactions epoch 634
State of Tx report for epoch 634 - summarising transactions and counting metadata by type.
State of Tokens epoch 634
State of Tokens report for epoch 634 - showing minting/burning of tokens and the most actively traded tokens.
State of Scripts epoch 634
State of Scripts report for epoch 634 - showing number of new scripts by type.
State of Pools epoch 634
State of Pools report for epoch 634 - listing new and retiring pools.
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.
Deep comparison epoch 633
Back validation of the exported data from Db-sync to BigQuery.
State of Tokens epoch 633
State of Tokens report for epoch 633 - showing minting/burning of tokens and the most actively traded tokens.
State of Transactions epoch 633
State of Tx report for epoch 633 - summarising transactions and counting metadata by type.
State of Scripts epoch 633
State of Scripts report for epoch 633 - showing number of new scripts by type.
State of Pools epoch 633
State of Pools report for epoch 633 - listing new and retiring pools.
Deep comparison epoch 632
Back validation of the exported data from Db-sync to BigQuery.
State of Transactions epoch 632
State of Tx report for epoch 632 - summarising transactions and counting metadata by type.
State of Tokens epoch 632
State of Tokens report for epoch 632 - showing minting/burning of tokens and the most actively traded tokens.
State of Scripts epoch 632
State of Scripts report for epoch 632 - showing number of new scripts by type.
State of Pools epoch 632
State of Pools report for epoch 632 - listing new and retiring pools.
Deep comparison epoch 631
Back validation of the exported data from Db-sync to BigQuery.
State of Transactions epoch 631
State of Tx report for epoch 631 - summarising transactions and counting metadata by type.
State of Tokens epoch 631
State of Tokens report for epoch 631 - showing minting/burning of tokens and the most actively traded tokens.
State of Scripts epoch 631
State of Scripts report for epoch 631 - showing number of new scripts by type.
State of Pools epoch 631
State of Pools report for epoch 631 - listing new and retiring pools.
Deep comparison epoch 630
Back validation of the exported data from Db-sync to BigQuery.
Deep comparison epoch 629
Back validation of the exported data from Db-sync to BigQuery.
State of Transactions epoch 630
State of Tx report for epoch 630 - summarising transactions and counting metadata by type.
State of Tokens epoch 630
State of Tokens report for epoch 630 - showing minting/burning of tokens and the most actively traded tokens.
State of Scripts epoch 630
State of Scripts report for epoch 630 - showing number of new scripts by type.
State of Pools epoch 630
State of Pools report for epoch 630 - listing new and retiring pools.
State of Transactions epoch 629
State of Tx report for epoch 629 - summarising transactions and counting metadata by type.
State of Tokens epoch 629
State of Tokens report for epoch 629 - showing minting/burning of tokens and the most actively traded tokens.
State of Scripts epoch 629
State of Scripts report for epoch 629 - showing number of new scripts by type.
State of Pools epoch 629
State of Pools report for epoch 629 - listing new and retiring pools.
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.
Deep comparison epoch 628
Back validation of the exported data from Db-sync to BigQuery.
State of Transactions epoch 628
State of Tx report for epoch 628 - summarising transactions and counting metadata by type.
State of Tokens epoch 628
State of Tokens report for epoch 628 - showing minting/burning of tokens and the most actively traded tokens.
State of Scripts epoch 628
State of Scripts report for epoch 628 - showing number of new scripts by type.
State of Pools epoch 628
State of Pools report for epoch 628 - listing new and retiring pools.
State of Tokens epoch 627
State of Tokens report for epoch 627 - showing minting/burning of tokens and the most actively traded tokens.
State of Scripts epoch 627
State of Scripts report for epoch 627 - showing number of new scripts by type.
State of Transactions epoch 627
State of Tx report for epoch 627 - summarising transactions and counting metadata by type.
State of Pools epoch 627
State of Pools report for epoch 627 - listing new and retiring pools.
Deep comparison epoch 627
Back validation of the exported data from Db-sync to BigQuery.
Deep comparison epoch 626
Back validation of the exported data from Db-sync to BigQuery.
State of Tokens epoch 626
State of Tokens report for epoch 626 - showing minting/burning of tokens and the most actively traded tokens.
State of Transactions epoch 626
State of Tx report for epoch 626 - summarising transactions and counting metadata by type.
State of Scripts epoch 626
State of Scripts report for epoch 626 - showing number of new scripts by type.
State of Pools epoch 626
State of Pools report for epoch 626 - listing new and retiring pools.
Deep comparison epoch 625
Back validation of the exported data from Db-sync to BigQuery.
State of Tokens epoch 625
State of Tokens report for epoch 625 - showing minting/burning of tokens and the most actively traded tokens.
State of Transactions epoch 625
State of Tx report for epoch 625 - summarising transactions and counting metadata by type.
State of Scripts epoch 625
State of Scripts report for epoch 625 - showing number of new scripts by type.
State of Pools epoch 625
State of Pools report for epoch 625 - listing new and retiring pools.
Deep comparison epoch 624
Back validation of the exported data from Db-sync to BigQuery.
State of Tokens epoch 624
State of Tokens report for epoch 624 - showing minting/burning of tokens and the most actively traded tokens.
State of Transactions epoch 624
State of Tx report for epoch 624 - summarising transactions and counting metadata by type.
State of Scripts epoch 624
State of Scripts report for epoch 624 - showing number of new scripts by type.
State of Pools epoch 624
State of Pools report for epoch 624 - listing new and retiring pools.
Deep comparison epoch 623
Back validation of the exported data from Db-sync to BigQuery.
State of Tokens epoch 623
State of Tokens report for epoch 623 - showing minting/burning of tokens and the most actively traded tokens.
State of Transactions epoch 623
State of Tx report for epoch 623 - summarising transactions and counting metadata by type.
State of Scripts epoch 623
State of Scripts report for epoch 623 - showing number of new scripts by type.
State of Pools epoch 623
State of Pools report for epoch 623 - listing new and retiring pools.
Deep comparison epoch 622
Back validation of the exported data from Db-sync to BigQuery.
State of Transactions epoch 622
State of Tx report for epoch 622 - summarising transactions and counting metadata by type.
State of Tokens epoch 622
State of Tokens report for epoch 622 - showing minting/burning of tokens and the most actively traded tokens.
State of Scripts epoch 622
State of Scripts report for epoch 622 - showing number of new scripts by type.
State of Pools epoch 622
State of Pools report for epoch 622 - listing new and retiring pools.
Deep comparison epoch 621
Back validation of the exported data from Db-sync to BigQuery.
State of Tokens epoch 621
State of Tokens report for epoch 621 - showing minting/burning of tokens and the most actively traded tokens.
State of Transactions epoch 621
State of Tx report for epoch 621 - summarising transactions and counting metadata by type.
State of Scripts epoch 621
State of Scripts report for epoch 621 - showing number of new scripts by type.
State of Pools epoch 621
State of Pools report for epoch 621 - listing new and retiring pools.
Deep comparison epoch 620
Back validation of the exported data from Db-sync to BigQuery.
Deep comparison epoch 619
Back validation of the exported data from Db-sync to BigQuery.