PREVIEW / futures_daily / 2019-07-02

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-02.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-07-02	ES	Futures	3202.64	3215.59	3192.39	3215.05	1119495.0
2019-07-02	NQ	Futures	8971.7	9030.13	8937.73	9024.37	297574.0
2019-07-02	YM	Futures	28030.4	28145.9	27952.7	28137.5	163500.0
2019-07-02	CL	Futures	60.5	60.79	57.38	57.54	878938.0
2019-07-02	GC	Futures	1725.3	1772.3	1725.3	1752.4	383253.0
2019-07-02	ZN	Futures	127.160397	127.580325	127.129292	127.54922	1168305.0
2019-07-02	A6	Futures	0.71828	0.72178	0.71736	0.72065	93750.0
2019-07-02	AD	Futures	0.76836	0.77073	0.76826	0.76993	57622.0
2019-07-02	ALI	Futures	2172.57	2172.57	2172.57	2172.57	0.0
2019-07-02	B	Futures	48.71	49.25	46.78	46.91	386941.0
2019-07-02	B6	Futures	1.2949	1.2953	1.2889	1.2908	90682.0
2019-07-02	BR	Futures	0.20575	0.20787	0.20551	0.20679	42.0
2019-07-02	BTC	Futures	14957.8	15566.8	13725.9	15384.8	6869.0
2019-07-02	BZ	Futures	48.39	48.62	46.19	46.32	47774.0
2019-07-02	C	Futures	1747.0	1751.0	1731.0	1732.0	3041.0
2019-07-02	CB	Futures	286.377	286.961	285.91	286.961	25.0
2019-07-02	CC	Futures	1663.0	1671.0	1645.0	1647.0	17031.0
2019-07-02	CNH	Futures	6.8643	6.892	6.8559	6.8889	1535.0
2019-07-02	CSC	Futures	3.146	3.171	3.146	3.154	68.0
2019-07-02	CT	Futures	65.05	65.74	64.65	65.74	40.0
2019-07-02	DC	Futures	26.36	26.57	26.33	26.39	375.0
2019-07-02	DX	Futures	92.786	92.868	92.574	92.693	12480.0
2019-07-02	E1	Futures	1.18267	1.18707	1.18069	1.18441	21834.0
2019-07-02	E6	Futures	1.23885	1.24245	1.23727	1.23902	156093.0
2019-07-02	E7	Futures	1.2323	1.2359	1.2309	1.2325	5620.0
2019-07-02	EBM	Futures	204.69	206.13	203.25	203.82	14872.0
2019-07-02	ED	Futures	95.3671	95.4061	95.3671	95.3866	234330.0
2019-07-02	ER	Futures	98.519	98.538	98.514	98.533	245784.0
2019-07-02	EW	Futures	2054.9	2057.9	2040.2	2047.8	15546.0
2019-07-02	FBON	Futures	143.3	143.91	143.27	143.87	370.0
2019-07-02	FBTP	Futures	121.77	122.95	121.72	122.62	133488.0
2019-07-02	FBTS	Futures	107.159	107.437	107.139	107.293	92299.0
2019-07-02	FCE	Futures	5091.1	5097.5	5071.0	5091.6	66923.0
2019-07-02	FDAX	Futures	13177.6	13213.4	13130.7	13180.8	83524.0
2019-07-02	FDIV	Futures	148.83	148.83	148.69	148.69	10.0
2019-07-02	FDXM	Futures	13024.1	13049.1	12969.0	13018.4	28725.0
2019-07-02	FESX	Futures	3044.0	3057.9	3038.7	3055.3	636003.0
2019-07-02	FEU3	Futures	99.159	99.159	99.159	99.159	50.0
2019-07-02	FGBL	Futures	164.78	164.97	164.47	164.83	603487.0
2019-07-02	FGBM	Futures	134.63	134.68	134.47	134.63	442749.0
2019-07-02	FGBS	Futures	113.121	113.137	113.081	113.116	301937.0
2019-07-02	FGBX	Futures	210.06	210.33	208.83	209.77	44015.0
2019-07-02	FMWO	Futures	7389.1	7401.8	7377.5	7393.7	2485.0
2019-07-02	FOAT	Futures	151.94	152.09	151.76	152.0	122669.0
2019-07-02	FTDX	Futures	2881.4	2883.8	2865.6	2872.5	81.0
2019-07-02	FTI	Futures	535.05	536.6	533.16	535.84	19798.0
2019-07-02	FTUK	Futures	6871.6	6927.0	6865.1	6922.8	93966.0
2019-07-02	FVSA	Futures	186.89	186.89	179.97	179.97	40607.0
2019-07-02	FXXP	Futures	347.0	348.1	346.0	347.4	47090.0
2019-07-02	G	Futures	120.24	121.13	120.18	120.99	262444.0

> showing 50 of 120 rows — these rows as CSV

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