PREVIEW / futures_daily / 2012-07-11

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-11.parquet
  size:    9 KB
  rows:    98

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-07-11	ES	Futures	1351.98	1359.58	1344.64	1353.25	1912327.0
2012-07-11	NQ	Futures	2958.36	2971.85	2918.76	2940.0	228325.0
2012-07-11	YM	Futures	12207.7	12273.7	12097.1	12162.1	136182.0
2012-07-11	CL	Futures	153.21	157.73	153.21	156.49	307821.0
2012-07-11	GC	Futures	2093.2	2116.7	2092.8	2106.4	140490.0
2012-07-11	ZN	Futures	117.325876	117.598252	117.162451	117.312258	916177.0
2012-07-11	A6	Futures	0.91042	0.9187	0.90953	0.91366	133267.0
2012-07-11	AD	Futures	0.97864	0.98406	0.97854	0.97985	83450.0
2012-07-11	B	Futures	87.66	90.01	87.51	89.55	163631.0
2012-07-11	B6	Futures	1.6215	1.6278	1.6182	1.6184	89965.0
2012-07-11	BR	Futures	0.2325	0.2325	0.23205	0.23214	27.0
2012-07-11	BZ	Futures	95.24	96.15	94.85	95.95	1671.0
2012-07-11	C	Futures	1624.0	1648.0	1610.0	1624.0	6088.0
2012-07-11	CB	Futures	85.309	85.565	85.175	85.175	5.0
2012-07-11	CC	Futures	1731.0	1769.0	1710.0	1727.0	11659.0
2012-07-11	CSC	Futures	3.86	3.895	3.86	3.888	47.0
2012-07-11	CT	Futures	92.82	94.08	91.5	93.05	265.0
2012-07-11	DC	Futures	28.41	28.68	28.36	28.6	230.0
2012-07-11	DX	Futures	81.085	81.299	80.804	81.268	19049.0
2012-07-11	E1	Futures	1.3193	1.32395	1.31517	1.31608	32455.0
2012-07-11	E6	Futures	1.44631	1.45186	1.44171	1.44289	229414.0
2012-07-11	E7	Futures	1.4372	1.4428	1.4325	1.4339	3414.0
2012-07-11	ED	Futures	95.1417	95.18	95.1417	95.1704	287486.0
2012-07-11	ER	Futures	97.675	97.7	97.665	97.69	79201.0
2012-07-11	EW	Futures	944.3	949.9	935.4	940.6	22542.0
2012-07-11	FBTP	Futures	65.24	66.19	65.16	66.06	16382.0
2012-07-11	FBTS	Futures	84.261	84.856	84.186	84.724	2688.0
2012-07-11	FCE	Futures	2341.3	2354.6	2326.9	2338.3	82177.0
2012-07-11	FDAX	Futures	7008.1	7100.4	6989.0	7043.6	118063.0
2012-07-11	FESX	Futures	1506.8	1524.4	1500.7	1514.9	888159.0
2012-07-11	FEU3	Futures	98.265	98.27	98.265	98.27	3.0
2012-07-11	FGBL	Futures	119.09	119.53	118.9	119.47	629661.0
2012-07-11	FGBM	Futures	116.52	116.62	116.4	116.57	328682.0
2012-07-11	FGBS	Futures	110.422	110.447	110.397	110.432	223706.0
2012-07-11	FGBX	Futures	127.09	127.71	126.58	127.69	3793.0
2012-07-11	FOAT	Futures	100.33	101.09	100.22	100.92	23852.0
2012-07-11	FTDX	Futures	701.7	704.4	696.1	697.9	39.0
2012-07-11	FTI	Futures	265.99	265.99	263.35	264.63	2595.0
2012-07-11	FTUK	Futures	4071.2	4099.6	4061.0	4084.6	79199.0
2012-07-11	FVSA	Futures	7687.55	7732.77	7506.67	7551.89	1948.0
2012-07-11	FXXP	Futures	181.7	182.9	181.7	182.3	595.0
2012-07-11	G	Futures	99.71	99.98	99.7	99.93	93476.0
2012-07-11	GF	Futures	283.211	285.332	279.066	284.642	6635.0
2012-07-11	GSCI	Futures	975.3	977.14	968.94	968.94	1467.0
2012-07-11	HE	Futures	98.694	98.988	97.358	97.599	27205.0
2012-07-11	HG	Futures	4.3653	4.4478	4.3653	4.4414	45056.0
2012-07-11	HO	Futures	2.221	2.2634	2.221	2.2565	34437.0
2012-07-11	HRC	Futures	2531.1	2531.1	2531.1	2531.1	50.0
2012-07-11	J1	Futures	0.0157915	0.0158491	0.0157175	0.0157464	78467.0
2012-07-11	J7	Futures	0.015738	0.015786	0.015657	0.015685	434.0

> showing 50 of 98 rows — these rows as CSV

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