PREVIEW / futures_daily / 2017-09-26

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-26.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-09-26	ES	Futures	2717.06	2720.59	2710.81	2714.34	1144642.0
2017-09-26	NQ	Futures	6905.25	6944.89	6886.45	6921.4	343472.0
2017-09-26	YM	Futures	23530.7	23574.0	23480.0	23505.4	102488.0
2017-09-26	CL	Futures	52.81	53.13	52.11	52.57	709515.0
2017-09-26	GC	Futures	1672.2	1675.9	1647.8	1656.3	385645.0
2017-09-26	ZN	Futures	124.256205	124.348635	124.055941	124.225396	1085938.0
2017-09-26	A6	Futures	0.81562	0.81706	0.8078	0.8112	113671.0
2017-09-26	AD	Futures	0.82287	0.82566	0.82007	0.82444	68296.0
2017-09-26	B	Futures	41.35	41.58	40.41	40.9	452774.0
2017-09-26	B6	Futures	1.4081	1.4126	1.4017	1.4064	111324.0
2017-09-26	BR	Futures	0.23619	0.23619	0.23619	0.23619	618.0
2017-09-26	BZ	Futures	40.98	41.23	40.1	40.57	34924.0
2017-09-26	C	Futures	1439.0	1449.0	1434.0	1441.0	5251.0
2017-09-26	CB	Futures	309.894	311.154	309.894	311.154	34.0
2017-09-26	CC	Futures	1463.0	1479.0	1456.0	1463.0	13872.0
2017-09-26	CNH	Futures	6.8341	6.8444	6.8337	6.8384	3.0
2017-09-26	CSC	Futures	3.553	3.557	3.522	3.526	85.0
2017-09-26	CT	Futures	81.62	81.9	80.46	80.75	10192.0
2017-09-26	DC	Futures	29.25	29.34	29.04	29.04	213.0
2017-09-26	DX	Futures	86.427	87.073	86.357	86.765	32788.0
2017-09-26	E1	Futures	1.27186	1.27358	1.26379	1.26856	32579.0
2017-09-26	E6	Futures	1.35795	1.35966	1.34762	1.35247	268602.0
2017-09-26	E7	Futures	1.3508	1.3525	1.3406	1.3454	5336.0
2017-09-26	EBM	Futures	178.82	181.25	178.82	179.63	25676.0
2017-09-26	ED	Futures	95.523	95.523	95.5036	95.5133	300284.0
2017-09-26	ER	Futures	98.337	98.342	98.337	98.337	25143.0
2017-09-26	EW	Futures	1885.7	1890.1	1881.6	1885.2	12548.0
2017-09-26	FBON	Futures	124.66	124.91	124.51	124.84	365.0
2017-09-26	FBTP	Futures	108.78	108.86	108.46	108.64	87970.0
2017-09-26	FBTS	Futures	103.228	103.237	103.2	103.228	33680.0
2017-09-26	FCE	Futures	4710.6	4723.1	4705.2	4718.2	49444.0
2017-09-26	FDAX	Futures	13190.4	13265.0	13180.4	13226.6	56190.0
2017-09-26	FDIV	Futures	147.59	147.59	147.51	147.51	15.0
2017-09-26	FDXM	Futures	13079.0	13153.0	13069.7	13115.0	18041.0
2017-09-26	FESX	Futures	2872.4	2882.2	2869.9	2871.6	634337.0
2017-09-26	FEU3	Futures	99.011	99.011	99.006	99.006	6.0
2017-09-26	FGBL	Futures	149.73	149.74	149.44	149.52	565578.0
2017-09-26	FGBM	Futures	129.74	129.77	129.64	129.71	455632.0
2017-09-26	FGBS	Futures	112.452	112.457	112.422	112.442	243627.0
2017-09-26	FGBX	Futures	168.28	168.6	167.52	167.89	33906.0
2017-09-26	FMWO	Futures	6606.9	6611.6	6592.7	6592.7	824.0
2017-09-26	FOAT	Futures	136.74	136.76	136.5	136.55	70159.0
2017-09-26	FTDX	Futures	2405.6	2405.6	2392.2	2395.2	89.0
2017-09-26	FTI	Futures	485.35	487.65	485.26	486.55	16182.0
2017-09-26	FTUK	Futures	6302.4	6308.9	6273.7	6276.3	80253.0
2017-09-26	FVSA	Futures	417.16	418.58	410.07	414.33	10921.0
2017-09-26	FXXP	Futures	324.7	325.6	324.6	324.9	14596.0
2017-09-26	G	Futures	113.56	113.82	113.43	113.64	150479.0
2017-09-26	GF	Futures	329.396	331.633	326.667	328.795	4350.0
2017-09-26	GSCI	Futures	479.86	481.12	479.38	480.22	83.0

> showing 50 of 109 rows — these rows as CSV

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