PREVIEW / futures_daily / 2017-07-19

all futures daily files

  file:    by_date/futures_daily/2017/2017-07-19.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-07-19	ES	Futures	2673.31	2686.63	2671.14	2686.08	958463.0
2017-07-19	NQ	Futures	6930.4	6965.08	6922.76	6957.15	233290.0
2017-07-19	YM	Futures	22746.9	22838.8	22731.0	22829.3	75838.0
2017-07-19	CL	Futures	47.81	48.82	47.65	48.68	846615.0
2017-07-19	GC	Futures	1585.5	1587.4	1576.7	1585.5	198029.0
2017-07-19	ZN	Futures	124.211588	124.288538	124.05769	124.150029	907676.0
2017-07-19	A6	Futures	0.81215	0.81697	0.81184	0.81656	95982.0
2017-07-19	AD	Futures	0.80619	0.80929	0.80457	0.80843	53545.0
2017-07-19	ALI	Futures	2538.17	2538.17	2538.17	2538.17	0.0
2017-07-19	B	Futures	34.43	35.22	34.35	35.14	300371.0
2017-07-19	B6	Futures	1.3657	1.3668	1.3624	1.364	77559.0
2017-07-19	BR	Futures	0.2331	0.23392	0.23299	0.23388	401.0
2017-07-19	BZ	Futures	34.21	34.98	34.14	34.91	20340.0
2017-07-19	C	Futures	1517.0	1551.0	1514.0	1545.0	9389.0
2017-07-19	CB	Futures	327.218	327.218	325.09	325.698	24.0
2017-07-19	CC	Futures	1442.0	1483.0	1442.0	1476.0	19357.0
2017-07-19	CNH	Futures	7.0019	7.009	7.0003	7.005	69.0
2017-07-19	CSC	Futures	3.478	3.501	3.472	3.495	60.0
2017-07-19	CT	Futures	80.8	81.07	80.18	80.25	14.0
2017-07-19	DC	Futures	29.39	29.41	29.13	29.28	236.0
2017-07-19	DX	Futures	88.218	88.418	88.19	88.323	11880.0
2017-07-19	E1	Futures	1.29139	1.29372	1.28955	1.29065	23803.0
2017-07-19	E6	Futures	1.32813	1.32836	1.32292	1.32389	173959.0
2017-07-19	E7	Futures	1.3211	1.3211	1.3159	1.3169	3576.0
2017-07-19	EBM	Futures	192.07	192.07	190.4	190.68	12411.0
2017-07-19	ED	Futures	95.5983	95.5983	95.5838	95.5886	145496.0
2017-07-19	ER	Futures	98.337	98.342	98.337	98.337	47011.0
2017-07-19	EW	Futures	1871.2	1891.8	1870.2	1890.6	10421.0
2017-07-19	FBON	Futures	123.96	124.08	123.84	123.89	500.0
2017-07-19	FBTP	Futures	107.34	107.54	107.22	107.39	52785.0
2017-07-19	FBTS	Futures	102.772	102.781	102.754	102.763	18619.0
2017-07-19	FCE	Futures	4660.3	4695.8	4643.7	4683.2	137418.0
2017-07-19	FDAX	Futures	13105.1	13141.9	13064.5	13090.3	67597.0
2017-07-19	FDXM	Futures	13019.7	13060.5	12984.1	13009.8	17309.0
2017-07-19	FESX	Futures	2843.8	2859.4	2832.4	2847.1	677939.0
2017-07-19	FGBL	Futures	146.81	147.19	146.78	147.09	520928.0
2017-07-19	FGBM	Futures	128.45	128.62	128.42	128.55	356634.0
2017-07-19	FGBS	Futures	112.157	112.187	112.146	112.177	180307.0
2017-07-19	FGBX	Futures	163.55	164.71	163.51	164.44	34640.0
2017-07-19	FMWO	Futures	6512.6	6540.0	6512.6	6526.9	1091.0
2017-07-19	FOAT	Futures	134.7	135.07	134.66	134.98	81861.0
2017-07-19	FTDX	Futures	2275.2	2296.2	2274.7	2291.7	61.0
2017-07-19	FTI	Futures	477.29	482.7	477.29	481.4	40336.0
2017-07-19	FTUK	Futures	6347.2	6378.7	6320.4	6358.9	76290.0
2017-07-19	FVSA	Futures	456.85	461.3	443.5	450.92	23863.0
2017-07-19	FXXP	Futures	326.3	327.9	325.2	326.9	20383.0
2017-07-19	G	Futures	114.42	114.84	114.27	114.81	143484.0
2017-07-19	GF	Futures	329.168	340.638	328.4	339.156	6938.0
2017-07-19	GSCI	Futures	456.3	459.03	456.3	459.03	6.0
2017-07-19	HE	Futures	92.612	95.369	92.037	94.852	17241.0

> showing 50 of 108 rows — these rows as CSV

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