PREVIEW / futures_daily / 2017-08-16

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-16.parquet
  size:    9 KB
  rows:    111

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-16	ES	Futures	2678.47	2688.8	2675.21	2681.73	1137333.0
2017-08-16	NQ	Futures	6953.62	6993.88	6938.04	6963.32	293910.0
2017-08-16	YM	Futures	23243.7	23327.2	23223.6	23268.0	108643.0
2017-08-16	CL	Futures	49.16	49.4	48.07	48.18	403773.0
2017-08-16	GC	Futures	1624.7	1640.8	1620.0	1632.4	273202.0
2017-08-16	ZN	Futures	124.211588	124.673284	124.103859	124.611725	1354262.0
2017-08-16	A6	Futures	0.80331	0.81471	0.80259	0.81297	109433.0
2017-08-16	AD	Futures	0.7978	0.80665	0.79673	0.80329	79007.0
2017-08-16	ALI	Futures	2717.16	2717.16	2717.16	2717.16	0.0
2017-08-16	B	Futures	35.66	35.95	35.08	35.16	305551.0
2017-08-16	B6	Futures	1.3468	1.3499	1.3434	1.3479	116162.0
2017-08-16	BFX	Futures	4771.3	4771.3	4768.8	4768.8	22.0
2017-08-16	BR	Futures	0.23295	0.23533	0.23295	0.2347	2312.0
2017-08-16	BZ	Futures	35.34	35.61	34.78	34.86	33911.0
2017-08-16	C	Futures	1471.0	1483.0	1449.0	1457.0	4420.0
2017-08-16	CB	Futures	324.725	326.58	323.356	325.394	150.0
2017-08-16	CC	Futures	1380.0	1400.0	1359.0	1365.0	27961.0
2017-08-16	CNH	Futures	6.9316	6.9316	6.9217	6.9217	3.0
2017-08-16	CSC	Futures	3.538	3.571	3.513	3.567	150.0
2017-08-16	CT	Futures	78.89	79.03	78.78	78.84	12.0
2017-08-16	DC	Futures	29.25	29.72	29.16	29.69	502.0
2017-08-16	DX	Futures	87.527	87.825	87.19	87.249	35146.0
2017-08-16	E1	Futures	1.26535	1.27555	1.26019	1.27321	32461.0
2017-08-16	E6	Futures	1.34698	1.35185	1.34068	1.35064	227828.0
2017-08-16	E7	Futures	1.3399	1.3447	1.3335	1.3436	4399.0
2017-08-16	EBM	Futures	178.15	178.43	176.2	176.76	12281.0
2017-08-16	ED	Futures	95.5862	95.591	95.5838	95.5886	150231.0
2017-08-16	ER	Futures	98.342	98.342	98.337	98.342	28346.0
2017-08-16	EW	Futures	1827.4	1839.3	1824.3	1831.9	11600.0
2017-08-16	FBON	Futures	124.82	125.0	124.64	124.92	150.0
2017-08-16	FBTP	Futures	109.08	109.29	108.88	109.12	54528.0
2017-08-16	FBTS	Futures	103.036	103.073	103.036	103.054	18740.0
2017-08-16	FCE	Futures	4600.0	4652.3	4597.7	4629.9	177889.0
2017-08-16	FDAX	Futures	12832.9	12945.6	12832.9	12905.0	69821.0
2017-08-16	FDXM	Futures	12756.0	12866.9	12753.9	12825.6	23765.0
2017-08-16	FESX	Futures	2825.9	2853.6	2825.1	2843.8	729343.0
2017-08-16	FEU3	Futures	99.021	99.021	99.016	99.016	30.0
2017-08-16	FGBL	Futures	148.8	149.0	148.4	148.76	532766.0
2017-08-16	FGBM	Futures	129.38	129.5	129.24	129.37	299435.0
2017-08-16	FGBS	Futures	112.362	112.382	112.327	112.362	214683.0
2017-08-16	FGBX	Futures	167.96	168.24	166.77	167.68	36841.0
2017-08-16	FMWO	Futures	6531.7	6543.6	6531.7	6535.3	725.0
2017-08-16	FOAT	Futures	135.92	136.14	135.64	135.89	75940.0
2017-08-16	FTDX	Futures	2270.2	2273.7	2265.7	2268.2	43.0
2017-08-16	FTI	Futures	483.43	487.32	483.43	486.4	26455.0
2017-08-16	FTUK	Futures	6375.7	6422.4	6369.2	6411.6	91536.0
2017-08-16	FVSA	Futures	503.82	503.82	484.92	495.94	23519.0
2017-08-16	FXXP	Futures	320.7	323.3	320.7	322.4	24701.0
2017-08-16	G	Futures	115.88	116.0	115.51	115.73	254013.0
2017-08-16	GF	Futures	321.362	321.691	313.414	313.798	5272.0

> showing 50 of 111 rows — these rows as CSV

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