PREVIEW / futures_daily / 2012-04-09

all futures daily files

  file:    by_date/futures_daily/2012/2012-04-09.parquet
  size:    8 KB
  rows:    76

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-09	ES	Futures	1385.61	1393.42	1382.33	1385.61	1083274.0
2012-04-09	NQ	Futures	3122.95	3148.44	3114.93	3126.1	192709.0
2012-04-09	YM	Futures	12506.2	12560.7	12472.2	12496.5	75104.0
2012-04-09	CL	Futures	189.01	189.14	185.84	188.88	205924.0
2012-04-09	GC	Futures	2193.7	2205.6	2187.9	2197.6	83338.0
2012-04-09	ZN	Futures	113.773188	113.773188	113.407663	113.62427	599647.0
2012-04-09	A6	Futures	0.91898	0.9224	0.91556	0.92204	52184.0
2012-04-09	AD	Futures	1.00712	1.01024	1.0043	1.00853	47804.0
2012-04-09	B	Futures	110.5	110.63	108.98	110.46	67662.0
2012-04-09	B6	Futures	1.6673	1.6697	1.6614	1.6689	35541.0
2012-04-09	BR	Futures	0.25886	0.25945	0.25876	0.25945	30.0
2012-04-09	BZ	Futures	116.25	116.94	115.3	116.83	309.0
2012-04-09	CB	Futures	78.178	78.178	78.043	78.043	32.0
2012-04-09	CC	Futures	1589.0	1603.0	1570.0	1597.0	13809.0
2012-04-09	CSC	Futures	3.616	3.616	3.611	3.611	12.0
2012-04-09	CT	Futures	110.81	112.93	110.76	111.98	15440.0
2012-04-09	DC	Futures	25.07	25.23	24.87	25.09	119.0
2012-04-09	DX	Futures	77.559	77.821	77.351	77.433	11583.0
2012-04-09	E1	Futures	1.42918	1.43233	1.42211	1.43062	16530.0
2012-04-09	E6	Futures	1.56394	1.56859	1.5563	1.56704	104022.0
2012-04-09	E7	Futures	1.5489	1.5534	1.5415	1.552	1614.0
2012-04-09	ED	Futures	95.0263	95.0454	95.0263	95.0358	79967.0
2012-04-09	EW	Futures	975.6	982.3	974.5	978.8	20380.0
2012-04-09	GF	Futures	311.831	314.029	310.104	310.104	1315.0
2012-04-09	GSCI	Futures	1081.17	1084.18	1073.73	1082.91	1365.0
2012-04-09	HE	Futures	103.339	103.999	102.788	103.449	322.0
2012-04-09	HG	Futures	4.9544	4.9813	4.8574	4.8771	52974.0
2012-04-09	HO	Futures	2.6067	2.6092	2.5657	2.595	17182.0
2012-04-09	HRC	Futures	2680.3	2680.3	2680.3	2680.3	0.0
2012-04-09	J1	Futures	0.0153852	0.0154542	0.0153639	0.0153689	53704.0
2012-04-09	J7	Futures	0.01532	0.01538	0.015293	0.015296	490.0
2012-04-09	JB	Futures	124.64	124.93	124.64	124.9	5407.0
2012-04-09	KC	Futures	417.81	419.52	405.7	406.84	10733.0
2012-04-09	KE	Futures	2407.89	2431.53	2400.62	2400.62	7925.0
2012-04-09	LBS	Futures	455.9	456.1	448.6	451.6	635.0
2012-04-09	LE	Futures	163.238	164.757	163.238	163.591	17545.0
2012-04-09	MFS	Futures	1333.0	1345.0	1331.4	1340.9	3367.0
2012-04-09	MGC	Futures	2180.6	2199.1	2174.1	2188.3	683.0
2012-04-09	MME	Futures	940.9	943.6	936.2	939.8	2444.0
2012-04-09	MP	Futures	0.04383	0.04408	0.0437	0.04405	29502.0
2012-04-09	N6	Futures	0.68974	0.69389	0.6867	0.69372	5316.0
2012-04-09	NG	Futures	44.622	44.919	43.731	44.707	129365.0
2012-04-09	NIY	Futures	7751.5	7824.7	7739.3	7780.0	9841.0
2012-04-09	NKD	Futures	8988.2	9072.9	8974.1	9016.5	2712.0
2012-04-09	NOK	Futures	0.174983	0.176248	0.174983	0.176177	5.0
2012-04-09	OJ	Futures	108.41	109.52	105.25	105.98	1644.0
2012-04-09	PA	Futures	713.02	723.27	709.64	713.08	1462.0
2012-04-09	PJY	Futures	108.77	108.77	108.77	108.77	33.0
2012-04-09	PL	Futures	1815.2	1829.3	1811.6	1819.4	3099.0
2012-04-09	QG	Futures	45.342	45.883	44.585	45.559	806.0

> showing 50 of 76 rows — these rows as CSV

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