streaming

Polygon ETL Streaming

Streams polygon data to Google Pub/Sub using polygon stream. Runs in Google Kubernetes Engine.

Prerequisites

• Kubernetes 1.8+
• Helm 2.16
• PV provisioner support in the underlying infrastructure
• gcloud

Setting Up

1. Create a GKE cluster:

   gcloud config set project <your_gcp_project>
   PROJECT=$(gcloud config get-value project 2> /dev/null)
   ENVIRONMENT_INDEX=0

   gcloud container clusters create ${PROJECT}-streaming \
   --zone us-central1-a \
   --num-nodes 1 \
   --disk-size 10GB \
   --machine-type n2-standard-2 \
   --network default \
   --subnetwork default \
   --scopes pubsub,storage-rw,logging-write,monitoring-write,service-management,service-control,trace
   
   gcloud container clusters get-credentials polygon-etl-streaming --zone us-central1-a
   
   # Make sure the user has "Kubernetes Engine Admin" role.
   helm init
   bash patch-tiller.sh

2. Create Pub/Sub topics and subscriptions:

   gcloud deployment-manager deployments create polygon-etl-pubsub-topics-0 --template deployment_manager_pubsub_topics.py
   gcloud deployment-manager deployments create polygon-etl-pubsub-subscriptions-0 --template deployment_manager_pubsub_subscriptions.py \
   --properties topics_project:${PROJECT}

3. Create GCS bucket. Upload a text file with block number you want to start streaming from to gs:/<YOUR_BUCKET_HERE>/polygon-etl/streaming/last_synced_block.txt.

4. Create "polygon-etl-app" service account with roles:

   • Pub/Sub Editor
   • Storage Object Admin

   Download the key. Create a Kubernetes secret:

   kubectl create secret generic streaming-app-key --from-file=key.json=$HOME/Downloads/key.json

5. Copy example_values.yaml file to values.yaml and adjust it at least with your bucket and project ID.

6. Install ETL apps via helm using chart from this repo and values we adjust on previous step, for example:

   helm install --name polygon-etl charts/polygon-etl-streaming --values values.yaml

7. Use describe command to troubleshoot, f.e.:

   kubectl describe pods
   kubectl describe node [NODE_NAME]

Configuration

The following table lists the configurable parameters of the polygon-etl-streaming chart and their default values.

Parameter	Description	Default
stream.image.repository	Stream image source repository name	blockchainetl/polygon-etl
stream.image.tag	Image release tag	1.0.2
stream.image.pullPolicy	Image pull policy	IfNotPresent
stream.resources	CPU/Memory resource request/limit	100m/128Mi, 350m/512Mi
stream.env.LAST_SYNCED_BLOCK_FILE_MAX_AGE_IN_SECONDS	The number of seconds since new blocks have been pulled from the node, after which the deployment is considered unhealthy	600
config.PROVIDER_URI	URI of polygon node	grpcs://api.mainnet.polygon.one:443
config.STREAM_OUTPUT	Google Pub Sub topic path prefix	projects/<your-project>/topics/crypto_polygon
config.GCS_PREFIX	Google Storage directory of last synced block file	gs://<your-bucket>/polygon-etl/streaming
config.ENTITY_TYPES	The list of entity types to export	``
config.LAG_BLOCKS	The number of blocks to lag behind the network	10
config.MAX_WORKERS	The number of workers	4
lsb_file	Last synced block file name	last_synced_block.txt

Alternatively, a YAML file that specifies the values for the parameters can be provided while installing the chart. For example,

$ helm install --name polygon --values values.yaml charts/polygon-etl-streaming

Creating a Cloud Source Repository for Configuration Files

Below are the commands for creating a Cloud Source Repository to hold values.yaml:

REPO_NAME=${PROJECT}-streaming-config-${ENVIRONMENT_INDEX} && echo "Repo name ${REPO_NAME}"
gcloud source repos create ${REPO_NAME}
gcloud source repos clone ${REPO_NAME} && cd ${REPO_NAME}

# Put values.yaml to the root of the repo

git add values.yaml && git commit -m "Initial commit"
git push

Check a separate file for operations.

Subscribing to Live polygon Data Feeds

Install Google Cloud SDK:

curl https://sdk.cloud.google.com | bash
exec -l $SHELL
gcloud init

Create a Pub/Sub subscription for polygon actions:

gcloud pubsub subscriptions create crypto_polygon.blocks.test --topic=crypto_polygon.blocks --topic-project=rising-guide-309217

Read a single message from the subscription to test it works:

gcloud pubsub subscriptions pull crypto_polygon.blocks.test

Now you can run a subscriber and process the messages in the subscription, using this Python script:

subscribe.py:

import time
from google.cloud import pubsub_v1
project_id = "<your_project>"
subscription_name = "crypto_polygon.actions.test"
subscriber = pubsub_v1.SubscriberClient()
# The `subscription_path` method creates a fully qualified identifier
# in the form `projects/{project_id}/subscriptions/{subscription_name}`
subscription_path = subscriber.subscription_path(project_id, subscription_name)
def callback(message):
    print('Received message: {}'.format(message))
    message.ack()
subscriber.subscribe(subscription_path, callback=callback)
# The subscriber is non-blocking. We must keep the main thread from
# exiting to allow it to process messages asynchronously in the background.
print('Listening for messages on {}'.format(subscription_path))
while True:
    time.sleep(60)

Make sure to provide project id in the script above

Install the dependencies and run the script:

pip install google-cloud-pubsub==1.0.2
python subscribe.py

You should see:

Listening for messages...
Received message: Message {
  data: b'{"type": "action", "version": 1, "nonce": 0, "gas_...'
  attributes: {}
}
Received message: Message {
  data: b'{"type": "action", "version": 1, "nonce": 0, "gas_...'
  attributes: {}
}
...

You can also use Go, Java, Node.js or C#: https://cloud.google.com/pubsub/docs/pull.