PREVIEW / futures_daily / 2017-09-06

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-06.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-09-06	ES	Futures	2673.86	2683.37	2669.78	2679.56	1574076.0
2017-09-06	NQ	Futures	6986.83	7012.98	6946.57	7000.35	335781.0
2017-09-06	YM	Futures	23024.9	23091.5	22981.5	23057.6	134473.0
2017-09-06	CL	Futures	49.87	50.72	49.8	50.45	788963.0
2017-09-06	GC	Futures	1711.4	1714.8	1700.4	1703.8	309352.0
2017-09-06	ZN	Futures	125.796744	125.889083	125.411998	125.427387	37724.0
2017-09-06	A6	Futures	0.82149	0.82386	0.818	0.82119	109782.0
2017-09-06	AD	Futures	0.82201	0.83858	0.81931	0.83162	129312.0
2017-09-06	ALI	Futures	2732.58	2732.58	2732.58	2732.58	0.0
2017-09-06	B	Futures	37.28	38.09	37.23	38.01	322595.0
2017-09-06	B6	Futures	1.363	1.3678	1.3611	1.3633	101962.0
2017-09-06	BR	Futures	0.23875	0.2406	0.23875	0.2406	149.0
2017-09-06	BZ	Futures	36.97	37.75	36.91	37.68	30783.0
2017-09-06	C	Futures	1507.0	1515.0	1461.0	1470.0	6143.0
2017-09-06	CB	Futures	303.595	308.949	303.595	308.949	27.0
2017-09-06	CC	Futures	1449.0	1449.0	1402.0	1423.0	21741.0
2017-09-06	CNH	Futures	6.756	6.7603	6.756	6.7603	1.0
2017-09-06	CSC	Futures	3.414	3.414	3.414	3.414	26.0
2017-09-06	CT	Futures	88.45	88.45	87.53	87.83	43.0
2017-09-06	DC	Futures	28.25	28.37	28.14	28.3	56.0
2017-09-06	DX	Futures	86.093	86.219	85.855	86.142	28041.0
2017-09-06	E1	Futures	1.28697	1.28991	1.28267	1.28414	33702.0
2017-09-06	E6	Futures	1.36605	1.37006	1.36456	1.36554	190153.0
2017-09-06	E7	Futures	1.3588	1.3628	1.3576	1.3584	3380.0
2017-09-06	EBM	Futures	174.51	175.05	173.97	174.51	13284.0
2017-09-06	ED	Futures	95.6056	95.6104	95.6007	95.6032	154203.0
2017-09-06	ER	Futures	98.342	98.342	98.337	98.337	22036.0
2017-09-06	EW	Futures	1826.8	1831.8	1822.8	1826.1	11910.0
2017-09-06	FBON	Futures	125.39	125.44	125.04	125.13	1033.0
2017-09-06	FBTP	Futures	109.85	109.87	109.43	109.5	141122.0
2017-09-06	FBTS	Futures	103.21	103.219	103.1	103.127	65715.0
2017-09-06	FCE	Futures	4524.3	4592.8	4516.7	4564.2	92442.0
2017-09-06	FDAX	Futures	12699.2	12951.9	12687.6	12864.5	111503.0
2017-09-06	FDXM	Futures	12616.8	12871.1	12609.5	12785.3	35690.0
2017-09-06	FESX	Futures	2776.9	2820.2	2772.0	2803.9	943845.0
2017-09-06	FGBL	Futures	150.52	150.57	150.01	150.32	997898.0
2017-09-06	FGBM	Futures	130.17	130.17	129.9	130.0	604307.0
2017-09-06	FGBS	Futures	112.537	112.537	112.452	112.467	533093.0
2017-09-06	FGBX	Futures	170.71	171.01	169.75	170.62	72550.0
2017-09-06	FMWO	Futures	6529.3	6554.3	6529.3	6543.6	995.0
2017-09-06	FOAT	Futures	137.34	137.34	136.88	137.05	218823.0
2017-09-06	FTDX	Futures	2302.2	2331.8	2302.2	2317.2	121.0
2017-09-06	FTI	Futures	475.33	480.33	474.73	478.15	24726.0
2017-09-06	FTUK	Futures	6340.3	6373.1	6320.0	6350.7	115905.0
2017-09-06	FVSA	Futures	514.84	521.13	500.67	510.11	18648.0
2017-09-06	FXXP	Futures	317.1	320.1	316.4	318.6	23850.0
2017-09-06	G	Futures	116.89	116.92	116.61	116.78	165923.0
2017-09-06	GF	Futures	311.825	315.168	311.331	314.182	1438.0
2017-09-06	GSCI	Futures	467.85	469.64	467.85	469.34	40.0
2017-09-06	HE	Futures	89.579	90.069	88.529	88.949	22805.0

> showing 50 of 108 rows — these rows as CSV

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