PREVIEW / futures_daily / 2009-07-27

all futures daily files

  file:    by_date/futures_daily/2009/2009-07-27.parquet
  size:    8 KB
  rows:    85

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
2009-07-27	ES	Futures	937.37	944.09	929.7	940.25	1521546.0
2009-07-27	NQ	Futures	1798.76	1812.0	1777.65	1801.3	258387.0
2009-07-27	YM	Futures	8166.3	8223.1	8111.2	8183.4	117995.0
2009-07-27	CL	Futures	175.2	177.63	174.05	176.05	245180.0
2009-07-27	GC	Futures	1319.5	1330.9	1314.1	1322.0	41117.0
2009-07-27	ZN	Futures	91.741528	91.778466	91.10127	91.446025	569051.0
2009-07-27	A6	Futures	0.65471	0.66147	0.6523	0.65889	67249.0
2009-07-27	AD	Futures	0.91018	0.9165	0.90791	0.91442	51003.0
2009-07-27	B	Futures	66.94	68.04	66.91	67.54	67787.0
2009-07-27	B6	Futures	1.7124	1.7212	1.7062	1.7183	77178.0
2009-07-27	BFX	Futures	2444.4	2452.1	2418.3	2428.1	206.0
2009-07-27	BR	Futures	0.20509	0.20509	0.20509	0.20509	11.0
2009-07-27	BZ	Futures	70.34	70.45	70.34	70.45	3.0
2009-07-27	C	Futures	1959.0	1963.0	1908.0	1909.0	2559.0
2009-07-27	CC	Futures	2597.0	2610.0	2532.0	2553.0	4482.0
2009-07-27	CT	Futures	50.42	50.91	49.37	50.69	236.0
2009-07-27	DC	Futures	21.57	21.79	21.52	21.63	97.0
2009-07-27	DX	Futures	80.66	80.987	80.358	80.609	4381.0
2009-07-27	E1	Futures	1.23801	1.2433	1.23285	1.23814	31777.0
2009-07-27	E6	Futures	1.68889	1.69743	1.68224	1.69091	181275.0
2009-07-27	E7	Futures	1.6717	1.6799	1.6651	1.6736	1603.0
2009-07-27	ED	Futures	93.9094	93.9424	93.9094	93.9424	103303.0
2009-07-27	ER	Futures	97.071	97.076	97.061	97.071	56231.0
2009-07-27	EW	Futures	599.4	604.2	595.1	603.3	22311.0
2009-07-27	FCE	Futures	2236.9	2245.4	2196.3	2210.0	105993.0
2009-07-27	FDAX	Futures	5820.5	5843.0	5724.5	5751.9	109222.0
2009-07-27	FESX	Futures	1562.7	1571.0	1538.2	1548.4	844798.0
2009-07-27	FEU3	Futures	97.653	97.653	97.653	97.653	1.0
2009-07-27	FGBL	Futures	91.32	91.48	91.15	91.44	598831.0
2009-07-27	FGBM	Futures	97.66	97.71	97.52	97.67	310602.0
2009-07-27	FGBS	Futures	104.022	104.041	103.945	103.984	369776.0
2009-07-27	FGBX	Futures	82.78	82.92	82.5	82.85	1863.0
2009-07-27	FTDX	Futures	602.3	606.3	590.2	594.2	264.0
2009-07-27	FTI	Futures	229.24	230.02	225.71	227.35	24971.0
2009-07-27	FTUK	Futures	3043.2	3046.6	2999.8	3015.7	92276.0
2009-07-27	G	Futures	74.16	74.4	74.11	74.28	45450.0
2009-07-27	GF	Futures	282.797	283.279	281.143	282.245	710.0
2009-07-27	GSCI	Futures	940.2	942.91	933.93	942.29	367.0
2009-07-27	HE	Futures	85.287	86.007	83.236	85.179	7439.0
2009-07-27	HG	Futures	3.5531	3.6212	3.5349	3.5735	17534.0
2009-07-27	HO	Futures	1.8298	1.8561	1.8207	1.8431	28454.0
2009-07-27	HRC	Futures	2434.4	2434.4	2434.4	2434.4	0.0
2009-07-27	J1	Futures	0.0132992	0.0133042	0.013201	0.0132274	70363.0
2009-07-27	J7	Futures	0.013114	0.013115	0.013018	0.013045	49.0
2009-07-27	JB	Futures	116.47	116.61	116.44	116.47	1200.0
2009-07-27	KC	Futures	336.46	339.18	333.48	337.68	4417.0
2009-07-27	KE	Futures	2632.0	2666.77	2617.61	2646.39	6143.0
2009-07-27	L	Futures	97.367	97.367	97.337	97.357	23991.0
2009-07-27	LBS	Futures	773.3	803.8	773.3	799.7	669.0
2009-07-27	LE	Futures	149.136	150.343	148.511	150.176	9751.0

> showing 50 of 85 rows — these rows as CSV

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