PREVIEW / futures_daily / 2017-01-11

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-11.parquet
  size:    9 KB
  rows:    106

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-01-11	ES	Futures	2454.13	2462.8	2444.64	2461.45	1733727.0
2017-01-11	NQ	Futures	5931.64	5949.91	5901.88	5947.85	218752.0
2017-01-11	YM	Futures	20853.2	20964.8	20810.0	20936.4	185272.0
2017-01-11	CL	Futures	54.37	56.48	54.31	55.92	815846.0
2017-01-11	GC	Futures	1525.8	1539.1	1511.5	1536.7	328686.0
2017-01-11	ZN	Futures	122.042312	122.454926	121.843645	122.072876	1460875.0
2017-01-11	A6	Futures	0.75303	0.76409	0.7518	0.76112	125649.0
2017-01-11	AD	Futures	0.77239	0.77903	0.76877	0.77602	100885.0
2017-01-11	ALI	Futures	2387.84	2407.22	2379.44	2403.99	145.0
2017-01-11	B	Futures	40.08	41.47	40.01	41.05	419902.0
2017-01-11	B6	Futures	1.2789	1.2891	1.2642	1.2821	188898.0
2017-01-11	BR	Futures	0.2181	0.21967	0.21739	0.21967	325.0
2017-01-11	BZ	Futures	39.71	41.17	39.68	40.75	45944.0
2017-01-11	C	Futures	1858.0	1871.0	1806.0	1815.0	11836.0
2017-01-11	CC	Futures	1676.0	1676.0	1603.0	1619.0	24195.0
2017-01-11	CNH	Futures	7.3773	7.3836	7.3447	7.3447	6.0
2017-01-11	CSC	Futures	4.057	4.08	4.022	4.034	46.0
2017-01-11	CT	Futures	84.15	84.79	83.85	84.02	15194.0
2017-01-11	DC	Futures	33.59	33.88	33.19	33.45	455.0
2017-01-11	DX	Futures	94.985	95.865	94.263	94.735	74587.0
2017-01-11	E1	Futures	1.22252	1.23095	1.21335	1.22537	38479.0
2017-01-11	E6	Futures	1.2223	1.23021	1.21058	1.22478	312235.0
2017-01-11	E7	Futures	1.2161	1.2239	1.2043	1.2185	6161.0
2017-01-11	EBM	Futures	193.13	193.99	192.28	192.56	10365.0
2017-01-11	ED	Futures	95.5713	95.5713	95.5617	95.5665	225238.0
2017-01-11	ER	Futures	98.303	98.313	98.298	98.308	107410.0
2017-01-11	EW	Futures	1787.1	1796.6	1782.0	1794.0	20541.0
2017-01-11	FBON	Futures	121.82	122.67	121.68	122.49	366.0
2017-01-11	FBTP	Futures	106.31	107.01	106.12	106.76	102914.0
2017-01-11	FBTS	Futures	101.837	101.891	101.809	101.864	34811.0
2017-01-11	FCE	Futures	4298.6	4324.1	4269.5	4299.0	99526.0
2017-01-11	FDAX	Futures	12218.8	12342.8	12160.7	12284.2	107838.0
2017-01-11	FDXM	Futures	12166.4	12293.6	12111.7	12234.8	27601.0
2017-01-11	FESX	Futures	2638.3	2654.3	2620.7	2638.3	998836.0
2017-01-11	FGBL	Futures	147.14	147.88	147.04	147.43	906714.0
2017-01-11	FGBM	Futures	128.91	129.08	128.83	128.95	523629.0
2017-01-11	FGBS	Futures	112.137	112.147	112.097	112.117	322972.0
2017-01-11	FGBX	Futures	168.19	170.09	167.82	168.84	43180.0
2017-01-11	FMWO	Futures	5937.1	5951.5	5937.1	5937.1	600.0
2017-01-11	FOAT	Futures	132.78	133.28	132.63	133.01	103805.0
2017-01-11	FTDX	Futures	1808.7	1823.9	1803.3	1812.2	133.0
2017-01-11	FTI	Futures	442.11	443.11	441.65	442.38	29.0
2017-01-11	FTUK	Futures	6109.3	6158.9	6097.8	6124.6	109660.0
2017-01-11	FVSA	Futures	896.15	926.29	882.44	907.11	11818.0
2017-01-11	FXXP	Futures	300.8	302.7	299.6	301.2	20301.0
2017-01-11	G	Futures	111.3	111.6	111.14	111.34	151051.0
2017-01-11	GF	Futures	295.34	298.531	293.231	295.511	6079.0
2017-01-11	GSCI	Futures	519.58	523.54	519.58	522.41	2893.0
2017-01-11	HE	Futures	88.222	89.338	87.647	88.695	26715.0
2017-01-11	HG	Futures	3.2402	3.2669	3.2247	3.2414	66763.0

> showing 50 of 106 rows — these rows as CSV

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