PREVIEW / futures_daily / 2017-12-12

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-12.parquet
  size:    9 KB
  rows:    109

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
2017-12-12	ES	Futures	2896.26	2904.41	2893.81	2898.7	1032184.0
2017-12-12	NQ	Futures	7522.51	7526.62	7484.33	7499.01	134498.0
2017-12-12	YM	Futures	25795.7	25917.0	25749.3	25883.2	122118.0
2017-12-12	CL	Futures	58.08	58.62	56.91	57.2	826488.0
2017-12-12	GC	Futures	1577.0	1582.1	1569.9	1574.2	232769.0
2017-12-12	ZN	Futures	122.669369	122.761927	122.42255	122.54596	1175166.0
2017-12-12	A6	Futures	0.77374	0.77919	0.77312	0.77703	18453.0
2017-12-12	AD	Futures	0.79092	0.79366	0.78868	0.79005	34035.0
2017-12-12	B	Futures	45.94	46.77	44.81	45.0	508993.0
2017-12-12	B6	Futures	1.3924	1.3967	1.3888	1.3902	68785.0
2017-12-12	BR	Futures	0.22736	0.22736	0.22607	0.22607	5.0
2017-12-12	BZ	Futures	45.64	46.4	44.48	44.66	55976.0
2017-12-12	C	Futures	1301.0	1310.0	1283.0	1284.0	25271.0
2017-12-12	CB	Futures	279.208	279.208	279.208	279.208	9.0
2017-12-12	CC	Futures	1427.0	1435.0	1390.0	1393.0	25695.0
2017-12-12	CNH	Futures	6.7987	6.7993	6.7979	6.7993	144.0
2017-12-12	CSC	Futures	3.368	3.372	3.344	3.346	71.0
2017-12-12	CT	Futures	85.1	86.65	84.98	85.16	22039.0
2017-12-12	DC	Futures	26.59	26.65	26.46	26.52	90.0
2017-12-12	DX	Futures	87.839	88.111	87.693	87.994	8318.0
2017-12-12	E1	Futures	1.23358	1.23686	1.2314	1.23286	16828.0
2017-12-12	E6	Futures	1.34328	1.34578	1.33739	1.33971	158612.0
2017-12-12	E7	Futures	1.3365	1.3423	1.3308	1.333	883.0
2017-12-12	EBM	Futures	173.7	174.24	172.89	173.7	15888.0
2017-12-12	ED	Futures	95.399	95.399	95.3844	95.3893	331166.0
2017-12-12	ER	Futures	98.337	98.337	98.332	98.337	49759.0
2017-12-12	EW	Futures	2010.7	2012.3	2001.4	2001.9	31286.0
2017-12-12	FBON	Futures	127.05	127.07	126.5	126.53	221.0
2017-12-12	FBTP	Futures	114.63	114.78	114.01	114.15	83061.0
2017-12-12	FBTS	Futures	104.006	104.015	103.887	103.924	40330.0
2017-12-12	FCE	Futures	4827.9	4849.0	4787.2	4848.5	162477.0
2017-12-12	FDAX	Futures	13834.1	13858.8	13744.2	13845.7	144516.0
2017-12-12	FDXM	Futures	13672.2	13699.2	13586.9	13685.7	3231.0
2017-12-12	FESX	Futures	2924.6	2930.3	2905.0	2927.0	1648486.0
2017-12-12	FGBL	Futures	151.6	151.66	151.23	151.32	473178.0
2017-12-12	FGBM	Futures	130.3	130.31	130.15	130.2	368279.0
2017-12-12	FGBS	Futures	112.562	112.567	112.532	112.557	309660.0
2017-12-12	FGBX	Futures	172.84	173.11	171.77	171.97	41298.0
2017-12-12	FMWO	Futures	6924.6	6944.6	6921.0	6936.4	8165.0
2017-12-12	FOAT	Futures	140.21	140.24	139.87	139.94	76534.0
2017-12-12	FTDX	Futures	2504.5	2508.5	2499.5	2506.5	822.0
2017-12-12	FTI	Futures	510.06	511.82	508.02	511.68	36558.0
2017-12-12	FTUK	Futures	6478.1	6505.6	6456.2	6501.7	390951.0
2017-12-12	FVSA	Futures	298.14	302.36	293.93	294.98	15293.0
2017-12-12	FXXP	Futures	330.5	332.8	329.6	332.4	97788.0
2017-12-12	G	Futures	115.18	115.28	114.97	115.06	128596.0
2017-12-12	GF	Futures	315.004	319.976	314.085	318.031	7283.0
2017-12-12	GSCI	Futures	496.41	496.41	487.62	487.62	3091.0
2017-12-12	HE	Futures	89.241	89.441	88.674	88.741	18612.0
2017-12-12	HG	Futures	3.6085	3.6253	3.5918	3.6187	80504.0

> showing 50 of 109 rows — these rows as CSV

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