PREVIEW / futures_daily / 2018-05-07

all futures daily files

  file:    by_date/futures_daily/2018/2018-05-07.parquet
  size:    9 KB
  rows:    108

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
2018-05-07	ES	Futures	2895.66	2916.05	2894.02	2903.54	1148919.0
2018-05-07	NQ	Futures	7934.37	8018.93	7926.47	7989.38	323768.0
2018-05-07	YM	Futures	25519.7	25729.3	25496.5	25598.7	172201.0
2018-05-07	CL	Futures	70.11	71.1	69.76	70.99	758916.0
2018-05-07	GC	Futures	1680.5	1685.3	1673.2	1677.7	235292.0
2018-05-07	ZN	Futures	118.733705	118.873282	118.687179	118.795739	633457.0
2018-05-07	A6	Futures	0.77519	0.77571	0.77057	0.77293	80166.0
2018-05-07	AD	Futures	0.78809	0.78864	0.7849	0.78652	48774.0
2018-05-07	B	Futures	54.96	55.94	54.84	55.82	230472.0
2018-05-07	B6	Futures	1.4038	1.4085	1.4023	1.4069	61615.0
2018-05-07	BFX	Futures	4503.5	4503.5	4497.2	4497.2	7.0
2018-05-07	BR	Futures	0.21477	0.21549	0.21363	0.21393	1412.0
2018-05-07	BTC	Futures	13488.1	13628.6	12863.2	13249.4	4705.0
2018-05-07	BZ	Futures	54.38	55.36	54.29	55.25	21266.0
2018-05-07	CB	Futures	294.003	294.003	290.358	292.18	29.0
2018-05-07	CC	Futures	2018.0	2087.0	2006.0	2076.0	16137.0
2018-05-07	CNH	Futures	6.4498	6.4693	6.4498	6.4581	36.0
2018-05-07	CSC	Futures	3.467	3.509	3.467	3.503	39.0
2018-05-07	CT	Futures	98.78	100.13	97.66	97.75	26087.0
2018-05-07	DC	Futures	27.84	28.25	27.84	28.23	170.0
2018-05-07	DX	Futures	87.16	87.546	87.042	87.327	19364.0
2018-05-07	E1	Futures	1.20791	1.2102	1.20165	1.20502	19584.0
2018-05-07	E6	Futures	1.35106	1.35325	1.34407	1.34717	165318.0
2018-05-07	E7	Futures	1.3438	1.346	1.337	1.34	2872.0
2018-05-07	EBM	Futures	182.03	182.56	181.51	181.77	11175.0
2018-05-07	ED	Futures	94.9208	94.9257	94.9111	94.916	76703.0
2018-05-07	ER	Futures	98.347	98.347	98.342	98.347	10373.0
2018-05-07	EW	Futures	2011.8	2030.7	2009.6	2020.6	9877.0
2018-05-07	FBON	Futures	129.46	129.69	129.45	129.64	107.0
2018-05-07	FBTP	Futures	115.79	116.19	115.65	116.11	40925.0
2018-05-07	FBTS	Futures	104.278	104.324	104.278	104.315	17360.0
2018-05-07	FCE	Futures	4919.0	4919.0	4887.3	4912.3	41192.0
2018-05-07	FDAX	Futures	13384.5	13479.0	13319.0	13469.7	74303.0
2018-05-07	FDXM	Futures	13266.3	13358.0	13200.4	13349.8	21681.0
2018-05-07	FESX	Futures	2927.2	2935.6	2910.6	2933.9	542754.0
2018-05-07	FGBL	Futures	149.72	150.02	149.69	149.92	254131.0
2018-05-07	FGBM	Futures	129.68	129.77	129.66	129.73	131183.0
2018-05-07	FGBS	Futures	112.517	112.527	112.507	112.512	85093.0
2018-05-07	FGBX	Futures	169.54	170.41	169.54	170.29	19665.0
2018-05-07	FMWO	Futures	6951.5	6983.0	6949.1	6980.7	3047.0
2018-05-07	FOAT	Futures	138.67	139.0	138.67	138.93	38481.0
2018-05-07	FTDX	Futures	2681.5	2724.0	2681.5	2723.5	268.0
2018-05-07	FTI	Futures	512.75	514.27	511.09	513.76	12752.0
2018-05-07	FVSA	Futures	331.79	331.79	326.05	326.05	15222.0
2018-05-07	FXXP	Futures	332.0	334.6	331.4	334.5	22397.0
2018-05-07	GF	Futures	301.657	301.657	295.739	296.169	2198.0
2018-05-07	GSCI	Futures	542.56	543.97	538.68	542.51	3518.0
2018-05-07	HE	Futures	77.251	78.67	76.778	77.934	21670.0
2018-05-07	HG	Futures	3.6343	3.6573	3.6078	3.6272	57375.0
2018-05-07	HH	Futures	17.494	17.797	17.417	17.662	4577.0

> showing 50 of 108 rows — these rows as CSV

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