PREVIEW / futures_daily / 2012-08-21

all futures daily files

  file:    by_date/futures_daily/2012/2012-08-21.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-08-21	ES	Futures	1432.75	1442.87	1425.91	1430.47	1731248.0
2012-08-21	NQ	Futures	3191.93	3216.61	3169.55	3183.89	242251.0
2012-08-21	YM	Futures	12835.4	12911.1	12769.4	12805.3	103835.0
2012-08-21	CL	Futures	174.04	177.02	173.78	175.19	220192.0
2012-08-21	GC	Futures	2167.1	2194.4	2164.0	2193.5	128719.0
2012-08-21	ZN	Futures	115.541815	115.650765	115.214964	115.582671	947738.0
2012-08-21	A6	Futures	0.9365	0.94369	0.93641	0.94001	114954.0
2012-08-21	AD	Futures	1.01323	1.01815	1.01213	1.01313	91962.0
2012-08-21	B	Futures	103.18	104.93	103.18	104.08	172395.0
2012-08-21	B6	Futures	1.6419	1.6517	1.6414	1.6489	116282.0
2012-08-21	BFX	Futures	2851.6	2864.5	2851.6	2862.2	22.0
2012-08-21	BR	Futures	0.23699	0.2374	0.23563	0.23625	155.0
2012-08-21	BZ	Futures	109.35	110.53	109.35	109.69	1481.0
2012-08-21	C	Futures	1650.0	1650.0	1618.0	1631.0	2417.0
2012-08-21	CB	Futures	98.483	98.483	98.483	98.483	10.0
2012-08-21	CC	Futures	1816.0	1850.0	1805.0	1835.0	9467.0
2012-08-21	CSC	Futures	4.084	4.127	4.073	4.114	13.0
2012-08-21	CT	Futures	97.48	100.71	97.48	100.71	45.0
2012-08-21	DC	Futures	30.25	30.5	29.9	30.44	386.0
2012-08-21	DX	Futures	80.061	80.085	79.401	79.513	27408.0
2012-08-21	E1	Futures	1.32783	1.34293	1.3277	1.34087	50484.0
2012-08-21	E6	Futures	1.45669	1.47356	1.45669	1.47097	267939.0
2012-08-21	E7	Futures	1.448	1.4644	1.4478	1.4618	5176.0
2012-08-21	ED	Futures	95.168	95.1704	95.1632	95.168	75420.0
2012-08-21	ER	Futures	97.842	97.852	97.822	97.842	47356.0
2012-08-21	EW	Futures	986.7	996.2	985.4	988.8	18561.0
2012-08-21	FBTP	Futures	66.61	67.44	66.61	67.26	16655.0
2012-08-21	FBTS	Futures	87.146	87.477	87.122	87.328	1761.0
2012-08-21	FCE	Futures	2595.2	2622.4	2595.2	2615.7	70614.0
2012-08-21	FDAX	Futures	7696.0	7760.4	7688.3	7744.0	94099.0
2012-08-21	FESX	Futures	1672.5	1686.7	1669.1	1684.7	739899.0
2012-08-21	FGBL	Futures	117.25	117.28	116.69	116.78	577160.0
2012-08-21	FGBM	Futures	115.99	116.0	115.67	115.7	266509.0
2012-08-21	FGBS	Futures	110.467	110.477	110.387	110.397	298745.0
2012-08-21	FGBX	Futures	124.57	124.57	123.31	123.5	4826.0
2012-08-21	FOAT	Futures	102.51	102.61	102.31	102.34	14423.0
2012-08-21	FTDX	Futures	738.0	743.1	738.0	741.7	105.0
2012-08-21	FTI	Futures	284.56	286.56	283.88	285.84	20417.0
2012-08-21	FTUK	Futures	4242.2	4271.4	4229.9	4267.0	75153.0
2012-08-21	FVSA	Futures	6455.92	6519.97	6379.07	6455.92	4437.0
2012-08-21	FXXP	Futures	195.6	195.8	194.7	195.7	2000.0
2012-08-21	G	Futures	98.99	99.2	98.75	98.84	108668.0
2012-08-21	GF	Futures	281.274	282.112	277.63	278.024	1033.0
2012-08-21	GSCI	Futures	1085.9	1093.15	1085.1	1087.51	143.0
2012-08-21	HE	Futures	94.11	94.141	93.338	93.677	9563.0
2012-08-21	HG	Futures	4.3462	4.4644	4.343	4.4477	20995.0
2012-08-21	HO	Futures	2.5246	2.5617	2.5246	2.5462	14280.0
2012-08-21	HRC	Futures	2548.9	2548.9	2548.9	2548.9	0.0
2012-08-21	J1	Futures	0.0157702	0.0158215	0.0157601	0.0158153	76717.0
2012-08-21	J7	Futures	0.015736	0.015758	0.0157	0.015753	274.0

> showing 50 of 99 rows — these rows as CSV

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