PREVIEW / futures_daily / 2012-04-23

all futures daily files

  file:    by_date/futures_daily/2012/2012-04-23.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-04-23	ES	Futures	1382.84	1385.36	1364.45	1373.27	1848613.0
2012-04-23	NQ	Futures	3060.22	3064.8	3007.52	3036.44	318640.0
2012-04-23	YM	Futures	12610.3	12621.0	12434.3	12516.9	124249.0
2012-04-23	CL	Futures	190.45	190.59	186.78	189.14	213202.0
2012-04-23	GC	Futures	2196.1	2198.0	2170.4	2182.5	125013.0
2012-04-23	ZN	Futures	114.125175	114.490701	114.111638	114.355321	807118.0
2012-04-23	A6	Futures	0.92744	0.92861	0.91853	0.92159	133623.0
2012-04-23	AD	Futures	1.01215	1.01446	1.00702	1.01296	75641.0
2012-04-23	B	Futures	107.35	107.54	106.01	107.36	203505.0
2012-04-23	B6	Futures	1.6916	1.6931	1.6868	1.6918	95864.0
2012-04-23	BFX	Futures	2599.4	2613.5	2596.3	2606.5	42.0
2012-04-23	BR	Futures	0.25156	0.25156	0.25156	0.25156	211.0
2012-04-23	BZ	Futures	113.07	113.71	112.16	113.56	727.0
2012-04-23	C	Futures	1477.0	1492.0	1442.0	1446.0	1326.0
2012-04-23	CB	Futures	77.276	77.276	77.276	77.276	2.0
2012-04-23	CC	Futures	1711.0	1717.0	1646.0	1662.0	10345.0
2012-04-23	CSC	Futures	3.439	3.467	3.373	3.391	121.0
2012-04-23	CT	Futures	112.71	114.07	111.76	113.13	2038.0
2012-04-23	DC	Futures	23.92	24.18	23.17	23.22	623.0
2012-04-23	DX	Futures	76.905	77.293	76.852	77.061	18450.0
2012-04-23	E1	Futures	1.43848	1.44031	1.4284	1.43272	43651.0
2012-04-23	E6	Futures	1.57504	1.57742	1.56465	1.56955	226354.0
2012-04-23	E7	Futures	1.56	1.5624	1.5498	1.5545	2990.0
2012-04-23	EBM	Futures	291.76	291.76	289.06	289.74	6052.0
2012-04-23	ED	Futures	95.0597	95.0645	95.0502	95.0549	118047.0
2012-04-23	ER	Futures	97.508	97.523	97.503	97.508	46327.0
2012-04-23	EW	Futures	982.4	984.6	963.4	973.8	27106.0
2012-04-23	FBTP	Futures	65.38	65.4	64.9	65.16	11451.0
2012-04-23	FBTS	Futures	84.582	84.769	84.55	84.631	1479.0
2012-04-23	FCE	Futures	2247.5	2248.9	2187.9	2196.2	160514.0
2012-04-23	FDAX	Futures	7418.1	7428.6	7190.9	7215.8	182202.0
2012-04-23	FESX	Futures	1544.0	1545.4	1502.6	1506.0	1480940.0
2012-04-23	FEU3	Futures	98.093	98.093	98.083	98.083	200.0
2012-04-23	FGBL	Futures	115.3	115.92	115.27	115.85	648702.0
2012-04-23	FGBM	Futures	114.54	114.88	114.52	114.83	389186.0
2012-04-23	FGBS	Futures	110.099	110.178	110.099	110.173	275701.0
2012-04-23	FGBX	Futures	120.21	120.99	120.13	120.75	7336.0
2012-04-23	FOAT	Futures	93.77	94.14	93.43	93.93	19346.0
2012-04-23	FTDX	Futures	715.3	720.9	705.0	706.8	256.0
2012-04-23	FTI	Futures	262.25	262.47	256.13	257.43	38434.0
2012-04-23	FTUK	Futures	4168.1	4172.1	4080.5	4099.5	110303.0
2012-04-23	FVSA	Futures	9391.63	9904.21	9391.63	9871.14	3043.0
2012-04-23	FXXP	Futures	182.3	182.3	179.3	179.8	3767.0
2012-04-23	G	Futures	94.4	95.01	94.34	94.78	108100.0
2012-04-23	GF	Futures	316.093	316.093	311.979	314.218	2254.0
2012-04-23	GSCI	Futures	1065.53	1071.8	1060.21	1071.72	103.0
2012-04-23	HE	Futures	96.02	96.873	95.222	96.873	566.0
2012-04-23	HG	Futures	4.8383	4.8455	4.7316	4.7591	22899.0
2012-04-23	HO	Futures	2.5833	2.5874	2.5558	2.5836	50747.0
2012-04-23	HRC	Futures	2649.1	2649.1	2649.1	2649.1	5.0

> showing 50 of 99 rows — these rows as CSV

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