PREVIEW / futures_daily / 2009-10-29

all futures daily files

  file:    by_date/futures_daily/2009/2009-10-29.parquet
  size:    9 KB
  rows:    89

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-10-29	ES	Futures	1001.91	1026.26	1000.46	1023.85	2298367.0
2009-10-29	NQ	Futures	1897.3	1933.71	1893.35	1927.5	297972.0
2009-10-29	YM	Futures	8818.1	9007.8	8808.1	8990.6	165755.0
2009-10-29	CL	Futures	188.95	197.16	188.75	195.71	360575.0
2009-10-29	GC	Futures	1420.7	1449.3	1419.6	1447.5	130081.0
2009-10-29	ZN	Futures	94.239426	94.37642	93.616726	93.828444	1096483.0
2009-10-29	A6	Futures	0.72287	0.73904	0.71956	0.73839	110478.0
2009-10-29	AD	Futures	0.91294	0.92537	0.91107	0.92478	79171.0
2009-10-29	B	Futures	70.93	73.75	70.88	73.21	58393.0
2009-10-29	B6	Futures	1.704	1.7274	1.6995	1.7214	153815.0
2009-10-29	BFX	Futures	2675.5	2771.3	2674.8	2765.6	199.0
2009-10-29	BR	Futures	0.22663	0.22857	0.22663	0.22834	16.0
2009-10-29	BZ	Futures	77.98	77.98	77.95	77.95	1.0
2009-10-29	C	Futures	2226.0	2243.0	2205.0	2231.0	3155.0
2009-10-29	CB	Futures	73.424	73.962	73.424	73.962	3.0
2009-10-29	CC	Futures	2922.0	2954.0	2878.0	2944.0	7407.0
2009-10-29	CT	Futures	57.69	58.98	57.34	58.31	13186.0
2009-10-29	DC	Futures	24.59	25.19	24.51	25.12	346.0
2009-10-29	DX	Futures	78.226	78.343	77.588	77.659	19205.0
2009-10-29	E1	Futures	1.28722	1.2995	1.28431	1.29805	62500.0
2009-10-29	E6	Futures	1.74441	1.76089	1.73991	1.75923	312544.0
2009-10-29	E7	Futures	1.7266	1.7439	1.7235	1.7424	4245.0
2009-10-29	ED	Futures	94.2332	94.238	94.219	94.2285	126333.0
2009-10-29	ER	Futures	97.144	97.149	97.115	97.125	122619.0
2009-10-29	EW	Futures	643.1	658.0	640.9	654.1	46197.0
2009-10-29	FBTP	Futures	62.64	62.64	62.27	62.33	7376.0
2009-10-29	FCE	Futures	2396.2	2458.9	2393.5	2445.1	129996.0
2009-10-29	FDAX	Futures	5947.0	6110.2	5943.7	6085.7	171675.0
2009-10-29	FESX	Futures	1640.8	1690.4	1639.6	1681.4	1457989.0
2009-10-29	FEU3	Futures	97.712	97.712	97.697	97.697	196.0
2009-10-29	FGBL	Futures	93.87	93.88	93.23	93.41	912089.0
2009-10-29	FGBM	Futures	99.24	99.24	98.77	98.86	534278.0
2009-10-29	FGBS	Futures	104.765	104.765	104.585	104.61	626575.0
2009-10-29	FGBX	Futures	86.89	86.96	86.27	86.44	2188.0
2009-10-29	FTDX	Futures	632.7	657.6	626.9	651.4	1259.0
2009-10-29	FTI	Futures	245.84	253.66	245.64	252.51	42732.0
2009-10-29	FTUK	Futures	3335.0	3410.6	3327.7	3391.7	113333.0
2009-10-29	G	Futures	77.04	77.11	76.54	76.69	71599.0
2009-10-29	GF	Futures	262.883	263.846	259.925	260.269	1334.0
2009-10-29	GSCI	Futures	993.7	1011.11	990.55	1009.44	250.0
2009-10-29	HE	Futures	85.367	87.844	85.062	87.196	21890.0
2009-10-29	HG	Futures	4.0733	4.2356	4.0663	4.2217	28594.0
2009-10-29	HO	Futures	1.9544	2.0319	1.951	2.0137	45821.0
2009-10-29	HRC	Futures	2713.1	2713.1	2713.1	2713.1	0.0
2009-10-29	J1	Futures	0.0138488	0.0139179	0.0137069	0.013722	119513.0
2009-10-29	J7	Futures	0.013674	0.013734	0.013532	0.013543	60.0
2009-10-29	JB	Futures	116.19	116.55	116.19	116.46	2835.0
2009-10-29	KC	Futures	355.04	363.09	352.53	360.98	10849.0
2009-10-29	KE	Futures	2339.32	2397.48	2338.15	2363.75	10736.0
2009-10-29	L	Futures	97.799	97.809	97.77	97.779	59012.0

> showing 50 of 89 rows — these rows as CSV

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