PREVIEW / futures_daily / 2017-10-24

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-24.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-10-24	ES	Futures	2787.22	2795.65	2786.94	2792.38	1047808.0
2017-10-24	NQ	Futures	7123.73	7156.32	7114.62	7141.05	235526.0
2017-10-24	YM	Futures	24520.2	24748.3	24520.2	24713.4	132148.0
2017-10-24	CL	Futures	52.33	53.06	51.98	52.91	709553.0
2017-10-24	GC	Futures	1633.6	1635.4	1622.1	1626.5	268907.0
2017-10-24	ZN	Futures	123.20867	123.254885	122.808142	122.977596	1353951.0
2017-10-24	A6	Futures	0.80286	0.80461	0.79905	0.80091	98574.0
2017-10-24	AD	Futures	0.80496	0.80638	0.80186	0.80308	73671.0
2017-10-24	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-10-24	B	Futures	40.54	41.36	40.28	41.19	334681.0
2017-10-24	B6	Futures	1.3781	1.3813	1.3694	1.3718	95959.0
2017-10-24	BR	Futures	0.2323	0.23309	0.22909	0.23045	1093.0
2017-10-24	BZ	Futures	40.18	40.96	39.95	40.86	32802.0
2017-10-24	C	Futures	1545.0	1551.0	1522.0	1527.0	8240.0
2017-10-24	CB	Futures	299.879	299.879	295.218	295.218	27.0
2017-10-24	CC	Futures	1574.0	1580.0	1542.0	1547.0	26698.0
2017-10-24	CSC	Futures	3.423	3.445	3.423	3.435	12.0
2017-10-24	CT	Futures	81.56	82.48	81.07	81.68	21156.0
2017-10-24	DC	Futures	27.7	27.78	27.55	27.66	198.0
2017-10-24	DX	Futures	87.62	87.783	87.489	87.588	18542.0
2017-10-24	E1	Futures	1.24558	1.24704	1.23763	1.24093	23563.0
2017-10-24	E6	Futures	1.3446	1.34956	1.3438	1.34876	176374.0
2017-10-24	E7	Futures	1.3374	1.3425	1.3368	1.3418	2681.0
2017-10-24	EBM	Futures	174.78	174.78	173.97	173.97	8266.0
2017-10-24	ED	Futures	95.4988	95.5036	95.4939	95.4939	191878.0
2017-10-24	ER	Futures	98.342	98.347	98.337	98.337	61822.0
2017-10-24	EW	Futures	1938.0	1949.5	1938.0	1946.0	9586.0
2017-10-24	FBON	Futures	124.76	124.83	124.49	124.65	198.0
2017-10-24	FBTP	Futures	110.44	110.53	109.96	110.07	69293.0
2017-10-24	FBTS	Futures	103.494	103.512	103.439	103.466	34841.0
2017-10-24	FCE	Futures	4815.4	4848.6	4811.8	4831.5	58900.0
2017-10-24	FDAX	Futures	13644.9	13717.4	13637.0	13681.2	67106.0
2017-10-24	FDXM	Futures	13530.3	13600.1	13523.0	13565.7	23323.0
2017-10-24	FESX	Futures	2931.9	2951.5	2931.9	2941.7	638401.0
2017-10-24	FEU3	Futures	99.016	99.016	99.011	99.011	17.0
2017-10-24	FGBL	Futures	149.49	149.52	148.87	148.97	702875.0
2017-10-24	FGBM	Futures	129.74	129.77	129.51	129.55	482324.0
2017-10-24	FGBS	Futures	112.487	112.487	112.442	112.447	234606.0
2017-10-24	FGBX	Futures	167.42	167.48	166.05	166.15	50577.0
2017-10-24	FMWO	Futures	6761.6	6761.6	6754.5	6759.2	703.0
2017-10-24	FOAT	Futures	136.96	137.01	136.46	136.52	110230.0
2017-10-24	FTDX	Futures	2498.5	2513.4	2477.5	2483.5	391.0
2017-10-24	FTI	Futures	504.04	505.01	502.18	502.23	17650.0
2017-10-24	FTUK	Futures	6491.6	6513.7	6486.8	6508.5	59154.0
2017-10-24	FVSA	Futures	351.72	359.39	344.04	356.83	23048.0
2017-10-24	FXXP	Futures	330.9	331.7	329.8	330.3	22345.0
2017-10-24	G	Futures	113.86	113.97	113.46	113.63	178807.0
2017-10-24	GF	Futures	329.797	337.286	328.989	336.478	4703.0
2017-10-24	GSCI	Futures	476.16	479.34	474.45	479.34	4.0
2017-10-24	HE	Futures	93.761	95.053	92.949	94.537	18717.0

> showing 50 of 109 rows — these rows as CSV

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