PREVIEW / futures_daily / 2018-10-23

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-23.parquet
  size:    10 KB
  rows:    114

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-10-23	ES	Futures	2988.64	2990.54	2919.78	2978.34	2849774.0
2018-10-23	NQ	Futures	8310.72	8321.17	8065.64	8293.58	825811.0
2018-10-23	YM	Futures	26638.8	26652.5	26062.8	26583.0	344634.0
2018-10-23	CL	Futures	72.48	72.6	68.51	69.23	853265.0
2018-10-23	GC	Futures	1552.7	1575.4	1552.0	1567.5	288378.0
2018-10-23	ZN	Futures	117.502993	118.187778	117.502993	117.798696	2923885.0
2018-10-23	A6	Futures	0.72922	0.72994	0.72634	0.72942	95891.0
2018-10-23	AD	Futures	0.77259	0.77406	0.77128	0.77345	64489.0
2018-10-23	B	Futures	58.81	58.87	55.75	56.16	513715.0
2018-10-23	B6	Futures	1.3372	1.3448	1.3337	1.3386	103943.0
2018-10-23	BR	Futures	0.2054	0.20574	0.20418	0.20506	263.0
2018-10-23	BTC	Futures	9235.4	9271.5	9163.2	9228.2	1492.0
2018-10-23	BZ	Futures	58.36	58.43	55.34	55.74	60226.0
2018-10-23	C	Futures	1515.0	1519.0	1489.0	1509.0	7334.0
2018-10-23	CB	Futures	267.271	267.271	267.091	267.121	15.0
2018-10-23	CC	Futures	1541.0	1542.0	1504.0	1527.0	19349.0
2018-10-23	CNH	Futures	6.9953	7.0006	6.9923	6.9923	421.0
2018-10-23	CSC	Futures	3.068	3.068	3.03	3.036	115.0
2018-10-23	CT	Futures	89.8	89.8	87.75	88.66	22824.0
2018-10-23	DC	Futures	25.74	25.76	25.21	25.23	524.0
2018-10-23	DX	Futures	90.985	91.122	90.766	90.926	22791.0
2018-10-23	E1	Futures	1.19556	1.19852	1.19461	1.19604	23998.0
2018-10-23	E6	Futures	1.28011	1.28334	1.27728	1.2805	221139.0
2018-10-23	E7	Futures	1.274	1.2771	1.2711	1.2742	4036.0
2018-10-23	EBM	Futures	208.2	210.01	207.94	208.98	15543.0
2018-10-23	ED	Futures	94.9841	95.0085	94.9841	94.989	416905.0
2018-10-23	ER	Futures	98.377	98.381	98.377	98.377	44086.0
2018-10-23	EW	Futures	1960.0	1961.2	1907.4	1941.0	17901.0
2018-10-23	FBON	Futures	125.94	126.48	125.88	126.31	1161.0
2018-10-23	FBTP	Futures	103.76	104.7	103.21	103.42	108257.0
2018-10-23	FBTS	Futures	101.778	102.153	101.544	101.731	79217.0
2018-10-23	FCE	Futures	4483.0	4512.5	4433.7	4445.4	134486.0
2018-10-23	FDAX	Futures	11944.9	12013.7	11794.0	11859.7	172388.0
2018-10-23	FDIV	Futures	137.73	137.73	136.39	136.52	2.0
2018-10-23	FDXM	Futures	11759.2	11806.7	11589.7	11654.3	85430.0
2018-10-23	FESX	Futures	2646.2	2668.9	2621.8	2635.2	1760872.0
2018-10-23	FGBL	Futures	152.69	153.1	152.58	152.92	765600.0
2018-10-23	FGBM	Futures	130.84	130.98	130.78	130.91	431292.0
2018-10-23	FGBS	Futures	112.658	112.688	112.653	112.673	320749.0
2018-10-23	FGBX	Futures	177.33	178.24	177.05	177.86	51905.0
2018-10-23	FMWO	Futures	6743.4	6779.4	6678.6	6726.1	1716.0
2018-10-23	FOAT	Futures	139.84	140.19	139.8	140.04	143483.0
2018-10-23	FTDX	Futures	2544.0	2549.4	2495.4	2502.7	564.0
2018-10-23	FTI	Futures	479.6	480.9	473.44	474.99	43880.0
2018-10-23	FTUK	Futures	6262.6	6265.7	6166.9	6207.2	160920.0
2018-10-23	FVSA	Futures	364.36	373.87	344.38	367.21	55163.0
2018-10-23	FXXP	Futures	308.4	309.3	304.9	306.1	110019.0
2018-10-23	G	Futures	114.55	114.78	114.28	114.64	266387.0
2018-10-23	GF	Futures	325.928	325.928	321.821	324.108	3280.0
2018-10-23	GSCI	Futures	534.74	535.82	528.57	530.28	226.0

> showing 50 of 114 rows — these rows as CSV

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