PREVIEW / futures_daily / 2018-09-20

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-20.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-09-20	ES	Futures	3162.98	3189.28	3159.45	3187.92	1474453.0
2018-09-20	NQ	Futures	8746.0	8847.05	8727.7	8837.76	403730.0
2018-09-20	YM	Futures	27890.9	28163.6	27860.4	28144.7	163186.0
2018-09-20	CL	Futures	74.3	74.69	73.31	73.61	607520.0
2018-09-20	GC	Futures	1532.1	1537.6	1527.4	1535.2	241605.0
2018-09-20	ZN	Futures	118.234468	118.265595	117.969892	118.125525	1614630.0
2018-09-20	A6	Futures	0.74774	0.75072	0.74671	0.75052	79038.0
2018-09-20	AD	Futures	0.78371	0.78619	0.78351	0.78452	70832.0
2018-09-20	B	Futures	57.9	58.19	57.22	57.36	300163.0
2018-09-20	B6	Futures	1.3572	1.373	1.3561	1.3697	144282.0
2018-09-20	BR	Futures	0.18376	0.18932	0.18376	0.18685	83.0
2018-09-20	BTC	Futures	9103.1	9203.2	9024.4	9153.2	1373.0
2018-09-20	BZ	Futures	57.57	57.93	56.99	57.12	22855.0
2018-09-20	C	Futures	1450.0	1464.0	1441.0	1447.0	6265.0
2018-09-20	CB	Futures	270.426	270.426	270.366	270.366	5.0
2018-09-20	CC	Futures	1532.0	1560.0	1527.0	1537.0	17907.0
2018-09-20	CNH	Futures	6.9169	6.9236	6.8984	6.8984	439.0
2018-09-20	CSC	Futures	3.248	3.258	3.248	3.258	24.0
2018-09-20	CT	Futures	89.27	89.67	87.79	88.72	38.0
2018-09-20	DC	Futures	26.71	26.86	26.71	26.86	84.0
2018-09-20	DX	Futures	89.455	89.455	88.733	88.815	28353.0
2018-09-20	E1	Futures	1.23503	1.24546	1.2342	1.24463	29623.0
2018-09-20	E6	Futures	1.30669	1.31908	1.30607	1.31808	266685.0
2018-09-20	E7	Futures	1.3001	1.3126	1.2998	1.3116	4825.0
2018-09-20	EBM	Futures	209.76	210.79	208.98	210.53	25246.0
2018-09-20	ED	Futures	95.0818	95.0818	95.0476	95.0525	482313.0
2018-09-20	ER	Futures	98.381	98.381	98.372	98.372	77466.0
2018-09-20	EW	Futures	2144.2	2160.5	2141.7	2157.6	14093.0
2018-09-20	FBON	Futures	127.93	128.14	127.79	127.82	976.0
2018-09-20	FBTP	Futures	109.16	109.62	108.66	108.95	77703.0
2018-09-20	FBTS	Futures	103.314	103.417	103.014	103.099	51628.0
2018-09-20	FCE	Futures	4855.8	4914.4	4850.4	4904.1	75399.0
2018-09-20	FDAX	Futures	12825.5	12986.4	12813.4	12950.7	57656.0
2018-09-20	FDXM	Futures	12613.7	12761.5	12593.1	12726.4	3496.0
2018-09-20	FESX	Futures	2812.5	2852.8	2810.8	2845.3	1381159.0
2018-09-20	FEU3	Futures	98.996	99.001	98.996	99.001	1.0
2018-09-20	FGBL	Futures	151.91	152.1	151.57	151.92	734969.0
2018-09-20	FGBM	Futures	130.47	130.54	130.36	130.47	513294.0
2018-09-20	FGBS	Futures	112.522	112.537	112.502	112.532	357258.0
2018-09-20	FGBX	Futures	174.34	174.79	173.76	174.36	38433.0
2018-09-20	FMWO	Futures	7268.3	7328.6	7268.3	7312.4	6147.0
2018-09-20	FOAT	Futures	139.84	139.96	139.6	139.85	157223.0
2018-09-20	FTDX	Futures	2809.7	2809.7	2754.2	2773.8	926.0
2018-09-20	FTI	Futures	503.83	509.21	503.73	507.82	18868.0
2018-09-20	FTUK	Futures	6545.4	6569.1	6511.0	6548.5	131917.0
2018-09-20	FVSA	Futures	258.8	259.66	250.17	251.9	22669.0
2018-09-20	FXXP	Futures	327.5	330.5	327.5	329.9	55593.0
2018-09-20	G	Futures	113.53	113.77	113.35	113.63	274365.0
2018-09-20	GF	Futures	329.516	331.024	326.915	327.175	5024.0
2018-09-20	GSCI	Futures	529.39	530.0	527.82	527.93	57.0

> showing 50 of 114 rows — these rows as CSV

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