PREVIEW / futures_daily / 2018-10-29

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-29.parquet
  size:    10 KB
  rows:    116

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-10-29	ES	Futures	2892.39	2935.77	2822.98	2866.91	2786555.0
2018-10-29	NQ	Futures	8012.21	8120.81	7643.42	7824.33	905327.0
2018-10-29	YM	Futures	26026.0	26333.5	25363.6	25726.9	371503.0
2018-10-29	CL	Futures	70.4	70.81	69.08	69.87	477487.0
2018-10-29	GC	Futures	1567.0	1568.6	1554.0	1555.9	234294.0
2018-10-29	ZN	Futures	118.545735	118.701368	118.234468	118.483481	1948721.0
2018-10-29	A6	Futures	0.73025	0.73179	0.72592	0.72685	98395.0
2018-10-29	AD	Futures	0.77269	0.77355	0.76961	0.77097	53337.0
2018-10-29	B	Futures	57.38	57.65	56.61	57.19	220627.0
2018-10-29	B6	Futures	1.3222	1.3248	1.3184	1.3198	84244.0
2018-10-29	BFX	Futures	3959.1	3962.6	3959.1	3962.6	7.0
2018-10-29	BR	Futures	0.21271	0.21359	0.20445	0.20544	8803.0
2018-10-29	BTC	Futures	9249.9	9322.3	8953.1	9032.7	3904.0
2018-10-29	BZ	Futures	56.97	57.26	56.23	56.8	17998.0
2018-10-29	C	Futures	1584.0	1591.0	1542.0	1549.0	10571.0
2018-10-29	CB	Futures	269.164	269.464	269.044	269.044	24.0
2018-10-29	CC	Futures	1572.0	1587.0	1522.0	1533.0	28281.0
2018-10-29	CNH	Futures	7.0074	7.0256	7.0055	7.0191	339.0
2018-10-29	CSC	Futures	3.076	3.082	3.042	3.054	43.0
2018-10-29	CT	Futures	88.48	89.35	86.5	86.62	12938.0
2018-10-29	DC	Futures	25.44	25.48	25.11	25.24	207.0
2018-10-29	DX	Futures	91.412	91.649	91.308	91.531	24382.0
2018-10-29	E1	Futures	1.19331	1.19378	1.1875	1.18892	19100.0
2018-10-29	E6	Futures	1.27216	1.27416	1.26799	1.27133	226065.0
2018-10-29	E7	Futures	1.2661	1.2679	1.2618	1.2651	3487.0
2018-10-29	EBM	Futures	211.31	211.83	207.94	208.46	25660.0
2018-10-29	ED	Futures	94.9987	95.0134	94.9841	95.0036	271151.0
2018-10-29	ER	Futures	98.377	98.381	98.377	98.377	33352.0
2018-10-29	EW	Futures	1892.8	1927.5	1859.6	1880.0	24406.0
2018-10-29	FBON	Futures	127.57	127.85	127.52	127.75	799.0
2018-10-29	FBTP	Futures	104.79	106.07	104.79	105.66	106017.0
2018-10-29	FBTS	Futures	102.227	102.733	102.218	102.546	79753.0
2018-10-29	FCE	Futures	4445.4	4501.8	4399.2	4464.2	97388.0
2018-10-29	FDAX	Futures	11768.7	12027.9	11719.8	11915.4	140284.0
2018-10-29	FDIV	Futures	138.63	138.63	137.6	137.6	1.0
2018-10-29	FDXM	Futures	11566.0	11819.1	11515.3	11709.1	69588.0
2018-10-29	FESX	Futures	2622.6	2665.5	2602.5	2643.6	1409098.0
2018-10-29	FGBL	Futures	153.72	153.88	153.18	153.46	744685.0
2018-10-29	FGBM	Futures	131.23	131.31	131.05	131.17	422778.0
2018-10-29	FGBS	Futures	112.713	112.739	112.688	112.708	320585.0
2018-10-29	FGBX	Futures	179.45	179.71	177.73	178.04	58827.0
2018-10-29	FMWO	Futures	6611.4	6699.4	6487.4	6627.6	1927.0
2018-10-29	FOAT	Futures	140.68	140.77	140.43	140.62	139523.0
2018-10-29	FTDX	Futures	2475.2	2532.2	2468.9	2504.7	380.0
2018-10-29	FTI	Futures	471.43	478.15	465.93	473.57	32984.0
2018-10-29	FTUK	Futures	6197.3	6309.9	6158.9	6260.8	137452.0
2018-10-29	FVSA	Futures	385.29	405.27	369.12	383.39	35299.0
2018-10-29	FXXP	Futures	303.9	309.7	302.8	307.3	60665.0
2018-10-29	G	Futures	115.7	115.81	115.32	115.52	255650.0
2018-10-29	GF	Futures	322.861	323.172	319.794	320.002	1703.0

> showing 50 of 116 rows — these rows as CSV

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