PREVIEW / futures_daily / 2009-09-14

all futures daily files

  file:    by_date/futures_daily/2009/2009-09-14.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-14	ES	Futures	999.26	1008.18	989.13	1006.49	1946759.0
2009-09-14	NQ	Futures	1898.15	1909.72	1879.8	1905.48	245248.0
2009-09-14	YM	Futures	8645.6	8687.4	8563.9	8670.1	132960.0
2009-09-14	CL	Futures	172.88	173.2	169.66	171.79	127365.0
2009-09-14	GC	Futures	1393.1	1397.4	1374.7	1384.0	93924.0
2009-09-14	ZN	Futures	93.977892	94.164702	93.554456	93.69145	570052.0
2009-09-14	A6	Futures	0.69184	0.69249	0.68538	0.69047	65855.0
2009-09-14	AD	Futures	0.9161	0.9161	0.90249	0.90949	66961.0
2009-09-14	B	Futures	64.68	64.97	63.71	64.55	140637.0
2009-09-14	B6	Futures	1.7355	1.7355	1.7188	1.7244	90053.0
2009-09-14	BFX	Futures	2759.6	2765.1	2743.9	2765.1	1375.0
2009-09-14	BR	Futures	0.21446	0.21599	0.21446	0.21599	19.0
2009-09-14	C	Futures	2011.0	2029.0	2004.0	2013.0	7957.0
2009-09-14	CC	Futures	2676.0	2693.0	2647.0	2680.0	4958.0
2009-09-14	CT	Futures	52.36	53.75	51.76	53.48	174.0
2009-09-14	DC	Futures	22.97	23.52	22.97	23.48	142.0
2009-09-14	DX	Futures	78.511	78.966	78.384	78.573	5573.0
2009-09-14	E1	Futures	1.27625	1.28008	1.26806	1.27705	33185.0
2009-09-14	E6	Futures	1.72984	1.73647	1.72012	1.73185	214700.0
2009-09-14	E7	Futures	1.7126	1.7198	1.7036	1.7153	2242.0
2009-09-14	ED	Futures	94.1292	94.134	94.0962	94.1151	164718.0
2009-09-14	ER	Futures	97.208	97.208	97.184	97.188	136509.0
2009-09-14	EW	Futures	654.7	664.1	647.9	661.9	41789.0
2009-09-14	FCE	Futures	2445.8	2472.2	2425.3	2462.6	92814.0
2009-09-14	FDAX	Futures	6111.2	6191.9	6069.5	6163.9	154670.0
2009-09-14	FESX	Futures	1662.9	1689.8	1654.5	1680.8	637660.0
2009-09-14	FEU3	Futures	97.776	97.776	97.761	97.761	4331.0
2009-09-14	FGBL	Futures	93.7	93.72	93.48	93.54	501465.0
2009-09-14	FGBM	Futures	99.16	99.16	98.93	98.97	308251.0
2009-09-14	FGBS	Futures	104.774	104.779	104.687	104.697	315489.0
2009-09-14	FGBX	Futures	86.64	86.69	86.34	86.44	1428.0
2009-09-14	FTDX	Futures	654.9	657.6	646.0	653.1	316.0
2009-09-14	FTI	Futures	251.98	253.83	249.8	252.55	14080.0
2009-09-14	FTUK	Futures	3279.6	3320.7	3264.6	3307.4	137541.0
2009-09-14	G	Futures	76.63	76.86	76.59	76.72	48229.0
2009-09-14	GF	Futures	272.729	273.486	271.352	272.385	2165.0
2009-09-14	GSCI	Futures	902.54	910.75	896.54	904.05	2747.0
2009-09-14	HE	Futures	78.321	78.396	76.11	76.373	18473.0
2009-09-14	HG	Futures	3.9506	3.9506	3.8496	3.9081	20794.0
2009-09-14	HO	Futures	1.7491	1.7589	1.7301	1.7559	12775.0
2009-09-14	HRC	Futures	2738.7	2738.7	2738.7	2738.7	0.0
2009-09-14	J1	Futures	0.0138915	0.0139267	0.0137861	0.0138162	83519.0
2009-09-14	J7	Futures	0.013713	0.013738	0.013609	0.013636	42.0
2009-09-14	JB	Futures	117.35	117.54	117.34	117.47	1068.0
2009-09-14	KC	Futures	331.68	353.46	330.23	351.34	15088.0
2009-09-14	KE	Futures	2219.5	2222.99	2163.66	2175.3	6429.0
2009-09-14	L	Futures	97.76	97.76	97.73	97.74	31780.0
2009-09-14	LBS	Futures	713.7	728.7	708.4	724.2	356.0
2009-09-14	LE	Futures	145.223	145.683	144.512	145.097	20209.0
2009-09-14	MFS	Futures	1226.7	1242.9	1226.7	1241.8	509.0

> showing 50 of 86 rows — these rows as CSV

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