PREVIEW / futures_daily / 2018-07-06

all futures daily files

  file:    by_date/futures_daily/2018/2018-07-06.parquet
  size:    10 KB
  rows:    114

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-07-06	ES	Futures	2972.65	3004.42	2966.4	3000.89	1287758.0
2018-07-06	NQ	Futures	8299.76	8438.51	8279.36	8433.55	320304.0
2018-07-06	YM	Futures	25624.7	25822.8	25542.6	25769.1	168009.0
2018-07-06	CL	Futures	74.11	74.97	73.07	74.75	611419.0
2018-07-06	GC	Futures	1606.6	1608.9	1600.6	1603.3	200193.0
2018-07-06	ZN	Futures	119.681004	119.960705	119.541153	119.681004	992184.0
2018-07-06	A6	Futures	0.75966	0.76573	0.75874	0.76398	90594.0
2018-07-06	AD	Futures	0.77189	0.77543	0.77113	0.77391	60973.0
2018-07-06	B	Futures	57.22	57.3	56.33	56.88	315279.0
2018-07-06	B6	Futures	1.3683	1.3755	1.3663	1.3729	96625.0
2018-07-06	BR	Futures	0.19249	0.19614	0.19191	0.19603	43.0
2018-07-06	BTC	Futures	9245.6	9459.3	9160.2	9352.5	2038.0
2018-07-06	BZ	Futures	56.92	57.01	56.03	56.57	25487.0
2018-07-06	C	Futures	1711.0	1729.0	1683.0	1707.0	5418.0
2018-07-06	CB	Futures	265.656	267.665	265.656	267.665	67.0
2018-07-06	CC	Futures	1783.0	1789.0	1722.0	1767.0	16817.0
2018-07-06	CNH	Futures	6.7483	6.7587	6.7351	6.739	67.0
2018-07-06	CSC	Futures	3.238	3.238	3.206	3.22	70.0
2018-07-06	CT	Futures	93.51	96.32	93.48	96.1	35.0
2018-07-06	DC	Futures	25.56	25.58	25.25	25.36	218.0
2018-07-06	DX	Futures	89.146	89.25	88.625	88.809	19778.0
2018-07-06	E1	Futures	1.20982	1.2164	1.20887	1.21413	18854.0
2018-07-06	E6	Futures	1.31403	1.32303	1.31297	1.32024	224361.0
2018-07-06	E7	Futures	1.3075	1.3163	1.3064	1.3135	3634.0
2018-07-06	EBM	Futures	194.59	195.11	193.02	193.8	17040.0
2018-07-06	ED	Futures	94.9815	94.9961	94.9815	94.9864	124808.0
2018-07-06	ER	Futures	98.362	98.367	98.362	98.367	21491.0
2018-07-06	EW	Futures	2089.9	2114.0	2085.1	2109.7	10572.0
2018-07-06	FBON	Futures	128.99	129.2	128.97	129.05	181.0
2018-07-06	FBTP	Futures	107.79	108.16	107.54	107.65	43894.0
2018-07-06	FBTS	Futures	102.42	102.614	102.179	102.336	41468.0
2018-07-06	FCE	Futures	4840.2	4854.1	4802.0	4830.3	56510.0
2018-07-06	FDAX	Futures	13076.1	13113.2	12975.2	13046.8	72650.0
2018-07-06	FDXM	Futures	12907.0	12945.2	12810.0	12880.1	27293.0
2018-07-06	FESX	Futures	2881.4	2887.3	2857.2	2871.4	821900.0
2018-07-06	FGBL	Futures	153.12	153.52	153.09	153.42	428971.0
2018-07-06	FGBM	Futures	131.14	131.3	131.12	131.25	260718.0
2018-07-06	FGBS	Futures	112.729	112.764	112.718	112.749	214373.0
2018-07-06	FGBX	Futures	178.64	179.12	178.12	178.78	37125.0
2018-07-06	FMWO	Futures	6998.4	7046.1	6984.4	7039.2	2582.0
2018-07-06	FOAT	Futures	141.21	141.49	141.19	141.37	65293.0
2018-07-06	FTDX	Futures	2684.3	2711.2	2681.8	2700.9	591.0
2018-07-06	FTI	Futures	512.34	513.58	507.72	510.86	22589.0
2018-07-06	FTUK	Futures	6728.3	6761.3	6689.1	6724.8	69573.0
2018-07-06	FVSA	Futures	304.2	311.97	292.53	300.31	24746.0
2018-07-06	FXXP	Futures	330.7	330.7	327.5	329.2	39789.0
2018-07-06	G	Futures	115.59	115.82	115.54	115.66	124254.0
2018-07-06	GF	Futures	316.743	319.177	314.982	315.293	6506.0
2018-07-06	GSCI	Futures	534.72	539.26	534.72	539.21	131.0
2018-07-06	HE	Futures	84.103	85.774	83.852	84.047	20053.0

> showing 50 of 114 rows — these rows as CSV

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