PREVIEW / futures_daily / 2017-03-17

all futures daily files

  file:    by_date/futures_daily/2017/2017-03-17.parquet
  size:    9 KB
  rows:    108

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-03-17	ES	Futures	2583.97	2587.23	2576.91	2579.62	1277357.0
2017-03-17	NQ	Futures	6378.61	6389.8	6367.72	6370.07	143955.0
2017-03-17	YM	Futures	22034.0	22083.6	22007.6	22014.0	105018.0
2017-03-17	CL	Futures	51.66	52.1	51.46	51.68	345780.0
2017-03-17	GC	Futures	1566.4	1573.2	1563.6	1571.6	153151.0
2017-03-17	ZN	Futures	121.308693	121.800319	121.293329	121.677412	845989.0
2017-03-17	A6	Futures	0.78707	0.79097	0.78533	0.78995	77771.0
2017-03-17	AD	Futures	0.76671	0.76752	0.76329	0.76548	54982.0
2017-03-17	ALI	Futures	2556.86	2556.86	2556.86	2556.86	0.0
2017-03-17	B	Futures	37.78	38.1	37.63	37.8	220349.0
2017-03-17	B6	Futures	1.2991	1.3036	1.295	1.3027	99021.0
2017-03-17	BFX	Futures	4584.4	4593.4	4584.4	4593.4	50.0
2017-03-17	BR	Futures	0.22821	0.22966	0.22821	0.22966	692.0
2017-03-17	BZ	Futures	37.6	37.92	37.46	37.63	20151.0
2017-03-17	C	Futures	1716.0	1721.0	1694.0	1697.0	6035.0
2017-03-17	CB	Futures	265.476	267.001	265.476	267.001	17.0
2017-03-17	CC	Futures	1553.0	1562.0	1531.0	1537.0	12750.0
2017-03-17	CNH	Futures	7.2159	7.2256	7.2159	7.2256	25.0
2017-03-17	CSC	Futures	3.578	3.627	3.569	3.603	137.0
2017-03-17	CT	Futures	87.04	87.61	86.83	87.34	8908.0
2017-03-17	DC	Futures	29.12	29.7	28.99	29.57	303.0
2017-03-17	DX	Futures	93.227	93.427	93.138	93.274	23348.0
2017-03-17	E1	Futures	1.24725	1.24984	1.24379	1.24564	17466.0
2017-03-17	E6	Futures	1.2462	1.24759	1.24137	1.24292	188293.0
2017-03-17	E7	Futures	1.2398	1.2413	1.235	1.2366	3617.0
2017-03-17	EBM	Futures	192.94	192.94	192.1	192.66	10746.0
2017-03-17	ED	Futures	95.5252	95.5349	95.5204	95.5252	212909.0
2017-03-17	ER	Futures	98.303	98.313	98.303	98.303	69096.0
2017-03-17	EW	Futures	1837.2	1842.3	1832.8	1837.3	15570.0
2017-03-17	FBON	Futures	119.14	119.58	118.89	119.44	672.0
2017-03-17	FBTP	Futures	102.81	103.04	102.35	102.83	102644.0
2017-03-17	FBTS	Futures	101.537	101.546	101.428	101.492	35541.0
2017-03-17	FCE	Futures	4409.4	4432.8	4398.4	4424.0	90430.0
2017-03-17	FDAX	Futures	12756.1	12826.3	12719.7	12780.9	73473.0
2017-03-17	FDXM	Futures	12648.2	12714.2	12608.5	12668.6	19344.0
2017-03-17	FESX	Futures	2741.0	2759.8	2734.5	2746.7	1128826.0
2017-03-17	FEU3	Futures	98.981	98.981	98.981	98.981	4.0
2017-03-17	FGBL	Futures	146.43	146.95	146.21	146.88	632663.0
2017-03-17	FGBM	Futures	128.72	128.93	128.59	128.9	473891.0
2017-03-17	FGBS	Futures	112.302	112.332	112.262	112.302	255640.0
2017-03-17	FGBX	Futures	164.63	166.09	164.23	165.95	44696.0
2017-03-17	FMWO	Futures	6244.7	6244.7	6244.7	6244.7	0.0
2017-03-17	FOAT	Futures	129.98	130.19	129.62	130.03	116230.0
2017-03-17	FTDX	Futures	1943.0	1964.1	1943.0	1960.7	1161.0
2017-03-17	FTI	Futures	466.16	468.52	464.7	467.75	33483.0
2017-03-17	FTUK	Futures	6281.3	6311.3	6271.9	6288.2	108239.0
2017-03-17	FVSA	Futures	658.58	661.35	650.26	653.03	14816.0
2017-03-17	FXXP	Futures	311.9	314.0	311.8	313.3	38315.0
2017-03-17	G	Futures	113.47	113.96	113.35	113.91	133260.0
2017-03-17	GF	Futures	301.196	304.194	300.331	303.559	4026.0

> showing 50 of 108 rows — these rows as CSV

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