PREVIEW / futures_daily / 2014-06-20

all futures daily files

  file:    by_date/futures_daily/2014/2014-06-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
2014-06-20	ES	Futures	2024.61	2032.67	2023.84	2029.03	1162086.0
2014-06-20	NQ	Futures	4368.21	4383.78	4366.76	4376.57	158922.0
2014-06-20	YM	Futures	16977.2	17046.8	16966.1	17009.5	88929.0
2014-06-20	CL	Futures	193.81	195.33	193.28	195.14	213130.0
2014-06-20	GC	Futures	1739.6	1742.5	1722.2	1734.7	167785.0
2014-06-20	ZN	Futures	116.127249	116.200193	115.850061	116.025127	849313.0
2014-06-20	A6	Futures	0.90282	0.90446	0.90088	0.90175	46659.0
2014-06-20	AD	Futures	0.93662	0.94272	0.93622	0.94262	71341.0
2014-06-20	ALI	Futures	2782.49	2782.49	2782.49	2782.49	0.0
2014-06-20	B	Futures	120.28	120.48	119.77	120.17	198840.0
2014-06-20	B6	Futures	1.79	1.7923	1.7862	1.7873	95216.0
2014-06-20	BFX	Futures	3835.3	3838.2	3831.6	3838.2	22.0
2014-06-20	BR	Futures	0.23102	0.23163	0.23054	0.23163	681.0
2014-06-20	BZ	Futures	121.16	121.5	120.82	121.22	11644.0
2014-06-20	C	Futures	2036.0	2042.0	2015.0	2039.0	4113.0
2014-06-20	CC	Futures	2284.0	2292.0	2254.0	2284.0	14030.0
2014-06-20	CNH	Futures	7.1794	7.1794	7.1761	7.1761	1.0
2014-06-20	CSC	Futures	4.629	4.629	4.62	4.62	10.0
2014-06-20	CT	Futures	99.02	99.96	98.03	99.27	7421.0
2014-06-20	DC	Futures	36.64	37.05	36.64	36.9	48.0
2014-06-20	DX	Futures	76.289	76.484	76.204	76.357	13790.0
2014-06-20	E1	Futures	1.43442	1.43737	1.42929	1.43199	25462.0
2014-06-20	E6	Futures	1.60601	1.60919	1.60082	1.60424	132073.0
2014-06-20	E7	Futures	1.5955	1.5987	1.5905	1.5938	1855.0
2014-06-20	ED	Futures	95.4162	95.4162	95.4115	95.4115	72987.0
2014-06-20	ER	Futures	97.911	97.916	97.901	97.906	49198.0
2014-06-20	EW	Futures	1469.9	1477.5	1469.7	1476.1	14292.0
2014-06-20	FBTP	Futures	90.91	90.99	90.49	90.75	48564.0
2014-06-20	FBTS	Futures	97.921	97.93	97.832	97.885	10707.0
2014-06-20	FCE	Futures	3635.9	3646.7	3612.0	3619.2	83017.0
2014-06-20	FDAX	Futures	11020.2	11074.8	10993.3	11019.7	75560.0
2014-06-20	FDIV	Futures	153.2	153.2	152.71	152.71	6.0
2014-06-20	FESX	Futures	2379.2	2385.7	2365.6	2372.7	781330.0
2014-06-20	FGBL	Futures	127.0	127.03	126.66	126.81	421897.0
2014-06-20	FGBM	Futures	121.24	121.27	121.08	121.14	297387.0
2014-06-20	FGBS	Futures	110.743	110.748	110.723	110.738	147075.0
2014-06-20	FGBX	Futures	130.87	131.05	130.2	130.42	16152.0
2014-06-20	FMWO	Futures	5790.2	5806.6	5790.2	5802.8	150.0
2014-06-20	FOAT	Futures	116.7	116.77	116.45	116.6	42763.0
2014-06-20	FTDX	Futures	1243.1	1256.7	1242.7	1248.7	227.0
2014-06-20	FTI	Futures	361.29	362.63	360.6	361.25	26033.0
2014-06-20	FTUK	Futures	5204.2	5226.2	5192.3	5216.2	77540.0
2014-06-20	FVSA	Futures	1280.76	1285.06	1254.98	1259.27	9588.0
2014-06-20	FXXP	Futures	261.0	262.1	260.8	261.3	5730.0
2014-06-20	G	Futures	93.16	93.16	92.81	93.02	132752.0
2014-06-20	GF	Futures	318.78	320.274	316.021	317.056	3201.0
2014-06-20	GSCI	Futures	1113.0	1115.83	1112.17	1115.25	575.0
2014-06-20	HE	Futures	134.732	135.574	134.18	134.495	7916.0
2014-06-20	HG	Futures	3.9241	3.9873	3.9202	3.979	19384.0
2014-06-20	HH	Futures	57.677	57.677	57.234	57.436	5583.0

> showing 50 of 104 rows — these rows as CSV

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