PREVIEW / futures_daily / 2009-07-23

all futures daily files

  file:    by_date/futures_daily/2009/2009-07-23.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-07-23	ES	Futures	911.71	936.89	910.27	929.7	2299971.0
2009-07-23	NQ	Futures	1754.28	1806.08	1751.18	1783.84	354201.0
2009-07-23	YM	Futures	7973.2	8169.9	7965.1	8112.1	141006.0
2009-07-23	CL	Futures	168.38	173.76	165.81	172.91	321627.0
2009-07-23	GC	Futures	1319.0	1325.6	1311.4	1321.9	124922.0
2009-07-23	ZN	Futures	92.431036	92.578788	91.384461	91.433712	959039.0
2009-07-23	A6	Futures	0.65311	0.65833	0.64917	0.65391	74022.0
2009-07-23	AD	Futures	0.89773	0.91146	0.89714	0.91018	66323.0
2009-07-23	B	Futures	63.66	66.43	63.5	65.92	133461.0
2009-07-23	B6	Futures	1.7145	1.7274	1.7116	1.7204	103980.0
2009-07-23	BFX	Futures	2420.8	2443.6	2403.8	2438.5	68.0
2009-07-23	BR	Futures	0.20478	0.20478	0.20478	0.20478	68.0
2009-07-23	BZ	Futures	69.09	70.77	69.09	70.34	32.0
2009-07-23	C	Futures	1861.0	1934.0	1851.0	1920.0	3712.0
2009-07-23	CB	Futures	75.316	75.6	74.179	75.6	20.0
2009-07-23	CC	Futures	2465.0	2599.0	2465.0	2564.0	8888.0
2009-07-23	CT	Futures	52.22	53.08	51.79	52.63	217.0
2009-07-23	DC	Futures	20.92	21.34	20.58	21.31	174.0
2009-07-23	DX	Futures	80.849	81.187	80.435	80.829	6146.0
2009-07-23	E1	Futures	1.24185	1.24569	1.2298	1.23576	45038.0
2009-07-23	E6	Futures	1.68663	1.69684	1.67607	1.68616	236743.0
2009-07-23	E7	Futures	1.6693	1.6794	1.6587	1.6689	2410.0
2009-07-23	ED	Futures	93.9236	93.9283	93.9047	93.9094	121513.0
2009-07-23	ER	Futures	97.066	97.081	97.056	97.066	92376.0
2009-07-23	EW	Futures	577.9	598.3	576.5	593.0	29403.0
2009-07-23	FCE	Futures	2170.4	2219.5	2150.7	2211.3	126603.0
2009-07-23	FDAX	Futures	5636.2	5783.2	5597.8	5759.1	154139.0
2009-07-23	FESX	Futures	1512.0	1551.3	1502.4	1541.8	1121314.0
2009-07-23	FEU3	Futures	97.633	97.653	97.633	97.643	67.0
2009-07-23	FGBL	Futures	92.05	92.22	91.51	91.63	833322.0
2009-07-23	FGBM	Futures	98.09	98.25	97.78	97.86	427604.0
2009-07-23	FGBS	Futures	104.138	104.205	104.051	104.094	548286.0
2009-07-23	FGBX	Futures	83.1	83.59	82.82	83.01	1235.0
2009-07-23	FTDX	Futures	600.5	606.7	590.7	596.9	741.0
2009-07-23	FTI	Futures	222.18	226.2	220.04	225.87	27498.0
2009-07-23	FTUK	Futures	2964.3	3018.7	2947.3	3007.7	108969.0
2009-07-23	G	Futures	74.74	74.86	74.16	74.21	114467.0
2009-07-23	GF	Futures	284.037	284.175	281.97	282.177	1126.0
2009-07-23	GSCI	Futures	910.95	933.2	905.31	926.83	259.0
2009-07-23	HE	Futures	88.85	89.174	86.295	87.734	10053.0
2009-07-23	HG	Futures	3.5307	3.5644	3.4717	3.544	22442.0
2009-07-23	HO	Futures	1.7665	1.8265	1.7503	1.8156	39471.0
2009-07-23	HRC	Futures	2409.0	2409.0	2409.0	2409.0	0.0
2009-07-23	J1	Futures	0.0134553	0.0134654	0.0132148	0.0132375	119502.0
2009-07-23	J7	Futures	0.01329	0.01329	0.013032	0.013055	164.0
2009-07-23	JB	Futures	116.36	116.46	116.21	116.37	1082.0
2009-07-23	KC	Futures	326.97	340.4	324.66	337.95	12617.0
2009-07-23	KE	Futures	2660.78	2737.52	2654.78	2693.15	6317.0
2009-07-23	L	Futures	97.337	97.357	97.298	97.337	29123.0
2009-07-23	LBS	Futures	740.8	777.4	740.8	777.4	491.0

> showing 50 of 86 rows — these rows as CSV

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