PREVIEW / futures_daily / 2012-03-29

all futures daily files

  file:    by_date/futures_daily/2012/2012-03-29.parquet
  size:    9 KB
  rows:    98

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
2012-03-29	ES	Futures	1410.3	1414.83	1396.95	1409.04	1827754.0
2012-03-29	NQ	Futures	3168.2	3177.37	3135.84	3160.18	246572.0
2012-03-29	YM	Futures	12692.0	12727.0	12608.3	12718.2	108216.0
2012-03-29	CL	Futures	194.63	194.85	188.27	189.47	319988.0
2012-03-29	GC	Futures	2225.2	2228.3	2201.3	2212.3	163878.0
2012-03-29	ZN	Futures	112.229858	112.608922	112.135092	112.55477	1055725.0
2012-03-29	A6	Futures	0.92645	0.92789	0.91889	0.92375	130594.0
2012-03-29	AD	Futures	1.00581	1.00803	1.00239	1.00601	90574.0
2012-03-29	B	Futures	111.8	112.05	109.13	110.0	121561.0
2012-03-29	B6	Futures	1.6668	1.6742	1.6638	1.6714	96035.0
2012-03-29	BFX	Futures	2844.4	2844.4	2803.8	2803.8	7.0
2012-03-29	BR	Futures	0.25733	0.25759	0.25731	0.25731	158.0
2012-03-29	BZ	Futures	117.38	117.38	115.85	116.35	1710.0
2012-03-29	C	Futures	1504.0	1522.0	1457.0	1465.0	7587.0
2012-03-29	CB	Futures	80.734	80.734	78.447	78.851	20.0
2012-03-29	CC	Futures	1743.0	1748.0	1669.0	1692.0	16826.0
2012-03-29	CSC	Futures	3.673	3.673	3.632	3.632	2.0
2012-03-29	CT	Futures	117.64	118.13	116.48	117.06	16850.0
2012-03-29	DC	Futures	25.69	25.69	25.42	25.46	77.0
2012-03-29	DX	Futures	76.809	77.056	76.663	76.888	19453.0
2012-03-29	E1	Futures	1.44765	1.45105	1.44123	1.44463	34066.0
2012-03-29	E6	Futures	1.59032	1.59378	1.58256	1.58674	226316.0
2012-03-29	E7	Futures	1.5752	1.5785	1.5674	1.5715	3800.0
2012-03-29	EBM	Futures	285.7	286.03	278.96	279.29	15019.0
2012-03-29	ED	Futures	95.0931	95.0979	95.0693	95.0788	157583.0
2012-03-29	ER	Futures	97.548	97.553	97.513	97.523	144908.0
2012-03-29	EW	Futures	1003.8	1007.1	991.6	1004.7	22725.0
2012-03-29	FBTP	Futures	68.2	68.2	67.27	67.49	30003.0
2012-03-29	FBTS	Futures	85.827	85.827	85.201	85.282	5189.0
2012-03-29	FCE	Futures	2428.5	2436.3	2391.9	2396.9	114679.0
2012-03-29	FDAX	Futures	7718.8	7746.4	7577.3	7619.8	165623.0
2012-03-29	FESX	Futures	1670.3	1677.9	1639.9	1646.1	1435290.0
2012-03-29	FEU3	Futures	98.122	98.122	98.093	98.098	177.0
2012-03-29	FGBL	Futures	113.06	113.51	112.93	113.41	668609.0
2012-03-29	FGBM	Futures	113.59	113.83	113.5	113.77	433903.0
2012-03-29	FGBS	Futures	109.934	109.964	109.904	109.959	436354.0
2012-03-29	FGBX	Futures	117.13	117.9	116.69	117.6	5322.0
2012-03-29	FTDX	Futures	739.6	741.9	730.2	732.1	186.0
2012-03-29	FTI	Futures	273.32	274.46	269.43	270.36	39689.0
2012-03-29	FTUK	Futures	4196.5	4207.5	4143.3	4153.5	135638.0
2012-03-29	FVSA	Futures	8033.89	8653.17	8033.89	8519.27	2159.0
2012-03-29	FXXP	Futures	187.6	188.2	185.5	185.8	1702.0
2012-03-29	G	Futures	93.58	93.96	93.55	93.79	119484.0
2012-03-29	GF	Futures	320.361	322.035	316.331	316.645	3523.0
2012-03-29	GSCI	Futures	1098.9	1101.83	1077.53	1079.59	840.0
2012-03-29	HE	Futures	102.238	102.238	99.79	100.973	268.0
2012-03-29	HG	Futures	4.9833	5.0056	4.9321	4.9774	53239.0
2012-03-29	HO	Futures	2.6567	2.67	2.5985	2.6126	35117.0
2012-03-29	HRC	Futures	2699.8	2699.8	2699.8	2699.8	0.0
2012-03-29	J1	Futures	0.0151382	0.0153225	0.0151232	0.0152285	103926.0

> showing 50 of 98 rows — these rows as CSV

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