PREVIEW / futures_daily / 2017-08-21

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-21.parquet
  size:    9 KB
  rows:    109

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-08-21	ES	Futures	2639.62	2642.61	2625.49	2638.81	1339966.0
2017-08-21	NQ	Futures	6824.02	6837.83	6762.01	6811.09	360383.0
2017-08-21	YM	Futures	22927.6	22960.4	22811.3	22930.8	128742.0
2017-08-21	CL	Futures	50.18	50.2	48.45	48.78	885024.0
2017-08-21	GC	Futures	1640.3	1653.8	1636.6	1649.9	261478.0
2017-08-21	ZN	Futures	124.811793	124.996471	124.688674	124.934912	857262.0
2017-08-21	A6	Futures	0.814	0.81646	0.81245	0.81482	54294.0
2017-08-21	AD	Futures	0.80899	0.81041	0.80696	0.80955	44863.0
2017-08-21	ALI	Futures	2708.66	2708.66	2708.66	2708.66	0.0
2017-08-21	B	Futures	37.07	37.07	35.88	36.14	271574.0
2017-08-21	B6	Futures	1.3467	1.3511	1.3442	1.3493	70584.0
2017-08-21	BR	Futures	0.235	0.23611	0.23351	0.23384	1862.0
2017-08-21	BZ	Futures	36.69	36.69	35.57	35.83	33088.0
2017-08-21	C	Futures	1496.0	1502.0	1467.0	1493.0	5058.0
2017-08-21	CB	Futures	322.383	324.147	319.342	319.342	12.0
2017-08-21	CC	Futures	1394.0	1417.0	1371.0	1405.0	19598.0
2017-08-21	CNH	Futures	6.9084	6.9084	6.8949	6.8949	13.0
2017-08-21	CSC	Futures	3.577	3.588	3.563	3.575	47.0
2017-08-21	CT	Futures	79.26	80.27	78.79	80.19	69.0
2017-08-21	DC	Futures	29.72	29.98	29.62	29.82	227.0
2017-08-21	DX	Futures	87.181	87.303	86.766	86.852	18575.0
2017-08-21	E1	Futures	1.27518	1.28144	1.27026	1.27911	19914.0
2017-08-21	E6	Futures	1.34933	1.35717	1.346	1.35511	144246.0
2017-08-21	E7	Futures	1.342	1.35	1.3389	1.348	2606.0
2017-08-21	EBM	Futures	172.86	173.14	169.25	169.52	12515.0
2017-08-21	ED	Futures	95.5935	95.6007	95.5935	95.6007	104318.0
2017-08-21	ER	Futures	98.342	98.342	98.337	98.337	11097.0
2017-08-21	EW	Futures	1797.2	1802.1	1789.4	1796.1	12124.0
2017-08-21	FBON	Futures	125.17	125.41	125.08	125.17	238.0
2017-08-21	FBTP	Futures	109.29	109.63	109.15	109.28	57618.0
2017-08-21	FBTS	Futures	103.082	103.091	103.054	103.064	24769.0
2017-08-21	FCE	Futures	4564.6	4570.9	4530.2	4549.9	69639.0
2017-08-21	FDAX	Futures	12792.9	12801.3	12648.6	12689.7	87543.0
2017-08-21	FDXM	Futures	12714.2	12722.5	12569.7	12611.6	28425.0
2017-08-21	FESX	Futures	2803.9	2808.7	2781.8	2791.6	770384.0
2017-08-21	FGBL	Futures	149.07	149.5	149.03	149.38	376327.0
2017-08-21	FGBM	Futures	129.46	129.63	129.43	129.57	208328.0
2017-08-21	FGBS	Futures	112.347	112.397	112.347	112.387	158903.0
2017-08-21	FGBX	Futures	168.51	169.56	168.51	169.07	19268.0
2017-08-21	FMWO	Futures	6436.4	6459.1	6435.2	6444.8	3252.0
2017-08-21	FOAT	Futures	136.16	136.42	136.12	136.34	58060.0
2017-08-21	FTDX	Futures	2250.1	2259.6	2242.1	2245.1	54.0
2017-08-21	FTI	Futures	480.15	480.65	477.0	478.25	26746.0
2017-08-21	FTUK	Futures	6318.2	6329.9	6296.6	6315.7	72592.0
2017-08-21	FVSA	Futures	551.05	557.35	538.45	551.05	19125.0
2017-08-21	FXXP	Futures	318.0	318.7	316.3	316.9	33909.0
2017-08-21	G	Futures	115.89	116.26	115.85	116.15	133617.0
2017-08-21	GF	Futures	306.508	306.727	303.329	305.083	5998.0
2017-08-21	GSCI	Futures	454.87	454.87	450.38	450.38	9.0
2017-08-21	HE	Futures	91.679	91.959	89.929	90.524	17147.0

> showing 50 of 109 rows — these rows as CSV

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