PREVIEW / futures_daily / 2009-04-07

all futures daily files

  file:    by_date/futures_daily/2009/2009-04-07.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-07	ES	Futures	792.02	794.64	772.72	775.82	2101777.0
2009-04-07	NQ	Futures	1474.05	1479.94	1423.21	1438.94	308263.0
2009-04-07	YM	Futures	7102.3	7124.8	6916.7	6962.4	150712.0
2009-04-07	CL	Futures	144.27	145.48	135.88	137.98	254031.0
2009-04-07	GC	Futures	1204.8	1228.0	1204.8	1223.0	68272.0
2009-04-07	ZN	Futures	94.742836	95.094814	94.706424	94.912756	415202.0
2009-04-07	A6	Futures	0.56592	0.56934	0.55874	0.56488	47616.0
2009-04-07	AD	Futures	0.79523	0.79897	0.78873	0.79592	34875.0
2009-04-07	B	Futures	51.81	52.53	50.12	50.69	91284.0
2009-04-07	B6	Futures	1.5341	1.5377	1.5172	1.5324	67552.0
2009-04-07	BFX	Futures	1981.6	1981.6	1929.1	1931.4	437.0
2009-04-07	BZ	Futures	53.58	54.03	53.5	53.5	5.0
2009-04-07	C	Futures	1838.0	1932.0	1826.0	1926.0	8918.0
2009-04-07	CB	Futures	76.436	77.339	76.436	76.436	14.0
2009-04-07	CC	Futures	2267.0	2372.0	2226.0	2362.0	10360.0
2009-04-07	CT	Futures	44.53	44.95	43.91	44.41	8469.0
2009-04-07	DC	Futures	28.63	28.63	27.72	27.81	380.0
2009-04-07	DX	Futures	87.915	88.394	87.545	88.214	5156.0
2009-04-07	E1	Futures	1.16815	1.17014	1.15621	1.16059	24724.0
2009-04-07	E6	Futures	1.58892	1.5894	1.56758	1.57102	140019.0
2009-04-07	E7	Futures	1.5711	1.5711	1.5499	1.5528	1492.0
2009-04-07	EBM	Futures	212.85	215.18	210.92	214.79	4245.0
2009-04-07	ED	Futures	93.2095	93.2519	93.2095	93.2283	152284.0
2009-04-07	ER	Futures	96.664	96.704	96.66	96.699	95577.0
2009-04-07	EW	Futures	499.7	500.8	481.3	484.4	24550.0
2009-04-07	FCE	Futures	1866.6	1873.6	1824.1	1842.2	124598.0
2009-04-07	FDAX	Futures	4783.4	4789.9	4666.3	4714.8	129993.0
2009-04-07	FESX	Futures	1270.9	1273.3	1236.7	1253.5	1037746.0
2009-04-07	FEU3	Futures	97.249	97.283	97.249	97.278	99.0
2009-04-07	FGBL	Futures	92.26	92.42	92.09	92.18	454817.0
2009-04-07	FGBM	Futures	97.28	97.51	97.22	97.35	307820.0
2009-04-07	FGBS	Futures	103.407	103.522	103.378	103.474	348505.0
2009-04-07	FGBX	Futures	81.91	82.13	81.65	81.77	1848.0
2009-04-07	FTDX	Futures	465.8	466.7	449.7	454.2	314.0
2009-04-07	FTI	Futures	188.06	188.93	183.99	186.17	36162.0
2009-04-07	FTUK	Futures	2652.8	2661.1	2566.2	2587.5	130078.0
2009-04-07	G	Futures	76.5	76.74	76.45	76.63	61515.0
2009-04-07	GF	Futures	268.347	269.254	267.788	268.696	259.0
2009-04-07	GSCI	Futures	776.18	777.88	765.55	767.67	230.0
2009-04-07	HE	Futures	119.647	120.884	119.647	120.843	373.0
2009-04-07	HG	Futures	2.7613	2.8346	2.7282	2.8036	16924.0
2009-04-07	HO	Futures	1.5765	1.5882	1.5351	1.5443	18373.0
2009-04-07	HRC	Futures	2595.1	2595.1	2595.1	2595.1	0.0
2009-04-07	J1	Futures	0.0124791	0.0126329	0.0124791	0.0125585	62525.0
2009-04-07	J7	Futures	0.012332	0.012458	0.012332	0.012388	77.0
2009-04-07	JB	Futures	114.6	114.92	114.55	114.91	1201.0
2009-04-07	KC	Futures	329.68	332.91	326.44	330.52	10152.0
2009-04-07	KE	Futures	2980.2	3029.5	2903.79	2908.72	9674.0
2009-04-07	L	Futures	96.885	96.944	96.875	96.944	35005.0
2009-04-07	LBS	Futures	952.0	959.7	942.1	953.5	162.0

> showing 50 of 86 rows — these rows as CSV

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