PREVIEW / futures_daily / 2017-07-25

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-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-07-25	ES	Futures	2681.19	2693.96	2680.38	2688.8	1074033.0
2017-07-25	NQ	Futures	6965.38	6990.06	6954.21	6975.37	237095.0
2017-07-25	YM	Futures	22722.5	22875.8	22708.8	22791.3	115421.0
2017-07-25	CL	Futures	47.79	50.05	47.71	49.26	885700.0
2017-07-25	GC	Futures	1602.4	1605.9	1594.2	1598.4	230392.0
2017-07-25	ZN	Futures	124.242368	124.303927	123.595994	123.688333	1468763.0
2017-07-25	A6	Futures	0.81348	0.81821	0.81132	0.81502	81194.0
2017-07-25	AD	Futures	0.81367	0.81545	0.81214	0.81362	66333.0
2017-07-25	ALI	Futures	2554.66	2554.66	2554.66	2554.66	0.0
2017-07-25	B	Futures	34.39	35.99	34.38	35.49	284288.0
2017-07-25	B6	Futures	1.3635	1.3698	1.3617	1.3649	82252.0
2017-07-25	BR	Futures	0.23433	0.23459	0.23262	0.23292	2940.0
2017-07-25	BZ	Futures	34.24	35.76	34.18	35.27	27529.0
2017-07-25	C	Futures	1570.0	1570.0	1527.0	1533.0	10587.0
2017-07-25	CB	Futures	319.92	319.92	319.889	319.92	49.0
2017-07-25	CC	Futures	1488.0	1493.0	1455.0	1462.0	23876.0
2017-07-25	CSC	Futures	3.441	3.505	3.439	3.503	108.0
2017-07-25	CT	Futures	81.08	81.17	81.08	81.17	1.0
2017-07-25	DC	Futures	28.62	29.22	28.59	29.13	416.0
2017-07-25	DX	Futures	87.634	87.737	87.27	87.67	23124.0
2017-07-25	E1	Futures	1.30146	1.30342	1.29372	1.29544	26193.0
2017-07-25	E6	Futures	1.33724	1.34577	1.33644	1.33861	223824.0
2017-07-25	E7	Futures	1.3299	1.3386	1.3294	1.3316	4331.0
2017-07-25	EBM	Futures	188.45	189.57	187.06	187.34	17992.0
2017-07-25	ED	Futures	95.5741	95.5789	95.5644	95.5692	213916.0
2017-07-25	ER	Futures	98.337	98.342	98.337	98.342	40382.0
2017-07-25	EW	Futures	1887.3	1907.1	1886.5	1904.3	18704.0
2017-07-25	FBON	Futures	124.56	124.64	123.91	123.97	671.0
2017-07-25	FBTP	Futures	108.85	109.08	107.87	107.97	86280.0
2017-07-25	FBTS	Futures	102.909	102.936	102.872	102.881	42620.0
2017-07-25	FCE	Futures	4620.8	4663.9	4605.1	4633.8	89650.0
2017-07-25	FDAX	Futures	12888.2	12944.5	12848.2	12912.9	82263.0
2017-07-25	FDXM	Futures	12801.0	12864.8	12769.6	12833.5	21385.0
2017-07-25	FESX	Futures	2822.6	2847.9	2813.6	2834.1	838100.0
2017-07-25	FGBL	Futures	147.59	147.68	146.77	146.8	666994.0
2017-07-25	FGBM	Futures	128.86	128.9	128.59	128.62	375924.0
2017-07-25	FGBS	Futures	112.217	112.227	112.187	112.202	228390.0
2017-07-25	FGBX	Futures	164.85	165.01	162.85	162.95	40295.0
2017-07-25	FMWO	Futures	6532.9	6561.5	6532.9	6553.1	1282.0
2017-07-25	FOAT	Futures	135.46	135.63	134.74	134.78	118146.0
2017-07-25	FTDX	Futures	2263.6	2272.7	2260.1	2260.1	85.0
2017-07-25	FTI	Futures	480.94	483.58	479.74	481.82	26162.0
2017-07-25	FTUK	Futures	6328.2	6386.1	6328.2	6376.1	90400.0
2017-07-25	FVSA	Futures	447.95	447.95	427.18	433.12	27257.0
2017-07-25	FXXP	Futures	322.7	324.7	322.0	323.5	46429.0
2017-07-25	G	Futures	114.76	114.89	114.07	114.19	198810.0
2017-07-25	GF	Futures	325.875	327.467	321.156	321.649	5738.0
2017-07-25	GSCI	Futures	456.36	458.36	454.9	457.82	840.0
2017-07-25	HE	Futures	93.272	93.875	92.784	93.559	8512.0
2017-07-25	HG	Futures	3.3384	3.4716	3.3263	3.4625	154048.0

> showing 50 of 108 rows — these rows as CSV

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