Skip to main content
Schema: thorchain.defi Table: fact_pool_block_statistics Type: Base Table

What

Fact table containing the actions the liquidity providers do in the THORChain, with the amount in RUNE/Asset

Columns

Column NameData TypeDescription
FACT_POOL_BLOCK_STATISTICS_IDTEXTThe surrogate key for the table. Will be unique and is used as a foreign key in other tables
DAYDATEThe timestamp in day for the recorded of the block fee
ADD_ASSET_LIQUIDITY_VOLUMENUMBERHow much asset liquidity has been added to the pool at this time for this pool
ADD_LIQUIDITY_COUNTNUMBERThe count of add liquidity transactions
ADD_LIQUIDITY_VOLUMENUMBERThe asset volume of liquidity added to the pool
ADD_RUNE_LIQUIDITY_VOLUMENUMBERADD_RUNE_LIQUIDITY_VOLUME column
ASSETTEXTAsset name or pool name
ASSET_DEPTHNUMBERThe current pool depth, which is the total Rune pooled in the asset
ASSET_PRICENUMBERThe asset price in RUNE for this day
ASSET_PRICE_USDFLOATThe asset price in USD
AVERAGE_SLIPNUMBERThe average slip point for this block within the day
IMPERMANENT_LOSS_PROTECTION_PAIDNUMBERThe total impermanent loss protection paid for this pool on this day
RUNE_DEPTHNUMBERThe pool depth
STATUSTEXTThe pool status, which is active or not
SWAP_COUNTNUMBERTotal swap transactions count
SWAP_VOLUMENUMBERTotal swap volume
TO_ASSET_AVERAGE_SLIPNUMBERIf the transaction is from Rune to Asset, the average slip point
TO_ASSET_COUNTNUMBERHow many swaps happen from Rune to Asset
TO_ASSET_FEESNUMBERThe total swap fees paid to transfer from Rune to Asset
TO_ASSET_VOLUMENUMBERThe total volume transferred from Rune to Asset
TO_RUNE_AVERAGE_SLIPNUMBERIf the transaction is from Asset to Rune, the average slip point
TO_RUNE_COUNTNUMBERHow many swaps happen from Asset to Rune
TO_RUNE_FEESNUMBERThe total swap fees paid to transfer from Asset to Rune
TO_RUNE_VOLUMENUMBERThe total volume transferred from Asset to Rune
TOTALFEESNUMBERThe total fees paid for the swaps
UNIQUE_MEMBER_COUNTNUMBERAll memberships with a rune address. Take the member from rune and asset and then subtract the balance = 0 then get the results
UNIQUE_SWAPPER_COUNTNUMBERThe unique swap addresses for this pool
UNITSNUMBERThe swap units
WITHDRAW_ASSET_VOLUMENUMBERHow many assets get withdrawn from the liquidity pools
WITHDRAW_COUNTNUMBERHow many times the withdraw events happens
WITHDRAW_RUNE_VOLUMENUMBERHow many rune volume get withdrawn from the pool
WITHDRAW_VOLUMENUMBERHow many asset volume get withdrawn from the pool
TOTAL_STAKENUMBERTOTAL_STAKE column
DEPTH_PRODUCTNUMBERDEPTH_PRODUCT column
SYNTH_UNITSNUMBERSYNTH_UNITS column
POOL_UNITSNUMBERPOOL_UNITS column
LIQUIDITY_UNIT_VALUE_INDEXFLOATLIQUIDITY_UNIT_VALUE_INDEX column
PREV_LIQUIDITY_UNIT_VALUE_INDEXFLOATPREV_LIQUIDITY_UNIT_VALUE_INDEX column
_AUDIT_RUN_IDTEXT_AUDIT_RUN_ID column
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.