Report Name

Blockchain Analytics and Data Pipelines - Report 3

Reporting Period

August 21 - September 19 (30 days)

Report Description

The ICON-ETL package has had its first full release (v0.1.0), and is available on Pypi! Integration with Airflow is underway, with DAGs working to extract and load the blockchain data into a Postgres database. The recent change to the ICON RPC Server (as part of the 1.5.0 release) has been fixed as part of the 1.5.1 release, however the bug did significantly delay our work on this project by nearly a month. Basic queries on data are functioning, with visualizations coming in the next week or so.

Project Completion Percentage

80%

Remaining Time to Completion

3.5 weeks

Expected Results for the Next Period

Next reporting period should see the final deliverables for the project which was delayed as mentioned above. We also have two fellows working on building analytics solutions on top of our process this session. Work from their projects will be integrated when their fellowship ends in 2 months.

Materials Proving Progress on the Project

• icon-etl
  • https://github.com/insight-icon/icon-etl
  • https://pypi.org/project/icon-etl/
• icon-etl-airflow
  • https://github.com/insight-icon/icon-etl-airflow
• Infrastructure
  • https://github.com/insight-infrastructure/terraform-aws-ec2-airflow
  • https://github.com/insight-infrastructure/terraform-aws-superset

Review of each KPI (Key Performance Indicator) or specific goal/milestone

Phase 1: Metrics High Grading (80%)

Milestones:

• Canvass community and foundation for a high grading of metrics to be collected (completed)