PREVIEW / futures_daily / 2018-02-21

all futures daily files

  file:    by_date/futures_daily/2018/2018-02-21.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
2018-02-21	ES	Futures	2950.33	2986.47	2927.51	2933.21	1661308.0
2018-02-21	NQ	Futures	7950.26	8064.16	7895.21	7917.76	440206.0
2018-02-21	YM	Futures	26313.5	26636.2	26074.1	26135.3	254310.0
2018-02-21	CL	Futures	62.07	62.3	61.35	62.12	466924.0
2018-02-21	GC	Futures	1700.4	1709.7	1691.7	1701.5	255616.0
2018-02-21	ZN	Futures	118.951648	119.075058	118.53514	118.673976	2154049.0
2018-02-21	A6	Futures	0.81057	0.81293	0.80254	0.8044	128483.0
2018-02-21	AD	Futures	0.8031	0.80447	0.79955	0.80072	77259.0
2018-02-21	B	Futures	46.68	47.02	46.21	46.94	245865.0
2018-02-21	B6	Futures	1.4572	1.4585	1.4473	1.4507	142662.0
2018-02-21	BR	Futures	0.23177	0.23378	0.23177	0.23309	2316.0
2018-02-21	BTC	Futures	14625.9	14756.0	13298.6	13493.8	1326.0
2018-02-21	BZ	Futures	46.11	46.41	45.61	46.33	26015.0
2018-02-21	C	Futures	1370.0	1395.0	1362.0	1389.0	6716.0
2018-02-21	CB	Futures	282.173	284.552	282.173	284.552	12.0
2018-02-21	CC	Futures	1566.0	1596.0	1558.0	1594.0	19479.0
2018-02-21	CNH	Futures	6.4738	6.4738	6.4508	6.463	19.0
2018-02-21	CSC	Futures	3.325	3.34	3.265	3.312	86.0
2018-02-21	CT	Futures	90.52	92.39	90.46	92.16	7830.0
2018-02-21	DC	Futures	26.37	26.72	25.96	26.35	325.0
2018-02-21	DX	Futures	84.214	84.575	84.04	84.437	23071.0
2018-02-21	E1	Futures	1.29877	1.30181	1.29428	1.29586	21208.0
2018-02-21	E6	Futures	1.40053	1.40354	1.39453	1.39685	220540.0
2018-02-21	E7	Futures	1.3937	1.3964	1.3875	1.3899	3503.0
2018-02-21	EBM	Futures	172.62	174.24	172.08	173.97	18859.0
2018-02-21	ED	Futures	95.1149	95.1198	95.0809	95.0858	431011.0
2018-02-21	ER	Futures	98.337	98.337	98.332	98.332	20094.0
2018-02-21	EW	Futures	2003.9	2028.8	1990.6	1997.4	13049.0
2018-02-21	FBON	Futures	125.98	126.09	125.85	125.96	330.0
2018-02-21	FBTP	Futures	110.8	111.22	110.8	111.04	77395.0
2018-02-21	FBTS	Futures	103.604	103.64	103.595	103.613	35799.0
2018-02-21	FCE	Futures	4651.4	4697.3	4639.5	4681.9	54646.0
2018-02-21	FDAX	Futures	12902.0	12977.8	12826.8	12928.5	76169.0
2018-02-21	FDXM	Futures	12922.9	12997.7	12848.0	12950.4	29890.0
2018-02-21	FESX	Futures	2793.1	2810.2	2779.2	2799.6	789534.0
2018-02-21	FGBL	Futures	146.81	147.22	146.59	146.91	677126.0
2018-02-21	FGBM	Futures	128.46	128.63	128.39	128.47	487863.0
2018-02-21	FGBS	Futures	112.311	112.331	112.296	112.306	230277.0
2018-02-21	FGBX	Futures	163.5	164.53	163.21	164.03	58496.0
2018-02-21	FMWO	Futures	6986.5	7072.9	6974.9	7042.5	1095.0
2018-02-21	FOAT	Futures	135.79	136.19	135.78	135.89	89989.0
2018-02-21	FTDX	Futures	2586.7	2598.2	2561.3	2594.2	221.0
2018-02-21	FTI	Futures	487.67	491.53	485.97	490.15	20558.0
2018-02-21	FTUK	Futures	6284.6	6346.2	6268.0	6337.4	91594.0
2018-02-21	FVSA	Futures	449.36	467.83	428.43	439.51	16691.0
2018-02-21	FXXP	Futures	323.0	324.8	321.1	324.1	27998.0
2018-02-21	G	Futures	112.0	112.35	111.96	112.15	291005.0
2018-02-21	GF	Futures	329.779	329.779	320.941	322.039	7821.0
2018-02-21	GSCI	Futures	504.33	505.47	504.33	505.47	21.0
2018-02-21	HE	Futures	89.725	90.591	88.761	89.757	17817.0

> showing 50 of 111 rows — these rows as CSV

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