PREVIEW / futures_daily / 2012-05-01

all futures daily files

  file:    by_date/futures_daily/2012/2012-05-01.parquet
  size:    8 KB
  rows:    82

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-05-01	ES	Futures	1405.01	1422.64	1401.99	1411.31	1305665.0
2012-05-01	NQ	Futures	3115.79	3154.17	3105.47	3114.64	180909.0
2012-05-01	YM	Futures	12803.8	12918.6	12744.5	12854.4	82605.0
2012-05-01	CL	Futures	192.41	195.23	191.49	194.74	245921.0
2012-05-01	GC	Futures	2227.2	2235.5	2215.7	2222.3	105171.0
2012-05-01	ZN	Futures	114.571929	114.720847	114.301169	114.341783	804991.0
2012-05-01	A6	Futures	0.93347	0.93482	0.92258	0.92537	106535.0
2012-05-01	AD	Futures	1.01809	1.02221	1.01537	1.0202	60225.0
2012-05-01	B	Futures	107.74	108.24	107.15	107.9	93386.0
2012-05-01	B6	Futures	1.7037	1.7049	1.6984	1.702	72750.0
2012-05-01	BR	Futures	0.2491	0.2491	0.2491	0.2491	3.0
2012-05-01	BZ	Futures	114.98	114.98	114.98	114.98	3190.0
2012-05-01	C	Futures	1469.0	1532.0	1463.0	1517.0	1911.0
2012-05-01	CB	Futures	73.199	73.468	73.199	73.199	8.0
2012-05-01	CC	Futures	1665.0	1776.0	1653.0	1748.0	17652.0
2012-05-01	CSC	Futures	3.405	3.508	3.382	3.499	23.0
2012-05-01	CT	Futures	109.37	110.0	108.91	109.71	8467.0
2012-05-01	DC	Futures	23.41	24.37	23.22	24.33	568.0
2012-05-01	DX	Futures	76.421	76.591	76.218	76.479	13049.0
2012-05-01	E1	Futures	1.44359	1.44869	1.43953	1.44215	29596.0
2012-05-01	E6	Futures	1.58089	1.58614	1.57659	1.57957	158386.0
2012-05-01	E7	Futures	1.566	1.571	1.5615	1.5644	2007.0
2012-05-01	ED	Futures	95.0693	95.074	95.0645	95.0693	86887.0
2012-05-01	ER	Futures	97.587	97.597	97.587	97.592	23508.0
2012-05-01	EW	Futures	1000.1	1016.2	997.2	1002.3	23988.0
2012-05-01	FTUK	Futures	4170.3	4220.6	4157.9	4215.9	33872.0
2012-05-01	G	Futures	95.01	95.26	94.76	94.83	70305.0
2012-05-01	GF	Futures	312.187	314.114	311.51	312.812	2395.0
2012-05-01	GSCI	Futures	1085.93	1094.03	1083.63	1092.36	55.0
2012-05-01	HE	Futures	92.086	92.326	91.339	91.579	23928.0
2012-05-01	HG	Futures	5.025	5.0492	4.9922	5.0335	35714.0
2012-05-01	HO	Futures	2.6127	2.6258	2.5997	2.6117	54670.0
2012-05-01	HRC	Futures	2590.2	2590.2	2590.2	2590.2	0.0
2012-05-01	J1	Futures	0.0157125	0.0157501	0.0156197	0.0156385	65116.0
2012-05-01	J7	Futures	0.015635	0.015675	0.015547	0.015565	576.0
2012-05-01	JB	Futures	125.5	125.6	125.46	125.55	1536.0
2012-05-01	KC	Futures	404.42	416.14	399.35	415.13	15255.0
2012-05-01	KE	Futures	2367.91	2373.29	2337.46	2353.58	7738.0
2012-05-01	L	Futures	98.513	98.523	98.503	98.513	18865.0
2012-05-01	LBS	Futures	489.6	493.8	485.5	492.2	337.0
2012-05-01	LE	Futures	161.436	161.754	159.74	160.412	31873.0
2012-05-01	MFS	Futures	1361.6	1374.9	1358.5	1367.2	3918.0
2012-05-01	MGC	Futures	2217.9	2225.6	2204.4	2212.9	486.0
2012-05-01	MME	Futures	941.8	954.4	938.3	945.7	4725.0
2012-05-01	MP	Futures	0.04389	0.04436	0.04382	0.04433	29574.0
2012-05-01	N6	Futures	0.69084	0.69084	0.68517	0.6878	8237.0
2012-05-01	NG	Futures	46.752	48.25	46.388	47.966	161946.0
2012-05-01	NIY	Futures	7698.6	7702.7	7556.3	7625.4	20771.0
2012-05-01	NKD	Futures	8912.9	8922.3	8757.6	8837.6	4068.0
2012-05-01	NOK	Futures	0.178075	0.178075	0.178075	0.178075	13.0

> showing 50 of 82 rows — these rows as CSV

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