PREVIEW / futures_daily / 2017-01-30

all futures daily files

  file:    by_date/futures_daily/2017/2017-01-30.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-01-30	ES	Futures	2473.92	2477.98	2453.59	2467.41	1850992.0
2017-01-30	NQ	Futures	6065.41	6075.14	6004.42	6039.78	249340.0
2017-01-30	YM	Futures	21033.3	21058.6	20855.3	20948.0	148335.0
2017-01-30	CL	Futures	56.88	57.21	56.09	56.32	486309.0
2017-01-30	GC	Futures	1526.1	1534.6	1520.2	1527.9	191770.0
2017-01-30	ZN	Futures	121.476876	121.629697	121.339338	121.492158	1214640.0
2017-01-30	A6	Futures	0.7732	0.77412	0.77023	0.77279	60218.0
2017-01-30	AD	Futures	0.77791	0.78148	0.77597	0.77934	45527.0
2017-01-30	ALI	Futures	2457.17	2457.17	2451.72	2451.72	30.0
2017-01-30	B	Futures	41.05	41.19	40.59	40.79	272301.0
2017-01-30	B6	Futures	1.3196	1.3229	1.3086	1.3106	83011.0
2017-01-30	BFX	Futures	4359.0	4370.5	4314.8	4322.0	10.0
2017-01-30	BR	Futures	0.22404	0.22756	0.22272	0.22664	3227.0
2017-01-30	BZ	Futures	40.78	40.98	40.38	40.59	23968.0
2017-01-30	C	Futures	1752.0	1768.0	1747.0	1749.0	19360.0
2017-01-30	CB	Futures	276.217	276.278	276.217	276.278	2.0
2017-01-30	CC	Futures	1597.0	1606.0	1579.0	1582.0	28507.0
2017-01-30	CNH	Futures	7.2932	7.2947	7.2827	7.2827	11.0
2017-01-30	CSC	Futures	3.96	3.972	3.919	3.944	132.0
2017-01-30	CT	Futures	86.04	86.52	85.08	85.17	17296.0
2017-01-30	DC	Futures	32.73	32.9	32.44	32.69	433.0
2017-01-30	DX	Futures	93.509	94.054	93.244	93.494	38519.0
2017-01-30	E1	Futures	1.24458	1.25066	1.23653	1.2483	27549.0
2017-01-30	E6	Futures	1.23928	1.24269	1.22871	1.2372	206051.0
2017-01-30	E7	Futures	1.233	1.2362	1.2224	1.2308	3927.0
2017-01-30	EBM	Futures	192.85	192.85	189.71	190.28	33815.0
2017-01-30	ED	Futures	95.552	95.5665	95.5472	95.5617	210796.0
2017-01-30	ER	Futures	98.308	98.308	98.303	98.303	38554.0
2017-01-30	EW	Futures	1800.0	1800.0	1771.5	1789.5	21423.0
2017-01-30	FBON	Futures	120.91	120.93	120.24	120.58	1093.0
2017-01-30	FBTP	Futures	104.03	104.06	103.02	103.35	177292.0
2017-01-30	FBTS	Futures	101.539	101.584	101.358	101.439	59320.0
2017-01-30	FCE	Futures	4247.9	4254.1	4201.2	4212.7	84203.0
2017-01-30	FDAX	Futures	12433.1	12452.6	12311.2	12323.3	78128.0
2017-01-30	FDXM	Futures	12385.1	12403.0	12261.0	12273.7	23635.0
2017-01-30	FESX	Futures	2630.3	2632.7	2597.5	2601.5	970909.0
2017-01-30	FEU3	Futures	98.971	98.971	98.971	98.971	3.0
2017-01-30	FGBL	Futures	146.04	146.3	145.51	146.16	811990.0
2017-01-30	FGBM	Futures	128.35	128.47	128.18	128.42	532617.0
2017-01-30	FGBS	Futures	112.017	112.052	111.992	112.047	243206.0
2017-01-30	FGBX	Futures	164.81	165.34	162.97	164.89	52397.0
2017-01-30	FMWO	Futures	5997.4	5997.4	5958.8	5966.0	875.0
2017-01-30	FOAT	Futures	130.6	130.6	129.65	130.33	160216.0
2017-01-30	FTDX	Futures	1824.9	1824.9	1808.2	1808.7	166.0
2017-01-30	FTI	Futures	440.83	441.51	434.62	435.99	34885.0
2017-01-30	FTUK	Futures	6014.3	6020.3	5969.0	5973.6	96223.0
2017-01-30	FVSA	Futures	845.53	885.79	843.16	881.05	15120.0
2017-01-30	FXXP	Futures	302.1	302.1	299.0	299.3	29265.0
2017-01-30	G	Futures	110.27	110.68	109.96	110.55	151162.0
2017-01-30	GF	Futures	285.423	285.423	281.547	282.459	5379.0

> showing 50 of 110 rows — these rows as CSV

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