PREVIEW / futures_daily / 2019-07-19

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-19.parquet
  size:    10 KB
  rows:    119

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-19	ES	Futures	3241.22	3247.69	3204.26	3212.35	1482373.0
2019-07-19	NQ	Futures	9153.61	9188.43	8997.89	9029.55	438469.0
2019-07-19	YM	Futures	28671.0	28709.8	28425.2	28487.2	194392.0
2019-07-19	CL	Futures	56.98	57.64	56.24	56.9	734388.0
2019-07-19	GC	Futures	1802.6	1810.2	1768.7	1775.7	530022.0
2019-07-19	ZN	Futures	127.191503	127.269268	126.787128	126.942657	1260018.0
2019-07-19	A6	Futures	0.72898	0.72981	0.72528	0.7259	102417.0
2019-07-19	AD	Futures	0.77441	0.77517	0.76957	0.7725	74453.0
2019-07-19	ALI	Futures	2297.79	2303.89	2297.79	2303.89	10.0
2019-07-19	B	Futures	46.99	47.64	46.48	46.96	298982.0
2019-07-19	B6	Futures	1.2841	1.285	1.2768	1.2792	85632.0
2019-07-19	BFX	Futures	4110.0	4110.0	4089.3	4089.3	5.0
2019-07-19	BR	Futures	0.21374	0.21374	0.21266	0.21266	60.0
2019-07-19	BTC	Futures	14887.8	15181.8	14180.9	14642.8	4699.0
2019-07-19	BZ	Futures	46.45	47.02	45.9	46.37	36709.0
2019-07-19	C	Futures	1729.0	1744.0	1725.0	1728.0	4024.0
2019-07-19	CB	Futures	288.478	289.528	286.902	287.894	110.0
2019-07-19	CC	Futures	1630.0	1662.0	1629.0	1643.0	12217.0
2019-07-19	CNH	Futures	6.8773	6.8885	6.8753	6.8851	912.0
2019-07-19	CSC	Futures	3.134	3.134	3.114	3.124	121.0
2019-07-19	CT	Futures	60.2	61.54	60.2	61.47	32.0
2019-07-19	DC	Futures	26.35	26.49	26.19	26.41	341.0
2019-07-19	DX	Futures	92.877	93.368	92.829	93.216	21816.0
2019-07-19	E1	Futures	1.18765	1.18858	1.18371	1.18638	22280.0
2019-07-19	E6	Futures	1.2358	1.23618	1.22756	1.22947	184793.0
2019-07-19	E7	Futures	1.2293	1.2298	1.2213	1.2231	3714.0
2019-07-19	EBM	Futures	201.52	204.11	200.94	203.82	14363.0
2019-07-19	ED	Futures	95.3963	95.4061	95.3087	95.333	374913.0
2019-07-19	ER	Futures	98.543	98.543	98.524	98.529	99962.0
2019-07-19	EW	Futures	2049.4	2056.6	2031.9	2036.9	10011.0
2019-07-19	FBON	Futures	143.1	143.44	143.08	143.38	299.0
2019-07-19	FBTP	Futures	125.52	125.61	124.5	124.91	87343.0
2019-07-19	FBTS	Futures	107.724	107.772	107.532	107.619	56251.0
2019-07-19	FCE	Futures	5080.1	5098.3	5039.1	5055.5	91056.0
2019-07-19	FDAX	Futures	12901.2	12982.8	12845.9	12897.5	118179.0
2019-07-19	FDIV	Futures	145.77	146.28	145.77	146.28	20.0
2019-07-19	FDXM	Futures	12744.3	12822.3	12687.1	12738.6	45040.0
2019-07-19	FESX	Futures	3042.2	3062.3	3023.0	3030.9	1172867.0
2019-07-19	FEU3	Futures	99.159	99.159	99.159	99.159	50.0
2019-07-19	FGBL	Futures	164.95	165.04	164.76	164.87	436417.0
2019-07-19	FGBM	Futures	134.68	134.76	134.64	134.69	337943.0
2019-07-19	FGBS	Futures	113.126	113.131	113.091	113.116	166565.0
2019-07-19	FGBX	Futures	209.45	209.49	208.23	208.91	38403.0
2019-07-19	FMWO	Futures	7429.5	7451.4	7398.3	7417.9	2460.0
2019-07-19	FOAT	Futures	152.21	152.28	152.02	152.12	88658.0
2019-07-19	FTDX	Futures	2817.7	2834.0	2813.8	2822.6	24.0
2019-07-19	FTI	Futures	542.56	543.61	538.05	539.38	32330.0
2019-07-19	FTUK	Futures	6858.6	6907.1	6839.3	6870.2	80390.0
2019-07-19	FVSA	Futures	174.36	181.16	172.51	174.98	41193.0
2019-07-19	FXXP	Futures	346.8	347.8	344.8	345.8	44017.0

> showing 50 of 119 rows — these rows as CSV

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