_schema.yml

version: 2

models:  
  - name: prices_solana_hour
    meta:
      blockchain: |
        solana
      sector: prices
      short_description: |
          The prices.solana_hour table provides historical price information for each token. The prices are calculated as the volume weighted average price at the hourly level from our dex_solana.prices_block table.
          If there are no trades at a given interval, the previous price is used until a new trade occurs.
          It is recommended to use the contract_address to refer to a token rather than the token symbol as blockchains do not enforce unique token symbols. 
      contributors: couralex, jeff-dude, 0xRob
    config:
      tags: [ 'prices', 'hourly']
  
  - name: prices_solana_day
    meta:
      blockchain: |
        solana
      sector: prices
      short_description: |
          The prices.solana_day table provides historical price information for each token. The prices are calculated as the volume weighted average price at the day level from our dex_solana.prices_block table.
          If there are no trades at a given interval, the previous price is used until a new trade occurs.
          It is recommended to use the contract_address to refer to a token rather than the token symbol as blockchains do not enforce unique token symbols. 
      contributors: couralex, jeff-dude, 0xRob
    config:
      tags: [ 'prices', 'daily']
  
  - name: prices_solana_minute
    meta:
      blockchain: |
        solana
      sector: prices
      short_description: |
          The prices.solana_minute table provides historical price information for each token. The prices are calculated as the volume weighted average price at the minute level from our dex_solana.prices_block table.
          If there are no trades at a given interval, the previous price is used until a new trade occurs.
          It is recommended to use the contract_address to refer to a token rather than the token symbol as blockchains do not enforce unique token symbols. 
      contributors: couralex, jeff-dude, 0xRob
    config:
      tags: [ 'prices', 'daily']
    
  - name: prices_tokens
    meta:
      blockchain: arbitrum, avalanche_c, gnosis, polygon, optimism, ethereum, bnb, solana, fantom, celo, base, zksync, zora, linea, zkevm, blast, sei, nova, worldchain, kaia, ronin, ink, shape
      sector: prices
      contributors: aalan3, hildobby, pipistrella, viniabussafi, jeff-dude, hosuke
    config:
      tags: ['prices', 'tokens', 'usd']
    description: "Price tokens"
    columns:
      - &token_id
        name: token_id
        description: "Id of the token at coinpaprika. This id is required to pull the price feed data. NOTE: Not all tokens are listed at coinpaprika - consider using price data from DEX sources in this case or submit a listing request at coinpaprika."
      - &blockchain
        name: blockchain
        description: "Native blockchain of the token, if any"
      - &contract_address
        name: contract_address
        description: "Contract address of the token, if any"
        data_tests:
          - not_zero_address
      - &symbol
        name: symbol
        description: "Token symbol"
      - &decimals
        name: decimals
        description: "Number of decimals for the token contract"

  - name: prices_native_tokens
    meta:
      blockchain: arbitrum, avalanche_c, gnosis, polygon, optimism, ethereum, bnb, solana, fantom, celo, zksync, zora, sei, nova, worldchain, kaia, ronin, ink
      sector: prices
      contributors: aalan3, jeff-dude
    config:
      tags: ['prices', 'tokens', 'usd']
    description: "Price tokens for native tokens for all chains"
    data_tests:
      - dbt_utils.unique_combination_of_columns:
          combination_of_columns:
            - symbol
    columns:
      - *token_id
      - *blockchain
      - *contract_address
      - *symbol
      - *decimals