PREVIEW / futures_daily / 2011-04-28

all futures daily files

  file:    by_date/futures_daily/2011/2011-04-28.parquet
  size:    9 KB
  rows:    94

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-28	ES	Futures	1338.0	1344.93	1333.3	1341.46	1706910.0
2011-04-28	NQ	Futures	2743.86	2751.26	2729.06	2735.32	229280.0
2011-04-28	YM	Futures	11886.6	11962.8	11854.7	11947.8	97692.0
2011-04-28	CL	Futures	218.01	219.63	215.24	217.49	301604.0
2011-04-28	GC	Futures	2067.9	2082.8	2062.6	2072.5	183542.0
2011-04-28	ZN	Futures	101.579652	102.093212	101.540147	101.935194	1219039.0
2011-04-28	A6	Futures	0.92594	0.93358	0.92552	0.93032	96930.0
2011-04-28	AD	Futures	1.04651	1.05079	1.04472	1.04581	64863.0
2011-04-28	B	Futures	106.51	107.22	105.05	105.85	71171.0
2011-04-28	B6	Futures	1.7262	1.7389	1.7258	1.728	94116.0
2011-04-28	BFX	Futures	3240.0	3254.2	3224.1	3237.3	744.0
2011-04-28	BR	Futures	0.27951	0.27951	0.2759	0.27806	226.0
2011-04-28	BZ	Futures	112.32	112.32	111.54	111.54	403.0
2011-04-28	C	Futures	2118.0	2181.0	2102.0	2181.0	3210.0
2011-04-28	CB	Futures	119.682	120.269	119.682	120.269	11.0
2011-04-28	CC	Futures	2538.0	2626.0	2523.0	2611.0	17686.0
2011-04-28	CSC	Futures	4.477	4.482	4.433	4.433	9.0
2011-04-28	CT	Futures	151.38	153.39	145.0	150.46	15288.0
2011-04-28	DC	Futures	30.03	30.07	29.53	29.65	161.0
2011-04-28	DX	Futures	73.133	73.133	72.685	72.945	26202.0
2011-04-28	E1	Futures	1.49624	1.50711	1.49507	1.5003	34618.0
2011-04-28	E6	Futures	1.74796	1.76063	1.74772	1.75329	279673.0
2011-04-28	E7	Futures	1.7352	1.7479	1.7346	1.7402	5845.0
2011-04-28	EBM	Futures	231.09	231.32	224.75	225.92	4921.0
2011-04-28	ED	Futures	94.9264	94.9359	94.9264	94.9311	127659.0
2011-04-28	ER	Futures	97.252	97.262	97.242	97.242	121033.0
2011-04-28	EW	Futures	1003.3	1007.9	991.9	1003.7	29699.0
2011-04-28	FBTP	Futures	64.23	64.4	64.13	64.37	11534.0
2011-04-28	FCE	Futures	2748.1	2754.5	2730.0	2748.4	100709.0
2011-04-28	FDAX	Futures	7992.2	8025.8	7947.3	8002.9	112835.0
2011-04-28	FESX	Futures	1883.7	1890.1	1871.5	1884.3	986337.0
2011-04-28	FEU3	Futures	97.79	97.8	97.785	97.785	176.0
2011-04-28	FGBL	Futures	97.84	98.25	97.72	98.16	823612.0
2011-04-28	FGBM	Futures	102.96	103.14	102.83	103.05	405476.0
2011-04-28	FGBS	Futures	106.34	106.394	106.275	106.355	556479.0
2011-04-28	FGBX	Futures	93.64	94.5	93.57	94.34	4760.0
2011-04-28	FTDX	Futures	827.0	830.1	821.7	825.7	1034.0
2011-04-28	FTI	Futures	295.18	295.64	292.34	293.58	25741.0
2011-04-28	FTUK	Futures	4246.7	4254.7	4211.7	4222.9	77782.0
2011-04-28	FXXP	Futures	187.3	187.3	186.5	187.1	880.0
2011-04-28	G	Futures	82.34	82.74	82.26	82.67	97051.0
2011-04-28	GF	Futures	314.668	317.195	312.863	316.172	1620.0
2011-04-28	GSCI	Futures	1177.43	1182.51	1166.26	1172.35	32.0
2011-04-28	HE	Futures	102.563	102.882	101.766	102.855	553.0
2011-04-28	HG	Futures	5.6743	5.746	5.6131	5.6616	35977.0
2011-04-28	HO	Futures	2.7056	2.7285	2.6777	2.6971	53805.0
2011-04-28	HRC	Futures	3000.1	3000.1	3000.1	3000.1	0.0
2011-04-28	J1	Futures	0.0152817	0.0154375	0.0152717	0.0154174	113076.0
2011-04-28	J7	Futures	0.015196	0.015342	0.015182	0.015323	887.0
2011-04-28	JB	Futures	121.96	122.14	121.95	121.95	230.0

> showing 50 of 94 rows — these rows as CSV

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