PREVIEW / futures_daily / 2017-04-10

all futures daily files

  file:    by_date/futures_daily/2017/2017-04-10.parquet
  size:    9 KB
  rows:    110

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-04-10	ES	Futures	2554.1	2566.59	2549.49	2554.92	1351301.0
2017-04-10	NQ	Futures	6384.5	6411.59	6366.84	6386.27	197534.0
2017-04-10	YM	Futures	21746.0	21832.5	21684.8	21734.4	139608.0
2017-04-10	CL	Futures	54.83	55.74	54.8	55.63	565439.0
2017-04-10	GC	Futures	1605.7	1609.9	1596.2	1603.5	182195.0
2017-04-10	ZN	Futures	122.676027	122.952567	122.537758	122.814297	947722.0
2017-04-10	A6	Futures	0.7689	0.76983	0.76654	0.769	61876.0
2017-04-10	AD	Futures	0.76125	0.7664	0.76018	0.76574	48612.0
2017-04-10	ALI	Futures	2531.9	2531.9	2531.9	2531.9	0.0
2017-04-10	B	Futures	40.03	40.65	40.03	40.6	298898.0
2017-04-10	B6	Futures	1.2993	1.3053	1.2987	1.304	61880.0
2017-04-10	BR	Futures	0.22799	0.22821	0.22774	0.22821	718.0
2017-04-10	BZ	Futures	39.95	40.54	39.95	40.49	29224.0
2017-04-10	C	Futures	1672.0	1677.0	1636.0	1638.0	16512.0
2017-04-10	CB	Futures	258.152	258.152	257.237	257.542	21.0
2017-04-10	CC	Futures	1521.0	1523.0	1493.0	1502.0	40938.0
2017-04-10	CNH	Futures	7.2346	7.2399	7.2312	7.2312	43.0
2017-04-10	CSC	Futures	3.487	3.487	3.442	3.478	96.0
2017-04-10	CT	Futures	81.93	83.92	81.76	83.76	28603.0
2017-04-10	DC	Futures	28.48	28.5	28.19	28.33	125.0
2017-04-10	DX	Futures	94.21	94.345	93.977	94.053	21832.0
2017-04-10	E1	Futures	1.22834	1.23156	1.22748	1.2302	15746.0
2017-04-10	E6	Futures	1.22271	1.22576	1.2215	1.22438	132115.0
2017-04-10	E7	Futures	1.2172	1.2194	1.2153	1.2182	2513.0
2017-04-10	EBM	Futures	182.86	182.86	181.74	182.02	23106.0
2017-04-10	ED	Futures	95.5349	95.5542	95.53	95.5494	169629.0
2017-04-10	ER	Futures	98.328	98.332	98.323	98.332	98507.0
2017-04-10	EW	Futures	1811.9	1826.8	1808.3	1816.8	21062.0
2017-04-10	FBON	Futures	122.16	122.32	121.94	122.26	390.0
2017-04-10	FBTP	Futures	105.43	105.6	105.17	105.49	61796.0
2017-04-10	FBTS	Futures	101.927	101.927	101.845	101.864	29581.0
2017-04-10	FCE	Futures	4526.8	4531.2	4492.4	4502.5	82988.0
2017-04-10	FDAX	Futures	12945.6	12982.6	12880.2	12925.6	62340.0
2017-04-10	FDIV	Futures	146.33	146.33	145.85	145.85	1.0
2017-04-10	FDXM	Futures	12836.6	12866.9	12767.5	12812.0	15697.0
2017-04-10	FESX	Futures	2799.0	2801.4	2777.7	2788.3	612864.0
2017-04-10	FEU3	Futures	99.001	99.001	99.001	99.001	9.0
2017-04-10	FGBL	Futures	149.43	150.08	149.43	149.8	507043.0
2017-04-10	FGBM	Futures	129.85	130.18	129.85	130.08	314344.0
2017-04-10	FGBS	Futures	112.467	112.572	112.467	112.547	161582.0
2017-04-10	FGBX	Futures	171.34	173.24	171.24	172.4	25688.0
2017-04-10	FMWO	Futures	6200.1	6209.7	6190.5	6209.7	476.0
2017-04-10	FOAT	Futures	132.28	132.33	131.85	132.03	116393.0
2017-04-10	FTDX	Futures	2014.6	2018.5	2010.7	2018.0	125.0
2017-04-10	FTI	Futures	470.66	470.66	468.14	469.71	587.0
2017-04-10	FTUK	Futures	6247.1	6249.2	6225.3	6241.5	68336.0
2017-04-10	FVSA	Futures	654.42	700.17	651.65	696.01	32954.0
2017-04-10	FXXP	Futures	317.6	317.9	316.2	317.5	18947.0
2017-04-10	G	Futures	115.45	115.73	115.33	115.54	99912.0
2017-04-10	GF	Futures	308.46	313.444	308.403	310.179	7555.0

> showing 50 of 110 rows — these rows as CSV

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