PREVIEW / futures_daily / 2019-10-22

all futures daily files

  file:    by_date/futures_daily/2019/2019-10-22.parquet
  size:    10 KB
  rows:    120

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-10-22	ES	Futures	3254.74	3263.13	3234.98	3241.75	1125601.0
2019-10-22	NQ	Futures	9160.88	9206.4	9031.81	9056.59	377545.0
2019-10-22	YM	Futures	28132.3	28243.6	28045.2	28095.6	143610.0
2019-10-22	CL	Futures	54.76	56.0	54.38	55.66	506573.0
2019-10-22	GC	Futures	1834.9	1840.6	1830.6	1834.9	208969.0
2019-10-22	ZN	Futures	128.412229	128.690948	128.303838	128.644495	1025951.0
2019-10-22	A6	Futures	0.70543	0.70727	0.70389	0.7043	75054.0
2019-10-22	AD	Futures	0.76987	0.77103	0.76796	0.76942	89734.0
2019-10-22	ALI	Futures	2103.82	2104.73	2095.32	2099.57	123.0
2019-10-22	B	Futures	46.78	47.74	46.54	47.29	260598.0
2019-10-22	B6	Futures	1.3203	1.3242	1.3102	1.3122	175214.0
2019-10-22	BR	Futures	0.19558	0.19849	0.19542	0.19792	1005.0
2019-10-22	BTC	Futures	11836.9	11980.8	11599.6	11743.5	2446.0
2019-10-22	BZ	Futures	46.12	47.07	45.91	46.63	37803.0
2019-10-22	C	Futures	1662.0	1662.0	1638.0	1647.0	6756.0
2019-10-22	CB	Futures	247.127	247.127	242.788	246.478	17.0
2019-10-22	CC	Futures	1622.0	1637.0	1603.0	1607.0	17126.0
2019-10-22	CNH	Futures	7.0615	7.0761	7.0598	7.071	315.0
2019-10-22	CSC	Futures	3.296	3.318	3.287	3.303	146.0
2019-10-22	CT	Futures	62.72	63.46	62.26	62.95	17911.0
2019-10-22	DC	Futures	27.57	27.8	27.45	27.59	863.0
2019-10-22	DX	Futures	93.792	94.058	93.743	94.001	17852.0
2019-10-22	E1	Futures	1.17129	1.17164	1.16715	1.16795	22853.0
2019-10-22	E6	Futures	1.21301	1.21371	1.20943	1.21014	150232.0
2019-10-22	E7	Futures	1.2069	1.2074	1.2032	1.2039	2800.0
2019-10-22	EBM	Futures	198.65	199.47	198.1	198.1	36640.0
2019-10-22	ED	Futures	95.3423	95.3569	95.3375	95.352	241959.0
2019-10-22	ER	Futures	98.406	98.411	98.406	98.406	21191.0
2019-10-22	EW	Futures	2048.0	2057.0	2040.3	2045.2	7422.0
2019-10-22	FBON	Futures	144.49	145.07	144.49	145.02	367.0
2019-10-22	FBTP	Futures	130.88	131.89	130.87	131.65	79603.0
2019-10-22	FBTS	Futures	108.336	108.519	108.336	108.462	33171.0
2019-10-22	FCE	Futures	5130.5	5136.4	5092.0	5132.8	54371.0
2019-10-22	FDAX	Futures	13459.0	13493.9	13384.1	13456.4	82028.0
2019-10-22	FDIV	Futures	155.32	156.07	155.32	156.07	70.0
2019-10-22	FDXM	Futures	13277.6	13318.2	13209.9	13280.7	32289.0
2019-10-22	FESX	Futures	3150.9	3157.1	3134.3	3150.9	647902.0
2019-10-22	FGBL	Futures	165.07	165.89	164.96	165.59	533814.0
2019-10-22	FGBM	Futures	134.02	134.21	133.99	134.11	323815.0
2019-10-22	FGBS	Futures	112.764	112.795	112.759	112.769	206765.0
2019-10-22	FGBX	Futures	213.74	216.98	213.35	216.19	41751.0
2019-10-22	FMWO	Futures	7374.5	7381.3	7338.1	7375.6	632.0
2019-10-22	FOAT	Futures	152.47	153.03	152.46	152.95	90020.0
2019-10-22	FTDX	Futures	2799.9	2805.9	2783.2	2785.6	47.0
2019-10-22	FTI	Futures	548.07	548.64	545.21	548.01	19533.0
2019-10-22	FTUK	Futures	6627.2	6680.5	6601.2	6663.3	87836.0
2019-10-22	FVSA	Futures	162.47	166.18	160.87	163.53	24356.0
2019-10-22	FXXP	Futures	355.8	356.6	354.1	356.1	46248.0
2019-10-22	G	Futures	120.42	120.99	120.36	120.94	211578.0
2019-10-22	GF	Futures	298.86	301.424	298.284	300.43	2512.0

> showing 50 of 120 rows — these rows as CSV

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