PREVIEW / futures_daily / 2017-10-18

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-18.parquet
  size:    9 KB
  rows:    111

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-10-18	ES	Futures	2780.69	2786.94	2780.42	2784.5	753384.0
2017-10-18	NQ	Futures	7191.27	7203.6	7174.53	7187.74	180414.0
2017-10-18	YM	Futures	24249.9	24418.8	24246.7	24408.3	85637.0
2017-10-18	CL	Futures	52.61	53.0	52.36	52.7	555505.0
2017-10-18	GC	Futures	1637.5	1642.4	1626.9	1632.5	258543.0
2017-10-18	ZN	Futures	123.655413	123.670818	123.285695	123.378124	1059325.0
2017-10-18	A6	Futures	0.80667	0.8079	0.80399	0.80687	82912.0
2017-10-18	AD	Futures	0.81284	0.81702	0.81208	0.81666	71840.0
2017-10-18	ALI	Futures	2673.81	2673.81	2673.81	2673.81	0.0
2017-10-18	B	Futures	41.07	41.34	40.78	41.07	329325.0
2017-10-18	B6	Futures	1.3779	1.3805	1.3724	1.3788	112151.0
2017-10-18	BR	Futures	0.23653	0.2369	0.23615	0.2369	35.0
2017-10-18	BZ	Futures	40.67	41.0	40.45	40.73	25606.0
2017-10-18	C	Futures	1524.0	1537.0	1517.0	1526.0	7214.0
2017-10-18	CB	Futures	307.627	307.69	306.209	306.209	29.0
2017-10-18	CC	Futures	1534.0	1550.0	1527.0	1535.0	19642.0
2017-10-18	CNH	Futures	6.8	6.8259	6.8	6.8161	32.0
2017-10-18	CSC	Futures	3.487	3.493	3.466	3.487	55.0
2017-10-18	CT	Futures	79.65	80.07	79.33	79.44	10302.0
2017-10-18	DC	Futures	28.33	28.58	28.14	28.44	264.0
2017-10-18	DX	Futures	87.288	87.582	87.171	87.183	15594.0
2017-10-18	E1	Futures	1.25475	1.25572	1.24765	1.25157	20220.0
2017-10-18	E6	Futures	1.34688	1.35133	1.34266	1.3511	190602.0
2017-10-18	E7	Futures	1.3398	1.3441	1.3356	1.344	3902.0
2017-10-18	EBM	Futures	175.05	175.05	173.97	174.24	13702.0
2017-10-18	ED	Futures	95.4939	95.4988	95.4842	95.4939	235961.0
2017-10-18	ER	Futures	98.342	98.342	98.337	98.337	20233.0
2017-10-18	EW	Futures	1930.6	1940.8	1930.6	1936.2	8456.0
2017-10-18	FBON	Futures	125.49	125.54	124.83	124.84	527.0
2017-10-18	FBTP	Futures	110.58	110.72	110.06	110.14	96329.0
2017-10-18	FBTS	Futures	103.448	103.484	103.429	103.429	64392.0
2017-10-18	FCE	Futures	4804.2	4831.5	4800.6	4821.2	136429.0
2017-10-18	FDAX	Futures	13673.8	13756.9	13658.1	13694.3	64659.0
2017-10-18	FDIV	Futures	153.06	153.06	152.93	152.93	8.0
2017-10-18	FDXM	Futures	13558.4	13639.7	13543.8	13578.8	18541.0
2017-10-18	FESX	Futures	2940.1	2952.3	2936.0	2945.0	604462.0
2017-10-18	FEU3	Futures	99.011	99.011	99.006	99.006	2.0
2017-10-18	FGBL	Futures	150.4	150.5	149.91	149.96	721446.0
2017-10-18	FGBM	Futures	129.98	130.03	129.81	129.84	454796.0
2017-10-18	FGBS	Futures	112.502	112.512	112.472	112.482	208597.0
2017-10-18	FGBX	Futures	169.79	170.03	168.56	168.77	55497.0
2017-10-18	FMWO	Futures	6749.8	6756.9	6749.8	6752.1	441.0
2017-10-18	FOAT	Futures	137.82	137.88	137.31	137.37	94257.0
2017-10-18	FTDX	Futures	2510.4	2534.4	2507.4	2513.4	167.0
2017-10-18	FTI	Futures	505.24	507.24	504.41	505.75	38083.0
2017-10-18	FTUK	Futures	6515.4	6529.3	6500.2	6517.2	56501.0
2017-10-18	FVSA	Futures	352.99	356.83	342.76	346.6	17707.0
2017-10-18	FXXP	Futures	331.3	332.6	331.0	332.0	19157.0
2017-10-18	G	Futures	114.35	114.4	113.86	113.96	162142.0
2017-10-18	GF	Futures	327.965	329.15	325.055	327.749	4656.0

> showing 50 of 111 rows — these rows as CSV

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