Our plan is to build an open-source analytics-ready dataset of Cardano on-chain data which provides the community with an analytics-ready dataset of the Cardano blockchain.

The core data source will be Cardano DB-Sync, and the deliverable will be a Github repository of SQL views which create datasets to enable developers and data scientists to answer questions such as:

How is transaction volume increasing over time?
What are the transaction fees being paid to the network
How much ada is moving around the network
How is money consolidating or distributing amongst wallets
How maybe ppl are delegating

Deliverables

The output of this project would be an open-source Github repository containing data integration scripts and SQL Queries as well as associated schema documentation.

Additionally, if the Cardano Data Hub idea ( https://cardano.ideascale.com/a/dtd/Cardano-Analytics-Data-Hub/368258-48088 ) gets funded, this dataset will be integrated as one of the available datasets there.

Project Plan and Budget

The project will have 4 components:

Data Discovery and community requirement gathering - $1,200

Detailed data review and profiling of db-sync
Collaboration with community on requirements

Data Modelling - $1,200

Modelling datasets based on available data and community input

SQL Development - $1,575

Develop SQL views to aggregate and implement modelled data

Documentation - $600

Provide schema and user documentation for consumers and implementers of the data

Total Budget - $4,575

Budgets are based on a $75/h USD hourly rate. No funds are being requested for infrastructure costs or development tools.

Expected completion date would be 6-8 weeks after funding is received.

Core Team Experience

Michael Stewart

17 years of software development and architecture experience.
10 years focused in the data and analytics space
Led the development team of a boutique data / analytics firm where I designed and architected cloud based data warehouse solutions for fortune 500 companies
Member of the Cardano community since 2017
Co-Founder of Cardano Canucks stake pool and Canuckz NFTs
Co-Founder of CCSPA (Canadian Cardano Stake Pool Association)

Vivek Nankissoor

15+ years of experience in database requirements, design and development
Established and grew web analytics, marketing automation and QA practices
Engaged in marketing, data and analytics strategy development with enterprise retail, cpg organizations, banks, automotive, pharma, fintech and others
Co-Founder of Cardano Canucks stake pool and Canuckz NFTs
Co-Founder of CCSPA (Canadian Cardano Stake Pool Association)
Participant in community work such as financial literacy relating to crypto and raising awareness with various investment groups