PREVIEW / futures_daily / 2017-07-18

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-18.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-07-18	ES	Futures	2672.77	2674.67	2660.54	2671.14	1091158.0
2017-07-18	NQ	Futures	6886.61	6933.93	6841.94	6915.41	246038.0
2017-07-18	YM	Futures	22821.9	22843.0	22639.0	22749.0	115609.0
2017-07-18	CL	Futures	47.49	48.49	47.34	47.92	639640.0
2017-07-18	GC	Futures	1574.4	1588.2	1573.0	1585.4	253189.0
2017-07-18	ZN	Futures	123.796062	124.273148	123.780672	124.211588	1392924.0
2017-07-18	A6	Futures	0.80033	0.81533	0.79931	0.81317	153078.0
2017-07-18	AD	Futures	0.80182	0.80909	0.80146	0.80665	85948.0
2017-07-18	ALI	Futures	2555.61	2555.61	2555.61	2555.61	20.0
2017-07-18	B	Futures	34.22	34.93	34.11	34.53	251496.0
2017-07-18	B6	Futures	1.3674	1.3746	1.3618	1.3664	125609.0
2017-07-18	BFX	Futures	4639.1	4664.4	4639.1	4663.8	5.0
2017-07-18	BR	Futures	0.23095	0.23336	0.23095	0.23306	114.0
2017-07-18	BZ	Futures	34.01	34.7	33.89	34.31	20301.0
2017-07-18	C	Futures	1524.0	1546.0	1520.0	1524.0	9068.0
2017-07-18	CB	Futures	324.786	327.218	324.177	327.218	34.0
2017-07-18	CC	Futures	1448.0	1476.0	1434.0	1451.0	19102.0
2017-07-18	CNH	Futures	7.0055	7.0055	6.9922	6.9942	22.0
2017-07-18	CSC	Futures	3.522	3.522	3.489	3.499	74.0
2017-07-18	CT	Futures	79.95	80.65	79.19	80.37	13.0
2017-07-18	DC	Futures	29.58	29.65	29.35	29.44	368.0
2017-07-18	DX	Futures	88.661	88.68	88.031	88.149	33621.0
2017-07-18	E1	Futures	1.2807	1.2947	1.27972	1.29163	34243.0
2017-07-18	E6	Futures	1.31942	1.33157	1.31862	1.32887	264281.0
2017-07-18	E7	Futures	1.3125	1.3247	1.3117	1.3219	5821.0
2017-07-18	EBM	Futures	193.46	194.58	191.51	191.79	22184.0
2017-07-18	ED	Futures	95.5983	95.6032	95.5935	95.5983	183045.0
2017-07-18	ER	Futures	98.337	98.342	98.332	98.337	41687.0
2017-07-18	EW	Futures	1878.4	1879.3	1864.5	1871.6	11458.0
2017-07-18	FBON	Futures	123.48	124.05	123.38	123.89	574.0
2017-07-18	FBTP	Futures	106.97	107.49	106.87	107.33	82877.0
2017-07-18	FBTS	Futures	102.726	102.781	102.726	102.763	27390.0
2017-07-18	FCE	Futures	4690.8	4698.5	4635.6	4644.2	176169.0
2017-07-18	FDAX	Futures	13218.3	13234.1	13028.2	13083.0	96167.0
2017-07-18	FDXM	Futures	13135.9	13152.6	12949.6	13002.4	25376.0
2017-07-18	FESX	Futures	2858.5	2867.5	2825.9	2835.7	1009107.0
2017-07-18	FEU3	Futures	99.011	99.011	99.011	99.011	27.0
2017-07-18	FGBL	Futures	146.67	146.96	146.48	146.81	576792.0
2017-07-18	FGBM	Futures	128.39	128.54	128.33	128.45	380793.0
2017-07-18	FGBS	Futures	112.136	112.177	112.121	112.162	213548.0
2017-07-18	FGBX	Futures	163.37	164.24	163.01	163.7	39935.0
2017-07-18	FMWO	Futures	6510.3	6510.3	6496.0	6501.9	866.0
2017-07-18	FOAT	Futures	134.55	134.81	134.38	134.66	96467.0
2017-07-18	FTDX	Futures	2301.7	2304.2	2278.2	2278.2	73.0
2017-07-18	FTI	Futures	478.35	479.19	474.93	475.72	20939.0
2017-07-18	FTUK	Futures	6342.9	6356.7	6301.8	6332.5	83005.0
2017-07-18	FVSA	Futures	450.92	467.23	447.95	462.78	30411.0
2017-07-18	FXXP	Futures	327.8	328.0	324.2	324.9	35033.0
2017-07-18	G	Futures	113.89	114.65	113.72	114.53	170045.0
2017-07-18	GF	Futures	337.729	337.839	330.43	332.79	6048.0

> showing 50 of 110 rows — these rows as CSV

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