MetricsDAO / harmony_dbt

DBT Project for the Harmony Blockchain
12 stars 8 forks source link

Add Swaps-based prices table "tokenprices" #79

Closed tonykau1 closed 2 years ago

tonykau1 commented 2 years ago

Script to backfill liquidity pools and tokens tables. This uses harmony API to grab the token0, token1, name, symbol, and decimals based on the token_address.

tokenprices table generated from swaps pricing transactions and the liquidity_pools table.

liquidity_pools table requires tokens table to be updated with both token0 and token1. Updating tokens table is currently a manual process (via backfill script run on a list of tokens)