PREVIEW / futures_daily / 2013-08-23

all futures daily files

  file:    by_date/futures_daily/2013/2013-08-23.parquet
  size:    9 KB
  rows:    102

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-08-23	ES	Futures	1705.1	1712.57	1699.95	1711.28	1307807.0
2013-08-23	NQ	Futures	3589.97	3617.16	3581.87	3610.5	194415.0
2013-08-23	YM	Futures	14810.9	14873.3	14772.2	14857.5	117298.0
2013-08-23	CL	Futures	184.96	187.98	183.34	187.07	259545.0
2013-08-23	GC	Futures	1820.0	1851.4	1809.0	1846.0	161580.0
2013-08-23	ZN	Futures	111.748781	112.338336	111.397855	112.169892	1476295.0
2013-08-23	A6	Futures	0.84471	0.84799	0.84058	0.84621	91135.0
2013-08-23	AD	Futures	0.95736	0.95938	0.95263	0.95797	75506.0
2013-08-23	B	Futures	107.77	109.07	107.64	108.88	219413.0
2013-08-23	B6	Futures	1.6342	1.6415	1.629	1.6327	101998.0
2013-08-23	BR	Futures	0.2037	0.21044	0.2037	0.2094	1015.0
2013-08-23	BZ	Futures	108.89	109.87	108.45	109.68	7755.0
2013-08-23	C	Futures	1727.0	1740.0	1720.0	1736.0	2633.0
2013-08-23	CB	Futures	68.819	69.659	68.699	69.539	23.0
2013-08-23	CC	Futures	1825.0	1843.0	1823.0	1837.0	5701.0
2013-08-23	CSC	Futures	3.242	3.292	3.238	3.261	12.0
2013-08-23	CT	Futures	101.23	101.49	100.32	100.32	44.0
2013-08-23	DC	Futures	24.76	25.16	24.59	24.87	256.0
2013-08-23	DX	Futures	77.932	78.08	77.646	77.786	30453.0
2013-08-23	E1	Futures	1.39213	1.39895	1.38776	1.39458	28327.0
2013-08-23	E6	Futures	1.57628	1.58277	1.57356	1.57946	194675.0
2013-08-23	E7	Futures	1.5659	1.5723	1.5633	1.5692	3145.0
2013-08-23	ED	Futures	95.306	95.3084	95.3036	95.306	54960.0
2013-08-23	ER	Futures	97.822	97.827	97.822	97.822	47622.0
2013-08-23	EW	Futures	1236.9	1241.6	1229.7	1239.4	13472.0
2013-08-23	FBTP	Futures	78.34	78.41	77.99	78.22	22507.0
2013-08-23	FBTS	Futures	93.341	93.384	93.298	93.358	2958.0
2013-08-23	FCE	Futures	3132.9	3146.0	3102.4	3138.2	67886.0
2013-08-23	FDAX	Futures	9343.4	9368.9	9277.9	9342.3	73965.0
2013-08-23	FESX	Futures	1975.8	1989.9	1959.7	1982.9	648566.0
2013-08-23	FGBL	Futures	117.03	117.1	116.44	116.87	721484.0
2013-08-23	FGBM	Futures	116.12	116.16	115.69	115.92	491779.0
2013-08-23	FGBS	Futures	110.148	110.158	110.053	110.118	374008.0
2013-08-23	FGBX	Futures	118.88	119.22	118.02	118.97	12123.0
2013-08-23	FMWO	Futures	4944.6	4944.6	4944.6	4944.6	224.0
2013-08-23	FOAT	Futures	105.02	105.04	104.6	104.94	38270.0
2013-08-23	FTDX	Futures	981.4	981.4	975.3	978.1	95.0
2013-08-23	FTI	Futures	325.5	327.86	323.67	326.94	21637.0
2013-08-23	FTUK	Futures	4848.0	4884.8	4812.0	4864.9	77887.0
2013-08-23	FVSA	Futures	2648.5	2688.43	2581.95	2615.23	5356.0
2013-08-23	FXXP	Futures	223.6	225.1	222.9	224.6	3037.0
2013-08-23	G	Futures	90.93	91.25	90.71	91.19	132418.0
2013-08-23	GF	Futures	258.974	259.426	257.576	257.576	1640.0
2013-08-23	GSCI	Futures	1059.29	1070.64	1059.29	1066.69	187.0
2013-08-23	HE	Futures	102.222	103.19	101.375	102.948	17187.0
2013-08-23	HG	Futures	4.2291	4.2639	4.2044	4.2494	18152.0
2013-08-23	HH	Futures	38.669	38.691	38.283	38.393	5600.0
2013-08-23	HO	Futures	2.4654	2.4884	2.4549	2.4761	13457.0
2013-08-23	HRC	Futures	2266.5	2266.5	2266.5	2266.5	0.0
2013-08-23	J1	Futures	0.0127452	0.0127905	0.0126911	0.0127553	131623.0

> showing 50 of 102 rows — these rows as CSV

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