PREVIEW / futures_daily / 2017-12-22

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-22.parquet
  size:    9 KB
  rows:    89

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-22	ES	Futures	2920.17	2925.33	2915.28	2919.36	654510.0
2017-12-22	NQ	Futures	7600.66	7614.72	7574.6	7593.64	154620.0
2017-12-22	YM	Futures	26146.9	26199.6	26079.4	26118.4	70790.0
2017-12-22	CL	Futures	58.2	58.49	57.86	58.46	324554.0
2017-12-22	GC	Futures	1610.5	1623.3	1608.1	1621.2	193025.0
2017-12-22	ZN	Futures	121.898058	121.975189	121.867206	121.898058	309304.0
2017-12-22	AD	Futures	0.79843	0.80092	0.79472	0.79863	62694.0
2017-12-22	B	Futures	45.92	46.38	45.74	46.36	110419.0
2017-12-22	B6	Futures	1.3975	1.399	1.3935	1.397	24689.0
2017-12-22	BTC	Futures	19972.7	20267.2	15707.9	18102.8	2374.0
2017-12-22	C	Futures	1279.0	1279.0	1259.0	1261.0	6938.0
2017-12-22	CB	Futures	275.842	275.842	274.267	274.884	38.0
2017-12-22	CC	Futures	1407.0	1413.0	1346.0	1350.0	23075.0
2017-12-22	CNH	Futures	6.7328	6.7375	6.728	6.728	30.0
2017-12-22	CSC	Futures	3.227	3.227	3.223	3.223	24.0
2017-12-22	CT	Futures	90.34	91.18	89.93	90.95	16738.0
2017-12-22	DX	Futures	87.336	87.407	87.214	87.265	9375.0
2017-12-22	E1	Futures	1.2371	1.23844	1.23395	1.23553	14001.0
2017-12-22	E6	Futures	1.354	1.35417	1.34822	1.35224	139221.0
2017-12-22	E7	Futures	1.3472	1.3474	1.3416	1.3454	2311.0
2017-12-22	EBM	Futures	172.89	173.97	172.89	173.16	8543.0
2017-12-22	ED	Futures	95.3796	95.3844	95.3747	95.3747	78072.0
2017-12-22	ER	Futures	98.337	98.337	98.332	98.337	27398.0
2017-12-22	EW	Futures	2023.4	2027.4	2018.2	2024.3	7744.0
2017-12-22	FBON	Futures	126.42	126.76	126.22	126.74	484.0
2017-12-22	FBTP	Futures	111.93	112.18	111.73	112.14	38861.0
2017-12-22	FBTS	Futures	103.622	103.686	103.595	103.668	20167.0
2017-12-22	FCE	Futures	4798.9	4817.7	4789.0	4797.5	33208.0
2017-12-22	FDAX	Futures	13549.9	13596.1	13534.4	13561.3	36046.0
2017-12-22	FDXM	Futures	13581.7	13617.1	13557.8	13584.3	13264.0
2017-12-22	FESX	Futures	2896.8	2904.2	2887.8	2892.7	358088.0
2017-12-22	FGBL	Futures	149.8	150.01	149.75	149.93	202340.0
2017-12-22	FGBM	Futures	129.39	129.43	129.26	129.36	179969.0
2017-12-22	FGBS	Futures	112.367	112.367	112.316	112.352	175221.0
2017-12-22	FGBX	Futures	169.09	169.75	169.03	169.42	13486.0
2017-12-22	FMWO	Futures	6946.8	6946.8	6932.8	6935.2	448.0
2017-12-22	FOAT	Futures	138.63	138.77	138.53	138.67	32858.0
2017-12-22	FTDX	Futures	2519.4	2528.9	2515.9	2526.4	25.0
2017-12-22	FTI	Futures	507.37	508.25	506.03	507.61	12233.0
2017-12-22	FTUK	Futures	6574.6	6600.8	6570.7	6577.7	33594.0
2017-12-22	FVSA	Futures	283.39	284.45	277.07	281.29	10629.0
2017-12-22	FXXP	Futures	330.3	333.2	330.0	331.3	16669.0
2017-12-22	G	Futures	114.74	114.95	114.7	114.91	40113.0
2017-12-22	GSCI	Futures	497.23	498.91	497.23	498.91	2.0
2017-12-22	HG	Futures	3.8479	3.8904	3.8252	3.8767	99087.0
2017-12-22	HRC	Futures	1543.7	1543.7	1543.7	1543.7	0.0
2017-12-22	J1	Futures	0.0108211	0.0108351	0.0108131	0.0108333	71339.0
2017-12-22	J7	Futures	0.010788	0.010798	0.010777	0.010797	213.0
2017-12-22	JB	Futures	138.17	138.24	138.09	138.23	1465.0
2017-12-22	KC	Futures	152.87	152.93	149.18	150.31	14679.0

> showing 50 of 89 rows — these rows as CSV

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