PREVIEW / futures_daily / 2019-11-06

all futures daily files

  file:    by_date/futures_daily/2019/2019-11-06.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-11-06	ES	Futures	3325.11	3332.14	3315.9	3329.44	1076833.0
2019-11-06	NQ	Futures	9459.07	9482.41	9404.91	9458.21	314414.0
2019-11-06	YM	Futures	28785.3	28837.8	28698.1	28795.8	129297.0
2019-11-06	CL	Futures	58.5	59.1	57.32	57.57	623258.0
2019-11-06	GC	Futures	1831.0	1845.3	1830.3	1841.8	313719.0
2019-11-06	ZN	Futures	127.808337	128.226416	127.777368	128.164478	1484890.0
2019-11-06	A6	Futures	0.70799	0.70943	0.70553	0.70656	81515.0
2019-11-06	AD	Futures	0.76599	0.7662	0.76358	0.76413	55924.0
2019-11-06	ALI	Futures	2206.13	2209.16	2194.29	2209.16	104.0
2019-11-06	B	Futures	50.07	50.51	49.13	49.24	275935.0
2019-11-06	B6	Futures	1.3113	1.313	1.3075	1.3084	59761.0
2019-11-06	BR	Futures	0.20241	0.20297	0.19744	0.1978	14093.0
2019-11-06	BTC	Futures	13581.4	13740.3	13465.9	13516.4	1366.0
2019-11-06	BZ	Futures	49.52	49.82	48.45	48.57	34901.0
2019-11-06	C	Futures	1665.0	1668.0	1650.0	1662.0	7303.0
2019-11-06	CB	Futures	247.098	247.334	246.773	246.773	21.0
2019-11-06	CC	Futures	1639.0	1643.0	1605.0	1617.0	28748.0
2019-11-06	CNH	Futures	6.9918	7.0089	6.979	7.0059	897.0
2019-11-06	CSC	Futures	3.553	3.553	3.534	3.534	51.0
2019-11-06	CT	Futures	62.11	62.4	61.76	61.99	23267.0
2019-11-06	DC	Futures	29.7	29.7	29.45	29.48	352.0
2019-11-06	DX	Futures	94.488	94.531	94.333	94.492	13051.0
2019-11-06	E1	Futures	1.1622	1.16335	1.16059	1.16243	19273.0
2019-11-06	E6	Futures	1.20326	1.20537	1.20206	1.20271	132314.0
2019-11-06	E7	Futures	1.1972	1.1991	1.196	1.1965	2310.0
2019-11-06	EBM	Futures	194.54	196.19	194.27	195.36	23075.0
2019-11-06	ED	Futures	95.318	95.3423	95.318	95.3326	201571.0
2019-11-06	ER	Futures	98.391	98.401	98.391	98.396	57430.0
2019-11-06	EW	Futures	2098.4	2102.3	2084.3	2090.5	9105.0
2019-11-06	FBON	Futures	144.3	144.66	144.09	144.53	273.0
2019-11-06	FBTP	Futures	130.46	130.81	130.02	130.51	110332.0
2019-11-06	FBTS	Futures	108.336	108.442	108.298	108.394	43675.0
2019-11-06	FCE	Futures	5303.0	5334.8	5299.4	5324.8	66661.0
2019-11-06	FDAX	Futures	13863.7	13936.5	13826.2	13892.7	96219.0
2019-11-06	FDIV	Futures	160.75	161.68	160.75	161.68	25.0
2019-11-06	FDXM	Futures	13679.6	13751.4	13645.2	13711.3	39102.0
2019-11-06	FESX	Futures	3216.7	3235.1	3210.6	3226.4	1057449.0
2019-11-06	FGBL	Futures	164.66	165.13	164.43	164.87	567390.0
2019-11-06	FGBM	Futures	133.87	133.97	133.8	133.89	342136.0
2019-11-06	FGBS	Futures	112.704	112.724	112.694	112.709	207720.0
2019-11-06	FGBX	Futures	212.74	214.65	211.85	213.76	55045.0
2019-11-06	FMWO	Futures	7516.6	7542.8	7514.4	7529.1	2619.0
2019-11-06	FOAT	Futures	152.2	152.68	152.06	152.46	122840.0
2019-11-06	FTDX	Futures	2862.6	2862.6	2842.9	2860.6	65.0
2019-11-06	FTI	Futures	562.34	567.39	562.1	566.64	26008.0
2019-11-06	FTUK	Futures	6807.9	6840.3	6801.4	6824.6	67251.0
2019-11-06	FVSA	Futures	148.13	150.79	145.48	147.6	21540.0
2019-11-06	FXXP	Futures	364.7	366.3	363.9	365.4	56177.0
2019-11-06	G	Futures	120.18	120.88	120.09	120.62	156234.0
2019-11-06	GF	Futures	309.485	309.537	305.978	307.339	2144.0

> showing 50 of 118 rows — these rows as CSV

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