PREVIEW / futures_daily / 2017-12-28

all futures daily files

  file:    by_date/futures_daily/2017/2017-12-28.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-12-28	ES	Futures	2917.18	2922.62	2916.1	2919.08	535624.0
2017-12-28	NQ	Futures	7556.74	7586.32	7545.03	7549.72	138254.0
2017-12-28	YM	Futures	26144.8	26196.4	26137.4	26151.1	59438.0
2017-12-28	CL	Futures	59.52	59.93	59.43	59.83	345962.0
2017-12-28	GC	Futures	1638.0	1644.7	1636.1	1644.6	225664.0
2017-12-28	ZN	Futures	122.376271	122.391697	122.191156	122.268287	767669.0
2017-12-28	A6	Futures	0.79915	0.80326	0.79905	0.80193	49703.0
2017-12-28	AD	Futures	0.80346	0.80919	0.80315	0.80889	60515.0
2017-12-28	B	Futures	47.26	47.49	47.05	47.37	183704.0
2017-12-28	B6	Futures	1.3987	1.4031	1.3971	1.4019	56455.0
2017-12-28	BR	Futures	0.22641	0.2282	0.22641	0.2282	31.0
2017-12-28	BTC	Futures	19402.7	19569.2	17110.3	17603.3	746.0
2017-12-28	BZ	Futures	46.53	46.84	46.43	46.73	15221.0
2017-12-28	C	Futures	1259.0	1279.0	1251.0	1274.0	9112.0
2017-12-28	CB	Futures	274.39	275.379	274.39	275.379	1.0
2017-12-28	CC	Futures	1400.0	1438.0	1400.0	1426.0	21249.0
2017-12-28	CNH	Futures	6.7154	6.7154	6.6899	6.6916	42.0
2017-12-28	CSC	Futures	3.221	3.229	3.221	3.225	40.0
2017-12-28	CT	Futures	91.97	92.79	91.8	92.04	12897.0
2017-12-28	DC	Futures	25.28	25.39	25.24	25.33	114.0
2017-12-28	DX	Futures	87.045	87.045	86.656	86.679	15435.0
2017-12-28	E1	Futures	1.23953	1.249	1.2371	1.24767	20150.0
2017-12-28	E6	Futures	1.35587	1.36199	1.35502	1.36125	129545.0
2017-12-28	E7	Futures	1.3487	1.3551	1.3483	1.3545	2315.0
2017-12-28	EBM	Futures	172.08	172.08	171.54	171.81	5286.0
2017-12-28	ED	Futures	95.4039	95.4136	95.399	95.4039	140655.0
2017-12-28	ER	Futures	98.337	98.342	98.332	98.332	68653.0
2017-12-28	EW	Futures	2024.4	2030.4	2020.2	2029.6	8882.0
2017-12-28	FBON	Futures	126.8	126.92	126.24	126.46	109.0
2017-12-28	FBTP	Futures	112.06	112.28	111.63	111.84	61721.0
2017-12-28	FBTS	Futures	103.604	103.613	103.439	103.476	28845.0
2017-12-28	FCE	Futures	4796.2	4803.8	4766.7	4775.2	36201.0
2017-12-28	FDAX	Futures	13535.4	13556.7	13443.6	13450.8	44942.0
2017-12-28	FDIV	Futures	150.52	150.52	149.77	149.77	5.0
2017-12-28	FDXM	Futures	13558.9	13578.6	13465.4	13473.7	12757.0
2017-12-28	FESX	Futures	2890.3	2891.1	2864.1	2865.8	422248.0
2017-12-28	FGBL	Futures	150.39	150.4	149.83	149.95	267472.0
2017-12-28	FGBM	Futures	129.45	129.47	129.29	129.38	199048.0
2017-12-28	FGBS	Futures	112.336	112.377	112.326	112.357	168283.0
2017-12-28	FGBX	Futures	170.41	170.51	168.89	169.24	21973.0
2017-12-28	FMWO	Futures	6963.2	6963.2	6949.2	6949.2	349.0
2017-12-28	FOAT	Futures	138.81	138.88	138.21	138.39	50341.0
2017-12-28	FTDX	Futures	2525.4	2525.4	2514.4	2514.4	36.0
2017-12-28	FTI	Futures	507.0	508.02	505.66	506.31	10783.0
2017-12-28	FTUK	Futures	6606.5	6623.5	6601.3	6610.0	45292.0
2017-12-28	FVSA	Futures	285.5	294.98	280.23	293.93	10388.0
2017-12-28	FXXP	Futures	331.4	331.7	330.2	330.3	20214.0
2017-12-28	G	Futures	115.49	115.57	115.25	115.34	105892.0
2017-12-28	GF	Futures	313.653	317.058	311.545	314.788	2330.0
2017-12-28	GSCI	Futures	510.91	512.59	510.38	511.66	27.0

> showing 50 of 111 rows — these rows as CSV

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