PREVIEW / futures_daily / 2017-08-17

all futures daily files

  file:    by_date/futures_daily/2017/2017-08-17.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
2017-08-17	ES	Futures	2680.92	2682.82	2634.19	2640.44	2236170.0
2017-08-17	NQ	Futures	6959.2	6963.61	6802.27	6818.43	511900.0
2017-08-17	YM	Futures	23272.2	23276.5	22928.7	22974.1	193644.0
2017-08-17	CL	Futures	48.19	48.59	47.85	48.48	437626.0
2017-08-17	GC	Futures	1641.4	1649.0	1636.8	1644.5	329842.0
2017-08-17	ZN	Futures	124.611725	124.934912	124.442436	124.811793	1389101.0
2017-08-17	A6	Futures	0.8143	0.81769	0.80917	0.81174	100079.0
2017-08-17	AD	Futures	0.8064	0.80823	0.80212	0.80406	61517.0
2017-08-17	ALI	Futures	2705.2	2705.2	2705.2	2705.2	0.0
2017-08-17	B	Futures	35.25	35.76	34.98	35.7	334304.0
2017-08-17	B6	Futures	1.3483	1.3507	1.3445	1.3468	93856.0
2017-08-17	BFX	Futures	4762.2	4762.2	4753.8	4756.2	46.0
2017-08-17	BR	Futures	0.23511	0.23511	0.23262	0.23329	1788.0
2017-08-17	BZ	Futures	34.94	35.45	34.67	35.39	43863.0
2017-08-17	C	Futures	1461.0	1480.0	1453.0	1475.0	6011.0
2017-08-17	CB	Futures	324.786	326.367	320.559	323.965	47.0
2017-08-17	CC	Futures	1369.0	1399.0	1362.0	1388.0	21835.0
2017-08-17	CSC	Futures	3.565	3.588	3.563	3.583	95.0
2017-08-17	CT	Futures	78.6	78.72	78.49	78.72	19.0
2017-08-17	DC	Futures	29.74	29.95	29.7	29.86	435.0
2017-08-17	DX	Futures	87.195	87.769	87.036	87.339	40454.0
2017-08-17	E1	Futures	1.27469	1.2812	1.26879	1.27898	31341.0
2017-08-17	E6	Futures	1.35064	1.35294	1.33821	1.34726	249368.0
2017-08-17	E7	Futures	1.3438	1.3457	1.3311	1.3402	4506.0
2017-08-17	EBM	Futures	176.48	177.04	172.59	174.26	12407.0
2017-08-17	ED	Futures	95.5886	95.5935	95.5862	95.5935	150811.0
2017-08-17	ER	Futures	98.342	98.342	98.337	98.342	16911.0
2017-08-17	EW	Futures	1832.0	1832.9	1795.0	1800.0	20877.0
2017-08-17	FBON	Futures	124.99	125.1	124.9	125.07	266.0
2017-08-17	FBTP	Futures	109.15	109.37	109.07	109.29	48695.0
2017-08-17	FBTS	Futures	103.045	103.064	103.036	103.054	14023.0
2017-08-17	FCE	Futures	4617.0	4634.4	4566.0	4603.1	133055.0
2017-08-17	FDAX	Futures	12872.4	12937.1	12751.8	12845.0	88976.0
2017-08-17	FDXM	Futures	12792.6	12857.5	12676.5	12766.0	34721.0
2017-08-17	FESX	Futures	2835.7	2843.8	2801.4	2825.9	942689.0
2017-08-17	FGBL	Futures	148.97	149.28	148.72	148.94	482640.0
2017-08-17	FGBM	Futures	129.46	129.5	129.33	129.41	284177.0
2017-08-17	FGBS	Futures	112.377	112.377	112.337	112.347	196949.0
2017-08-17	FGBX	Futures	168.3	169.05	167.39	167.9	42182.0
2017-08-17	FMWO	Futures	6523.4	6531.7	6500.7	6506.7	246.0
2017-08-17	FOAT	Futures	136.16	136.16	135.85	136.03	85184.0
2017-08-17	FTDX	Futures	2271.2	2277.2	2259.6	2271.7	131.0
2017-08-17	FTI	Futures	485.01	486.58	481.21	484.41	13725.0
2017-08-17	FTUK	Futures	6397.8	6418.1	6336.8	6385.2	78015.0
2017-08-17	FVSA	Futures	497.52	563.64	492.8	521.13	22564.0
2017-08-17	FXXP	Futures	322.0	323.0	318.7	320.9	22445.0
2017-08-17	G	Futures	116.02	116.03	115.57	115.84	145580.0
2017-08-17	GF	Futures	313.962	314.346	307.22	308.536	5752.0
2017-08-17	GSCI	Futures	446.49	448.65	446.49	447.93	308.0
2017-08-17	HE	Futures	95.843	95.843	92.973	93.673	22268.0

> showing 50 of 110 rows — these rows as CSV

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