PREVIEW / futures_daily / 2009-01-02

all futures daily files

  file:    by_date/futures_daily/2009/2009-01-02.parquet
  size:    8 KB
  rows:    83

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-02	ES	Futures	849.86	880.78	846.55	873.94	1095813.0
2009-01-02	NQ	Futures	1353.88	1417.89	1346.06	1400.84	190785.0
2009-01-02	YM	Futures	7762.4	8030.4	7759.8	7976.1	88889.0
2009-01-02	CL	Futures	173.57	185.56	162.97	183.97	184679.0
2009-01-02	GC	Futures	1231.1	1239.6	1210.3	1226.2	46093.0
2009-01-02	ZN	Futures	96.638729	96.973409	95.049001	95.08486	206154.0
2009-01-02	A6	Futures	0.54875	0.56136	0.54676	0.56017	10835.0
2009-01-02	AD	Futures	0.80704	0.8149	0.80222	0.8092	15140.0
2009-01-02	B	Futures	48.65	51.8	45.87	51.39	49285.0
2009-01-02	B6	Futures	1.5062	1.5106	1.4913	1.5016	19710.0
2009-01-02	BFX	Futures	2149.9	2180.6	2145.9	2176.9	94.0
2009-01-02	BZ	Futures	51.59	51.59	51.59	51.59	50.0
2009-01-02	C	Futures	1766.0	1802.0	1748.0	1784.0	1899.0
2009-01-02	CC	Futures	2337.0	2337.0	2200.0	2241.0	5617.0
2009-01-02	CT	Futures	47.94	48.12	44.81	47.61	6239.0
2009-01-02	DX	Futures	85.23	85.956	85.044	85.863	2873.0
2009-01-02	E1	Futures	1.25154	1.25207	1.22588	1.23306	13451.0
2009-01-02	E6	Futures	1.64562	1.65225	1.63426	1.63651	57889.0
2009-01-02	E7	Futures	1.6277	1.6329	1.6154	1.6178	763.0
2009-01-02	EBM	Futures	210.15	213.6	210.15	212.07	572.0
2009-01-02	ED	Futures	93.1708	93.2367	93.0577	93.0907	73686.0
2009-01-02	ER	Futures	95.87	95.89	95.856	95.88	36601.0
2009-01-02	EW	Futures	524.9	540.2	518.1	533.9	25206.0
2009-01-02	FCE	Futures	1999.0	2096.4	1980.9	2062.2	52188.0
2009-01-02	FDAX	Futures	5333.5	5527.3	5309.5	5434.5	67482.0
2009-01-02	FESX	Futures	1425.4	1481.7	1412.8	1455.9	448125.0
2009-01-02	FEU3	Futures	96.425	96.45	96.425	96.445	214.0
2009-01-02	FGBL	Futures	93.11	93.75	92.66	93.58	212352.0
2009-01-02	FGBM	Futures	97.58	97.79	97.35	97.75	128491.0
2009-01-02	FGBS	Futures	103.157	103.205	103.042	103.153	148557.0
2009-01-02	FGBX	Futures	87.4	88.01	86.67	87.78	771.0
2009-01-02	FTDX	Futures	456.4	474.3	451.9	465.4	476.0
2009-01-02	FTI	Futures	198.98	207.78	197.7	206.58	14187.0
2009-01-02	FTUK	Futures	2884.9	3015.4	2880.7	2960.3	51906.0
2009-01-02	G	Futures	76.93	77.45	76.67	77.15	20858.0
2009-01-02	GF	Futures	257.786	267.116	256.542	264.282	162.0
2009-01-02	GSCI	Futures	812.33	863.83	812.09	853.96	501.0
2009-01-02	HE	Futures	117.677	123.476	117.532	123.428	8940.0
2009-01-02	HG	Futures	1.9641	2.0901	1.9303	2.0563	8424.0
2009-01-02	HO	Futures	1.6149	1.6866	1.5393	1.6726	7411.0
2009-01-02	HRC	Futures	3101.0	3101.0	3101.0	3101.0	0.0
2009-01-02	J1	Futures	0.0138919	0.0139323	0.0136822	0.013715	32876.0
2009-01-02	J7	Futures	0.013709	0.01375	0.013518	0.01355	82.0
2009-01-02	KC	Futures	319.67	320.24	311.81	316.96	3880.0
2009-01-02	KE	Futures	3134.06	3167.78	3062.86	3165.29	6275.0
2009-01-02	L	Futures	96.714	96.753	96.704	96.738	16157.0
2009-01-02	LBS	Futures	1053.4	1064.6	1043.9	1048.9	34.0
2009-01-02	LE	Futures	153.989	159.311	153.944	155.823	8120.0
2009-01-02	MP	Futures	0.0355	0.03585	0.03527	0.03565	2583.0
2009-01-02	N6	Futures	0.45323	0.45867	0.45197	0.45828	602.0

> showing 50 of 83 rows — these rows as CSV

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