PREVIEW / futures_daily / 2018-09-17

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-17.parquet
  size:    10 KB
  rows:    113

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-17	ES	Futures	3154.84	3157.28	3136.68	3140.74	1783534.0
2018-09-17	NQ	Futures	8788.39	8798.56	8662.66	8670.79	451747.0
2018-09-17	YM	Futures	27578.2	27612.9	27449.7	27486.5	146163.0
2018-09-17	CL	Futures	71.92	72.75	71.51	71.9	235309.0
2018-09-17	GC	Futures	1520.6	1533.2	1517.7	1528.3	209936.0
2018-09-17	ZN	Futures	118.685804	118.763621	118.514608	118.654678	1063405.0
2018-09-17	A6	Futures	0.73621	0.74074	0.73519	0.7391	58676.0
2018-09-17	AD	Futures	0.77674	0.77901	0.77628	0.77754	41394.0
2018-09-17	B	Futures	56.9	57.51	56.65	56.89	207609.0
2018-09-17	B6	Futures	1.3498	1.3592	1.3494	1.3589	84888.0
2018-09-17	BR	Futures	0.18155	0.18292	0.18148	0.18292	47.0
2018-09-17	BTC	Futures	9253.3	9331.9	8817.1	8910.0	2337.0
2018-09-17	BZ	Futures	56.66	57.25	56.41	56.65	21749.0
2018-09-17	C	Futures	1467.0	1496.0	1465.0	1468.0	8871.0
2018-09-17	CB	Futures	268.323	268.323	267.362	267.362	18.0
2018-09-17	CC	Futures	1552.0	1605.0	1550.0	1562.0	23911.0
2018-09-17	CNH	Futures	6.9454	6.9521	6.9269	6.9298	591.0
2018-09-17	CSC	Futures	3.244	3.256	3.24	3.242	33.0
2018-09-17	CT	Futures	91.94	92.39	91.46	91.46	19.0
2018-09-17	DC	Futures	26.78	26.93	26.64	26.76	127.0
2018-09-17	DX	Futures	89.826	89.835	89.303	89.37	13983.0
2018-09-17	E1	Futures	1.23527	1.24309	1.23467	1.24143	20267.0
2018-09-17	E6	Futures	1.30202	1.3098	1.30085	1.30841	163078.0
2018-09-17	E7	Futures	1.2953	1.3034	1.2943	1.302	2781.0
2018-09-17	EBM	Futures	206.9	208.46	205.6	205.86	21023.0
2018-09-17	ED	Futures	95.0818	95.0915	95.0769	95.0866	225996.0
2018-09-17	ER	Futures	98.372	98.377	98.372	98.372	41075.0
2018-09-17	EW	Futures	2157.3	2161.6	2137.9	2138.9	49582.0
2018-09-17	FBON	Futures	128.36	128.39	128.04	128.14	335.0
2018-09-17	FBTP	Futures	107.88	109.06	107.86	108.87	71359.0
2018-09-17	FBTS	Futures	102.93	103.361	102.93	103.305	43346.0
2018-09-17	FCE	Futures	4800.4	4819.8	4793.6	4811.2	105438.0
2018-09-17	FDAX	Futures	12680.4	12732.5	12643.6	12707.2	31719.0
2018-09-17	FDXM	Futures	12449.4	12511.4	12423.6	12487.2	984.0
2018-09-17	FESX	Futures	2783.1	2800.7	2783.1	2798.2	1434646.0
2018-09-17	FGBL	Futures	152.43	152.44	152.01	152.19	489765.0
2018-09-17	FGBM	Futures	130.69	130.71	130.5	130.56	435558.0
2018-09-17	FGBS	Futures	112.557	112.557	112.517	112.532	282138.0
2018-09-17	FGBX	Futures	175.31	175.66	174.71	175.41	36894.0
2018-09-17	FMWO	Futures	7199.9	7225.5	7199.9	7216.2	5234.0
2018-09-17	FOAT	Futures	140.24	140.31	140.02	140.15	126900.0
2018-09-17	FTDX	Futures	2848.5	2851.4	2845.5	2851.4	391.0
2018-09-17	FTI	Futures	500.39	503.22	499.79	501.65	15241.0
2018-09-17	FTUK	Futures	6498.5	6507.4	6458.3	6490.5	250458.0
2018-09-17	FVSA	Futures	261.39	264.84	257.94	260.53	33562.0
2018-09-17	FXXP	Futures	325.2	326.5	325.1	326.2	157328.0
2018-09-17	G	Futures	114.17	114.36	114.05	114.17	145443.0
2018-09-17	GF	Futures	330.504	332.168	327.435	331.128	5666.0
2018-09-17	GSCI	Futures	522.44	522.61	519.25	519.25	80.0
2018-09-17	HE	Futures	76.136	76.203	72.243	74.324	33637.0

> showing 50 of 113 rows — these rows as CSV

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