PREVIEW / futures_daily / 2018-03-26

all futures daily files

  file:    by_date/futures_daily/2018/2018-03-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
2018-03-26	ES	Futures	2821.98	2895.66	2817.63	2892.12	2302375.0
2018-03-26	NQ	Futures	7666.05	7934.37	7637.08	7927.93	637180.0
2018-03-26	YM	Futures	24869.7	25516.5	24808.6	25482.8	321554.0
2018-03-26	CL	Futures	66.18	66.83	65.36	65.83	585899.0
2018-03-26	GC	Futures	1724.3	1738.6	1722.5	1737.4	192809.0
2018-03-26	ZN	Futures	119.741762	119.834814	119.447099	119.571168	1302107.0
2018-03-26	A6	Futures	0.79237	0.7972	0.79216	0.79555	84033.0
2018-03-26	AD	Futures	0.78576	0.7892	0.78414	0.78748	67836.0
2018-03-26	B	Futures	50.84	51.17	50.23	50.53	267754.0
2018-03-26	B6	Futures	1.4708	1.4803	1.4702	1.4785	101356.0
2018-03-26	BR	Futures	0.22883	0.22944	0.22856	0.22944	15.0
2018-03-26	BTC	Futures	11950.6	11971.9	11141.1	11261.9	479.0
2018-03-26	BZ	Futures	50.22	50.44	49.58	49.88	27106.0
2018-03-26	C	Futures	1709.0	1714.0	1682.0	1699.0	6705.0
2018-03-26	CB	Futures	278.591	278.622	278.591	278.622	6.0
2018-03-26	CC	Futures	1916.0	1939.0	1905.0	1929.0	15971.0
2018-03-26	CNH	Futures	6.4085	6.4085	6.367	6.3675	68.0
2018-03-26	CSC	Futures	3.306	3.325	3.3	3.325	31.0
2018-03-26	CT	Futures	94.35	94.91	93.68	94.0	14523.0
2018-03-26	DC	Futures	26.24	26.46	26.12	26.37	122.0
2018-03-26	DX	Futures	83.977	84.038	83.524	83.565	25798.0
2018-03-26	E1	Futures	1.28246	1.28584	1.27837	1.28391	22139.0
2018-03-26	E6	Futures	1.40102	1.41268	1.4004	1.412	215794.0
2018-03-26	E7	Futures	1.3937	1.4051	1.393	1.4045	3411.0
2018-03-26	EBM	Futures	175.05	175.86	174.52	175.59	17143.0
2018-03-26	ED	Futures	95.0035	95.0084	94.9792	94.9889	320014.0
2018-03-26	ER	Futures	98.337	98.337	98.332	98.337	50928.0
2018-03-26	EW	Futures	1952.1	1992.7	1952.1	1991.6	18848.0
2018-03-26	FBON	Futures	129.62	129.82	129.42	129.66	118.0
2018-03-26	FBTP	Futures	114.58	114.6	114.07	114.22	92224.0
2018-03-26	FBTS	Futures	104.139	104.139	104.065	104.075	57900.0
2018-03-26	FCE	Futures	4463.5	4509.8	4433.5	4455.6	93633.0
2018-03-26	FDAX	Futures	12344.4	12456.1	12164.1	12222.3	101229.0
2018-03-26	FDXM	Futures	12231.4	12345.7	12056.3	12113.4	42221.0
2018-03-26	FESX	Futures	2666.5	2692.3	2642.3	2652.3	1200386.0
2018-03-26	FEU3	Futures	99.021	99.021	99.021	99.021	480.0
2018-03-26	FGBL	Futures	149.5	149.58	149.24	149.56	539516.0
2018-03-26	FGBM	Futures	129.54	129.56	129.42	129.55	335417.0
2018-03-26	FGBS	Futures	112.568	112.568	112.532	112.558	197064.0
2018-03-26	FGBX	Futures	170.62	170.72	169.89	170.66	38146.0
2018-03-26	FMWO	Futures	6806.7	6877.9	6768.1	6771.6	4150.0
2018-03-26	FOAT	Futures	138.71	138.73	138.47	138.67	84294.0
2018-03-26	FTDX	Futures	2526.6	2537.5	2476.2	2479.6	169.0
2018-03-26	FTI	Futures	475.69	479.73	472.02	474.09	37850.0
2018-03-26	FTUK	Futures	5999.8	6072.7	5991.0	6007.8	117107.0
2018-03-26	FVSA	Futures	466.11	491.08	444.71	482.76	24037.0
2018-03-26	FXXP	Futures	308.5	311.8	306.5	307.3	41267.0
2018-03-26	G	Futures	113.26	113.46	113.09	113.38	157523.0
2018-03-26	GF	Futures	296.373	298.932	292.507	292.943	3060.0
2018-03-26	GSCI	Futures	519.94	520.22	518.45	518.45	65.0

> showing 50 of 112 rows — these rows as CSV

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