PREVIEW / futures_daily / 2018-06-29

all futures daily files

  file:    by_date/futures_daily/2018/2018-06-29.parquet
  size:    10 KB
  rows:    116

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-06-29	ES	Futures	2954.19	2981.88	2950.66	2955.82	1641889.0
2018-06-29	NQ	Futures	8225.73	8305.59	8213.78	8239.14	396079.0
2018-06-29	YM	Futures	25548.9	25811.3	25506.7	25567.8	207549.0
2018-06-29	CL	Futures	74.28	75.42	73.87	75.11	602399.0
2018-06-29	GC	Futures	1595.2	1604.9	1591.9	1601.6	226196.0
2018-06-29	ZN	Futures	119.603309	119.634387	119.401303	119.525614	1402554.0
2018-06-29	A6	Futures	0.75606	0.76234	0.75462	0.7609	107731.0
2018-06-29	AD	Futures	0.7648	0.77234	0.76429	0.77138	113037.0
2018-06-29	B	Futures	57.2	58.69	56.92	58.44	414942.0
2018-06-29	B6	Futures	1.3535	1.368	1.353	1.3656	150305.0
2018-06-29	BR	Futures	0.19767	0.19767	0.19519	0.19519	483.0
2018-06-29	BTC	Futures	8398.0	8447.9	8198.6	8355.3	2512.0
2018-06-29	BZ	Futures	56.84	58.36	56.6	58.13	37117.0
2018-06-29	C	Futures	1706.0	1733.0	1683.0	1727.0	3923.0
2018-06-29	CB	Futures	278.549	279.749	278.489	279.719	31.0
2018-06-29	CC	Futures	1759.0	1816.0	1730.0	1801.0	27541.0
2018-06-29	CNH	Futures	6.7388	6.7388	6.7085	6.7211	43.0
2018-06-29	CSC	Futures	3.315	3.355	3.297	3.339	74.0
2018-06-29	CT	Futures	95.27	97.72	95.03	95.56	33.0
2018-06-29	DC	Futures	26.33	26.63	26.11	26.58	149.0
2018-06-29	DX	Futures	89.998	90.027	89.212	89.358	28018.0
2018-06-29	E1	Futures	1.2054	1.2158	1.20516	1.21353	31907.0
2018-06-29	E6	Futures	1.30033	1.31492	1.3001	1.31257	338579.0
2018-06-29	E7	Futures	1.2939	1.3082	1.2936	1.3059	5702.0
2018-06-29	EBM	Futures	182.82	187.79	182.03	186.74	24753.0
2018-06-29	ED	Futures	94.9961	94.9961	94.9864	94.9864	144159.0
2018-06-29	ER	Futures	98.362	98.367	98.357	98.362	162416.0
2018-06-29	EW	Futures	2071.8	2089.0	2068.7	2071.0	19104.0
2018-06-29	FBON	Futures	128.58	129.12	128.55	129.05	568.0
2018-06-29	FBTP	Futures	107.1	107.86	107.06	107.72	66344.0
2018-06-29	FBTS	Futures	102.587	102.735	102.234	102.642	44922.0
2018-06-29	FCE	Futures	4762.9	4813.2	4758.4	4781.3	82647.0
2018-06-29	FDAX	Futures	12793.8	12930.3	12793.8	12866.5	96223.0
2018-06-29	FDIV	Futures	146.71	146.75	144.82	146.57	485.0
2018-06-29	FDXM	Futures	12632.5	12765.6	12632.5	12702.1	39479.0
2018-06-29	FESX	Futures	2818.0	2849.7	2813.8	2832.2	1199288.0
2018-06-29	FEU3	Futures	99.016	99.016	99.011	99.011	70.0
2018-06-29	FGBL	Futures	152.79	153.26	152.51	153.17	699743.0
2018-06-29	FGBM	Futures	131.17	131.25	130.82	131.22	499789.0
2018-06-29	FGBS	Futures	112.774	112.779	112.663	112.769	502348.0
2018-06-29	FGBX	Futures	176.17	178.06	175.87	177.84	67442.0
2018-06-29	FMWO	Futures	6979.8	7003.1	6962.3	7001.9	1287.0
2018-06-29	FOAT	Futures	140.32	141.13	140.32	141.09	148439.0
2018-06-29	FTDX	Futures	2626.9	2646.5	2622.5	2634.8	220.0
2018-06-29	FTI	Futures	508.0	512.1	506.47	509.1	31506.0
2018-06-29	FTUK	Futures	6766.2	6813.0	6729.7	6772.4	123796.0
2018-06-29	FVSA	Futures	323.63	328.49	310.03	317.8	22897.0
2018-06-29	FXXP	Futures	326.0	328.7	325.8	327.6	54969.0
2018-06-29	G	Futures	115.44	115.61	115.09	115.46	214809.0
2018-06-29	GF	Futures	304.314	313.48	302.398	313.48	8985.0

> showing 50 of 116 rows — these rows as CSV

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