PREVIEW / futures_daily / 2009-03-17

all futures daily files

  file:    by_date/futures_daily/2009/2009-03-17.parquet
  size:    9 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-03-17	ES	Futures	718.16	740.55	711.01	738.89	2826223.0
2009-03-17	NQ	Futures	1293.44	1338.66	1288.39	1337.26	387148.0
2009-03-17	YM	Futures	6435.0	6605.4	6385.6	6596.4	178793.0
2009-03-17	CL	Futures	133.77	142.05	132.53	140.48	166614.0
2009-03-17	GC	Futures	1282.9	1284.1	1266.2	1272.3	70710.0
2009-03-17	ZN	Futures	94.354446	94.657876	93.856822	93.941782	656028.0
2009-03-17	A6	Futures	0.52301	0.52588	0.52125	0.52476	22323.0
2009-03-17	AD	Futures	0.77495	0.77761	0.7717	0.77583	24599.0
2009-03-17	B	Futures	44.93	47.62	44.26	47.22	102311.0
2009-03-17	B6	Futures	1.4651	1.4717	1.4534	1.4602	47923.0
2009-03-17	BFX	Futures	1859.6	1859.6	1848.2	1853.7	6045.0
2009-03-17	BR	Futures	0.16461	0.16461	0.16328	0.16362	351.0
2009-03-17	BZ	Futures	47.92	49.62	47.92	49.25	52.0
2009-03-17	C	Futures	1898.0	1922.0	1894.0	1899.0	3264.0
2009-03-17	CB	Futures	78.241	78.392	77.038	77.038	19.0
2009-03-17	CC	Futures	2128.0	2132.0	2089.0	2108.0	5194.0
2009-03-17	CT	Futures	40.72	40.77	40.18	40.42	7413.0
2009-03-17	DC	Futures	29.25	29.82	29.08	29.54	151.0
2009-03-17	DX	Futures	90.124	90.459	89.795	89.944	3928.0
2009-03-17	E1	Futures	1.12147	1.12492	1.11617	1.12333	17832.0
2009-03-17	E6	Futures	1.5383	1.54553	1.5332	1.54198	150299.0
2009-03-17	E7	Futures	1.5216	1.5274	1.5151	1.5241	1379.0
2009-03-17	EBM	Futures	215.18	218.27	214.79	216.72	4572.0
2009-03-17	ED	Futures	92.9361	93.0209	92.9361	92.9738	244980.0
2009-03-17	ER	Futures	96.508	96.557	96.488	96.542	194495.0
2009-03-17	EW	Futures	435.5	452.2	428.7	451.0	53943.0
2009-03-17	FCE	Futures	1751.7	1782.8	1727.9	1755.5	135594.0
2009-03-17	FDAX	Futures	4401.6	4430.5	4309.1	4355.4	52566.0
2009-03-17	FESX	Futures	1174.3	1188.1	1147.3	1162.9	1305857.0
2009-03-17	FEU3	Futures	97.076	97.131	97.071	97.121	340.0
2009-03-17	FGBL	Futures	92.81	93.1	92.39	92.54	824311.0
2009-03-17	FGBM	Futures	97.86	98.0	97.53	97.57	441673.0
2009-03-17	FGBS	Futures	103.723	103.771	103.565	103.594	364960.0
2009-03-17	FGBX	Futures	81.91	82.53	81.41	81.67	2792.0
2009-03-17	FTDX	Futures	388.5	395.7	384.0	384.9	529.0
2009-03-17	FTI	Futures	175.14	175.14	170.44	171.84	38192.0
2009-03-17	FTUK	Futures	2533.9	2576.5	2495.3	2535.2	323210.0
2009-03-17	G	Futures	78.59	78.86	78.31	78.39	63252.0
2009-03-17	GF	Futures	256.689	259.97	256.549	259.132	688.0
2009-03-17	GSCI	Futures	739.82	763.42	735.14	757.04	201.0
2009-03-17	HE	Futures	120.335	121.398	119.32	120.142	5336.0
2009-03-17	HG	Futures	2.4486	2.4838	2.4063	2.4288	11719.0
2009-03-17	HO	Futures	1.3594	1.443	1.3419	1.4294	10056.0
2009-03-17	HRC	Futures	2833.7	2833.7	2833.7	2833.7	0.0
2009-03-17	J1	Futures	0.012856	0.0128597	0.0127526	0.0128156	48542.0
2009-03-17	J7	Futures	0.012683	0.012688	0.012579	0.012642	38.0
2009-03-17	JB	Futures	116.24	116.3	115.94	115.95	1462.0
2009-03-17	KC	Futures	311.68	315.33	308.72	312.94	10206.0
2009-03-17	KE	Futures	2924.74	2992.53	2901.32	2983.9	8409.0
2009-03-17	L	Futures	96.571	96.679	96.561	96.649	53155.0

> showing 50 of 87 rows — these rows as CSV

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