Overview
This schema contains 53 tables and views for Thorchain data.Tables and Views
Fact Active Vault Events
Fact table containing the events triggered by the churning activities.
Fact Add Events
Fact table containing add events.
Fact Affiliate Fee Events
Fact table containing all affiliate fee events that occur in the Thorchain network.
Fact Asgard Fund Yggdrasil Events
Fact table containing add events.
Fact Block Pool Depths
Fact table containing all the available pools and its rune/asset depth at each block interval.
Fact Block Rewards
The summarized rewards information for each block per day.
Fact Bond Actions
Fact table containing the clean bond action table to record the node operators’ behaviors.
Fact Bond Events
Fact table containing all the information about the bond activities.
Fact Daily Earnings
The earnings information for the whole THORChain network broken down by daily.
Fact Daily Pool Stats
Fact table that shows the total valued locked and the total value bonded/pooled.
Fact Daily Tvl
Fact table that shows the total valued locked and the total value bonded/pooled.
Fact Errata Events
Fact table containing errata events.
Fact Failed Deposit Messages
Fact table containing failed deposit messages.
Fact Fee Events
Fact table containing all related fees that happen in the Thorchain network.
Fact Gas Events
Fact table that provides the summary of the gas events for each block.
Fact Inactive Vault Events
Fact table that provides the summary of the gas events for each block.
Fact Liquidity Actions
Fact table containing the actions the liquidity providers do in the THORChain, with the amount
in RUNE/Asset.
Fact Loan Open Events
Fact table that shows that the loan open events.
Fact Loan Repayment Events
Fact table that shows that the loan repayment events.
Fact Mint Burn Events
Fact table that shows that the mint and burn events.
Fact Outbound Events
Fact table that provides the summary of the gas events for each block.
Fact Pending Liquidity Events
Fact table that provides the summary of the gas events for each block.
Fact Pool Balance Change Events
Fact table that shows the change of the pool balance.
Fact Pool Block Balances
Fact table containing the actions the liquidity providers do in the THORChain, with the amount
in RUNE/Asset.
Fact Pool Block Fees
Fact table that shows the fee paid by each pool at different timestamp.
Fact Pool Block Statistics
Fact table containing the actions the liquidity providers do in the THORChain, with the amount
in RUNE/Asset.
Fact Pool Events
Fact table that shows that the status of the pool at each block id.
Fact Refund Events
Fact table that shows that the refund events.
Fact Reserve Events
Fact table that shows the amount of rune reserved into the network.
Fact Rewards Event Entries
Fact table that hows the entries for the rewards.
Fact Rewards Events
Fact table that shows the entries for the rewards.
Fact Rune Pool Deposit Events
Fact table containing all rune pool deposit events.
Fact Rune Pool Withdraw Events
Fact table containing all rune pool withdraw events.
Fact Scheduled Outbound Events
Fact table that shows scheduled outbound events.
Fact Secure Asset Deposit Events
Fact table that shows secure asset deposits.
Fact Secure Asset Withdraw Events
Fact table that shows secure asset withdrawals.
Fact Send Messages
Fact table that shows send messages.
Fact Stake Events
Fact table containing stake events.
Fact Streamling Swap Details Events
Fact table that shows the streaming swap event transactions.
Fact Swaps
Fact table that shows the swap activity in Thorchain.
Fact Swaps Events
Fact table that shows the swap event entries table shows the entries for the swaps.
Fact Switch Events
Fact table that shows the switch events.
Fact Tcy Claim Events
Comprehensive fact table tracking THORchain Yield (TCY) reward claim events and transactions.
Fact Tcy Distribution Events
Comprehensive fact table tracking THORchain Yield (TCY) automatic reward distribution events and
transactions.
Fact Tcy Stake Events
Comprehensive fact table tracking THORchain Yield (TCY) staking events and transactions.
Fact Tcy Unstake Events
Comprehensive fact table tracking THORchain Yield (TCY) unstaking events and withdrawal
transactions.
Fact Total Block Rewards
Fact table containing stake events.
Fact Total Value Locked
Fact table that shows set mimir events.
Fact Trade Account Deposit Events
Fact table that shows trade account deposits.
Fact Trade Account Withdraw Events
Fact table that shows trade account withraws.
Fact Update Node Account Status Events
Fact table containing node account status events.
Fact Upgrades
Fact table containing upgrade events.
Fact Withdraw Events
Fact table containing all withdraw events.