futures

2 rows where Exch. Fees = "0.5"

✎ 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-%
21 21 /QG E-mini Natural Gas 0.5 $0.02 0.005 12.5 2500.0 935.0 6-mo from active 0 Financially energy 2.6649999618530273 6662.499904632568 0.140337713078221 7.504690538942298e-05 0.0018761726347355746 187.61726347355747 0.1686401064008177 421.60026600204424 2.217740536234544 6.327959054962196 0.35046695419046026 0.022177405362345443
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
);