PREVIEW / futures_daily / 2017-04-04

all futures daily files

  file:    by_date/futures_daily/2017/2017-04-04.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-04-04	ES	Futures	2556.82	2561.7	2546.5	2559.26	1209054.0
2017-04-04	NQ	Futures	6398.64	6416.6	6368.01	6411.89	195119.0
2017-04-04	YM	Futures	21715.4	21792.4	21643.6	21772.3	112384.0
2017-04-04	CL	Futures	52.66	53.77	52.28	53.48	532054.0
2017-04-04	GC	Futures	1605.5	1616.0	1605.5	1609.3	158364.0
2017-04-04	ZN	Futures	123.1062	123.259833	122.798934	122.937204	1266102.0
2017-04-04	A6	Futures	0.77958	0.7806	0.77352	0.77496	86864.0
2017-04-04	AD	Futures	0.76319	0.76329	0.7586	0.76115	57048.0
2017-04-04	ALI	Futures	2582.47	2582.47	2582.47	2582.47	0.0
2017-04-04	B	Futures	38.57	39.44	38.24	39.29	302109.0
2017-04-04	B6	Futures	1.3109	1.3123	1.3042	1.3075	90527.0
2017-04-04	BR	Futures	0.22894	0.23114	0.22781	0.23086	54.0
2017-04-04	BZ	Futures	38.43	39.31	38.15	39.18	27204.0
2017-04-04	C	Futures	1755.0	1767.0	1737.0	1760.0	10251.0
2017-04-04	CB	Futures	267.306	267.306	266.086	266.086	9.0
2017-04-04	CC	Futures	1609.0	1621.0	1596.0	1615.0	24811.0
2017-04-04	CSC	Futures	3.654	3.656	3.583	3.587	40.0
2017-04-04	CT	Futures	84.08	84.4	83.1	83.43	30266.0
2017-04-04	DC	Futures	30.07	30.18	29.42	29.6	150.0
2017-04-04	DX	Futures	93.483	93.73	93.446	93.563	15960.0
2017-04-04	E1	Futures	1.23872	1.23959	1.2365	1.23872	13762.0
2017-04-04	E6	Futures	1.23296	1.23411	1.22939	1.23313	140948.0
2017-04-04	E7	Futures	1.2269	1.2278	1.2231	1.2269	1897.0
2017-04-04	EBM	Futures	184.26	184.26	183.42	183.7	18265.0
2017-04-04	ED	Futures	95.5639	95.5736	95.5542	95.5591	218025.0
2017-04-04	ER	Futures	98.328	98.332	98.323	98.328	140578.0
2017-04-04	EW	Futures	1816.4	1818.7	1808.0	1814.2	17033.0
2017-04-04	FBON	Futures	122.21	122.54	121.95	122.32	515.0
2017-04-04	FBTP	Futures	104.87	105.4	104.81	105.2	82001.0
2017-04-04	FBTS	Futures	101.818	101.9	101.818	101.882	22480.0
2017-04-04	FCE	Futures	4489.7	4506.0	4473.8	4496.3	77539.0
2017-04-04	FDAX	Futures	12966.2	13013.2	12935.6	12993.1	62852.0
2017-04-04	FDXM	Futures	12854.4	12900.4	12821.9	12879.0	17615.0
2017-04-04	FESX	Futures	2779.4	2790.8	2769.6	2782.6	705207.0
2017-04-04	FGBL	Futures	149.08	149.55	149.04	149.37	832071.0
2017-04-04	FGBM	Futures	129.73	129.94	129.69	129.77	489824.0
2017-04-04	FGBS	Futures	112.462	112.527	112.417	112.442	414342.0
2017-04-04	FGBX	Futures	169.95	171.36	169.67	170.78	47996.0
2017-04-04	FMWO	Futures	6191.7	6209.7	6184.4	6209.7	258.0
2017-04-04	FOAT	Futures	131.9	132.48	131.85	132.23	120775.0
2017-04-04	FTDX	Futures	1984.7	2013.6	1984.7	2008.7	157.0
2017-04-04	FTI	Futures	466.34	467.7	464.7	466.47	21731.0
2017-04-04	FTUK	Futures	6193.6	6224.4	6180.8	6203.0	84173.0
2017-04-04	FVSA	Futures	650.26	654.42	641.94	646.1	16434.0
2017-04-04	FXXP	Futures	314.9	316.6	314.4	315.7	48861.0
2017-04-04	G	Futures	115.8	116.1	115.69	115.83	209976.0
2017-04-04	GF	Futures	305.981	305.981	301.657	302.176	3237.0
2017-04-04	GSCI	Futures	493.19	496.7	493.19	496.25	142.0
2017-04-04	HE	Futures	82.604	82.873	81.468	81.498	146.0
2017-04-04	HG	Futures	3.2076	3.2285	3.1953	3.2175	44110.0

> showing 50 of 108 rows — these rows as CSV

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