PREVIEW / futures_daily / 2011-03-21

all futures daily files

  file:    by_date/futures_daily/2011/2011-03-21.parquet
  size:    9 KB
  rows:    93

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-03-21	ES	Futures	1263.5	1283.3	1262.01	1280.08	1488232.0
2011-03-21	NQ	Futures	2531.74	2586.98	2527.19	2567.62	250481.0
2011-03-21	YM	Futures	11101.6	11296.2	11096.0	11247.3	113436.0
2011-03-21	CL	Futures	199.22	201.64	198.41	199.36	241888.0
2011-03-21	GC	Futures	1932.8	1947.6	1931.9	1935.8	129779.0
2011-03-21	ZN	Futures	101.737671	101.750839	101.00025	101.303119	1112904.0
2011-03-21	A6	Futures	0.84542	0.85468	0.84464	0.85374	87426.0
2011-03-21	AD	Futures	1.00867	1.01932	1.00847	1.01584	65591.0
2011-03-21	B	Futures	97.33	98.57	97.2	97.51	154204.0
2011-03-21	B6	Futures	1.6833	1.6946	1.6819	1.6936	97419.0
2011-03-21	BFX	Futures	2968.6	3031.1	2968.6	2998.2	357.0
2011-03-21	BR	Futures	0.26024	0.26024	0.26	0.26	106.0
2011-03-21	BZ	Futures	102.73	103.65	102.48	102.71	705.0
2011-03-21	C	Futures	2204.0	2285.0	2195.0	2264.0	11375.0
2011-03-21	CB	Futures	115.282	115.297	115.15	115.297	20.0
2011-03-21	CC	Futures	2508.0	2588.0	2494.0	2563.0	11759.0
2011-03-21	CSC	Futures	4.248	4.276	4.248	4.276	1.0
2011-03-21	CT	Futures	181.19	183.21	176.47	177.91	8633.0
2011-03-21	DC	Futures	28.48	28.67	27.93	28.48	201.0
2011-03-21	DX	Futures	75.491	75.626	75.213	75.277	20826.0
2011-03-21	E1	Futures	1.45199	1.45369	1.44374	1.44819	33662.0
2011-03-21	E6	Futures	1.67712	1.68447	1.6725	1.68281	233494.0
2011-03-21	E7	Futures	1.6652	1.6721	1.6601	1.6703	4168.0
2011-03-21	EBM	Futures	220.75	222.4	212.06	212.3	12580.0
2011-03-21	ED	Futures	94.8597	94.8645	94.8502	94.855	135500.0
2011-03-21	ER	Futures	97.267	97.281	97.237	97.242	152953.0
2011-03-21	EW	Futures	935.8	955.4	935.8	952.7	23884.0
2011-03-21	FBTP	Futures	64.44	64.5	64.21	64.31	6340.0
2011-03-21	FCE	Futures	2557.4	2602.3	2556.1	2598.7	131028.0
2011-03-21	FDAX	Futures	7197.2	7313.6	7189.7	7291.2	138090.0
2011-03-21	FESX	Futures	1753.6	1788.2	1752.4	1781.2	1190866.0
2011-03-21	FEU3	Futures	97.815	97.82	97.785	97.785	806.0
2011-03-21	FGBL	Futures	98.02	98.06	97.69	97.76	702622.0
2011-03-21	FGBM	Futures	103.24	103.31	103.0	103.03	568313.0
2011-03-21	FGBS	Futures	106.444	106.474	106.29	106.305	665038.0
2011-03-21	FGBX	Futures	94.71	94.87	94.18	94.3	4661.0
2011-03-21	FTDX	Futures	793.5	806.0	773.4	800.7	1130.0
2011-03-21	FTI	Futures	285.44	289.8	285.44	289.23	35244.0
2011-03-21	FTUK	Futures	3981.8	4027.6	3980.0	4015.7	85769.0
2011-03-21	FXXP	Futures	178.3	179.0	178.3	178.7	2521.0
2011-03-21	G	Futures	82.06	82.24	81.96	82.13	75297.0
2011-03-21	GF	Futures	314.606	318.297	314.485	317.026	920.0
2011-03-21	GSCI	Futures	1099.21	1120.5	1099.21	1109.54	227.0
2011-03-21	HE	Futures	104.502	105.724	104.29	105.565	517.0
2011-03-21	HG	Futures	5.8028	5.8188	5.6829	5.7089	28043.0
2011-03-21	HO	Futures	2.5627	2.5759	2.5478	2.5607	15846.0
2011-03-21	HRC	Futures	3098.9	3098.9	3098.9	3098.9	0.0
2011-03-21	J1	Futures	0.0155418	0.0155719	0.0154589	0.0155054	87282.0
2011-03-21	J7	Futures	0.01546	0.01547	0.015367	0.01541	373.0
2011-03-21	KC	Futures	673.55	681.42	667.73	671.36	8337.0

> showing 50 of 93 rows — these rows as CSV

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