PREVIEW / futures_daily / 2018-09-06

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-06.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-09-06	ES	Futures	3137.19	3142.08	3114.93	3126.88	1633946.0
2018-09-06	NQ	Futures	8779.24	8796.15	8636.71	8694.71	650890.0
2018-09-06	YM	Futures	27385.5	27501.4	27284.3	27422.3	201868.0
2018-09-06	CL	Futures	71.5	71.89	69.79	70.59	633824.0
2018-09-06	GC	Futures	1524.1	1537.0	1521.5	1526.4	284202.0
2018-09-06	ZN	Futures	119.463458	119.681004	119.385764	119.634387	55714.0
2018-09-06	A6	Futures	0.73981	0.74166	0.73703	0.74084	102640.0
2018-09-06	AD	Futures	0.769	0.77168	0.76591	0.77128	80839.0
2018-09-06	B	Futures	56.14	56.68	55.13	55.76	274791.0
2018-09-06	B6	Futures	1.3325	1.3378	1.331	1.3348	101708.0
2018-09-06	BR	Futures	0.18254	0.18357	0.18182	0.18357	2.0
2018-09-06	BTC	Futures	9904.0	9904.0	8888.6	9196.1	5796.0
2018-09-06	BZ	Futures	55.98	56.43	54.9	55.52	31739.0
2018-09-06	C	Futures	1540.0	1554.0	1526.0	1531.0	3651.0
2018-09-06	CB	Futures	260.993	264.958	260.993	262.255	63.0
2018-09-06	CC	Futures	1616.0	1629.0	1581.0	1593.0	15029.0
2018-09-06	CNH	Futures	6.9201	6.93	6.9062	6.9186	315.0
2018-09-06	CSC	Futures	3.347	3.351	3.299	3.301	102.0
2018-09-06	CT	Futures	91.57	91.97	91.31	91.31	12.0
2018-09-06	DC	Futures	27.55	27.63	27.13	27.16	246.0
2018-09-06	DX	Futures	90.013	90.14	89.861	89.963	17385.0
2018-09-06	E1	Futures	1.23145	1.23922	1.23098	1.23803	28411.0
2018-09-06	E6	Futures	1.30173	1.3048	1.29876	1.30106	238352.0
2018-09-06	E7	Futures	1.2953	1.298	1.292	1.2945	3193.0
2018-09-06	EBM	Futures	206.9	208.2	205.86	206.12	17780.0
2018-09-06	ED	Futures	95.0935	95.0959	95.0813	95.0886	222780.0
2018-09-06	ER	Futures	98.372	98.372	98.367	98.372	25615.0
2018-09-06	EW	Futures	2159.9	2167.0	2147.2	2151.4	15694.0
2018-09-06	FBON	Futures	128.6	128.65	128.38	128.57	604.0
2018-09-06	FBTP	Futures	106.45	107.5	106.45	106.88	85306.0
2018-09-06	FBTS	Futures	102.396	102.911	102.34	102.621	74597.0
2018-09-06	FCE	Futures	4739.5	4768.8	4720.6	4724.2	87019.0
2018-09-06	FDAX	Futures	12564.4	12638.6	12474.5	12492.8	106007.0
2018-09-06	FDIV	Futures	143.3	143.39	143.3	143.39	1.0
2018-09-06	FDXM	Futures	12404.4	12477.7	12314.6	12333.2	44373.0
2018-09-06	FESX	Futures	2767.9	2780.4	2749.5	2752.8	1252665.0
2018-09-06	FEU3	Futures	99.021	99.021	99.021	99.021	100.0
2018-09-06	FGBL	Futures	153.05	153.58	153.04	153.53	684379.0
2018-09-06	FGBM	Futures	130.89	131.13	130.89	131.11	482167.0
2018-09-06	FGBS	Futures	112.583	112.628	112.583	112.623	352052.0
2018-09-06	FGBX	Futures	176.93	178.32	176.93	178.2	41981.0
2018-09-06	FMWO	Futures	7149.8	7173.1	7120.7	7128.8	1645.0
2018-09-06	FOAT	Futures	140.62	141.04	140.62	141.01	268688.0
2018-09-06	FTDX	Futures	2854.9	2874.0	2831.8	2837.7	202.0
2018-09-06	FTI	Futures	507.21	507.3	499.46	500.25	31532.0
2018-09-06	FTUK	Futures	6578.6	6592.5	6511.8	6519.0	122036.0
2018-09-06	FVSA	Futures	286.56	292.66	278.72	287.43	33939.0
2018-09-06	FXXP	Futures	324.4	325.6	322.5	323.0	63342.0
2018-09-06	G	Futures	114.87	115.21	114.8	115.19	220566.0
2018-09-06	GF	Futures	315.994	317.034	315.058	315.734	1166.0

> showing 50 of 116 rows — these rows as CSV

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