PREVIEW / futures_daily / 2019-05-03

all futures daily files

  file:    by_date/futures_daily/2019/2019-05-03.parquet
  size:    10 KB
  rows:    115

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-05-03	ES	Futures	3152.49	3185.98	3150.33	3183.82	1295606.0
2019-05-03	NQ	Futures	8916.91	9070.73	8912.02	9062.09	454088.0
2019-05-03	YM	Futures	27732.6	27991.3	27703.1	27971.2	169687.0
2019-05-03	CL	Futures	63.19	64.19	62.94	63.59	646866.0
2019-05-03	GC	Futures	1582.7	1598.0	1579.4	1594.7	280323.0
2019-05-03	ZN	Futures	122.57542	122.792972	122.26463	122.668657	1488964.0
2019-05-03	A6	Futures	0.72219	0.72498	0.72065	0.72405	88058.0
2019-05-03	AD	Futures	0.75104	0.75494	0.75008	0.75367	70731.0
2019-05-03	B	Futures	51.93	52.72	51.54	52.21	249814.0
2019-05-03	B6	Futures	1.338	1.3529	1.3332	1.3514	135616.0
2019-05-03	BR	Futures	0.20132	0.20308	0.20096	0.2026	1913.0
2019-05-03	BTC	Futures	8335.6	8969.6	8281.4	8768.6	13229.0
2019-05-03	BZ	Futures	51.68	52.57	51.41	52.06	39000.0
2019-05-03	C	Futures	1717.0	1735.0	1694.0	1698.0	4828.0
2019-05-03	CB	Futures	278.065	278.723	278.065	278.424	50.0
2019-05-03	CC	Futures	1592.0	1616.0	1580.0	1602.0	21616.0
2019-05-03	CNH	Futures	6.7553	6.7592	6.7448	6.7461	207.0
2019-05-03	CSC	Futures	2.984	3.017	2.984	3.008	67.0
2019-05-03	CT	Futures	79.02	79.88	78.96	79.22	10510.0
2019-05-03	DC	Futures	25.17	25.46	25.04	25.4	817.0
2019-05-03	DX	Futures	93.527	93.805	93.154	93.225	12963.0
2019-05-03	E1	Futures	1.14952	1.15314	1.14695	1.15151	18971.0
2019-05-03	E6	Futures	1.23075	1.2342	1.22652	1.23305	205195.0
2019-05-03	E7	Futures	1.2246	1.2281	1.2205	1.2269	6434.0
2019-05-03	EBM	Futures	197.13	199.25	194.75	196.34	11380.0
2019-05-03	ED	Futures	95.155	95.1599	95.1453	95.155	204019.0
2019-05-03	ER	Futures	98.411	98.416	98.411	98.411	20270.0
2019-05-03	EW	Futures	2075.6	2107.8	2073.4	2105.3	12097.0
2019-05-03	FBON	Futures	136.53	136.53	136.15	136.49	241.0
2019-05-03	FBTP	Futures	115.94	115.95	115.63	115.88	51454.0
2019-05-03	FBTS	Futures	105.941	106.103	105.912	106.055	62127.0
2019-05-03	FCE	Futures	4970.9	4988.4	4960.5	4973.6	49001.0
2019-05-03	FDAX	Futures	12974.8	13126.4	12973.8	13060.6	88961.0
2019-05-03	FDIV	Futures	150.03	150.17	150.03	150.17	6.0
2019-05-03	FDXM	Futures	12856.1	13005.3	12856.1	12947.4	31828.0
2019-05-03	FESX	Futures	3002.1	3024.8	2999.5	3013.5	591087.0
2019-05-03	FGBL	Futures	159.36	159.68	159.07	159.5	599610.0
2019-05-03	FGBM	Futures	132.94	133.04	132.83	132.97	404568.0
2019-05-03	FGBS	Futures	112.754	112.774	112.744	112.764	201469.0
2019-05-03	FGBX	Futures	192.65	193.16	191.44	192.67	32066.0
2019-05-03	FMWO	Futures	7264.7	7323.7	7264.7	7307.5	2153.0
2019-05-03	FOAT	Futures	146.53	146.83	146.31	146.71	128155.0
2019-05-03	FTDX	Futures	2846.8	2849.3	2836.0	2841.4	113.0
2019-05-03	FTI	Futures	535.61	539.64	535.14	537.33	21080.0
2019-05-03	FTUK	Futures	6691.7	6760.5	6688.0	6721.5	76375.0
2019-05-03	FVSA	Futures	202.49	202.49	192.02	194.11	25214.0
2019-05-03	FXXP	Futures	344.7	347.0	344.5	345.9	52330.0
2019-05-03	G	Futures	117.29	117.53	116.98	117.06	158689.0
2019-05-03	GF	Futures	288.921	289.13	285.382	285.538	2618.0
2019-05-03	GSCI	Futures	498.13	498.69	496.55	497.62	35.0

> showing 50 of 115 rows — these rows as CSV

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