PREVIEW / futures_daily / 2017-05-25

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-25.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-05-25	ES	Futures	2609.76	2625.78	2609.22	2621.17	1315611.0
2017-05-25	NQ	Futures	6750.5	6825.88	6750.21	6809.98	239940.0
2017-05-25	YM	Futures	22155.4	22258.8	22144.8	22225.0	113070.0
2017-05-25	CL	Futures	53.08	53.86	50.18	50.65	1147389.0
2017-05-25	GC	Futures	1609.3	1610.5	1603.0	1606.7	202847.0
2017-05-25	ZN	Futures	124.074089	124.135542	123.935819	124.058725	2433716.0
2017-05-25	A6	Futures	0.76983	0.77126	0.76449	0.765	75514.0
2017-05-25	AD	Futures	0.76105	0.76202	0.75605	0.75631	74748.0
2017-05-25	ALI	Futures	2577.25	2577.25	2577.25	2577.25	0.0
2017-05-25	B	Futures	38.7	39.08	36.53	36.83	393667.0
2017-05-25	B6	Futures	1.3604	1.3653	1.3566	1.3571	79960.0
2017-05-25	BR	Futures	0.22111	0.22111	0.22111	0.22111	1.0
2017-05-25	BZ	Futures	38.42	38.89	36.37	36.67	44720.0
2017-05-25	C	Futures	1483.0	1508.0	1460.0	1466.0	8194.0
2017-05-25	CB	Futures	300.457	302.282	296.929	299.849	45.0
2017-05-25	CC	Futures	1453.0	1473.0	1427.0	1435.0	22376.0
2017-05-25	CNH	Futures	7.168	7.168	7.1435	7.1467	112.0
2017-05-25	CSC	Futures	3.618	3.653	3.612	3.643	60.0
2017-05-25	CT	Futures	85.84	86.54	85.39	85.45	16364.0
2017-05-25	DC	Futures	30.29	30.7	30.29	30.59	293.0
2017-05-25	DX	Futures	90.278	90.562	90.19	90.535	21262.0
2017-05-25	E1	Futures	1.2706	1.27542	1.27035	1.27147	16128.0
2017-05-25	E6	Futures	1.2932	1.29729	1.29067	1.29193	146755.0
2017-05-25	E7	Futures	1.2866	1.2906	1.2842	1.2853	2724.0
2017-05-25	EBM	Futures	185.95	186.78	185.67	185.67	2356.0
2017-05-25	ED	Futures	95.5954	95.5954	95.5833	95.5857	187449.0
2017-05-25	ER	Futures	98.337	98.337	98.332	98.337	13092.0
2017-05-25	EW	Futures	1835.6	1848.0	1835.5	1838.7	12537.0
2017-05-25	FBON	Futures	123.12	123.26	123.1	123.2	355.0
2017-05-25	FBTP	Futures	107.3	107.47	107.22	107.33	106084.0
2017-05-25	FBTS	Futures	102.525	102.535	102.48	102.489	28381.0
2017-05-25	FCE	Futures	4776.6	4791.0	4741.6	4755.5	74890.0
2017-05-25	FDAX	Futures	13370.5	13417.0	13235.9	13315.6	83424.0
2017-05-25	FDXM	Futures	13258.3	13298.1	13120.2	13198.7	23241.0
2017-05-25	FESX	Futures	2926.3	2932.8	2901.8	2910.8	746070.0
2017-05-25	FGBL	Futures	148.06	148.36	147.99	148.25	537741.0
2017-05-25	FGBM	Futures	129.21	129.37	129.21	129.32	409250.0
2017-05-25	FGBS	Futures	112.237	112.272	112.232	112.262	270996.0
2017-05-25	FGBX	Futures	165.75	166.75	165.45	166.25	28341.0
2017-05-25	FMWO	Futures	6439.8	6449.4	6432.6	6442.2	633.0
2017-05-25	FOAT	Futures	134.7	135.02	134.62	134.84	91459.0
2017-05-25	FTDX	Futures	2234.2	2234.2	2208.2	2229.8	119.0
2017-05-25	FTI	Futures	484.46	485.38	480.98	483.23	25571.0
2017-05-25	FTUK	Futures	6425.1	6439.7	6401.6	6419.1	76484.0
2017-05-25	FVSA	Futures	507.9	523.13	506.2	514.67	7537.0
2017-05-25	FXXP	Futures	331.2	331.7	329.1	330.1	11639.0
2017-05-25	G	Futures	115.95	116.08	115.82	115.98	348869.0
2017-05-25	GF	Futures	327.083	332.022	324.613	331.747	4457.0
2017-05-25	GSCI	Futures	479.44	481.84	469.65	470.39	28.0
2017-05-25	HE	Futures	86.853	87.718	86.122	87.583	6504.0

> showing 50 of 108 rows — these rows as CSV

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