PREVIEW / futures_daily / 2018-09-28

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-28.parquet
  size:    10 KB
  rows:    115

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-09-28	ES	Futures	3169.21	3172.74	3153.76	3165.69	1429127.0
2018-09-28	NQ	Futures	8901.35	8917.03	8847.34	8891.77	381496.0
2018-09-28	YM	Futures	27903.5	27941.5	27744.5	27880.4	177168.0
2018-09-28	CL	Futures	75.56	77.18	75.24	76.68	544047.0
2018-09-28	GC	Futures	1504.2	1518.4	1501.0	1516.1	307816.0
2018-09-28	ZN	Futures	118.296722	118.530171	118.265595	118.312285	1713641.0
2018-09-28	A6	Futures	0.74228	0.74547	0.74146	0.74362	68867.0
2018-09-28	AD	Futures	0.77684	0.78488	0.77663	0.78371	82704.0
2018-09-28	B	Futures	59.84	61.29	59.73	60.79	350243.0
2018-09-28	B6	Futures	1.35	1.351	1.3417	1.3458	105180.0
2018-09-28	BR	Futures	0.19012	0.19012	0.1875	0.1875	1202.0
2018-09-28	BTC	Futures	9668.3	9819.8	9408.5	9625.0	4965.0
2018-09-28	BZ	Futures	59.34	60.81	59.27	60.33	38868.0
2018-09-28	C	Futures	1418.0	1430.0	1384.0	1385.0	11050.0
2018-09-28	CB	Futures	275.773	275.773	273.039	273.159	17.0
2018-09-28	CC	Futures	1477.0	1492.0	1434.0	1437.0	29092.0
2018-09-28	CNH	Futures	6.9393	6.9449	6.9306	6.9369	500.0
2018-09-28	CSC	Futures	3.238	3.238	3.232	3.238	31.0
2018-09-28	CT	Futures	87.19	87.43	85.61	85.72	19848.0
2018-09-28	DC	Futures	26.96	26.96	26.78	26.91	181.0
2018-09-28	DX	Futures	89.897	90.234	89.821	89.998	23143.0
2018-09-28	E1	Futures	1.22164	1.22567	1.21524	1.21891	41631.0
2018-09-28	E6	Futures	1.30224	1.30341	1.29429	1.29885	299911.0
2018-09-28	E7	Futures	1.2957	1.2969	1.2879	1.2925	5246.0
2018-09-28	EBM	Futures	208.72	210.27	207.16	209.5	16519.0
2018-09-28	ED	Futures	95.0525	95.072	95.0525	95.0671	254984.0
2018-09-28	ER	Futures	98.377	98.377	98.367	98.377	163034.0
2018-09-28	EW	Futures	2125.8	2135.8	2113.7	2129.5	16584.0
2018-09-28	FBON	Futures	127.92	128.05	127.66	127.98	1169.0
2018-09-28	FBTP	Futures	107.7	107.91	105.53	106.61	220313.0
2018-09-28	FBTS	Futures	102.789	102.864	101.74	102.321	152752.0
2018-09-28	FCE	Futures	4985.6	4987.9	4916.7	4948.7	95554.0
2018-09-28	FDAX	Futures	13053.2	13062.1	12801.9	12872.3	111113.0
2018-09-28	FDIV	Futures	145.14	145.36	145.14	145.36	13.0
2018-09-28	FDXM	Futures	12826.6	12836.9	12580.7	12649.4	58961.0
2018-09-28	FESX	Futures	2881.4	2883.1	2826.8	2845.3	1483555.0
2018-09-28	FGBL	Futures	151.73	152.41	151.59	151.97	1054419.0
2018-09-28	FGBM	Futures	130.24	130.51	130.17	130.39	775591.0
2018-09-28	FGBS	Futures	112.492	112.532	112.467	112.507	764350.0
2018-09-28	FGBX	Futures	175.49	176.93	175.25	175.94	76493.0
2018-09-28	FMWO	Futures	7298.5	7298.5	7253.3	7292.7	1107.0
2018-09-28	FOAT	Futures	139.53	139.98	139.38	139.71	203347.0
2018-09-28	FTDX	Futures	2770.4	2789.6	2753.7	2763.0	205.0
2018-09-28	FTI	Futures	512.87	513.62	506.84	509.86	32269.0
2018-09-28	FTUK	Futures	6704.5	6721.9	6647.3	6690.6	118583.0
2018-09-28	FVSA	Futures	249.31	268.29	249.31	259.66	54183.0
2018-09-28	FXXP	Futures	333.1	333.1	329.5	330.9	71554.0
2018-09-28	G	Futures	113.83	114.09	113.67	113.73	292318.0
2018-09-28	GF	Futures	328.684	329.308	327.175	329.048	1342.0
2018-09-28	GSCI	Futures	541.15	546.2	541.15	544.8	39.0

> showing 50 of 115 rows — these rows as CSV

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