PREVIEW / futures_daily / 2019-04-17

all futures daily files

  file:    by_date/futures_daily/2019/2019-04-17.parquet
  size:    10 KB
  rows:    114

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-04-17	ES	Futures	3143.58	3157.89	3130.89	3133.05	1382265.0
2019-04-17	NQ	Futures	8844.9	8910.58	8835.68	8860.17	463944.0
2019-04-17	YM	Futures	27898.4	27991.3	27848.8	27896.3	182978.0
2019-04-17	CL	Futures	66.18	66.45	65.46	65.57	466682.0
2019-04-17	GC	Futures	1592.5	1595.7	1587.1	1589.1	223357.0
2019-04-17	ZN	Futures	122.171393	122.26463	121.96938	122.186933	1521927.0
2019-04-17	A6	Futures	0.74054	0.74374	0.73817	0.74003	106398.0
2019-04-17	AD	Futures	0.75817	0.76272	0.75711	0.75878	103434.0
2019-04-17	B	Futures	52.32	52.64	52.04	52.17	276611.0
2019-04-17	B6	Futures	1.3403	1.3424	1.3384	1.3394	74720.0
2019-04-17	BR	Futures	0.20456	0.20504	0.20228	0.20308	116.0
2019-04-17	BTC	Futures	8057.7	8165.9	8011.4	8088.6	6698.0
2019-04-17	BZ	Futures	52.18	52.49	51.91	52.02	40910.0
2019-04-17	C	Futures	1605.0	1662.0	1605.0	1659.0	6082.0
2019-04-17	CB	Futures	277.467	278.813	277.467	278.783	40.0
2019-04-17	CC	Futures	1582.0	1620.0	1575.0	1618.0	20254.0
2019-04-17	CNH	Futures	6.7224	6.7237	6.6883	6.6883	547.0
2019-04-17	CSC	Futures	2.875	2.898	2.866	2.884	102.0
2019-04-17	CT	Futures	82.75	83.28	82.28	82.93	6652.0
2019-04-17	DC	Futures	24.19	24.45	24.17	24.32	290.0
2019-04-17	DX	Futures	92.717	92.77	92.459	92.648	10497.0
2019-04-17	E1	Futures	1.16457	1.16527	1.16037	1.16107	29114.0
2019-04-17	E6	Futures	1.24447	1.2488	1.24386	1.24606	184443.0
2019-04-17	E7	Futures	1.2384	1.2425	1.2377	1.2399	4286.0
2019-04-17	EBM	Futures	196.87	197.66	195.01	195.81	25667.0
2019-04-17	ED	Futures	95.1257	95.1306	95.116	95.1209	214113.0
2019-04-17	ER	Futures	98.416	98.421	98.411	98.416	34741.0
2019-04-17	EW	Futures	2086.4	2096.3	2066.9	2072.2	10228.0
2019-04-17	FBON	Futures	135.12	135.18	134.87	134.98	320.0
2019-04-17	FBTP	Futures	115.17	115.38	114.89	115.12	53536.0
2019-04-17	FBTS	Futures	105.827	105.884	105.741	105.798	28587.0
2019-04-17	FCE	Futures	4937.1	4960.5	4917.7	4953.8	69317.0
2019-04-17	FDAX	Futures	12774.8	12864.3	12748.5	12824.3	100347.0
2019-04-17	FDIV	Futures	149.29	149.99	149.29	149.99	20.0
2019-04-17	FDXM	Futures	12653.7	12752.8	12639.1	12713.2	38643.0
2019-04-17	FESX	Futures	2961.9	2985.5	2961.0	2977.6	999140.0
2019-04-17	FGBL	Futures	158.77	158.85	158.34	158.57	679052.0
2019-04-17	FGBM	Futures	132.69	132.74	132.54	132.63	373688.0
2019-04-17	FGBS	Futures	112.739	112.744	112.698	112.724	260607.0
2019-04-17	FGBX	Futures	189.87	190.34	188.7	189.62	53709.0
2019-04-17	FMWO	Futures	7267.0	7293.6	7248.5	7258.9	2315.0
2019-04-17	FOAT	Futures	145.77	145.99	145.58	145.84	119689.0
2019-04-17	FTDX	Futures	2781.2	2789.6	2763.9	2773.8	770.0
2019-04-17	FTI	Futures	530.06	532.62	529.49	530.64	19338.0
2019-04-17	FTUK	Futures	6786.6	6805.9	6775.6	6797.6	78004.0
2019-04-17	FVSA	Futures	199.0	201.79	196.2	199.0	26559.0
2019-04-17	FXXP	Futures	343.7	344.6	342.7	343.8	69105.0
2019-04-17	G	Futures	116.92	116.93	116.71	116.82	185875.0
2019-04-17	GF	Futures	314.373	315.883	313.072	313.54	4374.0
2019-04-17	GSCI	Futures	510.09	510.09	507.5	507.5	21.0

> showing 50 of 114 rows — these rows as CSV

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