PREVIEW / futures_daily / 2017-12-15

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-15.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-12-15	ES	Futures	2883.22	2916.37	2882.95	2915.01	1410847.0
2017-12-15	NQ	Futures	7499.94	7615.89	7496.43	7610.91	288903.0
2017-12-15	YM	Futures	25876.9	26057.2	25875.8	26024.5	117089.0
2017-12-15	CL	Futures	57.18	57.5	56.98	57.32	357145.0
2017-12-15	GC	Futures	1591.7	1603.1	1591.3	1594.2	246113.0
2017-12-15	ZN	Futures	122.916189	122.962468	122.638517	122.839058	970192.0
2017-12-15	A6	Futures	0.78753	0.79113	0.78526	0.78629	104330.0
2017-12-15	AD	Futures	0.79457	0.79838	0.78904	0.78985	88029.0
2017-12-15	B	Futures	45.03	45.24	44.81	44.92	212995.0
2017-12-15	B6	Futures	1.4023	1.4045	1.3899	1.3919	153034.0
2017-12-15	BR	Futures	0.22717	0.22774	0.22717	0.22774	2071.0
2017-12-15	BZ	Futures	44.71	44.89	44.47	44.58	21478.0
2017-12-15	C	Futures	1287.0	1294.0	1282.0	1287.0	8284.0
2017-12-15	CB	Futures	282.513	282.513	281.432	281.432	14.0
2017-12-15	CC	Futures	1407.0	1420.0	1396.0	1400.0	14274.0
2017-12-15	CNH	Futures	6.7783	6.7808	6.7779	6.7779	30.0
2017-12-15	CSC	Futures	3.404	3.43	3.342	3.351	156.0
2017-12-15	CT	Futures	87.67	89.64	87.64	88.67	30467.0
2017-12-15	DC	Futures	26.87	27.18	26.42	26.5	151.0
2017-12-15	DX	Futures	87.477	87.82	87.275	87.771	24599.0
2017-12-15	E1	Futures	1.23698	1.23977	1.23249	1.23589	32027.0
2017-12-15	E6	Futures	1.3434	1.34918	1.34175	1.34283	288522.0
2017-12-15	E7	Futures	1.3365	1.3424	1.3351	1.3361	3676.0
2017-12-15	EBM	Futures	172.62	173.16	172.62	173.16	7068.0
2017-12-15	ED	Futures	95.4039	95.4039	95.3844	95.399	221090.0
2017-12-15	ER	Futures	98.337	98.342	98.332	98.337	86922.0
2017-12-15	EW	Futures	1984.7	2016.8	1984.0	2004.1	19065.0
2017-12-15	FBON	Futures	126.97	127.23	126.71	126.73	421.0
2017-12-15	FBTP	Futures	113.33	113.57	112.9	113.04	86889.0
2017-12-15	FBTS	Futures	103.805	103.833	103.714	103.732	55266.0
2017-12-15	FCE	Futures	4777.0	4798.0	4760.9	4778.7	77059.0
2017-12-15	FDAX	Futures	13705.9	13725.9	13668.6	13693.1	9343.0
2017-12-15	FDXM	Futures	13550.6	13649.3	13510.0	13612.9	27097.0
2017-12-15	FESX	Futures	2890.3	2909.1	2882.9	2900.1	1030180.0
2017-12-15	FEU3	Futures	99.011	99.011	99.011	99.011	8.0
2017-12-15	FGBL	Futures	151.51	151.71	151.41	151.5	449991.0
2017-12-15	FGBM	Futures	130.19	130.3	130.1	130.12	383477.0
2017-12-15	FGBS	Futures	112.552	112.562	112.512	112.517	273058.0
2017-12-15	FGBX	Futures	172.69	173.83	172.51	173.33	51262.0
2017-12-15	FMWO	Futures	6934.0	6934.0	6934.0	6934.0	0.0
2017-12-15	FOAT	Futures	140.05	140.27	139.93	140.05	71800.0
2017-12-15	FTDX	Futures	2514.4	2524.4	2508.9	2524.4	124.0
2017-12-15	FTI	Futures	505.75	509.09	504.97	507.79	26203.0
2017-12-15	FTUK	Futures	6449.2	6503.4	6442.7	6488.6	134817.0
2017-12-15	FVSA	Futures	297.09	300.25	283.39	287.61	20314.0
2017-12-15	FXXP	Futures	329.5	330.3	328.5	329.5	40105.0
2017-12-15	G	Futures	115.75	115.92	115.56	115.71	164697.0
2017-12-15	GF	Futures	317.166	320.463	313.599	319.436	5299.0
2017-12-15	GSCI	Futures	489.08	489.08	488.26	488.55	73.0
2017-12-15	HE	Futures	90.075	91.542	89.608	91.409	15344.0

> showing 50 of 110 rows — these rows as CSV

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