PREVIEW / futures_daily / 2017-05-26

all futures daily files

  file:    by_date/futures_daily/2017/2017-05-26.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-05-26	ES	Futures	2620.62	2623.61	2615.19	2621.44	879560.0
2017-05-26	NQ	Futures	6809.1	6827.06	6799.08	6822.05	163404.0
2017-05-26	YM	Futures	22216.6	22238.7	22179.6	22228.2	78293.0
2017-05-26	CL	Futures	50.5	51.73	49.9	51.58	763920.0
2017-05-26	GC	Futures	1606.7	1624.7	1603.6	1623.0	158997.0
2017-05-26	ZN	Futures	124.012635	124.258448	124.012635	124.074089	1922254.0
2017-05-26	A6	Futures	0.765	0.76562	0.76161	0.76387	77642.0
2017-05-26	AD	Futures	0.75625	0.75942	0.75585	0.75763	51557.0
2017-05-26	ALI	Futures	2568.69	2568.69	2568.69	2568.69	0.0
2017-05-26	B	Futures	36.84	37.45	36.32	37.35	341994.0
2017-05-26	B6	Futures	1.3571	1.3574	1.34	1.3423	166495.0
2017-05-26	BR	Futures	0.22248	0.22248	0.22248	0.22248	851.0
2017-05-26	BZ	Futures	36.59	37.27	36.17	37.2	32496.0
2017-05-26	C	Futures	1477.0	1518.0	1476.0	1513.0	9124.0
2017-05-26	CB	Futures	300.457	300.457	298.693	299.849	27.0
2017-05-26	CC	Futures	1440.0	1466.0	1438.0	1461.0	15770.0
2017-05-26	CNH	Futures	7.149	7.149	7.127	7.127	61.0
2017-05-26	CSC	Futures	3.653	3.653	3.623	3.623	48.0
2017-05-26	CT	Futures	85.58	85.94	85.29	85.38	10552.0
2017-05-26	DC	Futures	30.64	30.78	30.24	30.36	145.0
2017-05-26	DX	Futures	90.511	90.805	90.339	90.711	24104.0
2017-05-26	E1	Futures	1.27159	1.27591	1.26751	1.26961	21376.0
2017-05-26	E6	Futures	1.29239	1.29539	1.28692	1.28888	162243.0
2017-05-26	E7	Futures	1.2858	1.2888	1.2804	1.2824	3047.0
2017-05-26	EBM	Futures	185.67	187.34	184.56	186.5	5864.0
2017-05-26	ED	Futures	95.5857	95.593	95.5857	95.5881	180694.0
2017-05-26	ER	Futures	98.337	98.337	98.332	98.337	20512.0
2017-05-26	EW	Futures	1836.6	1838.6	1830.0	1834.0	11722.0
2017-05-26	FBON	Futures	123.13	123.66	123.12	123.64	786.0
2017-05-26	FBTP	Futures	107.47	107.5	107.26	107.48	94270.0
2017-05-26	FBTS	Futures	102.507	102.525	102.48	102.507	31496.0
2017-05-26	FCE	Futures	4751.9	4759.6	4707.0	4756.4	65723.0
2017-05-26	FDAX	Futures	13295.1	13312.5	13223.8	13294.5	65525.0
2017-05-26	FDXM	Futures	13184.0	13194.5	13107.6	13177.7	20258.0
2017-05-26	FESX	Futures	2907.5	2910.0	2881.4	2906.7	727122.0
2017-05-26	FEU3	Futures	99.006	99.011	99.006	99.011	9.0
2017-05-26	FGBL	Futures	148.41	148.78	148.27	148.69	638374.0
2017-05-26	FGBM	Futures	129.36	129.52	129.32	129.46	435120.0
2017-05-26	FGBS	Futures	112.267	112.302	112.257	112.282	306499.0
2017-05-26	FGBX	Futures	166.77	168.03	166.17	167.61	34427.0
2017-05-26	FMWO	Futures	6436.2	6437.4	6427.8	6433.8	533.0
2017-05-26	FOAT	Futures	135.1	135.36	134.84	135.29	87193.0
2017-05-26	FTDX	Futures	2231.3	2235.7	2221.0	2231.3	128.0
2017-05-26	FTI	Futures	482.95	483.96	480.98	483.78	20322.0
2017-05-26	FTUK	Futures	6421.7	6451.2	6413.1	6448.2	85555.0
2017-05-26	FVSA	Futures	514.67	526.52	504.51	507.9	10633.0
2017-05-26	FXXP	Futures	329.4	329.7	327.7	329.6	22074.0
2017-05-26	G	Futures	116.1	116.45	115.95	116.34	300783.0
2017-05-26	GF	Futures	332.351	332.735	321.869	322.582	6693.0
2017-05-26	GSCI	Futures	471.44	474.51	470.21	474.51	12.0

> showing 50 of 110 rows — these rows as CSV

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