PREVIEW / futures_daily / 2017-02-03

all futures daily files

  file:    by_date/futures_daily/2017/2017-02-03.parquet
  size:    9 KB
  rows:    109

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-02-03	ES	Futures	2465.24	2486.92	2461.45	2483.67	1415043.0
2017-02-03	NQ	Futures	6045.67	6084.27	6034.18	6075.72	181444.0
2017-02-03	YM	Futures	20874.2	21073.3	20837.4	21051.2	132981.0
2017-02-03	CL	Futures	57.45	58.02	57.15	57.61	462616.0
2017-02-03	GC	Futures	1555.7	1562.6	1543.6	1559.5	217983.0
2017-02-03	ZN	Futures	121.614415	122.088158	121.369902	121.553287	1887958.0
2017-02-03	A6	Futures	0.78355	0.78744	0.77976	0.78539	97738.0
2017-02-03	AD	Futures	0.78429	0.78644	0.78097	0.7846	48803.0
2017-02-03	ALI	Futures	2483.81	2483.81	2483.81	2483.81	0.0
2017-02-03	B	Futures	41.97	42.25	41.58	41.89	264757.0
2017-02-03	B6	Futures	1.3154	1.316	1.307	1.31	91247.0
2017-02-03	BFX	Futures	4373.0	4373.0	4373.0	4373.0	2.0
2017-02-03	BR	Futures	0.22621	0.22792	0.22528	0.22706	1483.0
2017-02-03	BZ	Futures	41.7	42.03	41.37	41.68	26703.0
2017-02-03	C	Futures	1752.0	1757.0	1731.0	1749.0	11895.0
2017-02-03	CB	Futures	270.419	270.419	267.367	267.398	11.0
2017-02-03	CC	Futures	1596.0	1601.0	1577.0	1590.0	23309.0
2017-02-03	CNH	Futures	7.2366	7.2472	7.2099	7.2147	24.0
2017-02-03	CSC	Futures	4.013	4.013	3.942	3.969	50.0
2017-02-03	CT	Futures	88.15	88.63	87.55	87.78	20700.0
2017-02-03	DC	Futures	33.38	33.49	32.59	32.9	491.0
2017-02-03	DX	Futures	92.946	93.453	92.662	92.962	49522.0
2017-02-03	E1	Futures	1.25078	1.25338	1.24223	1.24967	22906.0
2017-02-03	E6	Futures	1.24488	1.24892	1.23882	1.24534	206821.0
2017-02-03	E7	Futures	1.2383	1.2424	1.232	1.239	3537.0
2017-02-03	EBM	Futures	193.13	193.42	191.71	192.85	11018.0
2017-02-03	ED	Futures	95.5762	95.5955	95.5665	95.5762	361766.0
2017-02-03	ER	Futures	98.303	98.303	98.298	98.298	59830.0
2017-02-03	EW	Futures	1790.5	1816.6	1786.7	1815.2	15775.0
2017-02-03	FBON	Futures	120.35	120.5	119.97	120.05	1180.0
2017-02-03	FBTP	Futures	103.81	103.96	103.54	103.66	97989.0
2017-02-03	FBTS	Futures	101.539	101.575	101.494	101.53	20591.0
2017-02-03	FCE	Futures	4219.7	4269.1	4219.7	4248.4	74863.0
2017-02-03	FDAX	Futures	12266.8	12351.8	12266.8	12310.1	68868.0
2017-02-03	FDXM	Futures	12216.9	12299.9	12216.9	12260.5	21784.0
2017-02-03	FESX	Futures	2600.7	2626.3	2600.7	2620.7	786345.0
2017-02-03	FGBL	Futures	146.23	146.71	146.11	146.54	656877.0
2017-02-03	FGBM	Futures	128.67	128.83	128.61	128.79	478963.0
2017-02-03	FGBS	Futures	112.142	112.177	112.127	112.172	290167.0
2017-02-03	FGBX	Futures	164.59	165.28	163.86	164.75	38873.0
2017-02-03	FMWO	Futures	5998.6	6038.4	5998.6	6037.2	193.0
2017-02-03	FOAT	Futures	130.26	130.4	129.98	130.06	122558.0
2017-02-03	FTDX	Futures	1823.9	1823.9	1814.6	1819.0	61.0
2017-02-03	FTI	Futures	438.55	443.2	438.41	441.92	29141.0
2017-02-03	FTUK	Futures	6013.1	6051.6	5988.5	6049.1	81173.0
2017-02-03	FVSA	Futures	826.58	826.58	767.37	769.74	18087.0
2017-02-03	FXXP	Futures	299.8	301.7	299.8	301.2	27339.0
2017-02-03	G	Futures	110.74	111.44	110.69	111.34	147938.0
2017-02-03	GF	Futures	282.915	284.625	280.977	281.718	4156.0
2017-02-03	GSCI	Futures	526.51	530.53	526.51	527.83	330.0

> showing 50 of 109 rows — these rows as CSV

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