PREVIEW / futures_daily / 2018-04-16

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-16.parquet
  size:    10 KB
  rows:    112

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
2018-04-16	ES	Futures	2907.07	2922.03	2893.48	2916.32	1237183.0
2018-04-16	NQ	Futures	7811.76	7867.65	7770.8	7855.95	324486.0
2018-04-16	YM	Futures	25749.3	25960.0	25683.0	25874.7	199910.0
2018-04-16	CL	Futures	67.54	67.93	66.33	66.44	370368.0
2018-04-16	GC	Futures	1723.3	1728.0	1714.3	1724.4	269549.0
2018-04-16	ZN	Futures	119.571168	119.586677	119.323031	119.571168	988126.0
2018-04-16	A6	Futures	0.79854	0.80039	0.7971	0.80008	63882.0
2018-04-16	AD	Futures	0.80453	0.8063	0.80245	0.80609	50145.0
2018-04-16	B	Futures	52.84	52.95	51.69	51.91	297437.0
2018-04-16	B6	Futures	1.4793	1.4895	1.478	1.4881	100216.0
2018-04-16	BR	Futures	0.22132	0.22231	0.2206	0.22193	3761.0
2018-04-16	BTC	Futures	11368.4	11993.2	11190.8	11332.9	3858.0
2018-04-16	BZ	Futures	52.1	52.29	51.03	51.24	33532.0
2018-04-16	C	Futures	1614.0	1676.0	1613.0	1672.0	7821.0
2018-04-16	CB	Futures	290.791	290.791	290.791	290.791	39.0
2018-04-16	CC	Futures	1885.0	1979.0	1869.0	1971.0	35438.0
2018-04-16	CNH	Futures	6.3707	6.3707	6.3688	6.3688	5.0
2018-04-16	CSC	Futures	3.381	3.398	3.381	3.39	7.0
2018-04-16	CT	Futures	95.69	96.6	95.41	95.69	12700.0
2018-04-16	DC	Futures	27.1	27.23	27.08	27.14	60.0
2018-04-16	DX	Futures	84.41	84.462	84.019	84.066	17091.0
2018-04-16	E1	Futures	1.25741	1.26392	1.25609	1.26127	16565.0
2018-04-16	E6	Futures	1.39522	1.40265	1.39471	1.40113	176680.0
2018-04-16	E7	Futures	1.3882	1.395	1.3873	1.3937	2227.0
2018-04-16	EBM	Futures	176.66	176.66	175.32	175.86	29470.0
2018-04-16	ED	Futures	94.9306	94.9452	94.9257	94.9452	298940.0
2018-04-16	ER	Futures	98.342	98.342	98.337	98.342	18786.0
2018-04-16	EW	Futures	2002.6	2021.8	1998.0	2016.4	11142.0
2018-04-16	FBON	Futures	129.89	129.91	129.67	129.82	307.0
2018-04-16	FBTP	Futures	115.57	115.63	115.29	115.55	55729.0
2018-04-16	FBTS	Futures	104.195	104.195	104.158	104.167	25724.0
2018-04-16	FCE	Futures	4685.8	4692.0	4667.5	4679.5	55732.0
2018-04-16	FDAX	Futures	12987.6	12997.4	12867.5	12881.6	94848.0
2018-04-16	FDXM	Futures	12872.9	12880.2	12753.5	12766.9	28251.0
2018-04-16	FESX	Futures	2813.9	2818.1	2797.3	2802.3	747655.0
2018-04-16	FEU3	Futures	99.026	99.026	99.026	99.026	3.0
2018-04-16	FGBL	Futures	149.85	149.88	149.38	149.77	622585.0
2018-04-16	FGBM	Futures	129.68	129.68	129.5	129.63	330091.0
2018-04-16	FGBS	Futures	112.517	112.522	112.487	112.507	173639.0
2018-04-16	FGBX	Futures	170.43	170.43	169.23	170.14	43414.0
2018-04-16	FMWO	Futures	6936.3	6983.0	6936.3	6960.8	908.0
2018-04-16	FOAT	Futures	139.01	139.01	138.56	138.94	127004.0
2018-04-16	FTDX	Futures	2577.1	2604.3	2566.7	2576.1	160.0
2018-04-16	FTI	Futures	500.84	501.02	498.11	498.57	5138.0
2018-04-16	FTUK	Futures	6372.7	6387.3	6294.9	6308.6	97162.0
2018-04-16	FVSA	Futures	367.38	370.82	355.9	362.79	19686.0
2018-04-16	FXXP	Futures	323.0	323.6	321.1	321.8	33898.0
2018-04-16	G	Futures	113.43	113.47	113.12	113.33	147701.0
2018-04-16	GF	Futures	304.293	306.983	301.442	302.087	6463.0
2018-04-16	GSCI	Futures	524.49	525.17	522.52	522.97	158.0

> showing 50 of 112 rows — these rows as CSV

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