PREVIEW / futures_daily / 2019-07-30

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-30.parquet
  size:    10 KB
  rows:    118

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
2019-07-30	ES	Futures	3261.18	3266.84	3238.79	3250.39	1182050.0
2019-07-30	NQ	Futures	9215.49	9233.62	9127.99	9168.29	394698.0
2019-07-30	YM	Futures	28579.6	28615.3	28394.8	28522.9	148117.0
2019-07-30	CL	Futures	58.23	59.66	58.12	59.23	547401.0
2019-07-30	GC	Futures	1775.7	1783.3	1769.9	1778.5	259623.0
2019-07-30	ZN	Futures	126.771575	126.95821	126.647152	126.756022	1151527.0
2019-07-30	A6	Futures	0.71098	0.7118	0.70779	0.70841	68073.0
2019-07-30	AD	Futures	0.76655	0.76761	0.76479	0.7671	48385.0
2019-07-30	ALI	Futures	2247.7	2253.2	2230.6	2230.6	54.0
2019-07-30	B	Futures	48.13	49.11	48.11	48.76	297357.0
2019-07-30	B6	Futures	1.2502	1.2508	1.2399	1.2443	144581.0
2019-07-30	BR	Futures	0.21058	0.21114	0.20986	0.21034	1886.0
2019-07-30	BTC	Futures	13169.4	13671.9	13038.6	13403.4	2380.0
2019-07-30	BZ	Futures	47.47	48.45	47.43	48.13	32502.0
2019-07-30	C	Futures	1737.0	1747.0	1725.0	1738.0	5107.0
2019-07-30	CB	Futures	277.012	277.741	276.808	277.45	61.0
2019-07-30	CC	Futures	1587.0	1603.0	1573.0	1585.0	14389.0
2019-07-30	CNH	Futures	6.8965	6.8972	6.8867	6.8918	362.0
2019-07-30	CSC	Futures	3.137	3.14	3.104	3.109	104.0
2019-07-30	CT	Futures	63.04	63.04	62.09	62.09	6.0
2019-07-30	DC	Futures	26.33	26.43	26.08	26.13	249.0
2019-07-30	DX	Futures	94.201	94.317	94.129	94.171	9353.0
2019-07-30	E1	Futures	1.17443	1.17756	1.17374	1.17606	18633.0
2019-07-30	E6	Futures	1.22036	1.22216	1.219	1.22167	133778.0
2019-07-30	E7	Futures	1.2142	1.2158	1.2126	1.2153	2467.0
2019-07-30	EBM	Futures	202.09	203.82	201.81	203.82	26662.0
2019-07-30	ED	Futures	95.2649	95.2795	95.2503	95.26	335002.0
2019-07-30	ER	Futures	98.533	98.538	98.529	98.533	53633.0
2019-07-30	EW	Futures	2075.5	2090.8	2058.4	2089.5	15258.0
2019-07-30	FBON	Futures	143.64	143.75	143.56	143.75	630.0
2019-07-30	FBTP	Futures	125.39	125.48	124.55	125.16	104634.0
2019-07-30	FBTS	Futures	107.686	107.705	107.523	107.638	44547.0
2019-07-30	FCE	Futures	5106.1	5116.6	4996.3	5019.1	102861.0
2019-07-30	FDAX	Futures	13082.8	13111.3	12722.2	12785.4	150325.0
2019-07-30	FDIV	Futures	147.02	147.02	144.84	144.88	120.0
2019-07-30	FDXM	Futures	12930.5	12950.3	12567.5	12627.9	63699.0
2019-07-30	FESX	Futures	3075.4	3080.6	3005.5	3020.4	1226844.0
2019-07-30	FGBL	Futures	165.86	166.07	165.79	165.97	402733.0
2019-07-30	FGBM	Futures	134.81	134.84	134.75	134.82	243251.0
2019-07-30	FGBS	Futures	113.116	113.116	113.081	113.096	148329.0
2019-07-30	FGBX	Futures	212.85	213.61	212.64	213.4	35420.0
2019-07-30	FMWO	Futures	7449.1	7449.1	7390.2	7408.7	2205.0
2019-07-30	FOAT	Futures	153.03	153.12	152.84	153.06	103956.0
2019-07-30	FTDX	Futures	2896.2	2896.2	2840.4	2848.8	115.0
2019-07-30	FTI	Futures	547.5	548.64	540.19	541.97	29369.0
2019-07-30	FTUK	Futures	7041.0	7077.9	6983.3	7007.8	117256.0
2019-07-30	FVSA	Futures	165.7	177.45	164.47	173.12	64934.0
2019-07-30	FXXP	Futures	349.2	349.3	342.7	344.1	66842.0
2019-07-30	G	Futures	122.04	122.08	121.73	121.97	159220.0
2019-07-30	GF	Futures	279.298	282.095	277.14	280.819	2821.0

> showing 50 of 118 rows — these rows as CSV

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