PREVIEW / futures_daily / 2012-07-24

all futures daily files

  file:    by_date/futures_daily/2012/2012-07-24.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-24	ES	Futures	1360.84	1363.63	1340.59	1346.41	2115725.0
2012-07-24	NQ	Futures	2960.37	2972.71	2921.06	2925.07	282945.0
2012-07-24	YM	Futures	12268.8	12292.1	12090.3	12150.5	141548.0
2012-07-24	CL	Futures	159.81	161.69	158.68	160.62	309865.0
2012-07-24	GC	Futures	2106.7	2117.5	2095.8	2107.1	158537.0
2012-07-24	ZN	Futures	117.802534	118.006816	117.516539	117.897866	920373.0
2012-07-24	A6	Futures	0.91789	0.9231	0.91393	0.9151	175459.0
2012-07-24	AD	Futures	0.98305	0.98586	0.97914	0.97975	110013.0
2012-07-24	B	Futures	92.61	93.86	92.11	92.91	232100.0
2012-07-24	B6	Futures	1.6203	1.6252	1.6183	1.6206	98935.0
2012-07-24	BFX	Futures	2612.8	2612.8	2608.1	2609.6	51.0
2012-07-24	BR	Futures	0.23281	0.23281	0.23124	0.23169	613.0
2012-07-24	BZ	Futures	99.08	100.03	98.72	99.54	1642.0
2012-07-24	C	Futures	1595.0	1603.0	1562.0	1567.0	4046.0
2012-07-24	CB	Futures	89.75	89.75	89.75	89.75	3.0
2012-07-24	CC	Futures	1703.0	1717.0	1659.0	1665.0	14928.0
2012-07-24	CSC	Futures	4.053	4.101	4.049	4.062	10.0
2012-07-24	CT	Futures	93.53	94.23	92.07	92.59	49.0
2012-07-24	DC	Futures	30.23	30.28	29.79	30.04	387.0
2012-07-24	DX	Futures	81.372	81.77	81.299	81.672	18639.0
2012-07-24	E1	Futures	1.30407	1.30652	1.29632	1.29839	41473.0
2012-07-24	E6	Futures	1.43027	1.43287	1.42154	1.4239	240980.0
2012-07-24	E7	Futures	1.4211	1.424	1.4126	1.4151	3374.0
2012-07-24	ED	Futures	95.1752	95.1943	95.1704	95.18	132349.0
2012-07-24	ER	Futures	97.724	97.749	97.724	97.744	74469.0
2012-07-24	EW	Futures	937.1	940.5	918.6	921.8	31056.0
2012-07-24	FBTP	Futures	63.56	64.02	62.29	62.62	27977.0
2012-07-24	FBTS	Futures	83.847	83.913	82.896	83.012	4185.0
2012-07-24	FCE	Futures	2323.8	2323.8	2270.2	2289.2	109663.0
2012-07-24	FDAX	Futures	7031.1	7050.2	6893.5	6993.4	152472.0
2012-07-24	FESX	Futures	1479.8	1480.4	1440.5	1457.4	1119191.0
2012-07-24	FEU3	Futures	98.315	98.325	98.315	98.325	450.0
2012-07-24	FGBL	Futures	120.14	120.17	119.36	119.79	871888.0
2012-07-24	FGBM	Futures	116.84	116.86	116.5	116.75	450237.0
2012-07-24	FGBS	Futures	110.547	110.562	110.477	110.557	293309.0
2012-07-24	FGBX	Futures	129.85	129.93	127.64	128.5	6002.0
2012-07-24	FOAT	Futures	102.05	102.21	101.26	101.44	27436.0
2012-07-24	FTDX	Futures	695.6	697.0	692.4	697.0	211.0
2012-07-24	FTI	Futures	266.58	266.58	262.92	264.41	33859.0
2012-07-24	FTUK	Futures	3998.7	4015.8	3938.7	3977.2	91268.0
2012-07-24	FVSA	Futures	8203.15	8355.58	8009.16	8286.29	5740.0
2012-07-24	FXXP	Futures	180.5	180.6	178.6	179.3	1493.0
2012-07-24	G	Futures	100.46	100.85	100.22	100.8	207232.0
2012-07-24	GF	Futures	267.915	272.8	267.274	271.715	3044.0
2012-07-24	GSCI	Futures	1003.16	1008.33	996.87	1003.56	287.0
2012-07-24	HE	Futures	100.004	100.03	98.801	99.336	8994.0
2012-07-24	HG	Futures	4.3544	4.3821	4.3009	4.3196	54765.0
2012-07-24	HO	Futures	2.3077	2.3273	2.2884	2.3108	60152.0
2012-07-24	HRC	Futures	2450.1	2450.1	2450.1	2450.1	0.0
2012-07-24	J1	Futures	0.016007	0.0160571	0.0160008	0.0160396	58339.0

> showing 50 of 98 rows — these rows as CSV

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