Skip to main content

Overview

This schema contains 6 tables and views for Thorchain data.

Tables and Views

Dim Asset Metadata

A comprehensive dimensional table holding asset metadata and other relevant details pertaining to each id, from multiple providers.

Ez Asset Metadata

A convenience table holding prioritized asset metadata and other relevant details pertaining to each token_address and native asset.

Ez Prices Hourly

A convenience table for determining token prices by address and blockchain, and native asset prices by symbol and blockchain.

Fact Prices

Fact table that provides the summary of the gas events for each block.

Fact Prices Ohlc Hourly

A comprehensive fact table holding id and provider specific open, high, low, close hourly prices, from multiple providers.

Fact Rune Price

Fact table that provides the rune price at a given block height.