PREVIEW / futures_daily / 2017-10-26

all futures daily files

  file:    by_date/futures_daily/2017/2017-10-26.parquet
  size:    10 KB
  rows:    112

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-10-26	ES	Futures	2783.95	2789.94	2779.6	2786.13	1392205.0
2017-10-26	NQ	Futures	7124.02	7160.73	7088.78	7147.22	320283.0
2017-10-26	YM	Futures	24616.3	24714.5	24593.1	24656.4	125498.0
2017-10-26	CL	Futures	52.63	53.3	52.35	53.08	594647.0
2017-10-26	GC	Futures	1626.9	1633.5	1611.4	1615.5	384122.0
2017-10-26	ZN	Futures	122.792737	122.977596	122.530853	122.623282	1763165.0
2017-10-26	A6	Futures	0.79206	0.79412	0.78712	0.78835	150337.0
2017-10-26	AD	Futures	0.7958	0.79641	0.79158	0.79204	91335.0
2017-10-26	ALI	Futures	2718.01	2718.01	2718.01	2718.01	0.0
2017-10-26	B	Futures	41.18	41.94	40.91	41.76	236037.0
2017-10-26	B6	Futures	1.3849	1.3865	1.3726	1.3736	114564.0
2017-10-26	BFX	Futures	4810.7	4859.0	4810.7	4859.0	2.0
2017-10-26	BR	Futures	0.23215	0.23238	0.22785	0.22887	6059.0
2017-10-26	BZ	Futures	40.81	41.56	40.54	41.39	22056.0
2017-10-26	C	Futures	1517.0	1543.0	1517.0	1542.0	9983.0
2017-10-26	CB	Futures	295.817	298.557	295.817	297.612	33.0
2017-10-26	CC	Futures	1547.0	1584.0	1543.0	1579.0	28085.0
2017-10-26	CNH	Futures	6.832	6.8476	6.832	6.8476	14.0
2017-10-26	CSC	Futures	3.456	3.483	3.456	3.458	42.0
2017-10-26	CT	Futures	81.34	81.36	79.99	80.09	14473.0
2017-10-26	DC	Futures	27.96	28.3	27.86	27.98	433.0
2017-10-26	DX	Futures	87.433	88.48	87.311	88.381	44611.0
2017-10-26	E1	Futures	1.23995	1.24191	1.22907	1.22968	37996.0
2017-10-26	E6	Futures	1.35179	1.35424	1.3317	1.33393	391391.0
2017-10-26	E7	Futures	1.3449	1.3471	1.3248	1.327	7305.0
2017-10-26	EBM	Futures	174.24	175.32	173.97	175.32	14611.0
2017-10-26	ED	Futures	95.4988	95.4988	95.4891	95.4891	168768.0
2017-10-26	ER	Futures	98.342	98.347	98.337	98.347	72409.0
2017-10-26	EW	Futures	1938.1	1945.6	1935.4	1943.9	9870.0
2017-10-26	FBON	Futures	124.78	125.67	124.66	125.36	1100.0
2017-10-26	FBTP	Futures	110.26	111.22	110.14	110.86	172105.0
2017-10-26	FBTS	Futures	103.457	103.585	103.448	103.539	76042.0
2017-10-26	FCE	Futures	4817.2	4902.3	4814.1	4886.6	105123.0
2017-10-26	FDAX	Futures	13639.1	13835.2	13593.4	13806.3	108419.0
2017-10-26	FDIV	Futures	153.86	153.86	153.78	153.78	30.0
2017-10-26	FDXM	Futures	13518.8	13716.8	13478.2	13689.7	38043.0
2017-10-26	FESX	Futures	2927.0	2972.7	2914.8	2963.8	1390993.0
2017-10-26	FEU3	Futures	99.006	99.016	99.006	99.016	422.0
2017-10-26	FGBL	Futures	149.06	149.79	148.82	149.43	954235.0
2017-10-26	FGBM	Futures	129.54	129.93	129.46	129.79	679864.0
2017-10-26	FGBS	Futures	112.442	112.537	112.432	112.507	403126.0
2017-10-26	FGBX	Futures	166.32	167.46	165.85	166.81	72399.0
2017-10-26	FMWO	Futures	6736.8	6749.8	6732.1	6743.9	1114.0
2017-10-26	FOAT	Futures	136.64	137.24	136.44	136.91	131836.0
2017-10-26	FTDX	Futures	2474.0	2486.5	2464.0	2483.5	128.0
2017-10-26	FTI	Futures	500.15	507.65	500.15	505.94	32294.0
2017-10-26	FTUK	Futures	6447.7	6479.8	6434.3	6471.2	82666.0
2017-10-26	FVSA	Futures	365.78	373.46	351.72	356.83	29943.0
2017-10-26	FXXP	Futures	328.7	333.2	327.6	332.0	52000.0
2017-10-26	G	Futures	113.11	113.35	112.99	113.13	165267.0

> showing 50 of 112 rows — these rows as CSV

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