PREVIEW / futures_daily / 2017-07-06

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-06.parquet
  size:    9 KB
  rows:    108

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
2017-07-06	ES	Futures	2638.81	2641.52	2614.08	2617.61	1603746.0
2017-07-06	NQ	Futures	6642.4	6645.04	6559.52	6579.21	370735.0
2017-07-06	YM	Futures	22643.3	22665.5	22470.9	22495.3	143721.0
2017-07-06	CL	Futures	47.14	48.05	46.66	47.01	969676.0
2017-07-06	GC	Futures	1565.7	1569.6	1559.7	1561.6	192211.0
2017-07-06	ZN	Futures	123.426705	123.457485	122.91884	123.103518	1567162.0
2017-07-06	A6	Futures	0.7803	0.78153	0.77763	0.77845	65153.0
2017-07-06	AD	Futures	0.78565	0.78789	0.78423	0.7856	72120.0
2017-07-06	ALI	Futures	2555.59	2555.59	2555.59	2555.59	0.0
2017-07-06	B	Futures	34.14	34.77	33.77	34.02	308255.0
2017-07-06	B6	Futures	1.355	1.3599	1.3533	1.3587	89914.0
2017-07-06	BR	Futures	0.22226	0.22226	0.221	0.22226	27.0
2017-07-06	BZ	Futures	33.93	34.54	33.57	33.8	25556.0
2017-07-06	C	Futures	1555.0	1555.0	1504.0	1524.0	2331.0
2017-07-06	CB	Futures	319.312	320.011	318.339	318.339	31.0
2017-07-06	CC	Futures	1471.0	1478.0	1437.0	1463.0	19794.0
2017-07-06	CNH	Futures	7.0623	7.0623	7.0603	7.0603	1.0
2017-07-06	CSC	Futures	3.515	3.548	3.515	3.532	62.0
2017-07-06	CT	Futures	79.95	81.08	79.95	81.08	7.0
2017-07-06	DC	Futures	29.22	29.55	29.22	29.39	146.0
2017-07-06	DX	Futures	89.646	89.744	89.231	89.245	14274.0
2017-07-06	E1	Futures	1.2796	1.28488	1.2769	1.28365	20776.0
2017-07-06	E6	Futures	1.30544	1.31387	1.30292	1.31352	199674.0
2017-07-06	E7	Futures	1.2986	1.307	1.296	1.3066	3459.0
2017-07-06	EBM	Futures	199.03	199.31	196.53	197.92	16615.0
2017-07-06	ED	Futures	95.5644	95.5644	95.5499	95.5596	190139.0
2017-07-06	ER	Futures	98.332	98.337	98.332	98.337	37814.0
2017-07-06	EW	Futures	1859.2	1860.3	1835.3	1837.9	20841.0
2017-07-06	FBON	Futures	123.51	123.51	122.41	122.55	1643.0
2017-07-06	FBTP	Futures	107.42	107.51	106.06	106.25	154330.0
2017-07-06	FBTS	Futures	102.699	102.708	102.626	102.644	42601.0
2017-07-06	FCE	Futures	4674.9	4675.3	4606.3	4643.7	97540.0
2017-07-06	FDAX	Futures	13133.0	13144.6	12957.7	13021.4	98354.0
2017-07-06	FDXM	Futures	13048.0	13063.7	12877.4	12941.2	25632.0
2017-07-06	FESX	Futures	2839.0	2839.0	2797.3	2817.7	975652.0
2017-07-06	FGBL	Futures	147.01	147.08	145.74	145.8	1226202.0
2017-07-06	FGBM	Futures	128.55	128.59	128.08	128.12	725151.0
2017-07-06	FGBS	Futures	112.076	112.096	112.036	112.051	453736.0
2017-07-06	FGBX	Futures	164.06	164.18	161.68	162.04	77175.0
2017-07-06	FMWO	Futures	6406.7	6406.7	6366.2	6388.8	486.0
2017-07-06	FOAT	Futures	134.8	134.81	133.64	133.7	248308.0
2017-07-06	FTDX	Futures	2228.6	2235.6	2204.6	2211.6	939.0
2017-07-06	FTI	Futures	472.43	472.43	466.94	470.35	29971.0
2017-07-06	FTUK	Futures	6318.7	6324.7	6256.5	6285.8	87140.0
2017-07-06	FVSA	Futures	488.09	519.58	483.37	508.56	24669.0
2017-07-06	FXXP	Futures	324.7	325.1	321.1	322.7	30197.0
2017-07-06	G	Futures	113.87	113.88	113.28	113.41	256829.0
2017-07-06	GF	Futures	313.582	319.07	309.96	317.479	8219.0
2017-07-06	GSCI	Futures	452.43	456.14	450.54	451.15	780.0
2017-07-06	HE	Futures	97.264	97.436	94.421	94.938	23480.0

> showing 50 of 108 rows — these rows as CSV

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