PREVIEW / futures_daily / 2018-11-15

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-15.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-11-15	ES	Futures	2930.35	2968.04	2897.0	2965.6	2383852.0
2018-11-15	NQ	Futures	7875.14	8038.34	7796.45	8032.53	793461.0
2018-11-15	YM	Futures	26403.0	26693.6	26096.5	26647.3	350722.0
2018-11-15	CL	Futures	59.5	60.82	59.04	59.97	589346.0
2018-11-15	GC	Futures	1535.9	1542.4	1529.9	1539.9	253571.0
2018-11-15	ZN	Futures	118.218905	118.623551	118.141088	118.343412	2392837.0
2018-11-15	A6	Futures	0.74465	0.75134	0.74414	0.75052	134091.0
2018-11-15	AD	Futures	0.76369	0.769	0.76359	0.76829	73840.0
2018-11-15	B	Futures	48.87	49.83	48.61	49.24	316040.0
2018-11-15	B6	Futures	1.3377	1.3418	1.3102	1.3177	273286.0
2018-11-15	BR	Futures	0.20068	0.20266	0.20056	0.20205	853.0
2018-11-15	BTC	Futures	7976.0	8091.8	7462.1	7853.0	8633.0
2018-11-15	BZ	Futures	48.39	49.48	48.27	48.9	35140.0
2018-11-15	C	Futures	1470.0	1500.0	1468.0	1481.0	2856.0
2018-11-15	CB	Futures	268.563	271.567	268.563	270.996	46.0
2018-11-15	CC	Futures	1517.0	1561.0	1512.0	1529.0	27664.0
2018-11-15	CNH	Futures	6.9879	6.9885	6.9645	6.9721	755.0
2018-11-15	CSC	Futures	2.986	2.986	2.964	2.978	105.0
2018-11-15	CT	Futures	85.81	86.28	85.14	85.59	14328.0
2018-11-15	DC	Futures	24.88	24.93	24.66	24.83	408.0
2018-11-15	DX	Futures	91.987	92.381	91.792	91.95	36080.0
2018-11-15	E1	Futures	1.18122	1.18406	1.17885	1.18158	27393.0
2018-11-15	E6	Futures	1.26099	1.26627	1.25599	1.26494	242762.0
2018-11-15	E7	Futures	1.2547	1.2599	1.2497	1.2587	5680.0
2018-11-15	EBM	Futures	209.24	209.5	207.68	208.72	34228.0
2018-11-15	ED	Futures	94.989	94.9987	94.9694	94.9743	419834.0
2018-11-15	ER	Futures	98.381	98.386	98.381	98.386	30836.0
2018-11-15	EW	Futures	1936.7	1964.5	1919.0	1959.8	17737.0
2018-11-15	FBON	Futures	127.16	127.2	126.88	127.04	974.0
2018-11-15	FBTP	Futures	104.69	104.84	103.98	104.46	93532.0
2018-11-15	FBTS	Futures	102.546	102.574	102.143	102.368	78182.0
2018-11-15	FCE	Futures	4530.9	4557.3	4453.5	4491.1	96522.0
2018-11-15	FDAX	Futures	12015.3	12087.9	11825.0	11929.1	135650.0
2018-11-15	FDXM	Futures	11806.7	11879.1	11619.7	11722.5	70558.0
2018-11-15	FESX	Futures	2692.4	2705.8	2650.4	2673.1	1429025.0
2018-11-15	FGBL	Futures	153.26	154.0	153.19	153.9	1050591.0
2018-11-15	FGBM	Futures	131.15	131.51	131.14	131.45	546703.0
2018-11-15	FGBS	Futures	112.683	112.764	112.683	112.739	521095.0
2018-11-15	FGBX	Futures	177.21	178.6	177.01	178.36	63426.0
2018-11-15	FMWO	Futures	6737.7	6755.0	6639.2	6692.5	2727.0
2018-11-15	FOAT	Futures	140.27	140.78	140.23	140.7	157909.0
2018-11-15	FTDX	Futures	2546.0	2560.7	2498.3	2524.8	153.0
2018-11-15	FTI	Futures	488.22	490.4	482.23	486.92	17033.0
2018-11-15	FTUK	Futures	6259.4	6339.9	6232.2	6276.4	172209.0
2018-11-15	FVSA	Futures	338.68	358.84	331.63	354.81	27943.0
2018-11-15	FXXP	Futures	314.1	314.9	308.0	310.0	64699.0
2018-11-15	G	Futures	114.77	116.04	114.73	115.84	491830.0
2018-11-15	GF	Futures	315.517	318.746	314.872	318.262	5741.0
2018-11-15	GSCI	Futures	489.59	489.59	485.24	485.24	38.0
2018-11-15	HE	Futures	76.74	77.679	76.203	76.605	16450.0

> showing 50 of 115 rows — these rows as CSV

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