A Paradigm Shift in Ethereum Network Analysis Through Google BigQuery,Portation, and Visualization

The primary objective of this research is to comprehensively explore and analyze the dynamics of the Ethereum network using innovative methodologies and system architectures. The study aims to extract meaningful statistics from the Ethereum blockchain, focusing on account activity, popularity trends, and the distribution of transactions. Through rigorous data collection, robust query construction, and advanced analytical techniques, the research seeks to provide valuable insights into how the Ethereum network has evolved, particularly in the aftermath of the “crypto bubble explosion.” The overarching goal is to contribute to the understanding of Ethereum's structural patterns, user behaviors, and the impact of external factors on the network. The research has yielded significant results, unveiling key insights into Ethereum network dynamics. The data collection phase, facilitated by Google BigQuery, successfully captured and filtered relevant information from a specific block range post the “crypto bubble explosion.” The SQL queries, strategically designed for active account identification and popularity assessment, demonstrated efficiency and accuracy in handling the vast Ethereum dataset. The proposed system, introducing the novel methodology of “portation,” showcased its efficiency in extracting and interpreting Ethereum blockchain data using Google BigQuery. The system architecture, as illustrated in the diagram, proved to be a well-coordinated and dynamic framework, emphasizing the seamless flow of data and processes.