PREVIEW / futures_daily / 2009-01-09

all futures daily files

  file:    by_date/futures_daily/2009/2009-01-09.parquet
  size:    8 KB
  rows:    87

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-01-09	ES	Futures	856.23	863.79	833.57	836.17	2052723.0
2009-01-09	NQ	Futures	1397.76	1404.47	1359.47	1365.62	245200.0
2009-01-09	YM	Futures	7750.0	7790.0	7578.1	7588.8	156723.0
2009-01-09	CL	Futures	168.53	169.52	156.34	162.1	277431.0
2009-01-09	GC	Futures	1196.0	1212.0	1178.1	1192.1	106498.0
2009-01-09	ZN	Futures	95.778125	96.650682	95.527115	96.041087	482592.0
2009-01-09	A6	Futures	0.56025	0.56152	0.55271	0.55501	22847.0
2009-01-09	AD	Futures	0.83258	0.83356	0.8201	0.82718	26887.0
2009-01-09	B	Futures	49.66	50.09	47.08	48.74	112991.0
2009-01-09	B6	Futures	1.5797	1.5928	1.5686	1.5699	53350.0
2009-01-09	BFX	Futures	2188.0	2194.2	2165.1	2180.1	72.0
2009-01-09	BR	Futures	0.15776	0.15889	0.15633	0.1586	27.0
2009-01-09	BZ	Futures	48.56	48.94	47.58	48.94	229.0
2009-01-09	C	Futures	1831.0	1846.0	1793.0	1799.0	5893.0
2009-01-09	CB	Futures	77.664	78.325	77.664	77.994	20.0
2009-01-09	CC	Futures	2325.0	2359.0	2267.0	2281.0	6912.0
2009-01-09	CT	Futures	49.32	49.55	47.87	48.01	8103.0
2009-01-09	DC	Futures	26.83	28.18	26.32	27.32	261.0
2009-01-09	DX	Futures	85.567	86.584	85.116	86.537	3717.0
2009-01-09	E1	Futures	1.21578	1.22136	1.18827	1.19319	37941.0
2009-01-09	E6	Futures	1.61851	1.62455	1.58347	1.58643	176196.0
2009-01-09	E7	Futures	1.6003	1.607	1.565	1.5683	2353.0
2009-01-09	EBM	Futures	223.95	231.62	223.95	228.56	2172.0
2009-01-09	ED	Futures	93.2697	93.4062	93.2697	93.3544	279940.0
2009-01-09	ER	Futures	95.968	96.125	95.964	96.091	185082.0
2009-01-09	EW	Futures	531.0	535.9	512.5	514.8	38210.0
2009-01-09	FCE	Futures	2054.2	2077.0	2013.8	2035.4	118357.0
2009-01-09	FDAX	Futures	5369.5	5408.3	5195.4	5254.9	144801.0
2009-01-09	FESX	Futures	1450.7	1465.6	1417.9	1434.6	1160175.0
2009-01-09	FEU3	Futures	96.549	96.672	96.549	96.667	948.0
2009-01-09	FGBL	Futures	92.36	93.32	92.23	93.16	608114.0
2009-01-09	FGBM	Futures	97.33	97.88	97.26	97.78	352628.0
2009-01-09	FGBS	Futures	103.359	103.57	103.33	103.508	340978.0
2009-01-09	FGBX	Futures	84.63	85.87	84.1	85.58	1791.0
2009-01-09	FTDX	Futures	447.5	451.9	429.6	443.0	306.0
2009-01-09	FTI	Futures	212.62	215.9	210.14	212.98	29698.0
2009-01-09	FTUK	Futures	2942.9	2955.7	2876.7	2904.9	97251.0
2009-01-09	G	Futures	76.15	76.63	76.04	76.59	66893.0
2009-01-09	GF	Futures	258.338	260.896	258.338	260.135	58.0
2009-01-09	GSCI	Futures	824.22	825.41	800.2	818.75	140.0
2009-01-09	HE	Futures	122.075	122.075	120.528	120.722	7648.0
2009-01-09	HG	Futures	2.0887	2.2027	2.0746	2.1949	18041.0
2009-01-09	HO	Futures	1.7208	1.7324	1.6102	1.6642	19700.0
2009-01-09	HRC	Futures	3101.0	3101.0	3101.0	3101.0	0.0
2009-01-09	J1	Futures	0.0138565	0.0140233	0.013787	0.0139702	84730.0
2009-01-09	J7	Futures	0.013682	0.013848	0.013626	0.013802	59.0
2009-01-09	JB	Futures	116.25	116.35	116.09	116.34	7.0
2009-01-09	KC	Futures	325.96	341.53	325.1	334.1	13937.0
2009-01-09	KE	Futures	3166.53	3272.71	3166.53	3252.72	5901.0
2009-01-09	L	Futures	96.856	96.969	96.841	96.945	48556.0

> showing 50 of 87 rows — these rows as CSV

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