PREVIEW / futures_daily / 2012-01-27

all futures daily files

  file:    by_date/futures_daily/2012/2012-01-27.parquet
  size:    9 KB
  rows:    99

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
2012-01-27	ES	Futures	1319.44	1323.95	1311.66	1317.18	1730821.0
2012-01-27	NQ	Futures	2805.24	2818.39	2795.81	2808.96	169927.0
2012-01-27	YM	Futures	12262.5	12301.2	12161.9	12198.7	97066.0
2012-01-27	CL	Futures	186.76	188.07	185.27	186.07	253456.0
2012-01-27	GC	Futures	2309.2	2334.1	2299.6	2323.9	149457.0
2012-01-27	ZN	Futures	113.543325	113.921398	113.381294	113.82688	1085497.0
2012-01-27	A6	Futures	0.9403	0.9443	0.93745	0.9427	120912.0
2012-01-27	AD	Futures	1.00041	1.00382	0.9984	1.00131	81730.0
2012-01-27	B	Futures	98.66	99.49	98.24	98.98	101792.0
2012-01-27	B6	Futures	1.6394	1.6449	1.6344	1.6429	100109.0
2012-01-27	BFX	Futures	2694.4	2694.4	2684.9	2692.2	12.0
2012-01-27	BR	Futures	0.26742	0.26742	0.26639	0.26676	596.0
2012-01-27	BZ	Futures	105.15	105.97	104.98	105.49	669.0
2012-01-27	C	Futures	1634.0	1638.0	1573.0	1593.0	5959.0
2012-01-27	CB	Futures	84.637	84.637	84.367	84.502	32.0
2012-01-27	CC	Futures	1901.0	1923.0	1830.0	1865.0	12865.0
2012-01-27	CSC	Futures	3.937	3.942	3.903	3.903	11.0
2012-01-27	CT	Futures	122.74	124.27	122.74	123.14	7422.0
2012-01-27	DC	Futures	28.07	28.41	28.06	28.06	281.0
2012-01-27	DX	Futures	77.495	77.505	76.785	76.903	28579.0
2012-01-27	E1	Futures	1.42657	1.44114	1.42302	1.43851	35764.0
2012-01-27	E6	Futures	1.56668	1.58222	1.56321	1.57863	331156.0
2012-01-27	E7	Futures	1.5524	1.5679	1.5489	1.5642	5419.0
2012-01-27	EBM	Futures	272.55	274.19	272.23	273.87	6495.0
2012-01-27	ED	Futures	95.0868	95.0916	95.0677	95.0772	138227.0
2012-01-27	ER	Futures	97.44	97.449	97.39	97.4	162997.0
2012-01-27	EW	Futures	942.3	949.3	937.1	947.1	17629.0
2012-01-27	FBTP	Futures	62.54	63.57	62.39	63.21	12646.0
2012-01-27	FBTS	Futures	83.164	83.341	83.084	83.276	875.0
2012-01-27	FCE	Futures	2390.4	2398.2	2278.3	2363.7	80636.0
2012-01-27	FDAX	Futures	7204.5	7265.3	7162.6	7203.4	141730.0
2012-01-27	FESX	Futures	1640.6	1650.7	1624.6	1632.6	993679.0
2012-01-27	FEU3	Futures	97.954	97.954	97.954	97.954	273.0
2012-01-27	FGBL	Futures	112.32	112.7	112.1	112.4	637797.0
2012-01-27	FGBM	Futures	113.36	113.52	113.21	113.31	335304.0
2012-01-27	FGBS	Futures	109.934	109.969	109.874	109.894	338493.0
2012-01-27	FGBX	Futures	116.05	116.75	115.77	116.21	4875.0
2012-01-27	FTDX	Futures	691.1	693.0	689.3	691.1	191.0
2012-01-27	FTI	Futures	268.17	269.05	265.91	266.45	37615.0
2012-01-27	FTUK	Futures	4131.1	4149.1	4098.6	4107.3	103007.0
2012-01-27	FVSA	Futures	10294.58	10429.02	10198.54	10332.99	4587.0
2012-01-27	FXXP	Futures	181.5	182.1	180.3	180.4	772.0
2012-01-27	G	Futures	94.26	94.65	94.09	94.36	119975.0
2012-01-27	GF	Futures	326.166	328.499	325.371	327.862	1639.0
2012-01-27	GSCI	Futures	1041.68	1047.55	1038.63	1043.87	137.0
2012-01-27	HE	Futures	105.32	105.803	104.202	105.592	16115.0
2012-01-27	HG	Futures	5.1309	5.1955	5.0953	5.1296	42771.0
2012-01-27	HO	Futures	2.4671	2.4939	2.4549	2.4758	70817.0
2012-01-27	HRC	Futures	2857.1	2857.1	2857.1	2857.1	0.0
2012-01-27	J1	Futures	0.0162167	0.0163912	0.0162104	0.0163787	124548.0

> showing 50 of 99 rows — these rows as CSV

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