futures

2 rows where Tradable Months = "G,J,M,Q,V,Z"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ Symbol Description Exch. Fees NFA Fee Tick Size Tick Value Full Point / Multiplier Overnight Requirement Tradable Months Options Available Settlement Method Category price-2024-11-02 notional-2024-11-02 margin/notional-2024-11-02 Exchange Fee / Notional Tick Value / Notional Tick Value / Notional (x 100,000) atr14-2024-11-02 notional-atr14 margin-atr14-ratio atr14-% margin-notional-atr14-% margin/notional to atr14-%
46 46 /GC Gold 1.6 $0.02 0.1 10.0 100.0 15125.0 G,J,M,Q,V,Z 1 Deliverable metals 2738.60009765625 273860.009765625 0.055228947128659944 5.842401018568986e-06 3.6515006366056166e-05 3.6515006366056166 24.831982119576477 2483.198211957648 6.090935442513908 0.9067399851781279 6.71740029344504 0.060909354425139076
47 47 /MGC Micro Gold 0.5 $0.02 0.1 1.0 10.0 1513.0 G,J,M,Q,V,Z 0 Deliverable metals 2749.199951171875 27491.99951171875 0.05503419274233102 1.8187109300175485e-05 3.637421860035097e-05 3.637421860035097 24.810307437500263 248.10307437500262 6.0982718727343626 0.9024555462735482 6.7574207925427086 0.060982718727343614

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [futures] (
   [Symbol] TEXT,
   [Description] TEXT,
   [Exch. Fees] FLOAT,
   [NFA Fee] TEXT,
   [Tick Size] TEXT,
   [Tick Value] FLOAT,
   [Full Point / Multiplier] FLOAT,
   [Overnight Requirement] FLOAT,
   [Tradable Months] TEXT,
   [Options Available] INTEGER,
   [Settlement Method] TEXT,
   [Category] TEXT,
   [price-2024-11-02] FLOAT,
   [notional-2024-11-02] FLOAT,
   [margin/notional-2024-11-02] FLOAT,
   [Exchange Fee / Notional] FLOAT,
   [Tick Value / Notional] FLOAT,
   [Tick Value / Notional (x 100,000)] FLOAT,
   [atr14-2024-11-02] FLOAT,
   [notional-atr14] FLOAT,
   [margin-atr14-ratio] FLOAT,
   [atr14-%] FLOAT,
   [margin-notional-atr14-%] FLOAT,
   [margin/notional to atr14-%] FLOAT
);