PREVIEW / futures_daily / 2017-01-04

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-04.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-01-04	ES	Futures	2442.21	2457.93	2440.31	2454.67	1404875.0
2017-01-04	NQ	Futures	5782.84	5825.27	5778.72	5814.66	171952.0
2017-01-04	YM	Futures	20853.2	20940.6	20841.6	20914.3	104361.0
2017-01-04	CL	Futures	56.17	57.18	55.81	57.0	512641.0
2017-01-04	GC	Futures	1489.2	1500.7	1485.4	1496.5	179878.0
2017-01-04	ZN	Futures	121.415748	121.553287	121.140672	121.385184	1153515.0
2017-01-04	A6	Futures	0.73828	0.74504	0.73787	0.74268	86827.0
2017-01-04	AD	Futures	0.76126	0.76969	0.75952	0.76775	70131.0
2017-01-04	ALI	Futures	2309.68	2309.68	2309.68	2309.68	0.0
2017-01-04	B	Futures	41.52	42.13	41.22	42.06	282545.0
2017-01-04	B6	Futures	1.2855	1.2977	1.2837	1.2937	91122.0
2017-01-04	BR	Futures	0.21672	0.21775	0.21668	0.2176	792.0
2017-01-04	BZ	Futures	41.18	41.8	40.92	41.75	27804.0
2017-01-04	C	Futures	1819.0	1879.0	1819.0	1872.0	10784.0
2017-01-04	CB	Futures	271.609	272.402	269.748	272.402	23.0
2017-01-04	CC	Futures	1656.0	1710.0	1649.0	1703.0	22189.0
2017-01-04	CNH	Futures	7.4763	7.477	7.3853	7.3853	204.0
2017-01-04	CSC	Futures	4.006	4.006	3.949	3.965	69.0
2017-01-04	CT	Futures	82.46	85.27	82.22	85.1	37052.0
2017-01-04	DC	Futures	32.88	32.96	32.52	32.59	167.0
2017-01-04	DX	Futures	96.228	96.293	95.329	95.631	36179.0
2017-01-04	E1	Futures	1.21186	1.21967	1.20913	1.21608	20688.0
2017-01-04	E6	Futures	1.20613	1.21652	1.20382	1.21265	197711.0
2017-01-04	E7	Futures	1.2001	1.2101	1.1976	1.2065	3538.0
2017-01-04	EBM	Futures	192.56	193.7	191.71	193.42	17635.0
2017-01-04	ED	Futures	95.5858	95.5906	95.581	95.581	158044.0
2017-01-04	ER	Futures	98.293	98.293	98.288	98.293	24953.0
2017-01-04	EW	Futures	1775.6	1806.0	1775.3	1803.8	23533.0
2017-01-04	FBON	Futures	122.52	122.54	122.08	122.16	67.0
2017-01-04	FBTP	Futures	106.78	106.94	106.53	106.59	63162.0
2017-01-04	FBTS	Futures	101.9	101.936	101.873	101.9	15226.0
2017-01-04	FCE	Futures	4320.5	4325.4	4290.6	4308.2	69525.0
2017-01-04	FDAX	Futures	12242.0	12263.7	12169.7	12216.2	64717.0
2017-01-04	FDXM	Futures	12195.9	12212.7	12119.1	12166.9	16432.0
2017-01-04	FESX	Futures	2651.1	2655.1	2633.5	2643.1	735562.0
2017-01-04	FEU3	Futures	98.956	98.961	98.956	98.961	4.0
2017-01-04	FGBL	Futures	147.42	147.56	147.09	147.17	654983.0
2017-01-04	FGBM	Futures	129.11	129.17	129.05	129.09	459215.0
2017-01-04	FGBS	Futures	112.177	112.207	112.167	112.197	218449.0
2017-01-04	FGBX	Futures	169.61	169.89	167.93	168.17	48520.0
2017-01-04	FMWO	Futures	5897.3	5926.2	5897.3	5925.0	280.0
2017-01-04	FOAT	Futures	133.08	133.18	132.59	132.65	118620.0
2017-01-04	FTDX	Futures	1803.8	1819.0	1796.0	1799.4	85.0
2017-01-04	FTI	Futures	444.7	445.56	442.51	443.47	21041.0
2017-01-04	FTUK	Futures	6045.3	6052.5	6023.2	6037.2	76951.0
2017-01-04	FVSA	Futures	1030.43	1033.17	986.58	1003.03	15806.0
2017-01-04	FXXP	Futures	303.0	303.0	300.5	301.4	19184.0
2017-01-04	G	Futures	111.66	111.77	111.42	111.59	140324.0
2017-01-04	GF	Futures	289.335	291.008	285.765	286.658	3473.0
2017-01-04	GSCI	Futures	518.46	524.82	518.33	524.76	230.0

> showing 50 of 109 rows — these rows as CSV

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