PREVIEW / futures_daily / 2019-10-09

all futures daily files

  file:    by_date/futures_daily/2019/2019-10-09.parquet
  size:    10 KB
  rows:    121

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
2019-10-09	ES	Futures	3132.41	3176.52	3126.73	3160.01	1305749.0
2019-10-09	NQ	Futures	8782.6	8910.52	8763.58	8873.35	404170.0
2019-10-09	YM	Futures	27440.5	27714.5	27384.8	27614.8	165144.0
2019-10-09	CL	Futures	53.97	55.17	53.71	53.99	632666.0
2019-10-09	GC	Futures	1863.8	1872.5	1856.6	1866.1	285278.0
2019-10-09	ZN	Futures	130.564562	130.6265	130.069061	130.10003	1192798.0
2019-10-09	A6	Futures	0.69168	0.69393	0.69116	0.69157	64731.0
2019-10-09	AD	Futures	0.75653	0.75809	0.75562	0.75607	57867.0
2019-10-09	ALI	Futures	2110.93	2117.87	2105.8	2114.85	120.0
2019-10-09	B	Futures	45.96	47.02	45.88	46.2	266484.0
2019-10-09	B6	Futures	1.2451	1.2528	1.2431	1.2443	94196.0
2019-10-09	BFX	Futures	4331.4	4354.3	4331.4	4354.3	6.0
2019-10-09	BR	Futures	0.19687	0.19736	0.19614	0.19667	17.0
2019-10-09	BTC	Futures	11772.2	12628.0	11685.9	12433.8	4716.0
2019-10-09	BZ	Futures	45.38	46.35	45.27	45.55	36036.0
2019-10-09	C	Futures	1706.0	1706.0	1672.0	1687.0	11580.0
2019-10-09	CB	Futures	248.987	249.164	247.983	247.983	28.0
2019-10-09	CC	Futures	1606.0	1616.0	1574.0	1580.0	13962.0
2019-10-09	CNH	Futures	7.1542	7.1542	7.1205	7.1312	803.0
2019-10-09	CSC	Futures	3.18	3.216	3.171	3.209	46.0
2019-10-09	CT	Futures	59.69	60.72	59.36	60.44	13585.0
2019-10-09	DC	Futures	26.66	26.96	26.57	26.87	393.0
2019-10-09	DX	Futures	95.474	95.556	95.295	95.507	11274.0
2019-10-09	E1	Futures	1.16473	1.16611	1.16059	1.16094	18382.0
2019-10-09	E6	Futures	1.19296	1.19686	1.19285	1.19491	116311.0
2019-10-09	E7	Futures	1.1869	1.1906	1.1867	1.1888	2049.0
2019-10-09	EBM	Futures	194.54	195.91	194.0	195.64	27793.0
2019-10-09	ED	Futures	95.4103	95.4201	95.3909	95.3958	360937.0
2019-10-09	ER	Futures	98.47	98.47	98.455	98.46	50707.0
2019-10-09	EW	Futures	1955.6	1976.2	1952.7	1968.1	11754.0
2019-10-09	FBON	Futures	146.25	146.25	146.01	146.02	163.0
2019-10-09	FBTP	Futures	132.28	132.36	131.9	132.07	53425.0
2019-10-09	FBTS	Futures	108.5	108.548	108.481	108.51	34802.0
2019-10-09	FCE	Futures	4947.7	5002.4	4929.5	4977.1	64761.0
2019-10-09	FDAX	Futures	12622.3	12839.1	12598.6	12741.5	100322.0
2019-10-09	FDIV	Futures	145.81	146.14	145.58	145.58	120.0
2019-10-09	FDXM	Futures	12451.8	12671.5	12434.1	12575.2	39943.0
2019-10-09	FESX	Futures	3000.1	3042.2	2994.0	3022.9	846348.0
2019-10-09	FEU3	Futures	99.149	99.159	99.149	99.159	297.0
2019-10-09	FGBL	Futures	168.59	168.63	167.94	168.13	481564.0
2019-10-09	FGBM	Futures	135.31	135.34	135.04	135.12	322330.0
2019-10-09	FGBS	Futures	113.046	113.056	112.971	113.006	233523.0
2019-10-09	FGBX	Futures	225.53	225.89	223.6	224.25	32578.0
2019-10-09	FMWO	Futures	7076.5	7135.6	7067.4	7110.6	1270.0
2019-10-09	FOAT	Futures	155.29	155.38	154.79	154.94	80479.0
2019-10-09	FTDX	Futures	2646.9	2687.4	2643.5	2686.4	116.0
2019-10-09	FTI	Futures	534.89	538.59	532.48	536.48	24389.0
2019-10-09	FTUK	Futures	6585.5	6641.5	6585.5	6612.8	87209.0
2019-10-09	FVSA	Futures	209.39	212.2	197.04	203.22	35185.0
2019-10-09	FXXP	Futures	341.8	344.3	340.6	342.6	67613.0

> showing 50 of 121 rows — these rows as CSV

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