PREVIEW / futures_daily / 2014-11-18

all futures daily files

  file:    by_date/futures_daily/2014/2014-11-18.parquet
  size:    9 KB
  rows:    105

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
2014-11-18	ES	Futures	2130.17	2145.58	2126.52	2139.83	1146480.0
2014-11-18	NQ	Futures	4883.06	4924.2	4871.18	4911.74	213476.0
2014-11-18	YM	Futures	17875.9	17957.1	17855.6	17908.4	94815.0
2014-11-18	CL	Futures	145.62	147.43	142.98	143.89	188957.0
2014-11-18	GC	Futures	1555.1	1579.4	1551.3	1570.2	170800.0
2014-11-18	ZN	Futures	118.554029	118.773682	118.524742	118.685821	843364.0
2014-11-18	A6	Futures	0.844	0.84838	0.84206	0.84663	83359.0
2014-11-18	AD	Futures	0.89823	0.90158	0.8965	0.89874	43177.0
2014-11-18	ALI	Futures	3042.55	3042.55	3042.55	3042.55	0.0
2014-11-18	B	Futures	81.69	82.66	80.86	81.13	209549.0
2014-11-18	B6	Futures	1.643	1.6478	1.6425	1.6431	78773.0
2014-11-18	BFX	Futures	3855.3	3868.5	3855.3	3868.5	874.0
2014-11-18	BR	Futures	0.20702	0.20829	0.20675	0.2077	457.0
2014-11-18	BZ	Futures	82.46	83.48	81.66	81.96	15851.0
2014-11-18	C	Futures	2018.0	2041.0	2005.0	2011.0	4770.0
2014-11-18	CB	Futures	136.812	137.197	136.812	137.197	5.0
2014-11-18	CC	Futures	2082.0	2106.0	2065.0	2073.0	11513.0
2014-11-18	CNH	Futures	7.0334	7.0334	7.0252	7.0256	2.0
2014-11-18	CSC	Futures	4.741	4.749	4.694	4.699	28.0
2014-11-18	CT	Futures	74.56	76.16	74.2	75.99	6987.0
2014-11-18	DC	Futures	38.3	38.39	37.93	38.2	234.0
2014-11-18	DX	Futures	83.488	83.507	83.123	83.199	26249.0
2014-11-18	E1	Futures	1.32545	1.33568	1.32469	1.3344	37228.0
2014-11-18	E6	Futures	1.46597	1.47704	1.46491	1.47574	209275.0
2014-11-18	E7	Futures	1.4566	1.4677	1.4556	1.4665	3236.0
2014-11-18	ED	Futures	95.4398	95.4422	95.4398	95.4398	47937.0
2014-11-18	ER	Futures	97.994	97.999	97.989	97.994	28623.0
2014-11-18	EW	Futures	1489.3	1500.4	1486.7	1493.2	16582.0
2014-11-18	FBTP	Futures	95.8	95.99	95.71	95.76	45413.0
2014-11-18	FBTS	Futures	98.544	98.561	98.508	98.517	11384.0
2014-11-18	FCE	Futures	3419.9	3462.8	3414.2	3446.2	120207.0
2014-11-18	FDAX	Futures	10213.4	10395.3	10201.9	10356.9	107661.0
2014-11-18	FESX	Futures	2231.8	2265.8	2228.9	2254.2	950775.0
2014-11-18	FGBL	Futures	133.62	133.77	133.51	133.55	486284.0
2014-11-18	FGBM	Futures	123.23	123.26	123.11	123.15	269379.0
2014-11-18	FGBS	Futures	110.893	110.898	110.848	110.863	221403.0
2014-11-18	FGBX	Futures	146.52	146.94	146.32	146.44	16645.0
2014-11-18	FMWO	Futures	5747.6	5747.6	5746.3	5747.6	63.0
2014-11-18	FOAT	Futures	123.1	123.22	123.01	123.05	48705.0
2014-11-18	FTDX	Futures	1213.1	1234.8	1213.1	1234.8	218.0
2014-11-18	FTI	Futures	360.29	363.59	359.72	362.64	15186.0
2014-11-18	FTUK	Futures	5171.1	5199.3	5156.4	5180.0	77079.0
2014-11-18	FVSA	Futures	1560.38	1560.38	1516.43	1520.82	10063.0
2014-11-18	FXXP	Futures	255.3	257.6	255.3	257.0	8303.0
2014-11-18	G	Futures	99.94	100.12	99.67	99.79	138236.0
2014-11-18	GF	Futures	381.427	381.748	379.501	380.705	2236.0
2014-11-18	GSCI	Futures	880.19	880.19	871.16	873.44	380.0
2014-11-18	HE	Futures	123.96	123.96	121.109	122.25	11609.0
2014-11-18	HG	Futures	3.8553	3.8553	3.7937	3.8007	20073.0
2014-11-18	HH	Futures	50.594	51.44	49.891	50.582	8944.0

> showing 50 of 105 rows — these rows as CSV

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