PREVIEW / futures_daily / 2018-08-21

all futures daily files

  file:    by_date/futures_daily/2018/2018-08-21.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-08-21	ES	Futures	3102.71	3121.45	3097.55	3108.14	1055051.0
2018-08-21	NQ	Futures	8605.81	8688.59	8591.53	8624.76	320662.0
2018-08-21	YM	Futures	27136.8	27274.8	27102.0	27192.6	106828.0
2018-08-21	CL	Futures	68.16	69.26	68.03	68.58	437164.0
2018-08-21	GC	Futures	1517.5	1526.4	1513.7	1520.9	218291.0
2018-08-21	ZN	Futures	120.007322	120.022861	119.72762	119.789776	1316423.0
2018-08-21	A6	Futures	0.75514	0.75925	0.75431	0.75761	95658.0
2018-08-21	AD	Futures	0.7772	0.77867	0.77604	0.7767	70990.0
2018-08-21	B	Futures	52.59	53.18	52.52	52.94	201240.0
2018-08-21	B6	Futures	1.3214	1.3348	1.3212	1.3325	111915.0
2018-08-21	BR	Futures	0.19051	0.19203	0.18784	0.18883	5866.0
2018-08-21	BTC	Futures	9110.3	9217.2	8839.6	9153.1	3319.0
2018-08-21	BZ	Futures	52.51	53.1	52.46	52.87	15578.0
2018-08-21	C	Futures	1484.0	1519.0	1472.0	1518.0	3454.0
2018-08-21	CB	Futures	271.053	271.053	268.984	269.314	27.0
2018-08-21	CC	Futures	1529.0	1583.0	1518.0	1578.0	23047.0
2018-08-21	CNH	Futures	6.9049	6.9314	6.9001	6.9036	226.0
2018-08-21	CSC	Futures	3.242	3.242	3.218	3.232	49.0
2018-08-21	CT	Futures	93.22	94.02	93.22	93.69	5.0
2018-08-21	DC	Futures	26.25	26.31	26.01	26.16	283.0
2018-08-21	DX	Futures	90.567	90.6	89.937	90.117	24690.0
2018-08-21	E1	Futures	1.20827	1.21687	1.20827	1.21556	43048.0
2018-08-21	E6	Futures	1.28724	1.29999	1.28691	1.29669	317259.0
2018-08-21	E7	Futures	1.2807	1.2933	1.2805	1.2901	5382.0
2018-08-21	EBM	Futures	217.87	217.87	213.68	213.94	15737.0
2018-08-21	ED	Futures	95.0911	95.0935	95.0862	95.0862	183636.0
2018-08-21	ER	Futures	98.362	98.367	98.362	98.362	69107.0
2018-08-21	EW	Futures	2138.3	2161.1	2135.2	2156.1	12296.0
2018-08-21	FBON	Futures	129.09	129.93	129.07	129.67	676.0
2018-08-21	FBTP	Futures	104.99	105.86	104.8	105.64	66442.0
2018-08-21	FBTS	Futures	101.77	102.197	101.77	102.151	43270.0
2018-08-21	FCE	Futures	4842.3	4889.6	4835.1	4872.5	51052.0
2018-08-21	FDAX	Futures	12879.6	12990.4	12860.7	12940.2	66772.0
2018-08-21	FDIV	Futures	148.05	148.05	147.56	147.56	4.0
2018-08-21	FDXM	Futures	12714.0	12824.4	12697.5	12774.9	28938.0
2018-08-21	FESX	Futures	2833.0	2858.9	2827.2	2849.7	629256.0
2018-08-21	FEU3	Futures	99.016	99.021	99.016	99.016	396.0
2018-08-21	FGBL	Futures	154.16	154.26	153.75	153.82	470619.0
2018-08-21	FGBM	Futures	131.58	131.6	131.38	131.4	338685.0
2018-08-21	FGBS	Futures	112.739	112.744	112.693	112.708	242394.0
2018-08-21	FGBX	Futures	180.04	180.3	179.12	179.28	24538.0
2018-08-21	FMWO	Futures	7149.8	7191.7	7149.8	7176.6	1732.0
2018-08-21	FOAT	Futures	141.37	141.46	141.21	141.25	90293.0
2018-08-21	FTDX	Futures	2868.1	2882.3	2853.9	2869.6	298.0
2018-08-21	FTI	Futures	515.0	517.46	514.63	516.35	13798.0
2018-08-21	FTUK	Futures	6754.6	6765.7	6720.7	6740.3	68261.0
2018-08-21	FVSA	Futures	270.01	270.01	258.69	261.3	28975.0
2018-08-21	FXXP	Futures	330.8	333.1	330.1	332.0	31207.0
2018-08-21	G	Futures	116.16	116.22	115.71	115.76	204135.0
2018-08-21	GF	Futures	314.33	315.162	313.498	314.122	3202.0

> showing 50 of 116 rows — these rows as CSV

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