# GraphSQL

**Repository Path**: rockcor/graph-sql

## Basic Information

- **Project Name**: GraphSQL
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-03-17
- **Last Updated**: 2024-03-22

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# BigQuery SQL to transaction network
> code of my master thesis
Run in BigQuery console https://console.cloud.google.com/bigquery
* [Table of features and labels of target accounts](https://drive.google.com/file/d/1-1mGX0U7bQUhdJN4woUeloGgy4cFoCyG/view?usp=sharing)
* [Table of features, labels and indices of all accounts in reduced graph](https://drive.google.com/file/d/1-HXrPqDRD064_b7KdRIaBRyKuqvTPlsg/view?usp=sharing)
* [Table of edge indices of reduced graph](https://drive.google.com/file/d/1-GGhkPG6_RSu0zdJfY0gbxDnOm3DaDqr/view?usp=sharing)

## References
1. KOLINKO T. Analysing 1.2M mainnet contracts in 20 seconds using Eveem and BigQuery[EB/OL]//Google Cloud - Community. (2019-01-15). https://medium.com/google-cloud/analysing-1-2m-mainnet-contracts-in-20-seconds-using-eveem-and-bigquery-f69b6d66c7b2.
2. Ethereum in BigQuery: a Public Dataset for smart contract analytics[EB/OL]//Google Cloud Blog. https://cloud.google.com/blog/products/data-analytics/ethereum-bigquery-public-dataset-smart-contract-analytics.
3. An overview of BigQuery’s architecture and how to quickly get started[EB/OL]//Google Cloud Blog. https://cloud.google.com/blog/products/data-analytics/new-blog-series-bigquery-explained-overview.
4. blockchain-etl/awesome-bigquery-views[CP/OL]. Blockchain ETL. https://github.com/blockchain-etl/awesome-bigquery-views.
5. Labelled Ethereum Addresses[EB/OL]. https://www.kaggle.com/datasets/hamishhall/labelled-ethereum-addresses.
6. Ethereum Blockchain[EB/OL]. https://www.kaggle.com/datasets/bigquery/ethereum-blockchain.

## Acknowledgement