PREVIEW / futures_daily / 2017-09-12

all futures daily files

  file:    by_date/futures_daily/2017/2017-09-12.parquet
  size:    10 KB
  rows:    111

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-12	ES	Futures	2704.29	2713.8	2702.66	2712.71	1042880.0
2017-09-12	NQ	Futures	7031.21	7057.95	7015.04	7049.13	125609.0
2017-09-12	YM	Futures	23266.7	23337.5	23255.1	23326.9	117504.0
2017-09-12	CL	Futures	49.39	49.72	48.99	49.5	676040.0
2017-09-12	GC	Futures	1694.5	1700.3	1688.1	1695.7	287754.0
2017-09-12	ZN	Futures	125.165097	125.226716	124.779973	124.856998	1213871.0
2017-09-12	A6	Futures	0.82539	0.82714	0.822	0.82426	28666.0
2017-09-12	AD	Futures	0.84052	0.84235	0.83497	0.83579	32398.0
2017-09-12	ALI	Futures	2760.58	2760.58	2760.58	2760.58	0.0
2017-09-12	B	Futures	37.71	38.18	37.46	38.06	279336.0
2017-09-12	B6	Futures	1.3772	1.3905	1.3764	1.3901	68079.0
2017-09-12	BFX	Futures	4730.8	4745.7	4724.9	4745.7	24.0
2017-09-12	BR	Futures	0.2383	0.2383	0.2383	0.2383	1456.0
2017-09-12	BZ	Futures	37.45	37.85	37.15	37.73	22720.0
2017-09-12	C	Futures	1444.0	1449.0	1428.0	1444.0	10676.0
2017-09-12	CB	Futures	305.989	309.012	305.989	307.375	24.0
2017-09-12	CC	Futures	1443.0	1454.0	1426.0	1449.0	18787.0
2017-09-12	CNH	Futures	6.7513	6.7513	6.737	6.7381	33.0
2017-09-12	CSC	Futures	3.377	3.443	3.377	3.437	99.0
2017-09-12	CT	Futures	85.64	85.75	82.52	82.52	17.0
2017-09-12	DC	Futures	27.52	28.03	27.47	27.98	194.0
2017-09-12	DX	Futures	85.726	85.852	85.586	85.685	11573.0
2017-09-12	E1	Futures	1.28715	1.28849	1.2792	1.28079	10122.0
2017-09-12	E6	Futures	1.3713	1.37375	1.36782	1.37272	100215.0
2017-09-12	E7	Futures	1.364	1.3665	1.3607	1.3656	1029.0
2017-09-12	EBM	Futures	171.27	173.7	171.27	172.08	25323.0
2017-09-12	ED	Futures	95.5957	95.5957	95.5812	95.586	320639.0
2017-09-12	ER	Futures	98.347	98.347	98.342	98.342	66850.0
2017-09-12	EW	Futures	1848.0	1863.1	1847.8	1860.7	30285.0
2017-09-12	FBON	Futures	124.9	124.98	124.68	124.78	660.0
2017-09-12	FBTP	Futures	110.11	110.12	109.42	109.58	78642.0
2017-09-12	FBTS	Futures	103.283	103.283	103.191	103.21	41829.0
2017-09-12	FCE	Futures	4630.4	4665.8	4630.4	4656.4	159729.0
2017-09-12	FDAX	Futures	13149.8	13223.5	13149.8	13186.2	122244.0
2017-09-12	FDIV	Futures	145.3	145.64	145.3	145.3	320.0
2017-09-12	FDXM	Futures	13022.8	13074.9	13006.1	13040.5	1851.0
2017-09-12	FESX	Futures	2845.5	2861.0	2844.6	2853.6	1722317.0
2017-09-12	FGBL	Futures	150.41	150.44	149.54	149.67	756453.0
2017-09-12	FGBM	Futures	130.09	130.09	129.78	129.8	438331.0
2017-09-12	FGBS	Futures	112.527	112.527	112.467	112.472	308452.0
2017-09-12	FGBX	Futures	169.79	170.01	167.42	167.87	69889.0
2017-09-12	FMWO	Futures	6630.5	6643.6	6630.5	6641.2	6050.0
2017-09-12	FOAT	Futures	137.34	137.4	136.52	136.64	100191.0
2017-09-12	FTDX	Futures	2370.7	2376.7	2355.2	2355.2	1084.0
2017-09-12	FTI	Futures	483.51	485.49	483.42	484.66	31337.0
2017-09-12	FTUK	Futures	6418.2	6419.1	6375.3	6393.5	434965.0
2017-09-12	FVSA	Futures	459.73	459.73	451.22	454.06	7921.0
2017-09-12	FXXP	Futures	322.1	323.4	321.9	323.1	156574.0
2017-09-12	G	Futures	116.28	116.33	115.38	115.43	245566.0
2017-09-12	GF	Futures	325.904	327.104	323.339	325.522	6095.0

> showing 50 of 111 rows — these rows as CSV

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