PREVIEW / futures_daily / 2009-04-17

all futures daily files

  file:    by_date/futures_daily/2009/2009-04-17.parquet
  size:    8 KB
  rows:    86

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-04-17	ES	Futures	821.09	831.1	813.7	826.09	1873990.0
2009-04-17	NQ	Futures	1517.58	1528.82	1501.85	1518.99	247517.0
2009-04-17	YM	Futures	7228.8	7298.8	7181.3	7251.2	143262.0
2009-04-17	CL	Futures	140.06	143.32	139.09	141.32	163651.0
2009-04-17	GC	Futures	1214.2	1215.6	1198.5	1201.7	75752.0
2009-04-17	ZN	Futures	95.677399	95.786633	94.815659	94.98558	584160.0
2009-04-17	A6	Futures	0.57166	0.57453	0.56926	0.57166	35703.0
2009-04-17	AD	Futures	0.81413	0.81561	0.80862	0.81089	33091.0
2009-04-17	B	Futures	51.31	52.2	50.91	51.6	75938.0
2009-04-17	B6	Futures	1.5528	1.5548	1.535	1.539	57224.0
2009-04-17	BFX	Futures	2075.4	2100.9	2063.2	2090.6	1314.0
2009-04-17	BZ	Futures	54.7	55.09	54.03	54.47	37.0
2009-04-17	C	Futures	1756.0	1802.0	1747.0	1801.0	2385.0
2009-04-17	CB	Futures	76.135	76.135	75.683	75.683	9.0
2009-04-17	CC	Futures	2100.0	2146.0	2073.0	2129.0	6054.0
2009-04-17	CT	Futures	46.6	47.3	46.37	47.11	5244.0
2009-04-17	DC	Futures	27.19	27.43	27.17	27.4	120.0
2009-04-17	DX	Futures	88.008	88.909	87.977	88.863	6825.0
2009-04-17	E1	Futures	1.15621	1.15794	1.13526	1.13685	37748.0
2009-04-17	E6	Futures	1.56166	1.56391	1.54233	1.54352	122413.0
2009-04-17	E7	Futures	1.5438	1.5459	1.5242	1.5256	1672.0
2009-04-17	EBM	Futures	212.08	216.72	212.08	215.18	4636.0
2009-04-17	ED	Futures	93.2802	93.2943	93.2283	93.2613	188655.0
2009-04-17	ER	Futures	96.689	96.704	96.655	96.66	129367.0
2009-04-17	EW	Futures	522.1	533.1	518.6	528.7	27138.0
2009-04-17	FCE	Futures	1894.5	1938.3	1887.2	1926.6	154603.0
2009-04-17	FDAX	Futures	5031.7	5117.7	5007.7	5076.9	177122.0
2009-04-17	FESX	Futures	1341.1	1366.9	1332.1	1353.1	1398289.0
2009-04-17	FEU3	Futures	97.264	97.264	97.234	97.244	1160.0
2009-04-17	FGBL	Futures	92.49	92.52	91.8	91.93	510346.0
2009-04-17	FGBM	Futures	97.8	97.82	97.24	97.33	322411.0
2009-04-17	FGBS	Futures	103.68	103.68	103.464	103.503	357642.0
2009-04-17	FGBX	Futures	82.29	82.65	81.72	81.98	3241.0
2009-04-17	FTDX	Futures	502.7	528.8	502.7	510.8	581.0
2009-04-17	FTI	Futures	195.93	200.13	195.39	199.3	41625.0
2009-04-17	FTUK	Futures	2678.1	2714.7	2659.1	2690.4	108338.0
2009-04-17	G	Futures	77.87	77.99	77.23	77.3	60885.0
2009-04-17	GF	Futures	278.05	279.516	276.096	277.911	686.0
2009-04-17	GSCI	Futures	802.12	807.65	800.1	800.1	322.0
2009-04-17	HE	Futures	118.491	119.234	117.873	119.234	289.0
2009-04-17	HG	Futures	3.0607	3.1065	2.9973	3.091	16670.0
2009-04-17	HO	Futures	1.5678	1.6077	1.5543	1.5753	22436.0
2009-04-17	HRC	Futures	2595.1	2595.1	2595.1	2595.1	0.0
2009-04-17	J1	Futures	0.0126959	0.0127791	0.0126405	0.0127135	62071.0
2009-04-17	J7	Futures	0.012519	0.012608	0.01246	0.012541	429.0
2009-04-17	JB	Futures	114.42	114.63	114.36	114.59	1686.0
2009-04-17	KC	Futures	319.97	322.08	312.38	314.63	5217.0
2009-04-17	KE	Futures	2816.28	2833.54	2791.63	2805.19	5454.0
2009-04-17	L	Futures	96.954	96.954	96.905	96.925	39123.0
2009-04-17	LBS	Futures	931.2	932.8	896.0	900.1	136.0

> showing 50 of 86 rows — these rows as CSV

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