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

What

Fact table that shows limit swap events - orders placed with specific price limits

Columns

Column NameData TypeDescription
FACT_LIMIT_SWAP_EVENTS_IDTEXTThe surrogate key for the table. Will be unique and is used as a foreign key in other tables
BLOCK_TIMESTAMPTIMESTAMP_NTZTimestamp of block minting(without a timezone)
DIM_BLOCK_IDTEXTFK to DIM_BLOCK table
TX_IDTEXTThe unique transaction id
FROM_ADDRESSTEXTThe user address that initiates the limit swap
TO_ADDRESSTEXTThe destination address for the swap
FROM_ASSETTEXTThe asset being swapped from
FROM_E8NUMBERThe amount being swapped from (divide by 10^8 to get the decimal amount)
TO_ASSETTEXTThe asset being swapped to
TO_E8NUMBERThe amount being swapped to (divide by 10^8 to get the decimal amount)
MEMOTEXTThe transaction memo
EVENT_IDNUMBERUnique identifier for the event
_INSERTED_TIMESTAMPTIMESTAMP_NTZ_INSERTED_TIMESTAMP 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.