Skip to main content

Table Details

PropertyValue
Table Namedydx.raw.market_updates
Table StatusProduction-Ready
Clustering Key(s)to_date("ingested_at")

Table Columns

Column NameData TypeDescription
tickerVARCHAR(16777216)Market ticker symbol identifying the traded instrument.
clob_pair_idVARCHAR(16777216)Identifier of the central limit order book (CLOB) pair for this market.
atomic_resolutionNUMBER(38,0)Number of decimal places used to convert the market’s atomic (integer) quantities to human-readable size.
statusVARCHAR(16777216)Current status of the market (e.g. active, paused).
price_change_24hVARCHAR(16777216)Price change over the trailing 24 hours.
volume_24hVARCHAR(16777216)Trading volume over the trailing 24 hours.
trades_24hNUMBER(38,0)Number of trades over the trailing 24 hours.
next_funding_rateVARCHAR(16777216)Funding rate to be applied at the next funding interval.
initial_margin_fractionVARCHAR(16777216)Initial margin fraction required to open a position in this market.
maintenance_margin_fractionVARCHAR(16777216)Maintenance margin fraction required to keep a position open in this market.
open_interestVARCHAR(16777216)Total open interest in this market.
base_open_interestVARCHAR(16777216)Open interest expressed in the base asset.
quantum_conversion_exponentNUMBER(38,0)Exponent used to convert quote quantums to full quote units.
step_base_quantumsNUMBER(38,0)Minimum increment of order size, in base quantums.
subticks_per_tickNUMBER(38,0)Number of subticks per tick, defining price granularity.
base_assetVARCHAR(16777216)Base asset of the perpetual market.
quote_assetVARCHAR(16777216)Quote asset of the perpetual market.
idVARCHAR(16777216)Identifier of this market update record.
market_idNUMBER(38,0)Identifier of the market this record pertains to.
base_position_sizeVARCHAR(16777216)Aggregate position size expressed in the base asset.
incremental_position_sizeVARCHAR(16777216)Change in aggregate position size in this update.
max_position_sizeVARCHAR(16777216)Maximum allowed position size in this market.
ingested_atTIMESTAMP_NTZ(9)Timestamp (UTC) when this record was ingested into the Allium platform.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.