PREVIEW / futures_daily / 2009-04-09

all futures daily files

  file:    by_date/futures_daily/2009/2009-04-09.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-04-09	ES	Futures	784.63	814.42	783.68	812.51	2081575.0
2009-04-09	NQ	Futures	1459.16	1506.91	1457.47	1501.01	268598.0
2009-04-09	YM	Futures	6987.5	7209.1	6984.8	7191.1	156916.0
2009-04-09	CL	Futures	140.25	147.25	139.58	146.66	294835.0
2009-04-09	GC	Futures	1222.1	1229.3	1212.9	1223.0	53689.0
2009-04-09	ZN	Futures	95.276872	95.349695	94.706424	95.021991	505952.0
2009-04-09	A6	Futures	0.56384	0.57222	0.56001	0.56958	45085.0
2009-04-09	AD	Futures	0.79622	0.80675	0.79434	0.80232	43160.0
2009-04-09	B	Futures	51.56	53.36	51.18	53.14	101772.0
2009-04-09	B6	Futures	1.5297	1.5378	1.5175	1.5224	65049.0
2009-04-09	BFX	Futures	1957.9	1981.7	1957.9	1973.1	77.0
2009-04-09	BZ	Futures	55.59	56.09	55.59	56.09	5.0
2009-04-09	C	Futures	1863.0	1907.0	1863.0	1885.0	3342.0
2009-04-09	CB	Futures	76.737	77.038	76.737	77.038	17.0
2009-04-09	CC	Futures	2251.0	2312.0	2244.0	2264.0	9137.0
2009-04-09	CT	Futures	45.93	47.09	45.35	45.67	16068.0
2009-04-09	DC	Futures	27.93	28.63	27.79	27.98	242.0
2009-04-09	DX	Futures	88.163	88.806	87.797	88.636	4984.0
2009-04-09	E1	Futures	1.15674	1.16152	1.14348	1.1468	34210.0
2009-04-09	E6	Futures	1.57209	1.58086	1.55549	1.5581	154697.0
2009-04-09	E7	Futures	1.5541	1.5623	1.5376	1.54	1656.0
2009-04-09	EBM	Futures	210.53	213.24	210.14	210.53	3742.0
2009-04-09	ED	Futures	93.2519	93.266	93.233	93.2425	119159.0
2009-04-09	ER	Futures	96.699	96.709	96.674	96.694	88530.0
2009-04-09	EW	Futures	489.2	518.9	489.2	515.5	29550.0
2009-04-09	FCE	Futures	1840.6	1871.0	1821.5	1852.3	99595.0
2009-04-09	FDAX	Futures	4810.6	4922.8	4776.8	4892.8	146123.0
2009-04-09	FESX	Futures	1284.1	1315.9	1273.3	1303.3	1056661.0
2009-04-09	FEU3	Futures	97.283	97.283	97.273	97.273	120.0
2009-04-09	FGBL	Futures	92.05	92.29	91.78	91.93	518132.0
2009-04-09	FGBM	Futures	97.31	97.6	97.23	97.4	311569.0
2009-04-09	FGBS	Futures	103.503	103.685	103.493	103.608	346299.0
2009-04-09	FGBX	Futures	81.84	82.49	81.4	81.76	1517.0
2009-04-09	FTDX	Futures	467.6	482.0	467.6	480.2	1104.0
2009-04-09	FTI	Futures	188.48	190.49	186.5	190.29	459.0
2009-04-09	FTUK	Futures	2610.8	2642.8	2571.9	2616.5	102092.0
2009-04-09	G	Futures	77.0	77.73	77.0	77.56	49820.0
2009-04-09	GF	Futures	270.86	274.42	270.86	274.071	386.0
2009-04-09	GSCI	Futures	788.94	798.72	782.56	793.19	600.0
2009-04-09	HE	Futures	120.059	121.297	119.317	121.214	577.0
2009-04-09	HG	Futures	2.8135	2.9304	2.7973	2.9177	19828.0
2009-04-09	HO	Futures	1.5465	1.612	1.5465	1.5861	16047.0
2009-04-09	HRC	Futures	2619.0	2619.0	2619.0	2619.0	0.0
2009-04-09	J1	Futures	0.0126417	0.0126606	0.0125422	0.0125573	51001.0
2009-04-09	J7	Futures	0.012485	0.012486	0.012374	0.012387	32.0
2009-04-09	JB	Futures	114.46	114.59	114.27	114.44	2193.0
2009-04-09	KC	Futures	333.2	337.56	332.63	335.59	12894.0
2009-04-09	KE	Futures	2859.42	2918.58	2811.35	2812.58	9891.0
2009-04-09	L	Futures	96.944	96.983	96.934	96.964	31718.0
2009-04-09	LBS	Futures	958.2	979.9	958.2	959.2	352.0

> showing 50 of 86 rows — these rows as CSV

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