PREVIEW / futures_daily / 2017-06-26

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-26.parquet
  size:    9 KB
  rows:    110

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-06-26	ES	Futures	2643.15	2660.0	2640.98	2647.5	1265812.0
2017-06-26	NQ	Futures	6821.67	6879.27	6780.52	6792.57	311741.0
2017-06-26	YM	Futures	22537.5	22679.2	22524.9	22588.3	117059.0
2017-06-26	CL	Futures	44.57	45.08	44.02	44.8	661354.0
2017-06-26	GC	Futures	1606.1	1607.2	1578.5	1591.1	227469.0
2017-06-26	ZN	Futures	124.827183	124.996471	124.688674	124.873352	841606.0
2017-06-26	A6	Futures	0.7765	0.77989	0.77609	0.77856	52931.0
2017-06-26	AD	Futures	0.76785	0.771	0.76765	0.76892	44149.0
2017-06-26	ALI	Futures	2457.38	2457.38	2457.38	2457.38	0.0
2017-06-26	B	Futures	32.4	32.82	32.0	32.55	211491.0
2017-06-26	B6	Futures	1.335	1.3371	1.3314	1.3329	70172.0
2017-06-26	BR	Futures	0.22015	0.22278	0.22015	0.222	15.0
2017-06-26	BZ	Futures	32.26	32.59	31.8	32.34	16670.0
2017-06-26	C	Futures	1530.0	1544.0	1495.0	1508.0	3063.0
2017-06-26	CB	Futures	323.569	327.097	323.569	327.097	12.0
2017-06-26	CC	Futures	1419.0	1438.0	1386.0	1401.0	15043.0
2017-06-26	CNH	Futures	7.1002	7.1138	7.1002	7.1138	20.0
2017-06-26	CSC	Futures	3.565	3.565	3.536	3.536	7.0
2017-06-26	CT	Futures	80.46	80.82	79.43	80.51	25.0
2017-06-26	DC	Futures	29.91	29.96	29.51	29.55	200.0
2017-06-26	DX	Futures	90.519	90.725	90.398	90.684	15454.0
2017-06-26	E1	Futures	1.27419	1.27481	1.26793	1.26977	24015.0
2017-06-26	E6	Futures	1.28826	1.29135	1.2858	1.28683	159251.0
2017-06-26	E7	Futures	1.2816	1.2844	1.279	1.2801	2433.0
2017-06-26	EBM	Futures	192.91	192.91	190.4	190.68	13541.0
2017-06-26	ED	Futures	95.5789	95.5838	95.5741	95.5741	116418.0
2017-06-26	ER	Futures	98.337	98.337	98.332	98.337	30916.0
2017-06-26	EW	Futures	1850.9	1865.2	1849.6	1859.1	17878.0
2017-06-26	FBON	Futures	125.39	125.59	125.21	125.26	533.0
2017-06-26	FBTP	Futures	110.0	110.46	109.87	110.13	87193.0
2017-06-26	FBTS	Futures	102.909	102.945	102.89	102.909	32479.0
2017-06-26	FCE	Futures	4750.6	4795.7	4750.6	4770.0	75909.0
2017-06-26	FDAX	Futures	13426.2	13514.1	13416.2	13445.2	60721.0
2017-06-26	FDXM	Futures	13339.9	13429.9	13334.7	13362.4	18419.0
2017-06-26	FESX	Futures	2889.6	2917.3	2889.6	2902.6	662821.0
2017-06-26	FEU3	Futures	99.006	99.006	99.006	99.006	3.0
2017-06-26	FGBL	Futures	149.89	150.29	149.88	150.02	582260.0
2017-06-26	FGBM	Futures	129.46	129.59	129.43	129.48	346060.0
2017-06-26	FGBS	Futures	112.182	112.212	112.151	112.172	291276.0
2017-06-26	FGBX	Futures	171.38	172.69	171.34	171.66	35883.0
2017-06-26	FMWO	Futures	6449.5	6463.8	6438.8	6438.8	1649.0
2017-06-26	FOAT	Futures	137.1	137.39	137.03	137.12	76094.0
2017-06-26	FTDX	Futures	2285.2	2285.2	2262.6	2267.2	124.0
2017-06-26	FTI	Futures	479.26	483.04	478.84	479.81	23713.0
2017-06-26	FTUK	Futures	6369.2	6412.0	6362.3	6387.8	64584.0
2017-06-26	FVSA	Futures	466.05	469.19	451.88	459.75	18737.0
2017-06-26	FXXP	Futures	329.6	331.6	329.6	330.2	25402.0
2017-06-26	G	Futures	116.24	116.58	116.04	116.34	143187.0
2017-06-26	GF	Futures	317.863	328.07	316.381	328.07	6685.0
2017-06-26	GSCI	Futures	432.22	433.86	429.23	432.76	290.0

> showing 50 of 110 rows — these rows as CSV

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