PREVIEW / futures_daily / 2018-03-20

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-20.parquet
  size:    10 KB
  rows:    112

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-03-20	ES	Futures	2959.54	2967.7	2950.03	2961.72	1099899.0
2018-03-20	NQ	Futures	8089.74	8108.47	8032.68	8096.47	401041.0
2018-03-20	YM	Futures	25988.5	26138.0	25922.1	26087.5	190952.0
2018-03-20	CL	Futures	62.47	64.25	62.39	63.81	717709.0
2018-03-20	GC	Futures	1681.6	1683.7	1669.0	1675.7	292332.0
2018-03-20	ZN	Futures	119.385065	119.447099	119.043876	119.198962	1081891.0
2018-03-20	A6	Futures	0.79381	0.79411	0.78969	0.79021	96954.0
2018-03-20	AD	Futures	0.77483	0.7764	0.77347	0.77478	56315.0
2018-03-20	B	Futures	47.74	48.99	47.74	48.66	326466.0
2018-03-20	B6	Futures	1.4584	1.4626	1.4539	1.4557	98448.0
2018-03-20	BR	Futures	0.2297	0.2297	0.22902	0.22902	8.0
2018-03-20	BTC	Futures	11680.1	12519.4	11541.4	12408.4	2050.0
2018-03-20	BZ	Futures	47.19	48.4	47.17	48.06	35782.0
2018-03-20	C	Futures	1619.0	1661.0	1598.0	1640.0	17139.0
2018-03-20	CB	Futures	275.842	279.147	275.842	279.147	10.0
2018-03-20	CC	Futures	1785.0	1846.0	1783.0	1820.0	22350.0
2018-03-20	CNH	Futures	6.4508	6.4561	6.4477	6.4477	71.0
2018-03-20	CSC	Futures	3.327	3.327	3.312	3.312	19.0
2018-03-20	CT	Futures	93.28	95.81	93.05	95.5	19576.0
2018-03-20	DC	Futures	26.42	26.64	26.06	26.3	209.0
2018-03-20	DX	Futures	84.382	84.906	84.325	84.839	18114.0
2018-03-20	E1	Futures	1.2762	1.27741	1.26837	1.27042	21268.0
2018-03-20	E6	Futures	1.3991	1.40141	1.38829	1.38964	194101.0
2018-03-20	E7	Futures	1.3915	1.3938	1.3809	1.3823	2992.0
2018-03-20	EBM	Futures	174.52	174.79	173.98	174.52	25183.0
2018-03-20	ED	Futures	94.9986	95.0035	94.9646	94.9695	407992.0
2018-03-20	ER	Futures	98.337	98.342	98.332	98.337	81025.0
2018-03-20	EW	Futures	2038.7	2044.7	2030.2	2035.3	11595.0
2018-03-20	FBON	Futures	128.79	129.11	128.78	129.06	230.0
2018-03-20	FBTP	Futures	113.59	114.34	113.59	114.28	115728.0
2018-03-20	FBTS	Futures	103.945	104.056	103.927	104.028	54218.0
2018-03-20	FCE	Futures	4608.6	4627.6	4580.8	4619.6	64122.0
2018-03-20	FDAX	Futures	12764.1	12835.3	12669.6	12805.2	99182.0
2018-03-20	FDXM	Futures	12644.3	12721.6	12556.8	12691.2	35170.0
2018-03-20	FESX	Futures	2765.6	2775.6	2744.0	2770.6	852863.0
2018-03-20	FEU3	Futures	99.026	99.026	99.021	99.021	3.0
2018-03-20	FGBL	Futures	148.8	148.84	148.6	148.74	506462.0
2018-03-20	FGBM	Futures	129.27	129.28	129.16	129.22	336719.0
2018-03-20	FGBS	Futures	112.507	112.512	112.487	112.502	257169.0
2018-03-20	FGBX	Futures	168.86	169.15	168.42	169.02	34901.0
2018-03-20	FMWO	Futures	7012.2	7014.5	6994.7	7004.0	522.0
2018-03-20	FOAT	Futures	137.93	137.99	137.72	137.93	90864.0
2018-03-20	FTDX	Futures	2623.1	2649.3	2622.1	2649.3	95.0
2018-03-20	FTI	Futures	487.21	490.38	485.15	489.51	23922.0
2018-03-20	FTUK	Futures	6162.4	6180.5	6145.2	6176.1	94491.0
2018-03-20	FVSA	Futures	407.85	428.06	399.53	407.85	45126.0
2018-03-20	FXXP	Futures	317.4	318.6	315.9	318.4	27420.0
2018-03-20	G	Futures	113.15	113.49	112.93	112.98	215879.0
2018-03-20	GF	Futures	301.328	302.58	298.006	299.368	6674.0
2018-03-20	GSCI	Futures	509.93	512.1	509.02	510.16	26.0

> showing 50 of 112 rows — these rows as CSV

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