PREVIEW / futures_daily / 2018-11-16

all futures daily files

  file:    by_date/futures_daily/2018/2018-11-16.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-16	ES	Futures	2962.61	2981.05	2937.67	2974.81	1875116.0
2018-11-16	NQ	Futures	7984.91	8031.95	7905.64	8009.01	691502.0
2018-11-16	YM	Futures	26653.6	26857.9	26427.2	26801.0	238921.0
2018-11-16	CL	Futures	60.07	61.53	59.38	59.97	715914.0
2018-11-16	GC	Futures	1539.2	1553.9	1538.3	1550.1	242036.0
2018-11-16	ZN	Futures	118.343412	118.779184	118.296722	118.685804	1826749.0
2018-11-16	A6	Futures	0.74908	0.75535	0.7464	0.75463	118598.0
2018-11-16	AD	Futures	0.76779	0.77072	0.76718	0.76849	82643.0
2018-11-16	B	Futures	49.28	50.54	48.83	49.34	327717.0
2018-11-16	B6	Futures	1.3145	1.3262	1.3141	1.3213	147948.0
2018-11-16	BR	Futures	0.20209	0.20399	0.20129	0.2033	1872.0
2018-11-16	BTC	Futures	7867.5	8033.9	7795.1	7889.2	3416.0
2018-11-16	BZ	Futures	49.0	50.2	48.52	49.01	37139.0
2018-11-16	C	Futures	1481.0	1503.0	1471.0	1490.0	1995.0
2018-11-16	CB	Futures	270.366	270.366	268.293	268.984	14.0
2018-11-16	CC	Futures	1529.0	1565.0	1517.0	1539.0	15795.0
2018-11-16	CNH	Futures	6.972	6.9898	6.9532	6.9612	835.0
2018-11-16	CSC	Futures	2.982	2.992	2.958	2.974	292.0
2018-11-16	CT	Futures	85.59	86.71	85.31	85.44	12126.0
2018-11-16	DC	Futures	24.91	24.91	24.61	24.76	209.0
2018-11-16	DX	Futures	92.044	92.072	91.445	91.515	23825.0
2018-11-16	E1	Futures	1.18063	1.18916	1.1779	1.18833	25843.0
2018-11-16	E6	Futures	1.26193	1.27266	1.26154	1.27172	220310.0
2018-11-16	E7	Futures	1.2556	1.2663	1.2554	1.2655	4779.0
2018-11-16	EBM	Futures	208.2	208.46	207.16	207.68	32641.0
2018-11-16	ED	Futures	94.9743	95.0036	94.9694	94.9939	415513.0
2018-11-16	ER	Futures	98.381	98.386	98.381	98.381	28690.0
2018-11-16	EW	Futures	1963.3	1967.1	1943.2	1961.3	14385.0
2018-11-16	FBON	Futures	126.99	127.19	126.89	126.94	364.0
2018-11-16	FBTP	Futures	104.63	105.16	104.38	104.47	67188.0
2018-11-16	FBTS	Futures	102.377	102.583	102.321	102.387	48399.0
2018-11-16	FCE	Futures	4514.3	4534.0	4448.1	4483.9	94479.0
2018-11-16	FDAX	Futures	11992.7	12032.7	11801.9	11935.4	126507.0
2018-11-16	FDXM	Futures	11786.1	11824.3	11598.0	11728.7	67214.0
2018-11-16	FESX	Futures	2688.2	2694.1	2645.3	2668.0	1286692.0
2018-11-16	FEU3	Futures	99.011	99.011	99.011	99.011	1200.0
2018-11-16	FGBL	Futures	153.64	153.85	153.64	153.75	590451.0
2018-11-16	FGBM	Futures	131.34	131.43	131.32	131.39	300957.0
2018-11-16	FGBS	Futures	112.713	112.739	112.703	112.724	255501.0
2018-11-16	FGBX	Futures	177.94	178.38	177.86	178.22	41837.0
2018-11-16	FMWO	Futures	6758.5	6767.8	6711.0	6753.9	2349.0
2018-11-16	FOAT	Futures	140.57	140.7	140.51	140.56	108977.0
2018-11-16	FTDX	Futures	2536.1	2547.9	2501.3	2525.8	155.0
2018-11-16	FTI	Futures	488.77	490.4	482.46	484.67	40367.0
2018-11-16	FTUK	Futures	6328.7	6335.0	6222.4	6279.1	140461.0
2018-11-16	FVSA	Futures	345.74	360.86	327.6	336.67	32069.0
2018-11-16	FXXP	Futures	311.7	312.6	307.6	309.7	49752.0
2018-11-16	G	Futures	115.74	115.85	115.26	115.4	319834.0
2018-11-16	GF	Futures	317.939	318.154	315.033	315.41	4549.0
2018-11-16	GSCI	Futures	490.32	491.0	489.42	489.42	120.0

> showing 50 of 115 rows — these rows as CSV

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