PREVIEW / futures_daily / 2014-09-23

all futures daily files

  file:    by_date/futures_daily/2014/2014-09-23.parquet
  size:    9 KB
  rows:    106

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-09-23	ES	Futures	2072.46	2076.64	2056.01	2060.18	1631355.0
2014-09-23	NQ	Futures	4687.48	4706.6	4667.78	4678.79	276929.0
2014-09-23	YM	Futures	17332.1	17359.5	17173.9	17209.4	150323.0
2014-09-23	CL	Futures	170.85	173.47	170.63	172.47	247770.0
2014-09-23	GC	Futures	1593.5	1622.5	1593.3	1602.8	153197.0
2014-09-23	ZN	Futures	116.460004	116.767518	116.44536	116.708944	938261.0
2014-09-23	A6	Futures	0.85683	0.86227	0.85295	0.85401	142672.0
2014-09-23	AD	Futures	0.91824	0.92271	0.91458	0.9156	71923.0
2014-09-23	ALI	Futures	2958.96	2958.96	2958.64	2958.64	35.0
2014-09-23	B	Futures	101.23	101.94	100.86	101.17	192360.0
2014-09-23	B6	Futures	1.7186	1.7243	1.7124	1.7231	111709.0
2014-09-23	BFX	Futures	3858.9	3858.9	3850.2	3850.2	3.0
2014-09-23	BR	Futures	0.22071	0.22184	0.21966	0.21998	118.0
2014-09-23	BZ	Futures	101.92	102.64	101.58	101.89	13561.0
2014-09-23	C	Futures	2277.0	2295.0	2239.0	2247.0	14583.0
2014-09-23	CB	Futures	160.744	160.744	159.164	159.55	22.0
2014-09-23	CC	Futures	2464.0	2485.0	2424.0	2434.0	18407.0
2014-09-23	CNH	Futures	7.0936	7.0936	7.0807	7.082	4.0
2014-09-23	CSC	Futures	5.326	5.352	5.321	5.352	12.0
2014-09-23	CT	Futures	81.81	81.81	79.39	79.39	105.0
2014-09-23	DC	Futures	43.11	43.61	42.66	43.01	165.0
2014-09-23	DX	Futures	80.503	80.569	80.176	80.478	24751.0
2014-09-23	E1	Futures	1.36074	1.36803	1.36074	1.36253	29759.0
2014-09-23	E6	Futures	1.51306	1.51941	1.51258	1.51435	192720.0
2014-09-23	E7	Futures	1.5035	1.5099	1.5031	1.5048	2297.0
2014-09-23	ED	Futures	95.423	95.4278	95.423	95.423	70453.0
2014-09-23	ER	Futures	98.009	98.014	97.994	97.999	77749.0
2014-09-23	EW	Futures	1451.8	1455.5	1436.7	1439.7	22523.0
2014-09-23	FBTP	Futures	95.11	95.26	94.86	94.96	56395.0
2014-09-23	FBTS	Futures	98.757	98.766	98.686	98.703	10807.0
2014-09-23	FCE	Futures	3532.4	3536.0	3463.5	3470.3	125776.0
2014-09-23	FDAX	Futures	10674.6	10680.6	10486.2	10509.7	128214.0
2014-09-23	FDIV	Futures	138.4	138.4	137.52	137.52	25.0
2014-09-23	FESX	Futures	2349.1	2352.0	2310.0	2313.6	1103048.0
2014-09-23	FEU3	Futures	98.631	98.631	98.621	98.621	3.0
2014-09-23	FGBL	Futures	131.18	131.48	131.1	131.2	590951.0
2014-09-23	FGBM	Futures	122.74	122.77	122.58	122.64	320463.0
2014-09-23	FGBS	Futures	110.943	110.943	110.893	110.898	225943.0
2014-09-23	FGBX	Futures	140.15	140.87	140.09	140.51	20893.0
2014-09-23	FMWO	Futures	5716.2	5732.5	5701.2	5701.2	3026.0
2014-09-23	FOAT	Futures	120.97	121.23	120.94	121.06	46256.0
2014-09-23	FTDX	Futures	1182.8	1182.8	1165.3	1166.3	124.0
2014-09-23	FTI	Futures	364.28	364.89	360.26	361.91	33692.0
2014-09-23	FTUK	Futures	5212.9	5224.9	5118.5	5142.1	129446.0
2014-09-23	FVSA	Futures	1376.19	1424.9	1376.19	1424.9	14103.0
2014-09-23	FXXP	Futures	261.7	261.7	258.3	258.8	9171.0
2014-09-23	G	Futures	96.41	96.65	96.36	96.45	117240.0
2014-09-23	GF	Futures	356.539	358.639	355.333	358.056	3494.0
2014-09-23	GSCI	Futures	976.54	977.47	971.58	973.26	33.0
2014-09-23	HE	Futures	128.399	129.61	126.246	128.197	13037.0

> showing 50 of 106 rows — these rows as CSV

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