PREVIEW / futures_daily / 2009-05-01

all futures daily files

  file:    by_date/futures_daily/2009/2009-05-01.parquet
  size:    8 KB
  rows:    74

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-05-01	ES	Futures	825.38	837.05	822.04	834.91	1802797.0
2009-05-01	NQ	Futures	1560.28	1576.0	1551.57	1571.23	231095.0
2009-05-01	YM	Futures	7253.0	7348.1	7218.1	7338.2	121207.0
2009-05-01	CL	Futures	137.23	144.5	135.83	143.29	248750.0
2009-05-01	GC	Futures	1230.8	1233.4	1219.2	1229.8	46712.0
2009-05-01	ZN	Futures	93.990331	94.075291	93.565529	93.796136	382000.0
2009-05-01	A6	Futures	0.57692	0.58418	0.5758	0.58091	24892.0
2009-05-01	AD	Futures	0.82477	0.83245	0.82378	0.83205	38285.0
2009-05-01	B	Futures	49.77	52.13	49.17	51.95	52617.0
2009-05-01	B6	Futures	1.5382	1.5538	1.5352	1.5526	54208.0
2009-05-01	BR	Futures	0.17431	0.17431	0.17431	0.17431	4.0
2009-05-01	BZ	Futures	55.43	56.3	55.43	56.3	2.0
2009-05-01	C	Futures	1815.0	1815.0	1770.0	1770.0	971.0
2009-05-01	CB	Futures	76.285	76.285	76.285	76.285	11.0
2009-05-01	CC	Futures	2088.0	2113.0	2029.0	2050.0	10140.0
2009-05-01	CT	Futures	50.29	52.96	50.01	52.92	9739.0
2009-05-01	DC	Futures	25.73	25.75	25.46	25.51	213.0
2009-05-01	DX	Futures	87.426	87.493	86.942	87.226	1958.0
2009-05-01	E1	Futures	1.16298	1.17053	1.16244	1.16881	16026.0
2009-05-01	E6	Futures	1.56747	1.58003	1.56664	1.57256	69545.0
2009-05-01	E7	Futures	1.5495	1.5615	1.5486	1.5543	1103.0
2009-05-01	ED	Futures	93.3744	93.3886	93.3556	93.365	114953.0
2009-05-01	ER	Futures	96.713	96.713	96.699	96.713	18714.0
2009-05-01	EW	Futures	532.0	543.8	530.4	538.9	54234.0
2009-05-01	FTUK	Futures	2796.6	2805.9	2775.9	2792.3	35134.0
2009-05-01	G	Futures	76.75	76.92	76.21	76.33	28787.0
2009-05-01	GF	Futures	273.862	275.258	271.977	272.116	509.0
2009-05-01	GSCI	Futures	783.62	808.5	780.43	805.1	723.0
2009-05-01	HE	Futures	95.882	99.59	95.732	98.242	9572.0
2009-05-01	HG	Futures	2.8722	2.9827	2.8666	2.9559	10375.0
2009-05-01	HO	Futures	1.4585	1.5255	1.4401	1.5148	38150.0
2009-05-01	HRC	Futures	2595.1	2595.1	2595.1	2595.1	0.0
2009-05-01	J1	Futures	0.0127942	0.0128005	0.0126619	0.0126896	45761.0
2009-05-01	J7	Futures	0.012593	0.012603	0.012494	0.012517	47.0
2009-05-01	JB	Futures	114.64	115.19	114.63	115.15	3479.0
2009-05-01	KC	Futures	320.59	334.58	320.45	333.61	13234.0
2009-05-01	KE	Futures	2854.76	3035.16	2853.54	2997.38	13169.0
2009-05-01	L	Futures	96.983	97.003	96.944	96.954	25337.0
2009-05-01	LBS	Futures	829.1	832.3	817.7	828.6	173.0
2009-05-01	LE	Futures	144.946	146.183	144.813	145.123	6205.0
2009-05-01	MP	Futures	0.03697	0.03721	0.03688	0.03698	3648.0
2009-05-01	N6	Futures	0.44989	0.45634	0.44734	0.45292	898.0
2009-05-01	NG	Futures	205.383	217.368	203.446	214.644	69215.0
2009-05-01	NIY	Futures	7361.8	7386.1	7054.0	7378.0	8481.0
2009-05-01	NKD	Futures	8555.6	8800.7	8555.6	8795.9	6090.0
2009-05-01	NOK	Futures	0.150717	0.150717	0.14986	0.150422	5.0
2009-05-01	OJ	Futures	60.7	62.04	60.7	61.32	1183.0
2009-05-01	PA	Futures	251.82	251.82	240.89	246.18	858.0
2009-05-01	PJY	Futures	122.78	122.78	122.78	122.78	0.0
2009-05-01	PL	Futures	1284.5	1294.1	1249.0	1273.9	1680.0

> showing 50 of 74 rows — these rows as CSV

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