PREVIEW / futures_daily / 2017-05-19

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-19.parquet
  size:    10 KB
  rows:    112

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-19	ES	Futures	2567.41	2593.47	2564.15	2586.41	1672971.0
2017-05-19	NQ	Futures	6632.72	6685.72	6621.53	6658.34	292202.0
2017-05-19	YM	Futures	21778.7	21986.5	21759.7	21933.8	154499.0
2017-05-19	CL	Futures	51.45	52.72	51.38	52.48	652624.0
2017-05-19	GC	Futures	1594.4	1606.7	1593.5	1603.1	212923.0
2017-05-19	ZN	Futures	124.166268	124.243085	123.935819	124.074089	1226277.0
2017-05-19	A6	Futures	0.7612	0.76634	0.75997	0.7651	76919.0
2017-05-19	AD	Futures	0.74998	0.75529	0.74963	0.75498	77335.0
2017-05-19	ALI	Futures	2571.54	2571.54	2571.54	2571.54	0.0
2017-05-19	B	Futures	37.7	38.6	37.69	38.45	333274.0
2017-05-19	B6	Futures	1.3574	1.3683	1.3569	1.3674	95910.0
2017-05-19	BFX	Futures	4712.2	4785.5	4712.2	4783.0	29.0
2017-05-19	BR	Futures	0.21492	0.22256	0.21445	0.22162	8114.0
2017-05-19	BZ	Futures	37.4	38.3	37.4	38.17	34681.0
2017-05-19	C	Futures	1622.0	1624.0	1577.0	1581.0	11151.0
2017-05-19	CB	Futures	295.99	296.631	293.854	295.044	17.0
2017-05-19	CC	Futures	1590.0	1593.0	1543.0	1550.0	22301.0
2017-05-19	CNH	Futures	7.1858	7.186	7.1738	7.1738	110.0
2017-05-19	CSC	Futures	3.598	3.643	3.598	3.623	90.0
2017-05-19	CT	Futures	87.93	88.05	86.85	87.99	21076.0
2017-05-19	DC	Futures	30.28	30.65	30.24	30.46	418.0
2017-05-19	DX	Futures	91.038	91.061	90.339	90.399	26378.0
2017-05-19	E1	Futures	1.26282	1.27258	1.26232	1.27147	28168.0
2017-05-19	E6	Futures	1.28041	1.29326	1.28018	1.29245	198552.0
2017-05-19	E7	Futures	1.2739	1.2866	1.2739	1.2859	3883.0
2017-05-19	EBM	Futures	184.83	185.39	184.28	184.56	4086.0
2017-05-19	ED	Futures	95.6075	95.6075	95.5881	95.593	298590.0
2017-05-19	ER	Futures	98.337	98.342	98.332	98.337	48497.0
2017-05-19	EW	Futures	1798.4	1826.2	1795.5	1818.5	18833.0
2017-05-19	FBON	Futures	123.43	123.53	123.18	123.29	712.0
2017-05-19	FBTP	Futures	107.08	107.32	107.03	107.18	73773.0
2017-05-19	FBTS	Futures	102.507	102.553	102.498	102.516	23962.0
2017-05-19	FCE	Futures	4722.3	4747.4	4707.9	4738.0	95727.0
2017-05-19	FDAX	Futures	13328.3	13360.5	13295.6	13339.9	75202.0
2017-05-19	FDIV	Futures	150.79	151.23	150.79	151.23	3.0
2017-05-19	FDXM	Futures	13210.2	13243.7	13178.8	13222.7	20751.0
2017-05-19	FESX	Futures	2899.4	2914.9	2893.6	2910.8	1016725.0
2017-05-19	FEU3	Futures	99.011	99.011	99.011	99.011	5.0
2017-05-19	FGBL	Futures	148.39	148.47	148.12	148.24	484731.0
2017-05-19	FGBM	Futures	129.32	129.34	129.19	129.22	346219.0
2017-05-19	FGBS	Futures	112.247	112.267	112.222	112.237	181322.0
2017-05-19	FGBX	Futures	166.69	166.93	165.91	166.13	35221.0
2017-05-19	FMWO	Futures	6331.4	6388.0	6331.4	6380.8	2539.0
2017-05-19	FOAT	Futures	134.8	134.84	134.59	134.7	78820.0
2017-05-19	FTDX	Futures	2159.7	2177.3	2159.7	2173.4	158.0
2017-05-19	FTI	Futures	481.58	483.13	480.29	482.58	27044.0
2017-05-19	FTUK	Futures	6380.2	6395.2	6364.8	6372.9	103510.0
2017-05-19	FVSA	Futures	573.92	577.31	545.14	546.84	14023.0
2017-05-19	FXXP	Futures	328.0	329.5	327.4	329.2	29551.0
2017-05-19	G	Futures	115.92	115.96	115.58	115.76	138986.0

> showing 50 of 112 rows — these rows as CSV

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