Back to plugin list
coinpaprika

Coinpaprika

This plugin is in preview.

Support Coinpaprika coins, exchange, tickets and more

Publisher

coinpaprika

Repositorygithub.com
Latest version

v2.0.0

Type

Source

Platforms
Date Published

Nov 11, 2023

Price

Free

Set up process


brew install cloudquery/tap/cloudquery

1. Download CLI and login

See installation options

2. Create source and destination configs

Plugin configuration

cloudquery sync coinpaprika.yml postgresql.yml

3. Run the sync

CloudQuery sync

Overview

CloudQuery Coinpaprika Source Plugin

A Coinpaprika source plugin for CloudQuery that loads data from Coinpaprika API to any database, data warehouse or data lake supported by CloudQuery, such as PostgreSQL, BigQuery, Athena, and many more.

Configuration

The following source configuration file will sync to a PostgreSQL database. See the CloudQuery Quickstart for more information on how to configure the source and destination.
  1. Without API token, Free plan (25 000 calls/month) minimal interval 1h, see available history range depending on the selected API plan.
    kind: source
    spec:
      name: "coinpaprika"
      path: "coinpaprika/coinpaprika"
      registry: "cloudquery"
      version: "v2.0.0"
      backend_options:
        table_name: "cq_state_coinpaprika"
        connection: "@@plugins.sqlite.connection"
      tables:
        [ "*" ]
      destinations:
        - "sqlite"
      spec:
        api_debug: true
        start_date: "2023-05-15T08:00:00Z" # for free plan up to 1 year ago
        interval: 24h
        rate_duration: 30d
        rate_number: 25000
        tickers:
          ["btc-bitcoin"]
    ---
    kind: destination
    spec:
      name: sqlite
      path: cloudquery/sqlite
      registry: cloudquery
      version: "v2.4.15"
      spec:
        connection_string: ./db.sql
  2. With API token rate limited for Bussines plan (3 000 000 calls/month). API token can be generated at coinpaprika.com/api.
    kind: source
    spec:
      name: "coinpaprika"
      path: "coinpaprika/coinpaprika"
      version: "v2.0.0"
      backend_options:
        table_name: "cq_state_coinpaprika"
        connection: "@@plugins.sqlite.connection"
      tables:
        [ "*" ]
      destinations:
        - "sqlite"
      spec: 
        start_date: "2023-05-15T08:00:00Z"
        interval: 5m 
        access_token: "${COINPAPRIKA_API_TOKEN}"
        api_debug: true
        rate_duration: 30d
        rate_number: 3000000
        tickers: 
          ["*-bitcoin", "eth-ethereum"]
    ---
    kind: destination
    spec:
      name: sqlite
      path: cloudquery/sqlite
      registry: cloudquery
      version: "v2.4.15"
      spec:
        connection_string: ./db.sql
Spec fieldsDescriptionDefault valueOptional
start_dateStart date for synchronizing data in RFC3339 format.NO
end_dateEnd date for synchronizing data in RFC3339 format.NOWYES
intervalIntervals for historic data possible valuesNO
access_tokenCoinpaprika API token.YES
api_debugEnable request log.falseYES
rate_durationUnit of rate in time of request rate, go duration format.30YES
rate_numberNumber of request in rate_duration.30YES
tickerslist of globe pattern ticker ids to synchronize.*YES
concurrencyBest effort maximum number of Go routines to use. Lower this number to reduce memory usage.1000YES
The Coinpaprika plugin supports incremental syncing for historical tickers, only new tickers will be fetched. This is done by storing last timestamp of fetched ticker in CloudQuery backend. To enable this, backend option must be set in the spec.

Running

# https://www.cloudquery.io/docs
brew install cloudquery/tap/cloudquery 
cloudquery sync conf.yml


Subscribe to product updates

Be the first to know about new features.