PREVIEW / futures_daily / 2018-03-23

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-23.parquet
  size:    10 KB
  rows:    112

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-03-23	ES	Futures	2877.17	2891.31	2812.19	2824.97	2875654.0
2018-03-23	NQ	Futures	7832.83	7866.78	7630.06	7671.31	748098.0
2018-03-23	YM	Futures	25280.6	25390.1	24750.7	24872.9	483124.0
2018-03-23	CL	Futures	64.55	66.28	64.38	66.16	752994.0
2018-03-23	GC	Futures	1697.6	1724.9	1697.5	1724.3	454126.0
2018-03-23	ZN	Futures	119.648711	119.974391	119.524642	119.710745	1801888.0
2018-03-23	A6	Futures	0.79134	0.79648	0.79062	0.7935	125183.0
2018-03-23	AD	Futures	0.78348	0.79016	0.78323	0.78778	89191.0
2018-03-23	B	Futures	49.88	50.93	49.7	50.84	283010.0
2018-03-23	B6	Futures	1.4661	1.473	1.464	1.4702	103132.0
2018-03-23	BR	Futures	0.22856	0.22883	0.22856	0.22883	3.0
2018-03-23	BTC	Futures	11999.2	12165.6	11472.1	11950.6	2895.0
2018-03-23	BZ	Futures	49.12	50.31	49.05	50.22	49285.0
2018-03-23	C	Futures	1663.0	1708.0	1655.0	1700.0	10888.0
2018-03-23	CB	Futures	279.394	279.394	279.208	279.208	12.0
2018-03-23	CC	Futures	1859.0	1934.0	1842.0	1919.0	25707.0
2018-03-23	CNH	Futures	6.4278	6.4278	6.4244	6.4244	1.0
2018-03-23	CSC	Futures	3.31	3.31	3.268	3.287	34.0
2018-03-23	CT	Futures	94.58	94.7	93.55	94.06	14903.0
2018-03-23	DC	Futures	26.1	26.28	25.94	26.17	120.0
2018-03-23	DX	Futures	84.245	84.264	83.915	83.97	22742.0
2018-03-23	E1	Futures	1.27873	1.28451	1.27777	1.28162	23166.0
2018-03-23	E6	Futures	1.39527	1.40293	1.39522	1.40214	185899.0
2018-03-23	E7	Futures	1.3879	1.3954	1.3875	1.3947	2548.0
2018-03-23	EBM	Futures	174.79	175.59	174.52	175.05	16224.0
2018-03-23	ED	Futures	95.0035	95.0132	94.9841	94.9938	399464.0
2018-03-23	ER	Futures	98.337	98.337	98.332	98.337	36596.0
2018-03-23	EW	Futures	1989.3	1997.7	1948.1	1949.6	21553.0
2018-03-23	FBON	Futures	129.41	129.6	128.99	129.58	360.0
2018-03-23	FBTP	Futures	114.56	114.67	114.08	114.65	104583.0
2018-03-23	FBTS	Futures	104.121	104.149	104.065	104.139	44714.0
2018-03-23	FCE	Futures	4468.3	4512.5	4434.4	4481.6	117720.0
2018-03-23	FDAX	Futures	12390.1	12477.4	12219.1	12373.5	147004.0
2018-03-23	FDIV	Futures	142.78	143.23	142.78	143.23	140.0
2018-03-23	FDXM	Futures	12281.8	12365.2	12109.8	12263.3	60551.0
2018-03-23	FESX	Futures	2674.0	2695.6	2643.2	2677.3	1737145.0
2018-03-23	FEU3	Futures	99.021	99.021	99.021	99.021	4.0
2018-03-23	FGBL	Futures	149.53	149.64	149.2	149.5	715641.0
2018-03-23	FGBM	Futures	129.58	129.59	129.43	129.56	440688.0
2018-03-23	FGBS	Futures	112.563	112.568	112.542	112.563	240277.0
2018-03-23	FGBX	Futures	170.95	171.09	170.06	170.62	52619.0
2018-03-23	FMWO	Futures	6832.4	6866.2	6717.9	6827.7	6050.0
2018-03-23	FOAT	Futures	138.74	138.79	138.41	138.73	110832.0
2018-03-23	FTDX	Futures	2523.2	2537.0	2487.5	2526.1	399.0
2018-03-23	FTI	Futures	476.75	480.24	471.65	476.61	43534.0
2018-03-23	FTUK	Futures	5988.3	6068.3	5979.0	6050.2	150491.0
2018-03-23	FVSA	Futures	461.36	487.52	445.9	464.92	51350.0
2018-03-23	FXXP	Futures	308.6	311.6	306.5	310.2	55839.0
2018-03-23	G	Futures	113.59	113.72	113.03	113.38	206875.0
2018-03-23	GF	Futures	299.912	300.239	295.393	296.427	4697.0

> showing 50 of 112 rows — these rows as CSV

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