PREVIEW / futures_daily / 2009-01-20

all futures daily files

  file:    by_date/futures_daily/2009/2009-01-20.parquet
  size:    9 KB
  rows:    87

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-01-20	ES	Futures	804.3	817.52	753.07	761.1	2841680.0
2009-01-20	NQ	Futures	1340.47	1366.46	1265.56	1282.89	326088.0
2009-01-20	YM	Futures	7362.6	7472.2	7008.3	7074.2	234352.0
2009-01-20	CL	Futures	140.95	145.47	129.93	135.67	354707.0
2009-01-20	GC	Futures	1176.9	1208.2	1148.3	1192.3	169398.0
2009-01-20	ZN	Futures	96.256238	96.710446	95.240247	96.590918	692677.0
2009-01-20	A6	Futures	0.53392	0.54018	0.51052	0.51163	43670.0
2009-01-20	AD	Futures	0.78965	0.79368	0.77314	0.77609	37012.0
2009-01-20	B	Futures	46.02	47.09	44.33	45.01	135781.0
2009-01-20	B6	Futures	1.5387	1.5474	1.4384	1.4451	130223.0
2009-01-20	BFX	Futures	2021.8	2027.5	1969.3	1973.1	295.0
2009-01-20	BR	Futures	0.15707	0.15707	0.1525	0.1525	9.0
2009-01-20	BZ	Futures	45.84	47.24	44.75	45.19	216.0
2009-01-20	C	Futures	1786.0	1876.0	1780.0	1857.0	12968.0
2009-01-20	CB	Futures	76.672	76.672	76.672	76.672	4.0
2009-01-20	CC	Futures	2117.0	2195.0	2065.0	2179.0	8482.0
2009-01-20	CT	Futures	47.94	47.94	45.52	45.56	10771.0
2009-01-20	DC	Futures	26.43	26.97	25.92	26.11	103.0
2009-01-20	DX	Futures	89.233	90.301	89.103	90.073	4348.0
2009-01-20	E1	Futures	1.19199	1.19571	1.15464	1.15956	44811.0
2009-01-20	E6	Futures	1.57696	1.58217	1.51978	1.52416	240813.0
2009-01-20	E7	Futures	1.5569	1.5638	1.5023	1.5067	5000.0
2009-01-20	EBM	Futures	230.09	233.16	227.79	227.79	1712.0
2009-01-20	ED	Futures	93.2555	93.3073	93.2414	93.2697	193260.0
2009-01-20	ER	Futures	96.165	96.263	96.165	96.228	150184.0
2009-01-20	EW	Futures	506.6	513.0	469.8	474.2	32760.0
2009-01-20	FCE	Futures	1855.2	1878.0	1765.2	1809.1	132697.0
2009-01-20	FDAX	Futures	4727.5	4796.9	4561.0	4629.8	190722.0
2009-01-20	FESX	Futures	1300.2	1315.1	1241.0	1264.0	1387632.0
2009-01-20	FEU3	Futures	96.751	96.8	96.751	96.795	1589.0
2009-01-20	FGBL	Futures	93.65	93.83	93.05	93.36	765020.0
2009-01-20	FGBM	Futures	97.98	98.09	97.63	97.84	363602.0
2009-01-20	FGBS	Futures	103.532	103.628	103.445	103.517	364257.0
2009-01-20	FGBX	Futures	84.83	85.19	84.27	84.53	1078.0
2009-01-20	FTDX	Futures	417.0	426.9	411.7	416.1	275.0
2009-01-20	FTI	Futures	197.29	198.42	191.89	193.18	33149.0
2009-01-20	FTUK	Futures	2665.9	2722.3	2596.8	2643.6	151991.0
2009-01-20	G	Futures	74.9	74.91	73.96	74.48	98296.0
2009-01-20	GF	Futures	264.203	264.203	256.979	257.4	561.0
2009-01-20	GSCI	Futures	777.47	804.45	769.27	775.13	301.0
2009-01-20	HE	Futures	127.874	128.502	126.183	127.004	5475.0
2009-01-20	HG	Futures	2.1527	2.2168	2.0619	2.1175	14072.0
2009-01-20	HO	Futures	1.6283	1.6364	1.5203	1.5261	35739.0
2009-01-20	HRC	Futures	3189.6	3189.6	3189.6	3189.6	0.0
2009-01-20	J1	Futures	0.0139083	0.0141117	0.0138489	0.0140713	115810.0
2009-01-20	J7	Futures	0.013742	0.013943	0.013712	0.013902	110.0
2009-01-20	JB	Futures	116.89	117.04	116.7	116.96	4.0
2009-01-20	KC	Futures	329.1	332.53	325.53	328.39	5587.0
2009-01-20	KE	Futures	3037.87	3082.84	2895.47	2896.72	8904.0
2009-01-20	L	Futures	96.984	97.073	96.969	97.038	83911.0

> showing 50 of 87 rows — these rows as CSV

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