PREVIEW / futures_daily / 2011-07-07

all futures daily files

  file:    by_date/futures_daily/2011/2011-07-07.parquet
  size:    9 KB
  rows:    96

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
2011-07-07	ES	Futures	1326.83	1343.46	1326.58	1342.47	1678156.0
2011-07-07	NQ	Futures	2705.69	2751.24	2705.4	2750.67	214745.0
2011-07-07	YM	Futures	11885.6	12004.8	11885.6	11988.7	90617.0
2011-07-07	CL	Futures	186.2	190.77	186.1	189.33	339270.0
2011-07-07	GC	Futures	2070.3	2077.4	2060.2	2071.5	117622.0
2011-07-07	ZN	Futures	104.630303	104.656913	104.098104	104.284374	1304050.0
2011-07-07	A6	Futures	0.92187	0.92935	0.92109	0.92883	98903.0
2011-07-07	AD	Futures	1.03239	1.04107	1.0306	1.03868	75072.0
2011-07-07	B	Futures	96.98	100.79	96.69	100.7	125784.0
2011-07-07	B6	Futures	1.6636	1.665	1.6571	1.6589	95243.0
2011-07-07	BFX	Futures	3039.7	3061.2	3036.2	3053.1	28.0
2011-07-07	BR	Futures	0.28285	0.28299	0.28268	0.28276	43.0
2011-07-07	BZ	Futures	100.93	104.58	100.93	104.58	1182.0
2011-07-07	C	Futures	2133.0	2159.0	2111.0	2158.0	11912.0
2011-07-07	CB	Futures	111.779	111.779	110.135	110.683	25.0
2011-07-07	CC	Futures	2530.0	2538.0	2473.0	2526.0	7549.0
2011-07-07	CSC	Futures	4.496	4.499	4.496	4.499	4.0
2011-07-07	CT	Futures	152.11	152.46	149.89	150.8	73.0
2011-07-07	DC	Futures	30.4	30.73	30.25	30.6	190.0
2011-07-07	DX	Futures	74.539	75.014	74.425	74.531	21476.0
2011-07-07	E1	Futures	1.55883	1.56157	1.54	1.54876	47922.0
2011-07-07	E6	Futures	1.69732	1.70374	1.68544	1.70077	340487.0
2011-07-07	E7	Futures	1.6846	1.6913	1.6731	1.6883	5925.0
2011-07-07	ED	Futures	94.9382	94.9525	94.9334	94.9477	158785.0
2011-07-07	ER	Futures	97.247	97.281	97.222	97.252	166167.0
2011-07-07	EW	Futures	991.7	1003.0	991.7	1001.9	14830.0
2011-07-07	FBTP	Futures	63.81	63.81	63.06	63.39	9133.0
2011-07-07	FCE	Futures	2770.5	2795.2	2753.1	2767.0	115932.0
2011-07-07	FDAX	Futures	8019.2	8056.6	7975.3	8011.7	119729.0
2011-07-07	FESX	Futures	1829.9	1848.5	1815.2	1828.0	1278099.0
2011-07-07	FEU3	Futures	97.79	97.79	97.79	97.79	12.0
2011-07-07	FGBL	Futures	101.21	101.5	100.91	101.05	1231702.0
2011-07-07	FGBM	Futures	105.32	105.68	105.17	105.26	647781.0
2011-07-07	FGBS	Futures	107.02	107.204	106.965	107.025	806703.0
2011-07-07	FGBX	Futures	96.54	96.65	95.87	95.96	6918.0
2011-07-07	FTDX	Futures	804.2	817.2	802.0	811.4	178.0
2011-07-07	FTI	Futures	281.93	285.01	280.79	283.41	32572.0
2011-07-07	FTUK	Futures	4223.5	4267.3	4211.2	4247.2	83264.0
2011-07-07	FXXP	Futures	186.0	188.1	186.0	186.7	2867.0
2011-07-07	G	Futures	84.64	84.83	84.35	84.45	134289.0
2011-07-07	GF	Futures	328.152	334.543	327.455	334.427	3840.0
2011-07-07	GSCI	Futures	1079.04	1090.71	1078.96	1089.21	641.0
2011-07-07	HE	Futures	103.72	106.419	103.555	106.061	26338.0
2011-07-07	HG	Futures	5.7307	5.8741	5.7181	5.8721	42137.0
2011-07-07	HO	Futures	2.4242	2.5238	2.4228	2.5223	26626.0
2011-07-07	HRC	Futures	3072.8	3072.8	3031.0	3031.0	1.0
2011-07-07	J1	Futures	0.015538	0.0155631	0.0154437	0.0154764	106598.0
2011-07-07	J7	Futures	0.015433	0.015458	0.01534	0.015373	307.0
2011-07-07	JB	Futures	122.55	122.57	122.42	122.52	1660.0
2011-07-07	KC	Futures	631.66	643.25	627.28	635.44	8804.0

> showing 50 of 96 rows — these rows as CSV

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