PREVIEW / futures_daily / 2018-10-25

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-25.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-25	ES	Futures	2899.71	2953.94	2883.44	2915.44	2535913.0
2018-10-25	NQ	Futures	7989.56	8218.67	7917.83	8045.31	793502.0
2018-10-25	YM	Futures	26035.4	26409.3	25874.3	26196.6	321207.0
2018-10-25	CL	Futures	69.16	70.5	68.77	70.17	573096.0
2018-10-25	GC	Futures	1567.3	1574.1	1559.6	1562.0	259679.0
2018-10-25	ZN	Futures	118.296722	118.374538	117.969892	118.063272	2132579.0
2018-10-25	A6	Futures	0.72706	0.73086	0.72654	0.72932	90525.0
2018-10-25	AD	Futures	0.77583	0.7776	0.77264	0.77396	83652.0
2018-10-25	B	Futures	55.97	56.98	55.74	56.82	193711.0
2018-10-25	B6	Futures	1.3283	1.3318	1.319	1.322	102613.0
2018-10-25	BR	Futures	0.20361	0.20673	0.20308	0.20616	1893.0
2018-10-25	BTC	Futures	9278.8	9278.8	9148.5	9271.6	1331.0
2018-10-25	BZ	Futures	55.55	56.58	55.36	56.44	24556.0
2018-10-25	C	Futures	1508.0	1553.0	1506.0	1551.0	10250.0
2018-10-25	CB	Futures	266.16	270.936	266.16	269.765	67.0
2018-10-25	CC	Futures	1499.0	1548.0	1497.0	1543.0	26109.0
2018-10-25	CNH	Futures	7.001	7.0177	7.0005	7.0066	319.0
2018-10-25	CSC	Futures	3.002	3.078	2.988	3.062	173.0
2018-10-25	CT	Futures	86.51	87.27	85.46	87.19	21715.0
2018-10-25	DC	Futures	25.01	25.51	24.81	25.41	512.0
2018-10-25	DX	Futures	91.312	91.673	91.175	91.63	28287.0
2018-10-25	E1	Futures	1.19355	1.19592	1.18845	1.19035	22549.0
2018-10-25	E6	Futures	1.27238	1.27622	1.2676	1.26833	235221.0
2018-10-25	E7	Futures	1.266	1.2698	1.2614	1.2621	4568.0
2018-10-25	EBM	Futures	208.2	208.2	206.9	207.16	16958.0
2018-10-25	ED	Futures	94.9841	94.9987	94.9743	94.9792	331856.0
2018-10-25	ER	Futures	98.377	98.377	98.372	98.377	29225.0
2018-10-25	EW	Futures	1890.8	1920.2	1883.5	1908.9	25051.0
2018-10-25	FBON	Futures	126.9	127.35	126.86	127.2	820.0
2018-10-25	FBTP	Futures	103.08	104.24	102.92	104.05	90701.0
2018-10-25	FBTS	Futures	101.619	101.965	101.572	101.881	79960.0
2018-10-25	FCE	Futures	4397.9	4519.2	4395.2	4503.1	129899.0
2018-10-25	FDAX	Futures	11674.1	11949.6	11638.9	11892.3	150899.0
2018-10-25	FDXM	Futures	11470.9	11741.6	11433.7	11686.3	82240.0
2018-10-25	FESX	Futures	2600.8	2663.0	2600.0	2651.2	1680431.0
2018-10-25	FGBL	Futures	153.4	153.44	152.96	153.28	681800.0
2018-10-25	FGBM	Futures	131.17	131.18	130.94	131.1	429712.0
2018-10-25	FGBS	Futures	112.739	112.739	112.673	112.708	332913.0
2018-10-25	FGBX	Futures	178.76	178.82	177.78	178.26	97490.0
2018-10-25	FMWO	Futures	6611.4	6694.8	6600.9	6686.7	3305.0
2018-10-25	FOAT	Futures	140.46	140.47	140.12	140.31	130700.0
2018-10-25	FTDX	Futures	2455.6	2510.6	2437.4	2504.7	425.0
2018-10-25	FTI	Futures	468.4	479.92	468.12	477.11	36046.0
2018-10-25	FTUK	Futures	6147.7	6258.5	6131.2	6232.6	136190.0
2018-10-25	FVSA	Futures	373.87	379.58	361.5	367.21	48536.0
2018-10-25	FXXP	Futures	302.2	308.1	301.9	306.7	124576.0
2018-10-25	G	Futures	115.07	115.15	114.85	115.11	265460.0
2018-10-25	GF	Futures	323.069	323.848	319.742	320.106	2911.0
2018-10-25	GSCI	Futures	530.97	531.77	529.71	530.97	25.0
2018-10-25	HE	Futures	77.746	78.451	75.632	76.203	29841.0

> showing 50 of 114 rows — these rows as CSV

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