PREVIEW / futures_daily / 2019-09-16

all futures daily files

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

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-09-16	ES	Futures	3244.18	3253.39	3229.84	3249.33	1698082.0
2019-09-16	NQ	Futures	9079.35	9098.36	8986.86	9080.5	336745.0
2019-09-16	YM	Futures	28470.3	28527.0	28353.8	28428.3	143151.0
2019-09-16	CL	Futures	61.76	65.59	60.18	64.34	733511.0
2019-09-16	GC	Futures	1866.5	1874.6	1854.5	1864.5	349611.0
2019-09-16	ZN	Futures	127.684462	128.056088	127.591555	127.901243	1602081.0
2019-09-16	A6	Futures	0.70635	0.70799	0.70491	0.70656	60143.0
2019-09-16	AD	Futures	0.76171	0.76343	0.76	0.76181	81587.0
2019-09-16	ALI	Futures	2199.68	2199.68	2172.51	2177.94	71.0
2019-09-16	B	Futures	51.32	55.57	50.01	53.31	735539.0
2019-09-16	B6	Futures	1.2753	1.2754	1.2652	1.2677	102344.0
2019-09-16	BFX	Futures	4462.3	4462.9	4462.3	4462.9	28.0
2019-09-16	BR	Futures	0.19703	0.19703	0.19643	0.19675	25.0
2019-09-16	BTC	Futures	14766.0	14901.7	14437.3	14480.2	2313.0
2019-09-16	BZ	Futures	50.98	54.03	49.29	52.52	69899.0
2019-09-16	C	Futures	1571.0	1613.0	1571.0	1603.0	11340.0
2019-09-16	CB	Futures	263.04	263.04	262.154	262.744	24.0
2019-09-16	CC	Futures	1534.0	1568.0	1524.0	1564.0	23609.0
2019-09-16	CNH	Futures	7.0446	7.0741	7.0446	7.0651	764.0
2019-09-16	CSC	Futures	3.126	3.18	3.126	3.175	168.0
2019-09-16	CT	Futures	60.54	60.85	60.54	60.82	56.0
2019-09-16	DC	Futures	26.36	26.9	26.36	26.76	334.0
2019-09-16	DX	Futures	94.454	94.985	94.348	94.889	13702.0
2019-09-16	E1	Futures	1.17371	1.17486	1.16611	1.1683	24185.0
2019-09-16	E6	Futures	1.20846	1.20954	1.19957	1.20103	155489.0
2019-09-16	E7	Futures	1.2019	1.2036	1.1934	1.1948	4341.0
2019-09-16	EBM	Futures	186.33	188.25	185.51	187.98	23040.0
2019-09-16	ED	Futures	95.2014	95.2111	95.182	95.1917	398671.0
2019-09-16	ER	Futures	98.44	98.445	98.426	98.435	113841.0
2019-09-16	EW	Futures	2054.1	2074.6	2047.7	2068.5	42217.0
2019-09-16	FBON	Futures	144.86	145.05	144.18	145.05	201.0
2019-09-16	FBTP	Futures	131.9	132.41	131.53	132.31	64736.0
2019-09-16	FBTS	Futures	108.317	108.568	108.317	108.539	48161.0
2019-09-16	FCE	Futures	5082.5	5090.2	5062.6	5062.6	103951.0
2019-09-16	FDAX	Futures	13065.5	13079.7	12977.5	13057.6	107779.0
2019-09-16	FDXM	Futures	12864.2	12916.2	12820.4	12895.4	1414.0
2019-09-16	FESX	Futures	3095.7	3095.7	3065.0	3078.1	1220196.0
2019-09-16	FEU3	Futures	99.129	99.134	99.129	99.134	101.0
2019-09-16	FGBL	Futures	166.65	167.25	166.54	167.1	600072.0
2019-09-16	FGBM	Futures	134.7	134.87	134.68	134.85	409465.0
2019-09-16	FGBS	Futures	112.89	112.94	112.88	112.925	323194.0
2019-09-16	FGBX	Futures	217.33	219.97	216.88	218.99	55829.0
2019-09-16	FMWO	Futures	7385.6	7405.2	7370.6	7398.3	19674.0
2019-09-16	FOAT	Futures	153.88	154.29	153.6	154.11	89356.0
2019-09-16	FTDX	Futures	2812.3	2836.0	2812.3	2836.0	793.0
2019-09-16	FTI	Futures	544.85	545.66	542.96	543.66	9357.0
2019-09-16	FTUK	Futures	6745.3	6794.0	6738.9	6776.4	249974.0
2019-09-16	FVSA	Futures	182.45	184.13	180.2	181.88	38826.0
2019-09-16	FXXP	Futures	351.5	352.0	350.3	351.3	227153.0
2019-09-16	G	Futures	120.27	120.96	120.16	120.93	187327.0

> showing 50 of 119 rows — these rows as CSV

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