PREVIEW / futures_daily / 2018-02-14

all futures daily files

  file:    by_date/futures_daily/2018/2018-02-14.parquet
  size:    10 KB
  rows:    112

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2018-02-14	ES	Futures	2893.81	2936.47	2855.23	2931.31	2087016.0
2018-02-14	NQ	Futures	7682.35	7838.41	7561.43	7831.68	482298.0
2018-02-14	YM	Futures	25973.9	26256.5	25605.9	26220.7	335702.0
2018-02-14	CL	Futures	59.3	61.22	58.5	60.94	451588.0
2018-02-14	GC	Futures	1701.3	1735.4	1684.9	1734.6	431722.0
2018-02-14	ZN	Futures	119.491566	119.692107	118.735681	118.797386	2541538.0
2018-02-14	A6	Futures	0.808	0.81602	0.79946	0.81386	163306.0
2018-02-14	AD	Futures	0.80665	0.81315	0.8029	0.81117	87966.0
2018-02-14	B	Futures	45.09	46.34	44.45	46.18	349099.0
2018-02-14	B6	Futures	1.4462	1.4596	1.4369	1.4564	144520.0
2018-02-14	BFX	Futures	4640.9	4640.9	4630.8	4630.8	32.0
2018-02-14	BR	Futures	0.2301	0.23598	0.22861	0.23347	10503.0
2018-02-14	BTC	Futures	11067.0	12218.6	11067.0	12088.5	944.0
2018-02-14	BZ	Futures	44.24	45.72	43.88	45.58	40865.0
2018-02-14	C	Futures	1331.0	1344.0	1317.0	1338.0	8220.0
2018-02-14	CB	Futures	265.001	268.151	265.001	268.151	31.0
2018-02-14	CC	Futures	1501.0	1551.0	1482.0	1529.0	29292.0
2018-02-14	CNH	Futures	6.4645	6.4834	6.4437	6.4484	106.0
2018-02-14	CSC	Futures	3.235	3.282	3.235	3.263	68.0
2018-02-14	CT	Futures	89.29	89.29	88.08	88.3	14711.0
2018-02-14	DC	Futures	25.5	26.0	25.48	25.85	542.0
2018-02-14	DX	Futures	84.139	84.538	83.425	83.585	39237.0
2018-02-14	E1	Futures	1.30108	1.31067	1.29804	1.30739	30126.0
2018-02-14	E6	Futures	1.40286	1.41607	1.39453	1.41283	305544.0
2018-02-14	E7	Futures	1.3959	1.4089	1.3875	1.4058	7324.0
2018-02-14	EBM	Futures	172.35	173.43	171.81	172.08	15779.0
2018-02-14	ED	Futures	95.2096	95.2096	95.1659	95.1708	438498.0
2018-02-14	ER	Futures	98.332	98.337	98.332	98.332	74985.0
2018-02-14	EW	Futures	1956.7	1993.5	1927.1	1991.1	16851.0
2018-02-14	FBON	Futures	126.15	126.29	125.65	125.98	198.0
2018-02-14	FBTP	Futures	110.88	111.02	110.36	110.86	106262.0
2018-02-14	FBTS	Futures	103.668	103.695	103.631	103.659	45601.0
2018-02-14	FCE	Futures	4529.9	4593.5	4484.0	4560.4	122475.0
2018-02-14	FDAX	Futures	12702.8	12904.6	12514.0	12838.2	118023.0
2018-02-14	FDXM	Futures	12730.6	12925.0	12536.3	12860.0	55252.0
2018-02-14	FESX	Futures	2738.3	2771.8	2703.2	2757.9	1590985.0
2018-02-14	FGBL	Futures	146.66	146.78	146.11	146.41	782580.0
2018-02-14	FGBM	Futures	128.4	128.47	128.22	128.31	511480.0
2018-02-14	FGBS	Futures	112.301	112.311	112.271	112.291	242121.0
2018-02-14	FGBX	Futures	164.03	164.26	162.78	163.37	76802.0
2018-02-14	FMWO	Futures	6892.0	6970.2	6785.8	6910.7	901.0
2018-02-14	FOAT	Futures	135.92	136.15	135.5	135.79	97760.0
2018-02-14	FTDX	Futures	2463.6	2521.4	2463.6	2515.9	565.0
2018-02-14	FTI	Futures	478.72	484.5	473.89	481.1	25084.0
2018-02-14	FTUK	Futures	6242.2	6288.9	6188.9	6258.8	152945.0
2018-02-14	FVSA	Futures	489.99	512.15	445.67	462.9	37889.0
2018-02-14	FXXP	Futures	316.6	319.8	313.7	318.8	60291.0
2018-02-14	G	Futures	111.72	111.84	111.2	111.42	196438.0
2018-02-14	GF	Futures	323.411	326.266	322.533	325.387	5423.0
2018-02-14	GSCI	Futures	488.58	500.64	487.78	500.58	440.0

> showing 50 of 112 rows — these rows as CSV

> unlock the full archive -- $79 one-time