PREVIEW / futures_daily / 2013-09-20

all futures daily files

  file:    by_date/futures_daily/2013/2013-09-20.parquet
  size:    9 KB
  rows:    104

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
2013-09-20	ES	Futures	1764.0	1766.31	1747.57	1748.85	1767531.0
2013-09-20	NQ	Futures	3714.34	3722.95	3694.24	3694.24	208460.0
2013-09-20	YM	Futures	15492.1	15506.0	15319.0	15325.9	110893.0
2013-09-20	CL	Futures	187.27	187.86	185.01	185.45	250360.0
2013-09-20	GC	Futures	1806.9	1809.8	1752.2	1762.3	190860.0
2013-09-20	ZN	Futures	113.422378	113.691453	113.224112	113.563996	911777.0
2013-09-20	A6	Futures	0.88679	0.8884	0.88084	0.88348	83368.0
2013-09-20	AD	Futures	0.98238	0.98258	0.97804	0.97965	50384.0
2013-09-20	B	Futures	107.52	108.56	107.3	108.11	160650.0
2013-09-20	B6	Futures	1.6816	1.6855	1.6771	1.6805	89228.0
2013-09-20	BFX	Futures	3408.6	3410.7	3401.1	3404.4	44.0
2013-09-20	BR	Futures	0.22637	0.22835	0.22578	0.22596	61.0
2013-09-20	BZ	Futures	108.4	109.37	108.4	108.93	5219.0
2013-09-20	C	Futures	1823.0	1826.0	1796.0	1816.0	6956.0
2013-09-20	CB	Futures	73.375	74.203	73.375	74.107	10.0
2013-09-20	CC	Futures	1960.0	1960.0	1922.0	1944.0	11888.0
2013-09-20	CSC	Futures	3.244	3.244	3.244	3.244	2.0
2013-09-20	CT	Futures	101.09	101.09	98.66	99.24	64.0
2013-09-20	DC	Futures	24.76	24.86	24.67	24.86	84.0
2013-09-20	DX	Futures	76.652	76.876	76.61	76.747	22685.0
2013-09-20	E1	Futures	1.41218	1.41475	1.40897	1.41269	30966.0
2013-09-20	E6	Futures	1.59705	1.59929	1.59327	1.59598	166089.0
2013-09-20	E7	Futures	1.587	1.589	1.583	1.5857	2322.0
2013-09-20	ED	Futures	95.3351	95.3399	95.3303	95.3351	124483.0
2013-09-20	ER	Futures	97.847	97.852	97.832	97.837	109083.0
2013-09-20	EW	Futures	1278.1	1279.8	1265.1	1266.0	26594.0
2013-09-20	FBTP	Futures	78.66	78.75	78.44	78.63	34541.0
2013-09-20	FBTS	Futures	93.765	93.877	93.661	93.852	7760.0
2013-09-20	FCE	Futures	3245.9	3252.4	3231.6	3245.1	112149.0
2013-09-20	FDAX	Futures	9658.6	9678.0	9609.8	9630.9	83396.0
2013-09-20	FDIV	Futures	133.96	133.96	133.77	133.77	100.0
2013-09-20	FESX	Futures	2050.9	2054.4	2036.2	2046.7	1046118.0
2013-09-20	FEU3	Futures	98.468	98.468	98.458	98.458	1832.0
2013-09-20	FGBL	Futures	118.02	118.26	117.62	117.78	638238.0
2013-09-20	FGBM	Futures	116.99	117.12	116.79	116.87	396954.0
2013-09-20	FGBS	Futures	110.373	110.388	110.318	110.333	327640.0
2013-09-20	FGBX	Futures	118.28	118.62	117.6	117.95	19474.0
2013-09-20	FMWO	Futures	5156.0	5156.0	5156.0	5156.0	0.0
2013-09-20	FOAT	Futures	105.89	106.06	105.35	105.54	40242.0
2013-09-20	FTDX	Futures	1008.2	1010.6	1001.2	1004.5	163.0
2013-09-20	FTI	Futures	331.19	332.27	329.5	331.06	25858.0
2013-09-20	FTUK	Futures	4944.4	4954.5	4909.2	4926.0	96105.0
2013-09-20	FVSA	Futures	2477.89	2477.89	2386.6	2406.16	4993.0
2013-09-20	FXXP	Futures	229.1	229.8	228.7	228.8	7708.0
2013-09-20	G	Futures	91.19	91.22	90.48	90.73	108465.0
2013-09-20	GF	Futures	259.409	262.221	259.165	261.202	2660.0
2013-09-20	GSCI	Futures	1074.53	1076.71	1067.91	1071.85	49.0
2013-09-20	HE	Futures	110.497	110.687	108.725	108.946	19539.0
2013-09-20	HG	Futures	4.2411	4.2538	4.1816	4.2044	41634.0
2013-09-20	HH	Futures	39.991	39.991	39.495	39.808	6540.0

> showing 50 of 104 rows — these rows as CSV

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