PREVIEW / futures_daily / 2017-05-23

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-23.parquet
  size:    9 KB
  rows:    109

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
2017-05-23	ES	Futures	2599.44	2605.96	2592.11	2604.33	1024986.0
2017-05-23	NQ	Futures	6715.17	6735.19	6699.86	6726.94	219010.0
2017-05-23	YM	Futures	22040.4	22096.3	21986.5	22068.8	101974.0
2017-05-23	CL	Futures	52.87	53.64	52.38	53.31	584139.0
2017-05-23	GC	Futures	1611.8	1616.2	1599.2	1605.5	275112.0
2017-05-23	ZN	Futures	123.981909	124.227722	123.705369	123.751459	1674877.0
2017-05-23	A6	Futures	0.76685	0.77137	0.76613	0.76788	78844.0
2017-05-23	AD	Futures	0.75564	0.75819	0.75421	0.75457	57768.0
2017-05-23	ALI	Futures	2566.15	2566.15	2566.15	2566.15	0.0
2017-05-23	B	Futures	38.63	39.04	38.15	38.84	328325.0
2017-05-23	B6	Futures	1.3636	1.3674	1.3589	1.3603	122695.0
2017-05-23	BR	Futures	0.21984	0.22184	0.21959	0.22144	3535.0
2017-05-23	BZ	Futures	38.34	38.78	37.89	38.56	39671.0
2017-05-23	C	Futures	1578.0	1601.0	1569.0	1572.0	7721.0
2017-05-23	CB	Futures	295.987	297.416	295.987	296.808	33.0
2017-05-23	CC	Futures	1555.0	1571.0	1525.0	1545.0	22030.0
2017-05-23	CNH	Futures	7.1787	7.1843	7.1786	7.1843	83.0
2017-05-23	CSC	Futures	3.621	3.623	3.605	3.605	65.0
2017-05-23	CT	Futures	86.83	86.86	85.39	85.52	20296.0
2017-05-23	DC	Futures	30.37	30.37	30.13	30.26	422.0
2017-05-23	DX	Futures	90.213	90.67	90.097	90.617	34006.0
2017-05-23	E1	Futures	1.27159	1.27554	1.26764	1.26875	27661.0
2017-05-23	E6	Futures	1.2962	1.29959	1.28888	1.28992	243344.0
2017-05-23	E7	Futures	1.2895	1.2929	1.2825	1.2834	4789.0
2017-05-23	EBM	Futures	185.39	185.95	184.83	185.67	6211.0
2017-05-23	ED	Futures	95.5881	95.5978	95.5809	95.5833	307776.0
2017-05-23	ER	Futures	98.337	98.337	98.332	98.332	16664.0
2017-05-23	EW	Futures	1827.7	1835.9	1820.4	1830.7	12037.0
2017-05-23	FBON	Futures	123.03	123.09	122.65	122.89	998.0
2017-05-23	FBTP	Futures	107.21	107.39	107.14	107.3	104857.0
2017-05-23	FBTS	Futures	102.525	102.571	102.507	102.525	33755.0
2017-05-23	FCE	Futures	4736.2	4780.2	4727.7	4760.0	79694.0
2017-05-23	FDAX	Futures	13293.5	13409.6	13282.9	13364.2	80784.0
2017-05-23	FDXM	Futures	13181.9	13291.8	13168.3	13246.8	24349.0
2017-05-23	FESX	Futures	2900.2	2930.4	2897.7	2923.0	803652.0
2017-05-23	FGBL	Futures	148.05	148.26	147.59	147.85	666364.0
2017-05-23	FGBM	Futures	129.18	129.28	129.02	129.13	355449.0
2017-05-23	FGBS	Futures	112.222	112.247	112.182	112.217	298783.0
2017-05-23	FGBX	Futures	165.59	166.25	164.49	165.15	46292.0
2017-05-23	FMWO	Futures	6420.5	6425.4	6409.7	6421.7	3669.0
2017-05-23	FOAT	Futures	134.62	134.7	134.27	134.45	115401.0
2017-05-23	FTDX	Futures	2181.8	2214.6	2169.5	2192.1	210.0
2017-05-23	FTI	Futures	483.09	485.11	481.76	483.91	21457.0
2017-05-23	FTUK	Futures	6404.1	6423.4	6386.2	6401.6	82447.0
2017-05-23	FVSA	Futures	534.98	534.98	511.28	514.67	9758.0
2017-05-23	FXXP	Futures	329.0	330.8	328.3	330.3	30709.0
2017-05-23	G	Futures	115.99	116.11	115.77	115.97	228074.0
2017-05-23	GF	Futures	336.083	337.4	332.077	332.571	4589.0
2017-05-23	GSCI	Futures	483.19	484.55	483.19	484.18	16.0
2017-05-23	HE	Futures	85.392	86.853	85.365	86.717	8192.0

> showing 50 of 109 rows — these rows as CSV

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