PREVIEW / futures_daily / 2018-11-12

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-12.parquet
  size:    10 KB
  rows:    113

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-11-12	ES	Futures	3013.59	3031.48	2952.31	2958.28	1921301.0
2018-11-12	NQ	Futures	8161.17	8251.19	7928.28	7939.03	702949.0
2018-11-12	YM	Futures	27352.8	27480.2	26677.8	26727.3	247423.0
2018-11-12	CL	Futures	63.26	63.86	61.15	62.46	806219.0
2018-11-12	GC	Futures	1534.0	1536.1	1521.7	1525.3	203644.0
2018-11-12	ZN	Futures	117.705316	118.001019	117.643063	117.923202	563274.0
2018-11-12	A6	Futures	0.7428	0.74496	0.73837	0.73992	74691.0
2018-11-12	AD	Futures	0.76607	0.76748	0.76364	0.7648	49313.0
2018-11-12	B	Futures	52.25	53.13	50.9	51.83	319229.0
2018-11-12	B6	Futures	1.3315	1.3335	1.3212	1.324	144906.0
2018-11-12	BR	Futures	0.2033	0.20437	0.2017	0.20296	2608.0
2018-11-12	BTC	Futures	9105.1	9257.1	9105.1	9155.8	1997.0
2018-11-12	BZ	Futures	51.78	52.75	50.57	51.47	39814.0
2018-11-12	C	Futures	1522.0	1522.0	1497.0	1498.0	7937.0
2018-11-12	CB	Futures	265.86	266.49	265.86	266.16	10.0
2018-11-12	CC	Futures	1560.0	1583.0	1541.0	1549.0	29954.0
2018-11-12	CNH	Futures	6.9886	7.0178	6.9874	7.012	1090.0
2018-11-12	CSC	Futures	2.918	2.952	2.916	2.94	75.0
2018-11-12	CT	Futures	87.65	87.68	85.69	85.73	24506.0
2018-11-12	DC	Futures	24.18	24.56	24.14	24.46	706.0
2018-11-12	DX	Futures	92.029	92.652	91.958	92.511	21075.0
2018-11-12	E1	Futures	1.18181	1.18217	1.17565	1.17731	21383.0
2018-11-12	E6	Futures	1.26188	1.26321	1.25032	1.25315	202614.0
2018-11-12	E7	Futures	1.2562	1.2569	1.2442	1.247	4906.0
2018-11-12	EBM	Futures	208.2	210.53	208.2	210.01	25907.0
2018-11-12	ED	Futures	94.9646	94.9841	94.9597	94.9743	74187.0
2018-11-12	ER	Futures	98.381	98.386	98.381	98.381	27614.0
2018-11-12	EW	Futures	1978.1	1991.7	1945.0	1947.3	16702.0
2018-11-12	FBON	Futures	127.43	127.48	127.29	127.3	357.0
2018-11-12	FBTP	Futures	105.18	105.54	104.66	104.69	50088.0
2018-11-12	FBTS	Futures	102.827	102.883	102.518	102.574	53588.0
2018-11-12	FCE	Futures	4572.5	4587.7	4509.4	4513.9	51341.0
2018-11-12	FDAX	Futures	12164.6	12193.6	11870.2	11902.8	110227.0
2018-11-12	FDXM	Futures	11953.5	11982.4	11664.1	11696.7	52515.0
2018-11-12	FESX	Futures	2716.7	2721.8	2670.5	2675.6	1006702.0
2018-11-12	FGBL	Futures	153.08	153.55	153.06	153.4	507781.0
2018-11-12	FGBM	Futures	131.03	131.26	131.01	131.19	301654.0
2018-11-12	FGBS	Futures	112.663	112.713	112.658	112.698	256852.0
2018-11-12	FGBX	Futures	177.57	178.46	177.41	178.06	36224.0
2018-11-12	FMWO	Futures	6865.1	6865.1	6749.2	6751.6	4072.0
2018-11-12	FOAT	Futures	140.15	140.48	140.13	140.36	82646.0
2018-11-12	FTDX	Futures	2630.4	2637.8	2516.5	2519.0	469.0
2018-11-12	FTI	Futures	492.95	494.25	486.31	486.93	18648.0
2018-11-12	FTUK	Futures	6345.2	6394.8	6277.3	6292.5	92294.0
2018-11-12	FVSA	Futures	321.55	345.74	320.54	340.7	24429.0
2018-11-12	FXXP	Futures	317.8	318.0	312.5	313.1	40043.0
2018-11-12	G	Futures	114.82	115.17	114.78	115.09	222577.0
2018-11-12	GF	Futures	309.813	311.374	307.983	309.383	6499.0
2018-11-12	GSCI	Futures	501.66	502.28	493.43	497.88	2670.0
2018-11-12	HE	Futures	74.76	77.713	74.122	75.901	32464.0

> showing 50 of 113 rows — these rows as CSV

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