PREVIEW / futures_daily / 2017-12-14

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-14.parquet
  size:    9 KB
  rows:    110

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-14	ES	Futures	2900.34	2905.77	2882.13	2886.75	1467120.0
2017-12-14	NQ	Futures	7515.75	7546.79	7498.48	7506.09	292712.0
2017-12-14	YM	Futures	25996.1	26052.0	25871.6	25898.0	133926.0
2017-12-14	CL	Futures	56.66	57.26	56.1	57.07	367227.0
2017-12-14	GC	Futures	1595.0	1599.4	1588.3	1593.7	264708.0
2017-12-14	ZN	Futures	123.055025	123.070451	122.669369	122.977894	1297841.0
2017-12-14	A6	Futures	0.78465	0.78958	0.78413	0.78907	69797.0
2017-12-14	AD	Futures	0.7933	0.8	0.79041	0.79782	74363.0
2017-12-14	B	Futures	44.62	45.11	44.05	44.98	277672.0
2017-12-14	B6	Futures	1.4007	1.4063	1.3988	1.4042	97049.0
2017-12-14	BFX	Futures	4766.0	4766.0	4741.6	4741.6	27.0
2017-12-14	BR	Futures	0.22562	0.22562	0.22562	0.22562	2000.0
2017-12-14	BZ	Futures	44.3	44.77	43.72	44.63	29866.0
2017-12-14	C	Futures	1297.0	1302.0	1282.0	1291.0	8536.0
2017-12-14	CC	Futures	1406.0	1424.0	1400.0	1412.0	16440.0
2017-12-14	CNH	Futures	6.7785	6.7794	6.7785	6.7794	1.0
2017-12-14	CSC	Futures	3.361	3.423	3.361	3.396	69.0
2017-12-14	CT	Futures	86.53	88.25	86.31	87.98	21761.0
2017-12-14	DC	Futures	26.55	27.24	26.55	26.87	214.0
2017-12-14	DX	Futures	87.304	87.665	87.205	87.384	39191.0
2017-12-14	E1	Futures	1.24087	1.24342	1.23565	1.23965	42272.0
2017-12-14	E6	Futures	1.34963	1.35428	1.34379	1.34623	211958.0
2017-12-14	E7	Futures	1.3425	1.3475	1.337	1.3395	4092.0
2017-12-14	EBM	Futures	173.43	173.43	172.35	172.62	10114.0
2017-12-14	ED	Futures	95.4136	95.4184	95.399	95.4087	288917.0
2017-12-14	ER	Futures	98.337	98.342	98.332	98.337	121654.0
2017-12-14	EW	Futures	2001.9	2006.8	1983.5	1985.1	15305.0
2017-12-14	FBON	Futures	126.33	126.76	126.13	126.7	178.0
2017-12-14	FBTP	Futures	113.17	113.48	112.95	113.22	119750.0
2017-12-14	FBTS	Futures	103.768	103.814	103.768	103.796	37804.0
2017-12-14	FCE	Futures	4808.3	4825.3	4765.8	4785.5	69222.0
2017-12-14	FDAX	Futures	13740.6	13834.6	13671.7	13754.2	94531.0
2017-12-14	FDXM	Futures	13582.8	13671.1	13513.2	13593.7	3599.0
2017-12-14	FESX	Futures	2904.2	2914.8	2883.7	2899.3	1047120.0
2017-12-14	FEU3	Futures	99.016	99.016	99.016	99.016	11.0
2017-12-14	FGBL	Futures	151.35	151.55	150.97	151.28	628323.0
2017-12-14	FGBM	Futures	130.24	130.27	129.99	130.14	529009.0
2017-12-14	FGBS	Futures	112.567	112.577	112.512	112.537	373341.0
2017-12-14	FGBX	Futures	171.77	173.08	171.21	172.26	52010.0
2017-12-14	FMWO	Futures	6944.6	6950.5	6929.3	6934.0	2636.0
2017-12-14	FOAT	Futures	139.83	140.0	139.54	139.86	87060.0
2017-12-14	FTDX	Futures	2539.9	2539.9	2517.9	2528.4	1309.0
2017-12-14	FTI	Futures	508.3	509.64	505.38	506.73	21258.0
2017-12-14	FTUK	Futures	6493.8	6497.3	6455.4	6467.2	131146.0
2017-12-14	FVSA	Futures	296.03	299.2	292.87	297.09	20055.0
2017-12-14	FXXP	Futures	331.8	331.8	328.9	330.3	44240.0
2017-12-14	G	Futures	115.28	115.65	115.02	115.55	205219.0
2017-12-14	GF	Futures	314.896	317.382	314.031	316.193	4959.0
2017-12-14	GSCI	Futures	483.66	488.03	483.66	488.03	62.0
2017-12-14	HE	Futures	88.374	91.642	88.374	90.208	19582.0

> showing 50 of 110 rows — these rows as CSV

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