PREVIEW / futures_daily / 2012-03-06

all futures daily files

  file:    by_date/futures_daily/2012/2012-03-06.parquet
  size:    9 KB
  rows:    100

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-06	ES	Futures	1368.86	1370.62	1343.27	1346.79	2450910.0
2012-03-06	NQ	Futures	2991.36	2993.36	2944.76	2961.34	285518.0
2012-03-06	YM	Futures	12530.4	12545.9	12302.2	12324.4	160569.0
2012-03-06	CL	Futures	198.43	198.86	193.61	193.96	332561.0
2012-03-06	GC	Futures	2286.4	2289.6	2227.5	2239.2	237112.0
2012-03-06	ZN	Futures	113.354289	113.88089	113.327284	113.82688	30512.0
2012-03-06	A6	Futures	0.94804	0.95	0.93514	0.93532	176745.0
2012-03-06	AD	Futures	1.00894	1.00985	1.00051	1.00091	124080.0
2012-03-06	B	Futures	110.88	110.91	108.72	109.08	174460.0
2012-03-06	B6	Futures	1.6582	1.6602	1.6408	1.6418	132213.0
2012-03-06	BFX	Futures	2770.3	2770.3	2703.1	2703.1	29.0
2012-03-06	BR	Futures	0.2652	0.26577	0.26472	0.26577	91.0
2012-03-06	BZ	Futures	116.68	117.0	115.73	116.02	757.0
2012-03-06	C	Futures	1460.0	1502.0	1460.0	1478.0	5584.0
2012-03-06	CB	Futures	83.156	83.156	82.618	82.753	17.0
2012-03-06	CC	Futures	1742.0	1764.0	1722.0	1737.0	8181.0
2012-03-06	CSC	Futures	3.595	3.669	3.572	3.669	20.0
2012-03-06	CT	Futures	117.94	117.94	113.6	114.41	21967.0
2012-03-06	DC	Futures	24.41	25.43	24.41	25.33	147.0
2012-03-06	DX	Futures	77.252	77.802	77.228	77.793	28152.0
2012-03-06	E1	Futures	1.4389	1.44035	1.42748	1.42788	40408.0
2012-03-06	E6	Futures	1.57971	1.58102	1.56632	1.56656	280597.0
2012-03-06	E7	Futures	1.5653	1.5666	1.5518	1.5522	3830.0
2012-03-06	EBM	Futures	280.98	283.0	279.29	281.65	7862.0
2012-03-06	ED	Futures	95.0987	95.0987	95.082	95.0916	106730.0
2012-03-06	ER	Futures	97.528	97.533	97.513	97.523	74602.0
2012-03-06	EW	Futures	981.3	983.6	958.3	961.4	29645.0
2012-03-06	FBTP	Futures	68.43	68.56	67.69	67.93	13034.0
2012-03-06	FBTS	Futures	86.625	86.706	86.372	86.47	2911.0
2012-03-06	FCE	Futures	2459.7	2461.8	2361.5	2375.7	174499.0
2012-03-06	FDAX	Futures	7578.9	7584.4	7290.7	7354.2	214673.0
2012-03-06	FESX	Futures	1690.1	1690.1	1622.6	1639.3	1794628.0
2012-03-06	FEU3	Futures	98.083	98.088	98.078	98.078	325.0
2012-03-06	FGBL	Futures	113.36	113.79	113.33	113.61	769951.0
2012-03-06	FGBM	Futures	113.69	113.91	113.67	113.87	606672.0
2012-03-06	FGBS	Futures	109.949	110.009	109.929	109.979	829644.0
2012-03-06	FGBX	Futures	117.8	118.29	117.26	117.9	23662.0
2012-03-06	FTDX	Futures	712.9	712.9	686.5	693.0	528.0
2012-03-06	FTI	Futures	273.33	273.49	265.43	266.81	46156.0
2012-03-06	FTUK	Futures	4234.2	4235.3	4127.1	4153.8	146088.0
2012-03-06	FVSA	Futures	9444.87	10319.05	9444.87	10243.03	8227.0
2012-03-06	FXXP	Futures	187.0	187.1	181.4	183.1	2260.0
2012-03-06	G	Futures	94.17	94.65	94.11	94.51	146091.0
2012-03-06	GF	Futures	330.991	331.044	326.59	326.908	2866.0
2012-03-06	GSCI	Futures	1100.85	1100.85	1089.51	1091.4	444.0
2012-03-06	HE	Futures	107.827	107.827	104.685	104.867	35307.0
2012-03-06	HG	Futures	5.0652	5.0908	4.8908	4.9	59111.0
2012-03-06	HO	Futures	2.6596	2.6596	2.6226	2.6326	24848.0
2012-03-06	HRC	Futures	2719.2	2719.2	2719.2	2719.2	0.0
2012-03-06	J1	Futures	0.0154043	0.0155826	0.0153917	0.01555	112921.0

> showing 50 of 100 rows — these rows as CSV

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