PREVIEW / futures_daily / 2017-06-13

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-13.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-06-13	ES	Futures	2637.73	2651.57	2636.1	2649.95	1028985.0
2017-06-13	NQ	Futures	6729.01	6784.36	6721.35	6773.76	144808.0
2017-06-13	YM	Futures	22388.5	22504.8	22385.3	22495.3	141476.0
2017-06-13	CL	Futures	47.73	48.3	47.29	48.19	336773.0
2017-06-13	GC	Futures	1618.3	1622.5	1609.1	1619.5	175599.0
2017-06-13	ZN	Futures	124.380877	124.519385	124.288538	124.473216	982608.0
2017-06-13	A6	Futures	0.77362	0.77599	0.77188	0.77342	22763.0
2017-06-13	AD	Futures	0.76475	0.77116	0.76475	0.76999	33932.0
2017-06-13	ALI	Futures	2484.0	2484.0	2484.0	2484.0	0.0
2017-06-13	B	Futures	34.37	34.73	34.05	34.66	321281.0
2017-06-13	B6	Futures	1.3285	1.3372	1.3251	1.3368	50176.0
2017-06-13	BFX	Futures	4713.3	4718.2	4713.3	4718.2	33.0
2017-06-13	BR	Futures	0.21903	0.22078	0.21903	0.22078	3.0
2017-06-13	BZ	Futures	34.19	34.58	33.92	34.51	26775.0
2017-06-13	C	Futures	1680.0	1692.0	1639.0	1641.0	13810.0
2017-06-13	CB	Futures	316.271	322.322	316.271	322.322	18.0
2017-06-13	CC	Futures	1594.0	1605.0	1548.0	1561.0	39133.0
2017-06-13	CSC	Futures	3.651	3.668	3.651	3.655	55.0
2017-06-13	CT	Futures	83.17	83.22	82.3	82.49	22096.0
2017-06-13	DC	Futures	30.5	30.76	30.47	30.59	177.0
2017-06-13	DX	Futures	90.491	90.552	90.249	90.274	10608.0
2017-06-13	E1	Futures	1.27604	1.27923	1.27419	1.27616	6957.0
2017-06-13	E6	Futures	1.29026	1.29261	1.28814	1.29118	78330.0
2017-06-13	E7	Futures	1.2834	1.2858	1.2815	1.2844	1392.0
2017-06-13	EBM	Futures	188.17	189.29	187.9	189.01	10428.0
2017-06-13	ED	Futures	95.5644	95.5741	95.5644	95.5692	185892.0
2017-06-13	ER	Futures	98.337	98.337	98.332	98.337	66668.0
2017-06-13	EW	Futures	1868.2	1882.5	1867.9	1880.3	29766.0
2017-06-13	FBON	Futures	124.52	124.89	124.49	124.73	943.0
2017-06-13	FBTP	Futures	108.67	109.22	108.49	109.16	107467.0
2017-06-13	FBTS	Futures	102.799	102.863	102.79	102.863	44570.0
2017-06-13	FCE	Futures	4715.9	4758.7	4715.9	4735.3	184409.0
2017-06-13	FDAX	Futures	13422.3	13524.1	13401.1	13473.5	152332.0
2017-06-13	FDIV	Futures	151.93	151.93	151.84	151.84	20.0
2017-06-13	FDXM	Futures	13299.1	13397.5	13290.7	13346.7	2238.0
2017-06-13	FESX	Futures	2887.1	2905.1	2885.5	2894.5	1820644.0
2017-06-13	FGBL	Futures	149.97	150.01	149.64	149.83	496301.0
2017-06-13	FGBM	Futures	129.93	129.93	129.76	129.81	296270.0
2017-06-13	FGBS	Futures	112.402	112.402	112.357	112.367	167942.0
2017-06-13	FGBX	Futures	169.52	170.0	169.19	169.82	36024.0
2017-06-13	FMWO	Futures	6484.4	6500.0	6478.4	6484.4	10002.0
2017-06-13	FOAT	Futures	137.15	137.24	136.86	137.11	91649.0
2017-06-13	FTDX	Futures	2261.6	2281.7	2261.6	2277.7	242.0
2017-06-13	FTI	Futures	481.29	483.41	481.06	482.26	35892.0
2017-06-13	FTUK	Futures	6456.5	6470.3	6417.6	6424.1	530517.0
2017-06-13	FVSA	Futures	473.92	478.64	469.19	470.77	16319.0
2017-06-13	FXXP	Futures	329.2	330.2	328.8	329.5	132403.0
2017-06-13	G	Futures	116.79	116.79	115.99	116.18	186155.0
2017-06-13	GF	Futures	332.845	335.973	326.369	329.168	4552.0
2017-06-13	GSCI	Futures	447.44	450.42	447.37	449.99	3358.0

> showing 50 of 109 rows — these rows as CSV

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