PREVIEW / futures_daily / 2017-04-19

all futures daily files

  file:    by_date/futures_daily/2017/2017-04-19.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-04-19	ES	Futures	2538.9	2551.39	2531.84	2534.55	1254296.0
2017-04-19	NQ	Futures	6347.99	6396.28	6346.81	6357.41	213579.0
2017-04-19	YM	Futures	21550.8	21616.2	21431.5	21456.8	134881.0
2017-04-19	CL	Futures	55.04	55.38	52.7	53.06	832193.0
2017-04-19	GC	Futures	1651.8	1653.1	1631.0	1641.2	260702.0
2017-04-19	ZN	Futures	124.458171	124.473535	123.981909	124.166268	1198623.0
2017-04-19	A6	Futures	0.77516	0.77547	0.76808	0.7688	87280.0
2017-04-19	AD	Futures	0.76283	0.76309	0.75651	0.75666	69166.0
2017-04-19	ALI	Futures	2510.14	2510.14	2510.14	2510.14	0.0
2017-04-19	B	Futures	39.73	40.03	38.13	38.39	435407.0
2017-04-19	B6	Futures	1.3489	1.3504	1.3407	1.3423	154896.0
2017-04-19	BR	Futures	0.23024	0.23038	0.22817	0.22865	359.0
2017-04-19	BZ	Futures	39.59	39.94	38.03	38.28	43655.0
2017-04-19	C	Futures	1545.0	1553.0	1496.0	1503.0	9278.0
2017-04-19	CB	Futures	255.711	257.542	255.711	256.931	9.0
2017-04-19	CC	Futures	1464.0	1473.0	1396.0	1432.0	25851.0
2017-04-19	CNH	Futures	7.2012	7.2012	7.2004	7.2007	14.0
2017-04-19	CSC	Futures	3.475	3.482	3.453	3.482	42.0
2017-04-19	CT	Futures	85.62	86.66	85.36	86.57	7425.0
2017-04-19	DC	Futures	28.84	28.84	28.47	28.67	144.0
2017-04-19	DX	Futures	92.659	92.966	92.621	92.829	17791.0
2017-04-19	E1	Futures	1.2449	1.24539	1.24095	1.24305	19317.0
2017-04-19	E6	Futures	1.23975	1.24027	1.23601	1.23831	129350.0
2017-04-19	E7	Futures	1.2332	1.2339	1.2298	1.2321	2156.0
2017-04-19	EBM	Futures	184.54	185.38	183.98	184.26	18867.0
2017-04-19	ED	Futures	95.5978	95.6026	95.5833	95.593	212775.0
2017-04-19	ER	Futures	98.323	98.328	98.318	98.323	33198.0
2017-04-19	EW	Futures	1806.4	1820.9	1805.3	1809.8	15273.0
2017-04-19	FBON	Futures	121.89	122.07	121.8	121.81	623.0
2017-04-19	FBTP	Futures	105.31	105.53	105.05	105.15	77708.0
2017-04-19	FBTS	Futures	101.882	101.945	101.873	101.918	40225.0
2017-04-19	FCE	Futures	4390.7	4411.6	4382.7	4404.5	255745.0
2017-04-19	FDAX	Futures	12713.4	12736.6	12655.8	12714.9	66988.0
2017-04-19	FDXM	Futures	12598.0	12624.2	12544.6	12603.2	18079.0
2017-04-19	FESX	Futures	2727.9	2742.6	2722.2	2738.6	841002.0
2017-04-19	FGBL	Futures	150.51	150.54	149.95	150.03	629745.0
2017-04-19	FGBM	Futures	130.26	130.26	129.84	129.88	451936.0
2017-04-19	FGBS	Futures	112.612	112.612	112.457	112.467	285936.0
2017-04-19	FGBX	Futures	175.9	175.9	174.56	174.78	43315.0
2017-04-19	FMWO	Futures	6178.4	6184.4	6173.6	6178.4	1593.0
2017-04-19	FOAT	Futures	132.51	132.82	132.26	132.49	151126.0
2017-04-19	FTDX	Futures	1966.6	1979.8	1965.6	1978.8	76.0
2017-04-19	FTI	Futures	462.68	466.39	461.44	463.64	42373.0
2017-04-19	FTUK	Futures	6033.2	6069.1	6019.0	6041.7	140674.0
2017-04-19	FVSA	Futures	705.09	706.88	681.83	688.98	41831.0
2017-04-19	FXXP	Futures	313.3	314.8	312.8	314.4	19754.0
2017-04-19	G	Futures	116.28	116.31	115.73	115.85	136396.0
2017-04-19	GF	Futures	320.604	323.124	317.282	321.52	8330.0
2017-04-19	GSCI	Futures	498.35	499.79	487.49	487.55	36.0
2017-04-19	HE	Futures	79.705	79.705	78.689	78.749	310.0

> showing 50 of 108 rows — these rows as CSV

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