PREVIEW / futures_daily / 2012-06-19

all futures daily files

  file:    by_date/futures_daily/2012/2012-06-19.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-06-19	ES	Futures	1357.8	1374.26	1353.5	1367.68	1772340.0
2012-06-19	NQ	Futures	2971.85	3014.03	2966.97	2998.53	218312.0
2012-06-19	YM	Futures	12306.7	12446.4	12279.5	12381.4	108774.0
2012-06-19	CL	Futures	152.17	154.56	150.64	153.83	279625.0
2012-06-19	GC	Futures	2175.4	2184.7	2163.1	2169.9	124749.0
2012-06-19	ZN	Futures	116.617699	116.767506	116.181898	116.345323	956429.0
2012-06-19	A6	Futures	0.9026	0.90989	0.90125	0.90917	154921.0
2012-06-19	AD	Futures	0.97754	0.98436	0.97694	0.98305	99564.0
2012-06-19	B	Futures	87.09	87.89	85.75	86.95	276705.0
2012-06-19	B6	Futures	1.6369	1.6465	1.6314	1.6438	102584.0
2012-06-19	BFX	Futures	2527.1	2579.0	2527.1	2574.7	24.0
2012-06-19	BR	Futures	0.2299	0.23212	0.2299	0.23212	359.0
2012-06-19	BZ	Futures	91.62	93.43	91.24	92.44	1795.0
2012-06-19	C	Futures	1531.0	1542.0	1520.0	1538.0	3081.0
2012-06-19	CB	Futures	83.964	85.04	83.964	84.906	5.0
2012-06-19	CC	Futures	1650.0	1692.0	1644.0	1684.0	9334.0
2012-06-19	CSC	Futures	3.714	3.741	3.712	3.741	14.0
2012-06-19	CT	Futures	102.15	107.63	102.15	107.63	17025.0
2012-06-19	DC	Futures	27.17	27.41	27.14	27.14	136.0
2012-06-19	DX	Futures	79.697	79.862	78.998	79.189	34984.0
2012-06-19	E1	Futures	1.35468	1.37185	1.35442	1.36746	51487.0
2012-06-19	E6	Futures	1.48477	1.50294	1.48371	1.49798	312893.0
2012-06-19	E7	Futures	1.4761	1.4936	1.4747	1.4887	3099.0
2012-06-19	ED	Futures	95.1035	95.1226	95.1035	95.1131	254939.0
2012-06-19	ER	Futures	97.597	97.616	97.577	97.587	110198.0
2012-06-19	EW	Futures	937.8	951.4	934.9	945.8	22624.0
2012-06-19	FBTP	Futures	64.43	65.34	64.25	65.31	15114.0
2012-06-19	FBTS	Futures	83.392	83.814	83.219	83.798	5101.0
2012-06-19	FCE	Futures	2273.9	2314.3	2257.6	2305.4	133576.0
2012-06-19	FDAX	Futures	6820.4	6970.5	6808.3	6948.6	151104.0
2012-06-19	FESX	Futures	1454.1	1485.8	1443.9	1479.8	1353221.0
2012-06-19	FEU3	Futures	98.186	98.186	98.167	98.167	365.0
2012-06-19	FGBL	Futures	117.82	118.07	116.62	116.76	893114.0
2012-06-19	FGBM	Futures	115.69	115.78	115.03	115.09	458047.0
2012-06-19	FGBS	Futures	110.348	110.353	110.188	110.213	365640.0
2012-06-19	FGBX	Futures	127.58	128.24	124.72	124.99	14154.0
2012-06-19	FOAT	Futures	98.3	98.53	98.03	98.16	13588.0
2012-06-19	FTDX	Futures	682.6	689.6	678.9	687.7	97.0
2012-06-19	FTI	Futures	253.18	257.61	251.95	256.63	35621.0
2012-06-19	FTUK	Futures	3971.1	4047.1	3966.3	4038.4	114356.0
2012-06-19	FVSA	Futures	9390.87	9390.87	8757.78	8818.07	2813.0
2012-06-19	FXXP	Futures	175.3	177.5	174.3	177.1	3264.0
2012-06-19	G	Futures	98.86	99.36	98.44	98.45	130037.0
2012-06-19	GF	Futures	307.486	307.831	302.651	303.144	6158.0
2012-06-19	GSCI	Futures	923.25	931.89	923.25	928.48	82.0
2012-06-19	HE	Futures	100.451	100.898	99.898	100.109	15798.0
2012-06-19	HG	Futures	4.3795	4.4407	4.355	4.433	12431.0
2012-06-19	HO	Futures	2.1505	2.1707	2.125	2.1582	28339.0
2012-06-19	HRC	Futures	2470.4	2470.4	2470.4	2470.4	0.0
2012-06-19	J1	Futures	0.0158616	0.0159143	0.0158591	0.0158742	49131.0

> showing 50 of 99 rows — these rows as CSV

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