PREVIEW / futures_daily / 2012-09-18

all futures daily files

  file:    by_date/futures_daily/2012/2012-09-18.parquet
  size:    9 KB
  rows:    100

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-09-18	ES	Futures	1479.86	1482.15	1474.77	1478.84	1821180.0
2012-09-18	NQ	Futures	3275.5	3284.13	3265.72	3279.24	195602.0
2012-09-18	YM	Futures	13157.2	13193.4	13112.3	13181.7	105219.0
2012-09-18	CL	Futures	175.03	176.06	172.22	172.58	175924.0
2012-09-18	GC	Futures	2355.4	2371.1	2340.8	2364.8	163628.0
2012-09-18	ZN	Futures	116.024719	116.47794	115.969783	116.203261	763950.0
2012-09-18	A6	Futures	0.94389	0.94534	0.93853	0.94107	110421.0
2012-09-18	AD	Futures	1.02757	1.02938	1.02557	1.02717	66070.0
2012-09-18	B	Futures	103.45	104.33	101.77	102.15	212109.0
2012-09-18	B6	Futures	1.6962	1.6985	1.6934	1.6956	78117.0
2012-09-18	BFX	Futures	2937.0	2937.0	2913.4	2921.1	894.0
2012-09-18	BR	Futures	0.23677	0.2374	0.23677	0.2374	155.0
2012-09-18	BZ	Futures	109.02	109.18	106.71	107.06	564.0
2012-09-18	C	Futures	1664.0	1670.0	1648.0	1655.0	6512.0
2012-09-18	CB	Futures	97.947	97.947	97.947	97.947	2.0
2012-09-18	CC	Futures	1940.0	1940.0	1900.0	1909.0	13575.0
2012-09-18	CSC	Futures	4.093	4.093	4.084	4.093	3.0
2012-09-18	CT	Futures	99.23	99.3	98.72	98.77	34.0
2012-09-18	DC	Futures	30.56	31.14	30.53	30.91	147.0
2012-09-18	DX	Futures	76.603	76.874	76.554	76.855	15256.0
2012-09-18	E1	Futures	1.38908	1.3941	1.38638	1.38677	27431.0
2012-09-18	E6	Futures	1.54546	1.54616	1.53568	1.53651	227799.0
2012-09-18	E7	Futures	1.5357	1.5368	1.5266	1.5273	4224.0
2012-09-18	ED	Futures	95.2205	95.2253	95.2062	95.211	176867.0
2012-09-18	ER	Futures	97.852	97.857	97.842	97.852	104889.0
2012-09-18	EW	Futures	1033.5	1034.6	1024.4	1027.5	30707.0
2012-09-18	FBTP	Futures	70.6	71.12	70.38	71.04	15108.0
2012-09-18	FBTS	Futures	89.081	89.139	88.871	89.106	2664.0
2012-09-18	FCE	Futures	2650.4	2650.4	2608.9	2619.3	120096.0
2012-09-18	FDAX	Futures	8095.6	8100.0	8007.9	8077.5	74295.0
2012-09-18	FESX	Futures	1749.1	1749.1	1721.2	1736.9	1140739.0
2012-09-18	FEU3	Futures	98.473	98.473	98.473	98.473	5.0
2012-09-18	FGBL	Futures	116.36	116.73	116.18	116.55	665119.0
2012-09-18	FGBM	Futures	115.41	115.58	115.33	115.46	321031.0
2012-09-18	FGBS	Futures	110.243	110.278	110.238	110.253	260137.0
2012-09-18	FGBX	Futures	121.55	122.36	121.15	122.0	10136.0
2012-09-18	FOAT	Futures	101.94	102.42	101.94	102.31	17426.0
2012-09-18	FTDX	Futures	761.3	765.1	761.3	765.1	394.0
2012-09-18	FTI	Futures	287.5	287.58	285.58	286.34	35904.0
2012-09-18	FTUK	Futures	4276.8	4288.5	4251.6	4285.2	119304.0
2012-09-18	FVSA	Futures	5816.79	5902.33	5719.03	5767.91	5364.0
2012-09-18	FXXP	Futures	196.5	197.4	196.4	197.4	27070.0
2012-09-18	G	Futures	97.92	98.14	97.7	98.08	111424.0
2012-09-18	GF	Futures	286.858	287.15	284.619	286.907	2237.0
2012-09-18	GSCI	Futures	1089.85	1092.1	1077.27	1080.17	520.0
2012-09-18	HE	Futures	90.987	92.571	90.8	92.23	23815.0
2012-09-18	HG	Futures	4.839	4.8801	4.812	4.8666	51593.0
2012-09-18	HH	Futures	38.299	38.299	37.173	37.173	1185.0
2012-09-18	HO	Futures	2.5641	2.5722	2.5261	2.5311	14841.0
2012-09-18	HRC	Futures	2471.7	2471.7	2471.7	2471.7	0.0

> showing 50 of 100 rows — these rows as CSV

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