PREVIEW / futures_daily / 2012-10-01

all futures daily files

  file:    by_date/futures_daily/2012/2012-10-01.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-10-01	ES	Futures	1458.23	1477.31	1453.14	1462.56	1903230.0
2012-10-01	NQ	Futures	3209.06	3247.6	3196.11	3208.19	261991.0
2012-10-01	YM	Futures	13035.2	13208.0	13000.0	13121.1	147569.0
2012-10-01	CL	Futures	166.31	168.44	164.71	166.91	216005.0
2012-10-01	GC	Futures	2368.1	2395.8	2357.5	2380.9	190607.0
2012-10-01	ZN	Futures	117.315713	117.494255	117.219576	117.411851	765522.0
2012-10-01	A6	Futures	0.93589	0.93926	0.93217	0.93689	106077.0
2012-10-01	AD	Futures	1.01844	1.02266	1.01653	1.02005	78668.0
2012-10-01	B	Futures	102.08	103.01	101.42	102.05	120619.0
2012-10-01	B6	Futures	1.6871	1.6889	1.682	1.6843	93872.0
2012-10-01	BFX	Futures	2834.6	2880.1	2834.6	2878.9	10.0
2012-10-01	BR	Futures	0.23808	0.23886	0.2376	0.23811	197.0
2012-10-01	BZ	Futures	105.32	106.88	105.32	105.9	890.0
2012-10-01	C	Futures	1640.0	1648.0	1600.0	1602.0	1130.0
2012-10-01	CB	Futures	97.412	97.412	96.877	97.144	7.0
2012-10-01	CC	Futures	1885.0	1895.0	1836.0	1848.0	16863.0
2012-10-01	CSC	Futures	4.057	4.063	4.057	4.063	8.0
2012-10-01	CT	Futures	91.17	92.03	90.61	91.88	16551.0
2012-10-01	DC	Futures	30.53	30.65	30.37	30.51	89.0
2012-10-01	DX	Futures	77.533	77.731	77.169	77.401	18311.0
2012-10-01	E1	Futures	1.37093	1.37814	1.36553	1.37351	36151.0
2012-10-01	E6	Futures	1.51413	1.52497	1.50883	1.51861	282079.0
2012-10-01	E7	Futures	1.5052	1.5157	1.4999	1.5095	4441.0
2012-10-01	ED	Futures	95.2301	95.2349	95.2157	95.2301	88946.0
2012-10-01	ER	Futures	97.871	97.881	97.852	97.866	94802.0
2012-10-01	EW	Futures	1005.7	1012.9	993.7	999.2	40863.0
2012-10-01	FBTP	Futures	70.43	71.16	70.43	71.04	11712.0
2012-10-01	FBTS	Futures	88.654	89.324	88.654	89.282	3422.0
2012-10-01	FCE	Futures	2497.8	2573.0	2497.8	2568.8	141675.0
2012-10-01	FDAX	Futures	7900.0	8045.2	7898.4	8034.2	135456.0
2012-10-01	FESX	Futures	1660.0	1700.1	1658.6	1698.1	1141858.0
2012-10-01	FEU3	Futures	98.492	98.492	98.483	98.487	144.0
2012-10-01	FGBL	Futures	118.42	118.47	117.94	118.18	550444.0
2012-10-01	FGBM	Futures	116.26	116.28	115.98	116.09	296608.0
2012-10-01	FGBS	Futures	110.372	110.372	110.298	110.313	276573.0
2012-10-01	FGBX	Futures	126.19	126.21	125.02	125.49	4682.0
2012-10-01	FOAT	Futures	103.05	103.05	102.81	102.89	11969.0
2012-10-01	FTDX	Futures	762.7	782.9	760.8	770.2	76.0
2012-10-01	FTI	Futures	273.16	279.77	273.16	279.39	33465.0
2012-10-01	FTUK	Futures	4180.9	4257.0	4171.1	4239.5	105660.0
2012-10-01	FVSA	Futures	5865.67	5890.11	5535.72	5596.82	2735.0
2012-10-01	FXXP	Futures	194.0	196.2	194.0	195.8	1832.0
2012-10-01	G	Futures	99.51	99.55	99.16	99.32	118406.0
2012-10-01	GF	Futures	279.655	282.186	278.341	281.651	1662.0
2012-10-01	GSCI	Futures	1069.69	1082.27	1069.69	1074.93	177.0
2012-10-01	HE	Futures	91.732	93.752	91.701	93.379	22008.0
2012-10-01	HG	Futures	4.8197	4.8808	4.7825	4.8647	45943.0
2012-10-01	HH	Futures	44.374	44.374	44.374	44.374	1745.0
2012-10-01	HO	Futures	2.5448	2.5613	2.5237	2.5319	34786.0
2012-10-01	HRC	Futures	2443.1	2443.1	2443.1	2443.1	0.0

> showing 50 of 99 rows — these rows as CSV

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