PREVIEW / futures_daily / 2017-06-23

all futures daily files

  file:    by_date/futures_daily/2017/2017-06-23.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-06-23	ES	Futures	2642.34	2650.49	2639.08	2646.41	1197448.0
2017-06-23	NQ	Futures	6801.09	6836.36	6774.64	6832.54	213552.0
2017-06-23	YM	Futures	22569.3	22596.7	22497.4	22557.6	106186.0
2017-06-23	CL	Futures	44.2	44.61	43.92	44.41	690906.0
2017-06-23	GC	Futures	1596.9	1608.5	1596.5	1603.9	162670.0
2017-06-23	ZN	Futures	124.781013	124.857962	124.657894	124.827183	714183.0
2017-06-23	A6	Futures	0.77393	0.77804	0.77362	0.77712	53940.0
2017-06-23	AD	Futures	0.76978	0.77105	0.76541	0.76826	60583.0
2017-06-23	ALI	Futures	2464.67	2464.67	2464.67	2464.67	0.0
2017-06-23	B	Futures	32.21	32.55	32.03	32.4	252259.0
2017-06-23	B6	Futures	1.3286	1.3354	1.3282	1.3331	86075.0
2017-06-23	BR	Futures	0.21922	0.22115	0.21796	0.21918	65.0
2017-06-23	BZ	Futures	32.08	32.4	31.9	32.26	27319.0
2017-06-23	C	Futures	1492.0	1547.0	1492.0	1538.0	4376.0
2017-06-23	CB	Futures	320.528	322.353	320.528	322.353	32.0
2017-06-23	CC	Futures	1383.0	1431.0	1380.0	1427.0	20186.0
2017-06-23	CNH	Futures	7.0992	7.0992	7.0982	7.0982	4.0
2017-06-23	CSC	Futures	3.544	3.561	3.544	3.561	16.0
2017-06-23	CT	Futures	78.9	80.96	78.66	80.46	4473.0
2017-06-23	DC	Futures	29.51	29.91	29.49	29.88	244.0
2017-06-23	DX	Futures	90.814	90.851	90.445	90.521	14010.0
2017-06-23	E1	Futures	1.27039	1.27641	1.27026	1.27432	21066.0
2017-06-23	E6	Futures	1.28333	1.29015	1.28276	1.28877	128022.0
2017-06-23	E7	Futures	1.2767	1.2833	1.2762	1.282	2015.0
2017-06-23	EBM	Futures	194.58	195.13	193.18	193.46	10509.0
2017-06-23	ED	Futures	95.5838	95.5838	95.5741	95.5789	99742.0
2017-06-23	ER	Futures	98.332	98.337	98.332	98.332	20723.0
2017-06-23	EW	Futures	1846.4	1857.4	1841.9	1852.5	12661.0
2017-06-23	FBON	Futures	125.4	125.5	125.24	125.34	156.0
2017-06-23	FBTP	Futures	110.1	110.25	109.86	110.04	60957.0
2017-06-23	FBTS	Futures	102.945	102.945	102.9	102.927	29178.0
2017-06-23	FCE	Futures	4751.9	4760.9	4724.9	4743.4	63463.0
2017-06-23	FDAX	Futures	13461.5	13465.2	13335.7	13398.8	69001.0
2017-06-23	FDXM	Futures	13373.4	13382.8	13256.2	13316.4	20999.0
2017-06-23	FESX	Futures	2893.6	2895.3	2871.6	2884.7	673345.0
2017-06-23	FEU3	Futures	99.006	99.006	99.006	99.006	8.0
2017-06-23	FGBL	Futures	149.94	150.04	149.84	149.96	446001.0
2017-06-23	FGBM	Futures	129.5	129.53	129.39	129.5	331256.0
2017-06-23	FGBS	Futures	112.187	112.202	112.162	112.192	244580.0
2017-06-23	FGBX	Futures	171.82	172.06	171.17	171.38	29379.0
2017-06-23	FMWO	Futures	6426.9	6430.5	6410.2	6429.3	518.0
2017-06-23	FOAT	Futures	137.16	137.23	137.05	137.11	64965.0
2017-06-23	FTDX	Futures	2291.2	2291.2	2264.6	2271.7	76.0
2017-06-23	FTI	Futures	478.2	478.84	475.47	478.7	21592.0
2017-06-23	FTUK	Futures	6362.3	6378.3	6337.3	6369.2	63551.0
2017-06-23	FVSA	Futures	475.49	483.37	472.34	475.49	12509.0
2017-06-23	FXXP	Futures	329.4	329.7	327.5	329.0	23524.0
2017-06-23	G	Futures	116.28	116.34	115.91	116.25	138802.0
2017-06-23	GF	Futures	316.162	319.345	315.448	318.192	3531.0
2017-06-23	GSCI	Futures	429.17	431.61	429.17	430.39	291.0

> showing 50 of 110 rows — these rows as CSV

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