PREVIEW / futures_daily / 2017-05-12

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-12.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-05-12	ES	Futures	2595.91	2597.27	2589.4	2594.29	1087422.0
2017-05-12	NQ	Futures	6678.07	6701.33	6662.17	6700.44	186832.0
2017-05-12	YM	Futures	22024.5	22029.8	21974.9	21998.1	83758.0
2017-05-12	CL	Futures	49.88	50.16	49.4	49.92	537490.0
2017-05-12	GC	Futures	1566.5	1575.0	1565.8	1570.0	199881.0
2017-05-12	ZN	Futures	122.92184	123.490283	122.891114	123.367376	1395241.0
2017-05-12	A6	Futures	0.75689	0.76131	0.75586	0.75833	98848.0
2017-05-12	AD	Futures	0.74488	0.74667	0.74249	0.74402	55502.0
2017-05-12	ALI	Futures	2519.73	2536.02	2519.73	2536.02	10.0
2017-05-12	B	Futures	36.4	36.64	36.1	36.46	304757.0
2017-05-12	B6	Futures	1.3525	1.3536	1.3479	1.3515	89050.0
2017-05-12	BR	Futures	0.22995	0.23133	0.22886	0.23096	1983.0
2017-05-12	BZ	Futures	36.15	36.37	35.84	36.2	29339.0
2017-05-12	C	Futures	1551.0	1594.0	1539.0	1587.0	15419.0
2017-05-12	CB	Futures	281.923	281.923	277.864	279.238	31.0
2017-05-12	CC	Futures	1486.0	1550.0	1484.0	1541.0	29249.0
2017-05-12	CNH	Futures	7.2067	7.2067	7.2028	7.2028	2.0
2017-05-12	CSC	Futures	3.625	3.665	3.603	3.616	49.0
2017-05-12	CT	Futures	87.73	91.01	87.66	91.01	26885.0
2017-05-12	DC	Futures	30.39	30.8	30.07	30.26	736.0
2017-05-12	DX	Futures	92.729	92.78	92.267	92.357	24672.0
2017-05-12	E1	Futures	1.22871	1.23959	1.2276	1.23563	29750.0
2017-05-12	E6	Futures	1.25317	1.26164	1.25254	1.26037	175113.0
2017-05-12	E7	Futures	1.2467	1.2551	1.2461	1.2539	3491.0
2017-05-12	EBM	Futures	189.01	189.84	188.45	188.73	11787.0
2017-05-12	ED	Futures	95.5833	95.6123	95.5833	95.6123	412140.0
2017-05-12	ER	Futures	98.337	98.337	98.332	98.337	49323.0
2017-05-12	EW	Futures	1833.8	1834.4	1822.1	1826.5	8896.0
2017-05-12	FBON	Futures	122.41	122.63	122.36	122.59	1120.0
2017-05-12	FBTP	Futures	105.73	106.14	105.73	106.05	69697.0
2017-05-12	FBTS	Futures	102.263	102.326	102.253	102.29	31974.0
2017-05-12	FCE	Futures	4777.5	4798.2	4765.4	4792.4	6677.0
2017-05-12	FDAX	Futures	13428.6	13503.0	13422.8	13476.6	63288.0
2017-05-12	FDXM	Futures	13316.9	13383.9	13305.4	13358.2	15793.0
2017-05-12	FESX	Futures	2931.2	2947.5	2926.3	2939.4	720852.0
2017-05-12	FGBL	Futures	147.51	147.96	147.42	147.86	598254.0
2017-05-12	FGBM	Futures	128.95	129.13	128.91	129.06	504620.0
2017-05-12	FGBS	Futures	112.182	112.227	112.177	112.207	303739.0
2017-05-12	FGBX	Futures	165.57	166.53	165.31	166.27	36728.0
2017-05-12	FMWO	Futures	6344.6	6366.3	6344.6	6362.7	1809.0
2017-05-12	FOAT	Futures	133.88	134.28	133.83	134.19	92124.0
2017-05-12	FTDX	Futures	2117.1	2176.4	2117.1	2165.1	1472.0
2017-05-12	FTI	Futures	493.73	493.73	486.44	487.72	263.0
2017-05-12	FTUK	Futures	6298.9	6335.3	6287.3	6325.8	84854.0
2017-05-12	FVSA	Futures	533.29	541.76	528.21	534.98	14783.0
2017-05-12	FXXP	Futures	330.8	332.3	330.7	331.7	22576.0
2017-05-12	G	Futures	114.96	115.79	114.93	115.66	174346.0
2017-05-12	GF	Futures	327.083	333.284	326.918	333.284	8198.0
2017-05-12	GSCI	Futures	466.57	467.19	466.02	467.13	1884.0
2017-05-12	HE	Futures	83.472	84.581	83.174	84.337	17709.0

> showing 50 of 108 rows — these rows as CSV

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