PREVIEW / futures_daily / 2017-09-28

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-28.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
2017-09-28	ES	Futures	2722.77	2728.21	2718.15	2727.66	1109027.0
2017-09-28	NQ	Futures	6972.49	6986.88	6943.42	6975.43	268097.0
2017-09-28	YM	Futures	23536.0	23596.2	23482.2	23569.8	94355.0
2017-09-28	CL	Futures	52.74	53.56	51.9	52.25	801816.0
2017-09-28	GC	Futures	1635.2	1643.4	1629.2	1639.8	288511.0
2017-09-28	ZN	Futures	123.655413	123.794057	123.301099	123.778652	1668758.0
2017-09-28	A6	Futures	0.80677	0.80801	0.80173	0.8078	113391.0
2017-09-28	AD	Futures	0.8159	0.81986	0.8131	0.8193	75476.0
2017-09-28	B	Futures	40.53	41.16	39.94	40.37	446370.0
2017-09-28	B6	Futures	1.3999	1.4063	1.3944	1.4052	112555.0
2017-09-28	BR	Futures	0.23471	0.236	0.23471	0.23528	1027.0
2017-09-28	BZ	Futures	40.19	40.8	39.62	40.04	36522.0
2017-09-28	C	Futures	1466.0	1476.0	1442.0	1444.0	18429.0
2017-09-28	CB	Futures	307.375	307.375	304.257	304.792	12.0
2017-09-28	CC	Futures	1495.0	1508.0	1466.0	1470.0	23229.0
2017-09-28	CNH	Futures	6.8576	6.8828	6.8546	6.8591	38.0
2017-09-28	CSC	Futures	3.505	3.507	3.466	3.472	60.0
2017-09-28	CT	Futures	80.69	81.4	80.18	81.01	9001.0
2017-09-28	DC	Futures	28.72	28.85	28.49	28.51	155.0
2017-09-28	DX	Futures	87.213	87.433	86.895	86.906	24777.0
2017-09-28	E1	Futures	1.26416	1.26697	1.25915	1.26673	23877.0
2017-09-28	E6	Futures	1.34597	1.35258	1.343	1.3511	230338.0
2017-09-28	E7	Futures	1.3388	1.3455	1.3361	1.344	3820.0
2017-09-28	EBM	Futures	180.17	180.71	179.36	179.63	19333.0
2017-09-28	ED	Futures	95.5085	95.5279	95.4939	95.523	308587.0
2017-09-28	ER	Futures	98.337	98.342	98.332	98.342	79361.0
2017-09-28	EW	Futures	1902.7	1908.1	1893.8	1906.9	13408.0
2017-09-28	FBON	Futures	124.55	124.94	124.28	124.78	665.0
2017-09-28	FBTP	Futures	108.16	108.76	107.96	108.72	119874.0
2017-09-28	FBTS	Futures	103.219	103.274	103.182	103.274	45303.0
2017-09-28	FCE	Futures	4741.0	4745.1	4726.2	4740.6	46468.0
2017-09-28	FDAX	Futures	13329.1	13363.8	13299.7	13337.5	57456.0
2017-09-28	FDXM	Futures	13214.5	13250.0	13186.4	13224.9	15630.0
2017-09-28	FESX	Futures	2897.7	2900.9	2891.1	2896.0	566102.0
2017-09-28	FEU3	Futures	99.011	99.011	99.006	99.006	1.0
2017-09-28	FGBL	Futures	148.46	148.83	148.16	148.68	767571.0
2017-09-28	FGBM	Futures	129.41	129.52	129.25	129.48	508399.0
2017-09-28	FGBS	Futures	112.392	112.432	112.367	112.417	274777.0
2017-09-28	FGBX	Futures	165.66	166.03	164.68	165.77	42219.0
2017-09-28	FMWO	Futures	6608.1	6628.2	6608.1	6622.3	2367.0
2017-09-28	FOAT	Futures	135.72	135.94	135.33	135.85	118097.0
2017-09-28	FTDX	Futures	2404.6	2417.6	2402.6	2414.1	80.0
2017-09-28	FTI	Futures	489.5	491.98	489.17	491.11	18800.0
2017-09-28	FTUK	Futures	6320.2	6324.9	6288.5	6315.0	86894.0
2017-09-28	FVSA	Futures	407.23	410.07	401.56	404.39	16738.0
2017-09-28	FXXP	Futures	326.9	327.3	325.9	326.8	29047.0
2017-09-28	G	Futures	112.77	113.36	112.69	113.16	198095.0
2017-09-28	GF	Futures	332.997	335.234	332.178	333.815	1953.0
2017-09-28	GSCI	Futures	477.47	478.79	477.05	478.61	260.0
2017-09-28	HE	Futures	87.56	88.446	85.899	86.046	16372.0

> showing 50 of 108 rows — these rows as CSV

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