PREVIEW / futures_daily / 2018-01-11

all futures daily files

  file:    by_date/futures_daily/2018/2018-01-11.parquet
  size:    10 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-01-11	ES	Futures	2988.92	3011.2	2986.47	3010.11	1045414.0
2018-01-11	NQ	Futures	7819.38	7880.57	7805.03	7877.94	228872.0
2018-01-11	YM	Futures	26735.3	26956.8	26713.2	26950.5	115640.0
2018-01-11	CL	Futures	63.48	64.75	63.41	63.78	876642.0
2018-01-11	GC	Futures	1670.3	1679.4	1668.5	1676.6	264301.0
2018-01-11	ZN	Futures	121.404419	121.589533	121.296435	121.558681	1690056.0
2018-01-11	A6	Futures	0.80645	0.8119	0.80604	0.8117	116337.0
2018-01-11	AD	Futures	0.80975	0.81183	0.80701	0.81127	91790.0
2018-01-11	B	Futures	49.51	50.16	49.41	49.59	341936.0
2018-01-11	B6	Futures	1.408	1.4128	1.4026	1.4109	110233.0
2018-01-11	BR	Futures	0.23378	0.23442	0.23363	0.23427	398.0
2018-01-11	BTC	Futures	18570.3	19095.4	16418.7	17142.3	1298.0
2018-01-11	BZ	Futures	48.79	49.46	48.74	48.92	33268.0
2018-01-11	C	Futures	1288.0	1294.0	1263.0	1277.0	10284.0
2018-01-11	CB	Futures	271.765	271.765	269.325	269.696	34.0
2018-01-11	CC	Futures	1455.0	1462.0	1428.0	1438.0	19113.0
2018-01-11	CNH	Futures	6.671	6.671	6.6435	6.6435	10.0
2018-01-11	CSC	Futures	3.103	3.131	3.103	3.122	72.0
2018-01-11	CT	Futures	92.91	96.53	92.76	96.53	34198.0
2018-01-11	DC	Futures	24.61	24.65	24.41	24.52	171.0
2018-01-11	DX	Futures	86.463	86.684	85.961	86.029	22698.0
2018-01-11	E1	Futures	1.24657	1.25301	1.2422	1.24949	30507.0
2018-01-11	E6	Futures	1.35984	1.37236	1.35751	1.36998	317187.0
2018-01-11	E7	Futures	1.353	1.3654	1.3507	1.3632	7248.0
2018-01-11	EBM	Futures	173.43	174.24	171.27	171.54	21190.0
2018-01-11	ED	Futures	95.3505	95.3553	95.3407	95.3456	273167.0
2018-01-11	ER	Futures	98.337	98.337	98.332	98.332	91621.0
2018-01-11	EW	Futures	2052.2	2081.2	2050.1	2080.7	12541.0
2018-01-11	FBON	Futures	126.01	126.31	125.58	125.69	895.0
2018-01-11	FBTP	Futures	110.94	111.42	110.54	110.62	137129.0
2018-01-11	FBTS	Futures	103.604	103.631	103.476	103.503	92283.0
2018-01-11	FCE	Futures	4925.5	4934.4	4899.5	4908.5	61002.0
2018-01-11	FDAX	Futures	13782.3	13795.8	13635.0	13687.9	82563.0
2018-01-11	FDXM	Futures	13809.3	13821.8	13657.6	13711.1	25377.0
2018-01-11	FESX	Futures	2940.9	2947.5	2921.3	2929.5	899504.0
2018-01-11	FGBL	Futures	149.57	149.72	148.54	148.57	1056088.0
2018-01-11	FGBM	Futures	129.41	129.48	128.85	128.89	953272.0
2018-01-11	FGBS	Futures	112.377	112.387	112.246	112.261	833244.0
2018-01-11	FGBX	Futures	167.61	168.15	165.94	166.25	74882.0
2018-01-11	FMWO	Futures	7132.4	7165.1	7126.6	7151.1	1493.0
2018-01-11	FOAT	Futures	138.11	138.27	137.15	137.16	133906.0
2018-01-11	FTDX	Futures	2646.1	2657.6	2640.1	2641.6	327.0
2018-01-11	FTI	Futures	519.17	519.82	517.45	517.68	154.0
2018-01-11	FTUK	Futures	6710.5	6741.0	6706.1	6733.2	70449.0
2018-01-11	FVSA	Futures	252.84	253.89	246.52	248.63	25747.0
2018-01-11	FXXP	Futures	338.7	339.1	336.8	337.5	62439.0
2018-01-11	G	Futures	114.68	114.82	114.17	114.22	224248.0
2018-01-11	GF	Futures	310.29	312.267	308.094	310.455	5507.0
2018-01-11	GSCI	Futures	521.44	523.35	520.29	521.44	2488.0
2018-01-11	HE	Futures	96.711	96.711	94.344	94.677	30248.0

> showing 50 of 111 rows — these rows as CSV

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