PREVIEW / futures_daily / 2017-11-15

all futures daily files

  file:    by_date/futures_daily/2017/2017-11-15.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-11-15	ES	Futures	2802.72	2802.99	2779.6	2789.94	1917948.0
2017-11-15	NQ	Futures	7392.42	7393.89	7318.71	7360.41	399624.0
2017-11-15	YM	Futures	24674.4	24674.4	24504.4	24564.5	166036.0
2017-11-15	CL	Futures	55.31	55.8	55.13	55.58	319259.0
2017-11-15	GC	Futures	1629.6	1641.4	1624.2	1625.8	433647.0
2017-11-15	ZN	Futures	123.039216	123.455149	123.008406	123.285695	1794617.0
2017-11-15	A6	Futures	0.78475	0.78496	0.77889	0.78002	125331.0
2017-11-15	AD	Futures	0.79911	0.80058	0.7958	0.79712	73910.0
2017-11-15	B	Futures	43.54	43.95	43.36	43.76	279411.0
2017-11-15	B6	Futures	1.3733	1.3789	1.3702	1.3737	128981.0
2017-11-15	BR	Futures	0.22698	0.22751	0.22642	0.22694	4735.0
2017-11-15	BZ	Futures	43.11	43.55	42.98	43.37	27356.0
2017-11-15	C	Futures	1573.0	1574.0	1528.0	1547.0	13427.0
2017-11-15	CB	Futures	289.109	289.109	287.502	288.164	5.0
2017-11-15	CC	Futures	1608.0	1613.0	1574.0	1588.0	25490.0
2017-11-15	CNH	Futures	6.8204	6.8239	6.8099	6.8189	93.0
2017-11-15	CSC	Futures	3.427	3.439	3.416	3.439	37.0
2017-11-15	CT	Futures	80.61	80.94	80.56	80.82	12974.0
2017-11-15	DC	Futures	27.91	27.91	27.63	27.84	285.0
2017-11-15	DX	Futures	87.69	87.718	87.255	87.649	25251.0
2017-11-15	E1	Futures	1.23824	1.24423	1.23616	1.2391	30220.0
2017-11-15	E6	Futures	1.3483	1.35572	1.34705	1.34791	289868.0
2017-11-15	E7	Futures	1.3413	1.3486	1.3399	1.3408	6664.0
2017-11-15	EBM	Futures	172.08	172.35	171.27	171.81	33181.0
2017-11-15	ED	Futures	95.4745	95.4794	95.4697	95.4721	302747.0
2017-11-15	ER	Futures	98.347	98.347	98.342	98.347	11052.0
2017-11-15	EW	Futures	1939.7	1940.6	1918.4	1932.0	22456.0
2017-11-15	FBON	Futures	125.87	126.05	125.7	125.71	257.0
2017-11-15	FBTP	Futures	112.58	112.75	112.3	112.46	85753.0
2017-11-15	FBTS	Futures	103.704	103.768	103.686	103.75	83197.0
2017-11-15	FCE	Futures	4747.7	4756.2	4713.7	4745.9	144006.0
2017-11-15	FDAX	Futures	13641.2	13659.1	13497.8	13648.6	116587.0
2017-11-15	FDXM	Futures	13529.2	13542.8	13383.3	13533.4	42661.0
2017-11-15	FESX	Futures	2884.6	2895.2	2867.5	2892.8	1233287.0
2017-11-15	FGBL	Futures	150.28	150.79	150.24	150.38	783453.0
2017-11-15	FGBM	Futures	130.05	130.2	130.02	130.07	446502.0
2017-11-15	FGBS	Futures	112.532	112.562	112.532	112.547	244790.0
2017-11-15	FGBX	Futures	168.2	169.52	168.2	168.38	50748.0
2017-11-15	FMWO	Futures	6722.6	6736.8	6703.7	6735.6	2093.0
2017-11-15	FOAT	Futures	138.33	138.88	138.32	138.47	118804.0
2017-11-15	FTDX	Futures	2474.5	2474.5	2426.6	2452.0	604.0
2017-11-15	FTI	Futures	500.41	501.38	496.0	498.88	42341.0
2017-11-15	FTUK	Futures	6399.6	6417.4	6366.2	6386.6	116356.0
2017-11-15	FVSA	Futures	363.87	367.4	353.31	354.48	36704.0
2017-11-15	FXXP	Futures	324.4	324.7	322.3	324.4	49405.0
2017-11-15	G	Futures	114.22	114.59	114.18	114.3	184210.0
2017-11-15	GF	Futures	332.03	333.813	330.246	333.489	6185.0
2017-11-15	GSCI	Futures	489.25	490.77	489.08	490.71	75.0
2017-11-15	HE	Futures	89.0	90.402	87.486	90.255	24660.0
2017-11-15	HG	Futures	3.6874	3.7019	3.665	3.6898	111057.0

> showing 50 of 108 rows — these rows as CSV

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