PREVIEW / futures_daily / 2011-04-18

all futures daily files

  file:    by_date/futures_daily/2011/2011-04-18.parquet
  size:    9 KB
  rows:    95

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
2011-04-18	ES	Futures	1305.08	1305.58	1277.36	1288.0	2255340.0
2011-04-18	NQ	Futures	2628.55	2630.83	2562.78	2608.05	376034.0
2011-04-18	YM	Futures	11563.2	11566.0	11316.0	11413.7	146758.0
2011-04-18	CL	Futures	212.08	212.09	206.39	207.53	288280.0
2011-04-18	GC	Futures	2014.0	2028.4	2000.2	2020.7	199123.0
2011-04-18	ZN	Futures	100.960746	101.342624	100.723718	101.289951	1452206.0
2011-04-18	A6	Futures	0.89876	0.90039	0.89018	0.8955	118116.0
2011-04-18	AD	Futures	1.03645	1.03695	1.02281	1.03107	97236.0
2011-04-18	B	Futures	104.46	104.89	102.64	103.15	153145.0
2011-04-18	B6	Futures	1.6945	1.6952	1.6781	1.6872	157132.0
2011-04-18	BFX	Futures	3154.3	3156.4	3089.7	3092.0	175.0
2011-04-18	BR	Futures	0.27718	0.27718	0.27432	0.27533	280.0
2011-04-18	BZ	Futures	109.73	109.73	108.24	108.76	825.0
2011-04-18	C	Futures	2179.0	2199.0	2125.0	2128.0	2433.0
2011-04-18	CB	Futures	117.922	118.509	117.922	118.509	22.0
2011-04-18	CC	Futures	2513.0	2527.0	2409.0	2434.0	9987.0
2011-04-18	CSC	Futures	4.405	4.405	4.405	4.405	1.0
2011-04-18	CT	Futures	174.84	177.03	171.69	175.67	11327.0
2011-04-18	DC	Futures	30.24	30.24	29.08	29.22	145.0
2011-04-18	DX	Futures	74.71	75.675	74.68	75.352	39052.0
2011-04-18	E1	Futures	1.46744	1.47084	1.455	1.46063	55402.0
2011-04-18	E6	Futures	1.70555	1.70591	1.67452	1.68376	408656.0
2011-04-18	E7	Futures	1.6934	1.6934	1.6619	1.6712	6483.0
2011-04-18	EBM	Futures	223.57	232.03	223.34	231.09	9243.0
2011-04-18	ED	Futures	94.9359	94.9406	94.9026	94.9264	251990.0
2011-04-18	ER	Futures	97.247	97.277	97.232	97.257	162815.0
2011-04-18	EW	Futures	976.3	976.4	950.5	961.6	34903.0
2011-04-18	FBTP	Futures	64.48	64.48	64.08	64.24	10369.0
2011-04-18	FCE	Futures	2661.3	2661.3	2582.6	2594.2	169591.0
2011-04-18	FDAX	Futures	7686.3	7690.0	7484.4	7524.5	174516.0
2011-04-18	FESX	Futures	1824.1	1824.8	1767.7	1778.6	2159248.0
2011-04-18	FEU3	Futures	97.785	97.8	97.785	97.8	25.0
2011-04-18	FGBL	Futures	97.01	98.1	96.92	97.98	1280268.0
2011-04-18	FGBM	Futures	102.54	103.22	102.45	103.15	710914.0
2011-04-18	FGBS	Futures	106.191	106.419	106.152	106.409	831589.0
2011-04-18	FGBX	Futures	92.45	94.27	92.34	94.14	5951.0
2011-04-18	FTDX	Futures	822.6	823.4	800.7	802.5	654.0
2011-04-18	FTI	Futures	292.71	292.8	285.39	287.12	46350.0
2011-04-18	FTUK	Futures	4176.0	4176.0	4071.0	4089.9	122878.0
2011-04-18	FXXP	Futures	182.1	182.5	179.4	180.3	1974.0
2011-04-18	G	Futures	81.92	82.18	81.86	82.13	144076.0
2011-04-18	GF	Futures	320.083	321.527	318.398	320.624	2220.0
2011-04-18	GSCI	Futures	1150.41	1150.41	1141.27	1146.58	614.0
2011-04-18	HE	Futures	108.141	109.124	107.69	109.018	308.0
2011-04-18	HG	Futures	5.6709	5.7194	5.5693	5.6032	14507.0
2011-04-18	HO	Futures	2.6906	2.6913	2.6388	2.655	34571.0
2011-04-18	HRC	Futures	3000.1	3000.1	3000.1	3000.1	0.0
2011-04-18	J1	Futures	0.0151134	0.0152905	0.015092	0.0152064	152191.0
2011-04-18	J7	Futures	0.015027	0.015194	0.015001	0.015113	1073.0
2011-04-18	JB	Futures	121.19	121.52	121.13	121.41	14.0

> showing 50 of 95 rows — these rows as CSV

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