PREVIEW / futures_daily / 2009-09-28

all futures daily files

  file:    by_date/futures_daily/2009/2009-09-28.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-09-28	ES	Futures	1005.29	1023.37	999.02	1021.44	1516970.0
2009-09-28	NQ	Futures	1915.64	1955.72	1905.48	1944.71	251261.0
2009-09-28	YM	Futures	8735.5	8864.4	8689.2	8831.7	118407.0
2009-09-28	CL	Futures	163.82	167.26	161.99	165.53	231410.0
2009-09-28	GC	Futures	1372.9	1379.7	1364.1	1374.3	88768.0
2009-09-28	ZN	Futures	94.089978	94.301696	93.94053	94.202064	466912.0
2009-09-28	A6	Futures	0.69572	0.70324	0.68942	0.69928	70867.0
2009-09-28	AD	Futures	0.90308	0.91038	0.89668	0.90713	55599.0
2009-09-28	B	Futures	61.68	62.53	60.85	61.84	50676.0
2009-09-28	B6	Futures	1.6609	1.6612	1.6404	1.651	108450.0
2009-09-28	BFX	Futures	2769.6	2826.7	2765.1	2824.9	48.0
2009-09-28	BR	Futures	0.21975	0.21975	0.21971	0.21971	135.0
2009-09-28	C	Futures	2129.0	2147.0	2109.0	2130.0	2884.0
2009-09-28	CC	Futures	2700.0	2715.0	2680.0	2707.0	1846.0
2009-09-28	CT	Futures	53.59	54.35	53.16	54.28	5489.0
2009-09-28	DC	Futures	24.25	24.59	23.88	23.88	201.0
2009-09-28	DX	Futures	78.491	79.104	78.328	78.889	8057.0
2009-09-28	E1	Futures	1.28629	1.28933	1.25776	1.27784	45750.0
2009-09-28	E6	Futures	1.74216	1.74441	1.72581	1.72913	234719.0
2009-09-28	E7	Futures	1.7251	1.7277	1.7093	1.7126	2855.0
2009-09-28	ED	Futures	94.1481	94.1718	94.1387	94.1623	109501.0
2009-09-28	ER	Futures	97.198	97.208	97.184	97.203	65411.0
2009-09-28	EW	Futures	658.4	671.8	653.7	669.0	28518.0
2009-09-28	FCE	Futures	2457.7	2531.9	2443.2	2525.3	129788.0
2009-09-28	FDAX	Futures	6055.8	6260.9	6042.7	6225.5	177177.0
2009-09-28	FESX	Futures	1676.0	1731.6	1667.7	1721.4	1189236.0
2009-09-28	FEU3	Futures	97.771	97.776	97.771	97.776	2553.0
2009-09-28	FGBL	Futures	93.86	93.95	93.55	93.68	551897.0
2009-09-28	FGBM	Futures	99.14	99.18	98.99	99.09	343239.0
2009-09-28	FGBS	Futures	104.784	104.794	104.735	104.779	271370.0
2009-09-28	FGBX	Futures	87.76	87.76	87.33	87.46	3402.0
2009-09-28	FTDX	Futures	654.9	672.3	648.7	671.0	647.0
2009-09-28	FTI	Futures	251.24	257.86	250.99	256.96	21966.0
2009-09-28	FTUK	Futures	3358.8	3414.2	3328.7	3404.9	111838.0
2009-09-28	G	Futures	76.83	76.94	76.6	76.66	73086.0
2009-09-28	GF	Futures	264.882	265.777	264.056	265.57	1265.0
2009-09-28	GSCI	Futures	881.53	894.74	878.73	889.94	694.0
2009-09-28	HE	Futures	74.925	76.906	74.925	75.801	10143.0
2009-09-28	HG	Futures	3.8162	3.8231	3.7103	3.8001	14090.0
2009-09-28	HO	Futures	1.6907	1.7187	1.6725	1.6955	9706.0
2009-09-28	HRC	Futures	2713.5	2713.5	2713.5	2713.5	0.0
2009-09-28	J1	Futures	0.0140158	0.0142406	0.013992	0.0139958	102866.0
2009-09-28	J7	Futures	0.013828	0.014052	0.013812	0.013813	179.0
2009-09-28	JB	Futures	117.38	117.62	117.3	117.54	1350.0
2009-09-28	KC	Futures	336.17	339.33	335.24	335.64	4373.0
2009-09-28	KE	Futures	2242.77	2242.77	2189.26	2210.19	8395.0
2009-09-28	L	Futures	97.858	97.897	97.848	97.868	69608.0
2009-09-28	LBS	Futures	693.7	702.6	691.6	693.7	298.0
2009-09-28	LE	Futures	142.879	143.884	142.586	143.591	10912.0
2009-09-28	MFS	Futures	1234.9	1256.8	1234.1	1248.9	930.0

> showing 50 of 86 rows — these rows as CSV

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