PREVIEW / futures_daily / 2011-05-20

all futures daily files

  file:    by_date/futures_daily/2011/2011-05-20.parquet
  size:    9 KB
  rows:    93

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-05-20	ES	Futures	1328.1	1330.57	1313.74	1314.49	2248408.0
2011-05-20	NQ	Futures	2697.45	2702.29	2667.56	2668.98	257419.0
2011-05-20	YM	Futures	11835.9	11849.0	11713.7	11720.2	121204.0
2011-05-20	CL	Futures	190.31	192.92	185.1	192.3	394911.0
2011-05-20	GC	Futures	2021.5	2051.7	2011.9	2042.3	194402.0
2011-05-20	ZN	Futures	103.304689	103.568053	103.252016	103.502212	1084688.0
2011-05-20	A6	Futures	0.91197	0.91608	0.90742	0.9148	106278.0
2011-05-20	AD	Futures	1.02809	1.03217	1.01843	1.02381	106244.0
2011-05-20	B	Futures	94.76	95.8	92.16	95.38	209488.0
2011-05-20	B6	Futures	1.6851	1.6935	1.679	1.6906	129077.0
2011-05-20	BFX	Futures	3219.9	3224.6	3211.0	3211.0	36.0
2011-05-20	BR	Futures	0.27126	0.27177	0.27126	0.27177	20.0
2011-05-20	BZ	Futures	99.8	100.74	97.78	100.5	416.0
2011-05-20	C	Futures	2022.0	2024.0	1973.0	1975.0	7361.0
2011-05-20	CC	Futures	2373.0	2383.0	2307.0	2310.0	15615.0
2011-05-20	CSC	Futures	4.657	4.657	4.657	4.657	1.0
2011-05-20	CT	Futures	153.41	155.41	148.52	154.02	7123.0
2011-05-20	DC	Futures	30.6	31.21	30.6	31.09	394.0
2011-05-20	DX	Futures	74.82	75.541	74.71	75.202	41743.0
2011-05-20	E1	Futures	1.4859	1.49716	1.47857	1.49336	54794.0
2011-05-20	E6	Futures	1.69418	1.69844	1.67322	1.68174	421575.0
2011-05-20	E7	Futures	1.6816	1.6858	1.6609	1.6692	9137.0
2011-05-20	ED	Futures	94.9573	94.9597	94.9478	94.9525	131855.0
2011-05-20	ER	Futures	97.262	97.277	97.257	97.262	127966.0
2011-05-20	EW	Futures	987.9	990.7	974.9	977.7	26056.0
2011-05-20	FBTP	Futures	65.18	65.18	64.8	64.99	7898.0
2011-05-20	FCE	Futures	2768.3	2783.2	2735.0	2741.9	149716.0
2011-05-20	FDAX	Futures	7884.9	7920.6	7723.1	7764.7	159677.0
2011-05-20	FESX	Futures	1844.6	1854.2	1810.7	1817.1	1562749.0
2011-05-20	FEU3	Futures	97.805	97.81	97.805	97.805	151.0
2011-05-20	FGBL	Futures	99.39	99.88	99.32	99.83	1003394.0
2011-05-20	FGBM	Futures	103.75	104.13	103.74	104.09	566400.0
2011-05-20	FGBS	Futures	106.464	106.583	106.454	106.578	599810.0
2011-05-20	FGBX	Futures	96.17	97.01	95.97	96.92	3746.0
2011-05-20	FTDX	Futures	824.3	826.6	815.9	817.2	236.0
2011-05-20	FTI	Futures	288.49	289.23	284.23	285.66	47217.0
2011-05-20	FTUK	Futures	4174.9	4204.0	4138.2	4150.4	110181.0
2011-05-20	FXXP	Futures	187.0	188.1	186.0	186.3	1555.0
2011-05-20	G	Futures	83.62	83.9	83.54	83.85	115853.0
2011-05-20	GF	Futures	294.105	294.977	291.2	292.246	4207.0
2011-05-20	GSCI	Futures	1072.96	1081.73	1051.12	1081.73	176.0
2011-05-20	HE	Futures	96.628	97.502	96.496	97.396	10136.0
2011-05-20	HG	Futures	5.3793	5.5115	5.3647	5.4756	33620.0
2011-05-20	HO	Futures	2.3782	2.4125	2.3288	2.3994	5615.0
2011-05-20	HRC	Futures	3077.0	3077.0	3077.0	3077.0	0.0
2011-05-20	J1	Futures	0.0153822	0.0154187	0.0153458	0.0153986	78404.0
2011-05-20	J7	Futures	0.015287	0.015322	0.015256	0.015304	154.0
2011-05-20	JB	Futures	122.34	122.68	122.28	122.63	1958.0
2011-05-20	KC	Futures	635.47	642.54	620.12	621.44	13607.0
2011-05-20	KE	Futures	3730.46	3753.17	3642.58	3686.03	13007.0

> showing 50 of 93 rows — these rows as CSV

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