PREVIEW / futures_daily / 2017-08-28

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-28.parquet
  size:    9 KB
  rows:    103

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-28	ES	Futures	2654.02	2661.9	2647.77	2655.92	953054.0
2017-08-28	NQ	Futures	6841.36	6883.97	6819.61	6870.74	216424.0
2017-08-28	YM	Futures	23047.1	23107.3	22992.1	23035.4	89951.0
2017-08-28	CL	Futures	49.15	49.47	47.37	47.8	921285.0
2017-08-28	GC	Futures	1651.1	1676.8	1650.3	1673.6	321813.0
2017-08-28	ZN	Futures	124.965692	125.08881	124.888742	125.08881	1952451.0
2017-08-28	A6	Futures	0.81482	0.81893	0.8141	0.81882	58225.0
2017-08-28	AD	Futures	0.8156	0.81753	0.81316	0.81428	45815.0
2017-08-28	ALI	Futures	2691.04	2691.04	2691.04	2691.04	0.0
2017-08-28	B	Futures	36.47	36.77	35.81	36.06	207893.0
2017-08-28	B6	Futures	1.3506	1.3536	1.3463	1.3531	66179.0
2017-08-28	BR	Futures	0.23577	0.23577	0.23577	0.23577	8880.0
2017-08-28	BZ	Futures	36.2	36.49	35.51	35.75	20494.0
2017-08-28	CB	Futures	320.003	320.003	319.027	319.027	73.0
2017-08-28	CC	Futures	1414.0	1486.0	1414.0	1483.0	21219.0
2017-08-28	CNH	Futures	6.8639	6.8639	6.8422	6.8422	2.0
2017-08-28	CSC	Futures	3.505	3.505	3.451	3.456	80.0
2017-08-28	CT	Futures	80.07	82.08	80.07	82.08	28.0
2017-08-28	DC	Futures	28.99	28.99	28.72	28.72	67.0
2017-08-28	DX	Futures	86.233	86.355	86.014	86.037	19551.0
2017-08-28	E1	Futures	1.28734	1.2909	1.28353	1.28783	22201.0
2017-08-28	E6	Futures	1.36989	1.37453	1.3668	1.37407	151146.0
2017-08-28	E7	Futures	1.3623	1.3673	1.3596	1.3668	2771.0
2017-08-28	EBM	Futures	171.19	171.19	169.25	169.8	2227.0
2017-08-28	ED	Futures	95.591	95.5959	95.591	95.5935	60437.0
2017-08-28	ER	Futures	98.337	98.342	98.337	98.342	13629.0
2017-08-28	EW	Futures	1813.4	1819.7	1807.9	1814.0	9981.0
2017-08-28	FBON	Futures	124.54	124.91	124.54	124.85	66.0
2017-08-28	FBTP	Futures	108.73	108.89	108.39	108.85	37152.0
2017-08-28	FBTS	Futures	103.027	103.027	102.982	103.018	15740.0
2017-08-28	FCE	Futures	4553.4	4568.6	4530.6	4544.5	52686.0
2017-08-28	FDAX	Futures	12781.3	12815.5	12696.6	12774.5	66628.0
2017-08-28	FDXM	Futures	12702.6	12736.1	12618.9	12695.8	19968.0
2017-08-28	FESX	Futures	2798.1	2807.1	2784.3	2793.2	505090.0
2017-08-28	FGBL	Futures	149.77	149.87	149.51	149.86	298546.0
2017-08-28	FGBM	Futures	129.8	129.9	129.68	129.89	165197.0
2017-08-28	FGBS	Futures	112.422	112.457	112.412	112.452	115672.0
2017-08-28	FGBX	Futures	169.76	169.76	168.81	169.27	23040.0
2017-08-28	FMWO	Futures	6494.8	6516.2	6484.1	6504.3	39.0
2017-08-28	FOAT	Futures	136.49	136.51	136.21	136.47	43913.0
2017-08-28	FTDX	Futures	2249.1	2264.1	2248.6	2257.6	99.0
2017-08-28	FTI	Futures	478.06	478.34	474.54	476.58	21668.0
2017-08-28	FVSA	Futures	511.69	525.86	503.82	511.69	12564.0
2017-08-28	FXXP	Futures	316.8	318.1	315.8	316.4	13670.0
2017-08-28	GF	Futures	315.935	322.568	315.168	319.827	4291.0
2017-08-28	GSCI	Futures	451.34	451.34	451.34	451.34	2.0
2017-08-28	HE	Futures	87.864	88.179	86.185	86.255	19352.0
2017-08-28	HG	Futures	3.6988	3.7562	3.6958	3.7278	51729.0
2017-08-28	HH	Futures	18.356	18.72	18.23	18.582	2025.0
2017-08-28	HO	Futures	1.0732	1.0909	1.0627	1.0673	50520.0

> showing 50 of 103 rows — these rows as CSV

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