PREVIEW / futures_daily / 2016-07-05

all futures daily files

  file:    by_date/futures_daily/2016/2016-07-05.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
2016-07-05	ES	Futures	2267.08	2272.48	2237.66	2248.73	1862935.0
2016-07-05	NQ	Futures	5232.11	5247.14	5159.91	5191.15	200656.0
2016-07-05	YM	Futures	18676.0	18721.9	18476.5	18552.7	150836.0
2016-07-05	CL	Futures	57.05	57.32	53.82	54.13	609194.0
2016-07-05	GC	Futures	1730.4	1750.0	1722.0	1748.0	353805.0
2016-07-05	ZN	Futures	128.739104	129.403096	128.45238	129.312552	1121073.0
2016-07-05	A6	Futures	0.75707	0.76582	0.75625	0.75696	127057.0
2016-07-05	AD	Futures	0.7927	0.79772	0.78615	0.7881	71386.0
2016-07-05	ALI	Futures	2155.08	2155.08	2155.08	2155.08	0.0
2016-07-05	B	Futures	39.94	39.96	37.95	38.29	305737.0
2016-07-05	B6	Futures	1.4005	1.4075	1.3715	1.3744	173004.0
2016-07-05	BFX	Futures	3867.9	3867.9	3857.3	3859.1	16.0
2016-07-05	BR	Futures	0.2026	0.2026	0.19837	0.19847	84.0
2016-07-05	BZ	Futures	40.33	40.35	37.83	38.15	37154.0
2016-07-05	C	Futures	2531.0	2603.0	2531.0	2599.0	7493.0
2016-07-05	CB	Futures	281.329	281.329	280.743	281.329	19.0
2016-07-05	CC	Futures	2207.0	2250.0	2188.0	2247.0	22388.0
2016-07-05	CNH	Futures	7.2458	7.2584	7.2458	7.2556	22.0
2016-07-05	CSC	Futures	3.566	3.566	3.532	3.561	35.0
2016-07-05	CT	Futures	73.78	74.66	73.78	74.0	14.0
2016-07-05	DC	Futures	28.82	28.82	28.29	28.56	177.0
2016-07-05	DX	Futures	88.937	89.602	88.704	89.526	21408.0
2016-07-05	E1	Futures	1.29057	1.29821	1.28606	1.28631	19889.0
2016-07-05	E6	Futures	1.29981	1.30575	1.29126	1.29231	182561.0
2016-07-05	E7	Futures	1.2926	1.2984	1.2843	1.2855	4451.0
2016-07-05	EBM	Futures	184.94	186.75	182.84	185.54	17232.0
2016-07-05	ED	Futures	95.839	95.8438	95.8245	95.8341	159679.0
2016-07-05	ER	Futures	98.337	98.342	98.332	98.337	40707.0
2016-07-05	EW	Futures	1589.4	1593.9	1558.0	1566.9	22058.0
2016-07-05	FBON	Futures	122.68	122.68	122.28	122.51	264.0
2016-07-05	FBTP	Futures	109.2	109.33	108.88	109.21	84642.0
2016-07-05	FBTS	Futures	101.392	101.392	101.275	101.302	31004.0
2016-07-05	FCE	Futures	3679.2	3688.4	3599.5	3626.9	98379.0
2016-07-05	FDAX	Futures	10314.2	10314.2	10059.8	10129.5	93485.0
2016-07-05	FDXM	Futures	10047.8	10052.0	9807.2	9873.6	24099.0
2016-07-05	FESX	Futures	2236.6	2236.6	2180.3	2198.3	1375793.0
2016-07-05	FEU3	Futures	98.991	98.991	98.991	98.991	11.0
2016-07-05	FGBL	Futures	150.54	151.16	150.48	150.96	500976.0
2016-07-05	FGBM	Futures	129.02	129.22	128.99	129.18	382227.0
2016-07-05	FGBS	Futures	111.967	111.992	111.952	111.982	202796.0
2016-07-05	FGBX	Futures	190.17	192.72	189.97	192.0	32665.0
2016-07-05	FMWO	Futures	5494.7	5499.6	5470.4	5476.5	1875.0
2016-07-05	FOAT	Futures	138.44	138.7	138.25	138.64	81856.0
2016-07-05	FTDX	Futures	1532.5	1532.5	1514.6	1518.0	88.0
2016-07-05	FTI	Futures	390.67	391.03	385.4	387.29	30744.0
2016-07-05	FTUK	Futures	5430.1	5430.9	5354.6	5423.0	198858.0
2016-07-05	FVSA	Futures	2594.02	2685.04	2578.85	2639.53	10602.0
2016-07-05	FXXP	Futures	265.0	265.0	259.6	261.3	36416.0
2016-07-05	G	Futures	114.37	115.03	114.37	114.89	141307.0
2016-07-05	GF	Futures	284.698	288.492	279.057	287.693	5154.0

> showing 50 of 110 rows — these rows as CSV

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