PREVIEW / futures_daily / 2009-06-19

all futures daily files

  file:    by_date/futures_daily/2009/2009-06-19.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-06-19	ES	Futures	875.25	885.56	873.81	878.61	1623895.0
2009-06-19	NQ	Futures	1629.28	1663.06	1628.15	1648.7	280991.0
2009-06-19	YM	Futures	7664.6	7728.7	7612.3	7647.5	109665.0
2009-06-19	CL	Futures	189.13	191.68	182.6	184.23	271060.0
2009-06-19	GC	Futures	1293.1	1301.0	1289.6	1296.1	57557.0
2009-06-19	ZN	Futures	89.857693	90.251698	89.512939	90.128571	612918.0
2009-06-19	A6	Futures	0.63872	0.64837	0.6376	0.6437	55851.0
2009-06-19	AD	Futures	0.87245	0.87837	0.86948	0.87106	44553.0
2009-06-19	B	Futures	68.27	68.83	65.65	66.18	99813.0
2009-06-19	B6	Futures	1.7017	1.7249	1.6979	1.7199	93196.0
2009-06-19	BFX	Futures	2267.0	2300.1	2255.7	2282.5	202.0
2009-06-19	BR	Futures	0.19529	0.19543	0.19529	0.19529	1.0
2009-06-19	BZ	Futures	74.54	74.58	72.06	72.22	36.0
2009-06-19	C	Futures	1755.0	1758.0	1692.0	1696.0	5173.0
2009-06-19	CB	Futures	73.184	73.326	72.616	72.616	4.0
2009-06-19	CC	Futures	2262.0	2282.0	2235.0	2241.0	5070.0
2009-06-19	CT	Futures	49.8	49.8	47.68	47.7	4740.0
2009-06-19	DC	Futures	20.83	20.83	20.21	20.45	304.0
2009-06-19	DX	Futures	82.855	83.035	82.2	82.528	5027.0
2009-06-19	E1	Futures	1.22107	1.23113	1.2167	1.22742	36357.0
2009-06-19	E6	Futures	1.64959	1.66277	1.6471	1.65577	154115.0
2009-06-19	E7	Futures	1.6284	1.6457	1.6284	1.6388	2069.0
2009-06-19	ED	Futures	93.6544	93.6969	93.645	93.6828	213879.0
2009-06-19	ER	Futures	96.797	96.826	96.797	96.826	114050.0
2009-06-19	EW	Futures	554.1	562.8	553.0	556.8	26895.0
2009-06-19	FCE	Futures	2081.6	2113.9	2074.8	2099.6	141854.0
2009-06-19	FDAX	Futures	5311.4	5358.6	5288.4	5333.3	127282.0
2009-06-19	FESX	Futures	1435.0	1455.9	1430.8	1450.5	1161180.0
2009-06-19	FEU3	Futures	97.387	97.401	97.382	97.401	2811.0
2009-06-19	FGBL	Futures	90.63	91.1	90.28	90.97	616934.0
2009-06-19	FGBM	Futures	96.96	97.33	96.7	97.27	333989.0
2009-06-19	FGBS	Futures	103.589	103.777	103.531	103.743	430438.0
2009-06-19	FGBX	Futures	80.75	81.68	80.42	81.57	2242.0
2009-06-19	FTDX	Futures	545.2	552.3	540.7	549.6	877.0
2009-06-19	FTI	Futures	206.55	209.56	205.74	208.87	32783.0
2009-06-19	FTUK	Futures	2827.5	2882.6	2817.9	2865.0	142169.0
2009-06-19	G	Futures	74.62	75.09	74.44	75.0	67233.0
2009-06-19	GF	Futures	269.36	270.807	268.877	270.393	747.0
2009-06-19	GSCI	Futures	978.44	978.54	946.1	949.54	381.0
2009-06-19	HE	Futures	87.838	90.799	87.582	89.812	4439.0
2009-06-19	HG	Futures	3.1909	3.2365	3.1375	3.1754	9368.0
2009-06-19	HO	Futures	1.941	1.9543	1.8768	1.889	5309.0
2009-06-19	HRC	Futures	2328.7	2328.7	2328.7	2328.7	0.0
2009-06-19	J1	Futures	0.013055	0.013128	0.0129656	0.0130952	63476.0
2009-06-19	J7	Futures	0.012874	0.012938	0.012791	0.012915	35.0
2009-06-19	JB	Futures	115.13	115.34	115.0	115.34	1532.0
2009-06-19	KC	Futures	333.75	334.29	322.62	324.79	10964.0
2009-06-19	KE	Futures	3019.32	3047.35	2988.84	2997.38	8298.0
2009-06-19	L	Futures	96.954	97.003	96.944	96.984	54048.0
2009-06-19	LBS	Futures	972.0	984.3	956.5	979.3	150.0

> showing 50 of 86 rows — these rows as CSV

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