PREVIEW / futures_daily / 2017-06-22

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-22.parquet
  size:    9 KB
  rows:    110

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-06-22	ES	Futures	2642.88	2650.76	2638.81	2642.88	1056822.0
2017-06-22	NQ	Futures	6810.2	6835.18	6783.75	6801.39	233021.0
2017-06-22	YM	Futures	22581.9	22630.6	22560.8	22567.1	100300.0
2017-06-22	CL	Futures	43.94	44.73	43.64	44.14	668830.0
2017-06-22	GC	Futures	1591.1	1603.4	1591.1	1595.0	187385.0
2017-06-22	ZN	Futures	124.704064	124.904132	124.673284	124.765623	884620.0
2017-06-22	A6	Futures	0.77517	0.77588	0.77311	0.77404	55790.0
2017-06-22	AD	Futures	0.76429	0.77121	0.76368	0.76912	66599.0
2017-06-22	ALI	Futures	2467.84	2467.84	2467.84	2467.84	0.0
2017-06-22	B	Futures	31.88	32.57	31.68	32.17	346755.0
2017-06-22	B6	Futures	1.3281	1.3298	1.3259	1.3275	66366.0
2017-06-22	BFX	Futures	4632.5	4649.4	4632.5	4649.4	5.0
2017-06-22	BR	Futures	0.21977	0.21977	0.21977	0.21977	67.0
2017-06-22	BZ	Futures	31.76	32.43	31.56	32.03	28351.0
2017-06-22	C	Futures	1526.0	1528.0	1482.0	1505.0	8621.0
2017-06-22	CB	Futures	321.015	321.015	318.703	321.015	181.0
2017-06-22	CC	Futures	1389.0	1402.0	1371.0	1384.0	21477.0
2017-06-22	CNH	Futures	7.1003	7.1003	7.0981	7.0981	6.0
2017-06-22	CSC	Futures	3.538	3.555	3.538	3.548	15.0
2017-06-22	CT	Futures	78.63	79.06	78.28	78.79	4579.0
2017-06-22	DC	Futures	29.48	29.65	29.46	29.53	223.0
2017-06-22	DX	Futures	90.785	90.902	90.683	90.858	27551.0
2017-06-22	E1	Futures	1.2699	1.27149	1.26756	1.26977	15329.0
2017-06-22	E6	Futures	1.28551	1.28654	1.28219	1.28305	123236.0
2017-06-22	E7	Futures	1.2787	1.2796	1.2754	1.2763	2578.0
2017-06-22	EBM	Futures	194.58	194.85	193.46	193.74	12583.0
2017-06-22	ED	Futures	95.5838	95.5838	95.5692	95.5789	166784.0
2017-06-22	ER	Futures	98.332	98.337	98.332	98.332	28232.0
2017-06-22	EW	Futures	1839.4	1849.8	1835.2	1845.3	9185.0
2017-06-22	FBON	Futures	125.41	125.75	125.38	125.47	1012.0
2017-06-22	FBTP	Futures	110.22	110.67	110.01	110.19	103306.0
2017-06-22	FBTS	Futures	102.954	103.0	102.927	102.945	38883.0
2017-06-22	FCE	Futures	4744.7	4761.8	4712.3	4756.9	70325.0
2017-06-22	FDAX	Futures	13449.4	13477.3	13380.4	13474.1	61987.0
2017-06-22	FDXM	Futures	13365.0	13394.3	13298.1	13391.2	19920.0
2017-06-22	FESX	Futures	2892.0	2898.5	2870.8	2897.7	656223.0
2017-06-22	FEU3	Futures	99.011	99.011	99.006	99.006	43.0
2017-06-22	FGBL	Futures	149.88	150.12	149.78	149.97	636807.0
2017-06-22	FGBM	Futures	129.47	129.54	129.24	129.51	658696.0
2017-06-22	FGBS	Futures	112.222	112.232	112.151	112.202	419027.0
2017-06-22	FGBX	Futures	171.78	172.49	171.7	172.1	46114.0
2017-06-22	FMWO	Futures	6411.4	6426.9	6403.1	6426.9	626.0
2017-06-22	FOAT	Futures	137.25	137.32	137.0	137.18	87952.0
2017-06-22	FTDX	Futures	2290.2	2290.2	2274.7	2286.7	134.0
2017-06-22	FTI	Futures	478.7	479.9	475.29	478.61	23112.0
2017-06-22	FTUK	Futures	6371.0	6394.7	6339.0	6377.9	82767.0
2017-06-22	FVSA	Futures	484.94	491.24	469.19	470.77	10974.0
2017-06-22	FXXP	Futures	329.4	329.8	327.4	329.7	23482.0
2017-06-22	G	Futures	116.36	116.65	116.29	116.39	185583.0
2017-06-22	GF	Futures	314.515	316.546	311.058	314.899	3911.0

> showing 50 of 110 rows — these rows as CSV

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