PREVIEW / futures_daily / 2017-04-26

all futures daily files

  file:    by_date/futures_daily/2017/2017-04-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-04-26	ES	Futures	2588.04	2600.8	2586.41	2587.23	1493096.0
2017-04-26	NQ	Futures	6532.9	6551.45	6519.07	6520.54	221754.0
2017-04-26	YM	Futures	22084.7	22169.1	22053.0	22058.3	164795.0
2017-04-26	CL	Futures	51.5	52.38	51.06	51.77	655717.0
2017-04-26	GC	Futures	1618.3	1627.7	1612.2	1616.7	241045.0
2017-04-26	ZN	Futures	123.259833	123.521009	123.121563	123.459556	1505845.0
2017-04-26	A6	Futures	0.77291	0.77599	0.76449	0.76582	126056.0
2017-04-26	AD	Futures	0.75172	0.7536	0.74912	0.74952	98913.0
2017-04-26	ALI	Futures	2594.47	2594.47	2594.47	2594.47	0.0
2017-04-26	B	Futures	37.52	37.97	37.19	37.59	421762.0
2017-04-26	B6	Futures	1.3476	1.3505	1.3444	1.3484	95692.0
2017-04-26	BR	Futures	0.22759	0.22785	0.22415	0.22557	16689.0
2017-04-26	BZ	Futures	37.22	37.7	36.93	37.32	34197.0
2017-04-26	C	Futures	1484.0	1515.0	1470.0	1499.0	3530.0
2017-04-26	CB	Futures	259.403	261.203	259.403	261.203	9.0
2017-04-26	CC	Futures	1409.0	1453.0	1404.0	1434.0	21103.0
2017-04-26	CNH	Futures	7.2021	7.2158	7.2021	7.2116	30.0
2017-04-26	CSC	Futures	3.471	3.484	3.466	3.484	32.0
2017-04-26	CT	Futures	87.97	88.31	87.17	87.92	17376.0
2017-04-26	DC	Futures	28.71	28.86	28.56	28.67	230.0
2017-04-26	DX	Futures	91.979	92.426	91.867	92.16	32955.0
2017-04-26	E1	Futures	1.24762	1.24947	1.24317	1.247	24815.0
2017-04-26	E6	Futures	1.26193	1.26458	1.25363	1.25847	242147.0
2017-04-26	E7	Futures	1.2555	1.2582	1.2472	1.2521	7363.0
2017-04-26	EBM	Futures	184.26	187.34	184.26	187.34	33599.0
2017-04-26	ED	Futures	95.5349	95.5494	95.5349	95.5446	187507.0
2017-04-26	ER	Futures	98.332	98.332	98.328	98.332	54121.0
2017-04-26	EW	Futures	1855.1	1866.0	1852.0	1856.9	14260.0
2017-04-26	FBON	Futures	121.76	121.82	121.5	121.58	679.0
2017-04-26	FBTP	Futures	105.39	105.59	105.1	105.23	102929.0
2017-04-26	FBTS	Futures	102.0	102.018	101.981	102.0	35692.0
2017-04-26	FCE	Futures	4667.0	4671.5	4642.9	4663.4	77502.0
2017-04-26	FDAX	Futures	13203.7	13208.0	13145.1	13197.4	60204.0
2017-04-26	FDXM	Futures	13091.9	13093.0	13029.1	13081.5	18279.0
2017-04-26	FESX	Futures	2878.9	2878.9	2855.3	2869.2	986610.0
2017-04-26	FEU3	Futures	99.001	99.001	99.001	99.001	2.0
2017-04-26	FGBL	Futures	147.69	148.3	147.64	148.22	744467.0
2017-04-26	FGBM	Futures	128.92	129.15	128.91	129.12	473760.0
2017-04-26	FGBS	Futures	112.202	112.252	112.202	112.247	216432.0
2017-04-26	FGBX	Futures	167.45	168.81	167.37	168.75	49134.0
2017-04-26	FMWO	Futures	6320.5	6339.8	6316.9	6338.6	934.0
2017-04-26	FOAT	Futures	133.39	133.64	133.26	133.57	141768.0
2017-04-26	FTDX	Futures	2034.7	2048.9	2030.3	2047.9	136.0
2017-04-26	FTI	Futures	476.71	476.8	474.28	476.02	23440.0
2017-04-26	FTUK	Futures	6173.9	6202.2	6166.2	6197.9	78030.0
2017-04-26	FVSA	Futures	565.5	567.29	551.19	561.92	22760.0
2017-04-26	FXXP	Futures	322.7	324.4	321.9	324.2	34779.0
2017-04-26	G	Futures	115.6	115.76	115.45	115.66	164843.0
2017-04-26	GF	Futures	316.308	325.759	315.563	325.53	5261.0
2017-04-26	GSCI	Futures	478.95	481.96	478.95	480.65	22.0

> showing 50 of 110 rows — these rows as CSV

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