PREVIEW / futures_daily / 2017-08-23

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-23.parquet
  size:    9 KB
  rows:    108

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-08-23	ES	Futures	2665.98	2667.88	2650.49	2653.48	1243382.0
2017-08-23	NQ	Futures	6910.12	6916.88	6866.92	6874.56	301682.0
2017-08-23	YM	Futures	23135.9	23150.7	23022.8	23039.7	129593.0
2017-08-23	CL	Futures	48.89	49.78	48.78	49.68	701693.0
2017-08-23	GC	Futures	1641.9	1650.3	1638.7	1647.4	235686.0
2017-08-23	ZN	Futures	124.657894	125.042641	124.596335	125.011861	1206815.0
2017-08-23	A6	Futures	0.81245	0.81328	0.80948	0.81204	66716.0
2017-08-23	AD	Futures	0.80996	0.81123	0.80751	0.81087	50131.0
2017-08-23	ALI	Futures	2733.21	2733.21	2733.21	2733.21	0.0
2017-08-23	B	Futures	36.15	36.81	35.99	36.77	287199.0
2017-08-23	B6	Futures	1.3412	1.3424	1.3366	1.3392	85256.0
2017-08-23	BR	Futures	0.23422	0.23637	0.23384	0.23633	2166.0
2017-08-23	BZ	Futures	35.81	36.49	35.68	36.46	31540.0
2017-08-23	C	Futures	1479.0	1491.0	1471.0	1483.0	2727.0
2017-08-23	CB	Futures	323.751	323.751	323.751	323.751	12.0
2017-08-23	CC	Futures	1380.0	1400.0	1374.0	1389.0	14109.0
2017-08-23	CSC	Futures	3.52	3.528	3.489	3.499	44.0
2017-08-23	CT	Futures	80.66	82.31	80.66	81.23	15.0
2017-08-23	DC	Futures	29.3	29.39	28.97	29.11	330.0
2017-08-23	DX	Futures	87.251	87.359	86.878	86.906	18700.0
2017-08-23	E1	Futures	1.27051	1.27591	1.26793	1.27456	23920.0
2017-08-23	E6	Futures	1.34973	1.35643	1.34692	1.35603	159410.0
2017-08-23	E7	Futures	1.3427	1.3493	1.3398	1.3489	3808.0
2017-08-23	EBM	Futures	168.97	171.47	168.41	170.92	6554.0
2017-08-23	ED	Futures	95.5959	95.6007	95.5935	95.5983	93671.0
2017-08-23	ER	Futures	98.337	98.342	98.337	98.342	19473.0
2017-08-23	EW	Futures	1813.4	1813.6	1800.0	1808.5	11099.0
2017-08-23	FBON	Futures	124.9	124.95	124.42	124.88	599.0
2017-08-23	FBTP	Futures	108.55	108.77	107.93	108.41	104443.0
2017-08-23	FBTS	Futures	103.009	103.036	102.963	103.0	38226.0
2017-08-23	FCE	Futures	4595.0	4606.7	4566.4	4575.8	69341.0
2017-08-23	FDAX	Futures	12882.4	12916.1	12791.8	12824.0	70976.0
2017-08-23	FDXM	Futures	12803.1	12836.6	12705.8	12745.0	24059.0
2017-08-23	FESX	Futures	2819.4	2829.2	2799.0	2806.3	702314.0
2017-08-23	FGBL	Futures	149.3	149.79	149.18	149.76	614804.0
2017-08-23	FGBM	Futures	129.57	129.77	129.5	129.74	381110.0
2017-08-23	FGBS	Futures	112.392	112.432	112.382	112.427	272367.0
2017-08-23	FGBX	Futures	168.71	170.04	168.3	169.78	33303.0
2017-08-23	FMWO	Futures	6490.0	6494.8	6479.3	6493.6	662.0
2017-08-23	FOAT	Futures	136.17	136.55	135.98	136.51	104902.0
2017-08-23	FTDX	Futures	2278.7	2289.7	2268.2	2268.7	65.0
2017-08-23	FTI	Futures	483.16	483.99	479.68	480.75	22516.0
2017-08-23	FTUK	Futures	6383.5	6387.8	6350.7	6377.0	77492.0
2017-08-23	FVSA	Futures	506.96	529.01	503.82	514.84	22738.0
2017-08-23	FXXP	Futures	319.8	320.4	317.5	318.2	21938.0
2017-08-23	G	Futures	115.95	116.31	115.76	116.29	307626.0
2017-08-23	GF	Futures	312.428	313.305	309.577	311.112	4397.0
2017-08-23	GSCI	Futures	451.58	455.35	451.58	455.35	17.0
2017-08-23	HE	Futures	89.019	89.264	87.864	88.949	22213.0
2017-08-23	HG	Futures	3.6342	3.6384	3.6058	3.6276	45585.0

> showing 50 of 108 rows — these rows as CSV

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