Models: Prices: Prices Pipeline - FlipsideCrypto/fsc-evm GitHub Wiki

Model/function variables are set and managed in each repo's dbt_project.yml file, or the models/functions themselves. Please see the fsc-evm installation instructions in the README or the Installing fsc-evm guide for more details on how to access and utilize variables effectively.

Overview

  • The Prices models are used to deploy tables for the Prices pipeline, which references the pipeline established in the Crosschain repo. Please see the Prices Pipeline guide for more details on how to deploy and manage these tables effectively.

Bronze

Model: bronze.complete_native_asset_metadata

Usage

  • Description: This model retrieves metadata for Native assets based on the specified symbols and blockchains from crosschain.silver.complete_native_asset_metadata.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.bronze.bronze__complete_native_asset_metadata

Variables

Variable Type Default Required Description
PRICES_NATIVE_SYMBOLS String or Array - Yes The symbols to filter the asset metadata.
PRICES_NATIVE_BLOCKCHAINS String or Array GLOBAL_PROD_DB_NAME Yes The blockchains to filter the asset metadata.

Model: bronze.complete_native_prices

Usage

  • Description: This model retrieves prices for Native assets based on the specified symbols and blockchains from crosschain.silver.complete_native_prices.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.bronze.bronze__complete_native_prices

Variables

Variable Type Default Required Description
PRICES_NATIVE_SYMBOLS String or Array - Yes The symbols to filter the prices.
PRICES_NATIVE_BLOCKCHAINS String or Array GLOBAL_PROD_DB_NAME Yes The blockchains to filter the prices.

Model: bronze.complete_provider_asset_metadata

Usage

  • Description: This model retrieves raw, provider asset metadata filtered by specified platforms from crosschain.silver.complete_provider_asset_metadata.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.bronze.bronze__complete_provider_asset_metadata

Variables

Variable Type Default Required Description
PRICES_PROVIDER_PLATFORMS String or Array - Yes The platforms specific to the target blockchain for which the asset metadata is being retrieved.

Model: bronze.complete_provider_prices

Usage

  • Description: This model retrieves provider prices from crosschain.silver.complete_provider_prices.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.bronze.bronze__complete_provider_prices

Variables

Variable Type Default Required Description
- - - - -

Model: bronze.complete_token_asset_metadata

Usage

  • Description: This model retrieves token asset metadata for specified token addresses and blockchains from crosschain.silver.complete_token_asset_metadata.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.bronze.bronze__complete_token_asset_metadata

Variables

Variable Type Default Required Description
PRICES_TOKEN_ADDRESSES String or Array None No The addresses of the tokens for which metadata is being retrieved.
PRICES_TOKEN_BLOCKCHAINS String or Array GLOBAL_PROD_DB_NAME Yes The blockchains to filter the asset metadata.

Model: bronze.complete_token_prices

Usage

  • Description: This model retrieves token prices for specified token addresses and blockchains from crosschain.silver.complete_token_prices.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.bronze.bronze__complete_token_prices

Variables

Variable Type Default Required Description
PRICES_TOKEN_ADDRESSES String or Array None No The addresses of the tokens for which price data is being retrieved.
PRICES_TOKEN_BLOCKCHAINS String or Array GLOBAL_PROD_DB_NAME Yes The blockchains to filter the prices.

Silver

Model: silver.complete_native_asset_metadata

Usage

  • Description: This model retrieves metadata for Native assets from <DATABASE>.bronze.complete_native_asset_metadata.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.silver.silver__complete_native_asset_metadata

Variables

Variable Type Default Required Description
- - - - -

Model: silver.complete_native_prices

Usage

  • Description: This model retrieves prices for Native assets from <DATABASE>.bronze.complete_native_prices.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.silver.silver__complete_native_prices

Variables

Variable Type Default Required Description
- - - - -

Model: silver.complete_provider_asset_metadata

Usage

  • Description: This model retrieves raw, provider asset metadata from <DATABASE>.bronze.complete_provider_asset_metadata.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.silver.silver__complete_provider_asset_metadata

Variables

Variable Type Default Required Description
- - - - -

Model: silver.complete_provider_prices

Usage

  • Description: This model retrieves raw, provider prices from <DATABASE>.bronze.complete_provider_prices.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.silver.silver__complete_provider_prices

Variables

Variable Type Default Required Description
- - - - -

Model: silver.complete_token_asset_metadata

Usage

  • Description: This model retrieves token asset metadata from <DATABASE>.bronze.complete_token_asset_metadata.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.silver.silver__complete_token_asset_metadata

Variables

Variable Type Default Required Description
- - - - -

Model: silver.complete_token_prices

Usage

  • Description: This model retrieves token prices from <DATABASE>.bronze.complete_token_prices.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.silver.silver__complete_prices

Variables

Variable Type Default Required Description
- - - - -

Gold

Model: price.dim_asset_metadata

Usage

  • Description: This model retrieves raw, provider asset metadata from <DATABASE>.silver.complete_provider_asset_metadata.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.gold.price__dim_asset_metadata

Variables

Variable Type Default Required Description
- - - - -

Model: price.fact_prices_ohlc_hourly

Usage

  • Description: This model retrieves hourly OHLC (Open, High, Low, Close) price data from <DATABASE>.silver.complete_provider_prices.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.gold.price__fact_prices_ohlc_hourly

Variables

Variable Type Default Required Description
- - - - -

Model: price.ez_asset_metadata

Usage

  • Description: This model retrieves both token and native asset metadata from <DATABASE>.silver.complete_token_asset_metadata and <DATABASE>.silver.complete_native_asset_metadata.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.gold.price__ez_asset_metadata

Variables

Variable Type Default Required Description
- - - - -

Model: price.ez_prices_hourly

Usage

  • Description: This model retrieves token prices for specified token addresses and blockchains from <DATABASE>.silver.complete_token_prices and <DATABASE>.silver.complete_native_prices.
  • Min. Requirements:
    • Version: v3.0.0
    • Package: main_package
    • Sub-package: prices
  • Deployment Path: main_package.prices.gold.price__ez_prices_hourly

Variables

Variable Type Default Required Description
- - - - -
⚠️ **GitHub.com Fallback** ⚠️