PREVIEW / futures_daily / 2011-06-27

all futures daily files

  file:    by_date/futures_daily/2011/2011-06-27.parquet
  size:    9 KB
  rows:    95

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-06-27	ES	Futures	1256.31	1271.21	1248.37	1267.49	2000732.0
2011-06-27	NQ	Futures	2515.23	2573.59	2495.59	2561.07	316081.0
2011-06-27	YM	Futures	11233.3	11374.2	11172.8	11335.4	104596.0
2011-06-27	CL	Futures	174.92	175.19	171.94	173.86	278681.0
2011-06-27	GC	Futures	2031.4	2038.4	2017.7	2025.3	128943.0
2011-06-27	ZN	Futures	106.28012	106.466389	105.894275	105.93419	1246667.0
2011-06-27	A6	Futures	0.90221	0.90282	0.8943	0.89743	123473.0
2011-06-27	AD	Futures	1.00784	1.01043	1.00475	1.00914	71941.0
2011-06-27	B	Futures	89.94	90.8	87.47	90.3	106983.0
2011-06-27	B6	Futures	1.6593	1.664	1.6536	1.6603	94423.0
2011-06-27	BFX	Futures	2983.0	2983.0	2966.2	2972.0	154.0
2011-06-27	BR	Futures	0.27501	0.27501	0.2743	0.27484	118.0
2011-06-27	BZ	Futures	93.79	93.79	93.79	93.79	1215.0
2011-06-27	C	Futures	2049.0	2072.0	2041.0	2065.0	1954.0
2011-06-27	CB	Futures	109.861	110.135	109.861	110.135	13.0
2011-06-27	CC	Futures	2351.0	2387.0	2339.0	2378.0	5288.0
2011-06-27	CSC	Futures	4.546	4.546	4.546	4.546	6.0
2011-06-27	CT	Futures	162.35	170.2	158.97	166.03	91.0
2011-06-27	DC	Futures	30.4	30.87	30.4	30.82	198.0
2011-06-27	DX	Futures	75.455	75.851	74.979	75.096	35210.0
2011-06-27	E1	Futures	1.56811	1.57321	1.56079	1.56458	37000.0
2011-06-27	E6	Futures	1.68117	1.694	1.67107	1.69043	293388.0
2011-06-27	E7	Futures	1.6695	1.6816	1.6592	1.6781	4444.0
2011-06-27	ED	Futures	94.8667	94.8953	94.8477	94.8906	394318.0
2011-06-27	ER	Futures	97.356	97.356	97.321	97.331	92661.0
2011-06-27	EW	Futures	935.0	942.8	929.8	940.0	20914.0
2011-06-27	FBTP	Futures	64.4	64.4	63.95	64.26	6258.0
2011-06-27	FCE	Futures	2626.0	2652.7	2615.5	2634.6	103255.0
2011-06-27	FDAX	Futures	7606.7	7662.8	7588.0	7619.5	115563.0
2011-06-27	FESX	Futures	1738.2	1758.7	1730.5	1747.8	1130256.0
2011-06-27	FEU3	Futures	97.87	97.87	97.87	97.87	1.0
2011-06-27	FGBL	Futures	102.32	102.34	101.7	101.8	863974.0
2011-06-27	FGBM	Futures	106.29	106.31	105.95	106.0	526637.0
2011-06-27	FGBS	Futures	107.547	107.547	107.393	107.428	553366.0
2011-06-27	FGBX	Futures	97.25	97.25	95.9	95.99	6779.0
2011-06-27	FTDX	Futures	771.6	773.4	760.9	765.8	521.0
2011-06-27	FTI	Futures	269.29	271.22	268.47	269.87	28014.0
2011-06-27	FTUK	Futures	3980.1	4035.2	3969.6	4007.3	80801.0
2011-06-27	FXXP	Futures	177.7	178.9	177.7	178.5	2987.0
2011-06-27	G	Futures	85.47	85.68	85.35	85.39	84026.0
2011-06-27	GF	Futures	322.168	322.575	317.869	318.914	2607.0
2011-06-27	GSCI	Futures	1014.29	1016.65	1004.98	1013.1	298.0
2011-06-27	HE	Futures	102.185	102.185	99.918	100.451	8173.0
2011-06-27	HG	Futures	5.4365	5.4431	5.3546	5.377	20419.0
2011-06-27	HO	Futures	2.2564	2.2855	2.2286	2.2677	10530.0
2011-06-27	HRC	Futures	3072.8	3072.8	3072.8	3072.8	1.0
2011-06-27	J1	Futures	0.0156335	0.0156398	0.0155267	0.015543	113095.0
2011-06-27	J7	Futures	0.015538	0.015538	0.015425	0.015439	231.0
2011-06-27	JB	Futures	123.0	123.29	123.0	123.23	2.0
2011-06-27	KC	Futures	592.62	598.65	585.52	593.92	8568.0

> showing 50 of 95 rows — these rows as CSV

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