PREVIEW / futures_daily / 2018-10-04

all futures daily files

  file:    by_date/futures_daily/2018/2018-10-04.parquet
  size:    10 KB
  rows:    116

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-04	ES	Futures	3173.28	3173.55	3131.8	3153.49	2165850.0
2018-10-04	NQ	Futures	8886.83	8886.83	8660.92	8728.0	704908.0
2018-10-04	YM	Futures	28255.3	28255.3	27887.8	28065.7	266898.0
2018-10-04	CL	Futures	79.75	80.05	77.34	77.81	687949.0
2018-10-04	GC	Futures	1522.7	1534.5	1520.4	1522.9	290842.0
2018-10-04	ZN	Futures	117.518556	117.565246	117.145037	117.39405	2803647.0
2018-10-04	A6	Futures	0.73179	0.7322	0.72747	0.7285	93949.0
2018-10-04	AD	Futures	0.78695	0.78761	0.78265	0.78341	63398.0
2018-10-04	B	Futures	63.18	63.5	61.82	62.15	361253.0
2018-10-04	B6	Futures	1.336	1.3455	1.3332	1.3438	100525.0
2018-10-04	BR	Futures	0.19336	0.19504	0.1918	0.19458	38.0
2018-10-04	BTC	Futures	9257.0	9538.4	9242.6	9459.0	1697.0
2018-10-04	BZ	Futures	62.81	63.02	61.37	61.68	35552.0
2018-10-04	C	Futures	1387.0	1418.0	1377.0	1396.0	5584.0
2018-10-04	CB	Futures	272.769	272.769	272.408	272.769	43.0
2018-10-04	CC	Futures	1405.0	1436.0	1399.0	1404.0	19682.0
2018-10-04	CNH	Futures	6.9454	6.9769	6.9454	6.9636	391.0
2018-10-04	CSC	Futures	3.208	3.212	3.2	3.206	183.0
2018-10-04	CT	Futures	85.92	86.17	84.89	85.31	11104.0
2018-10-04	DC	Futures	26.63	26.71	26.56	26.66	225.0
2018-10-04	DX	Futures	90.928	90.989	90.429	90.64	25227.0
2018-10-04	E1	Futures	1.20386	1.20564	1.20054	1.20291	23439.0
2018-10-04	E6	Futures	1.28361	1.29045	1.28156	1.28734	233008.0
2018-10-04	E7	Futures	1.2774	1.284	1.2752	1.2811	4038.0
2018-10-04	EBM	Futures	209.76	211.05	209.24	210.79	15530.0
2018-10-04	ED	Futures	95.0573	95.0769	95.0476	95.0622	406279.0
2018-10-04	ER	Futures	98.372	98.377	98.372	98.377	31834.0
2018-10-04	EW	Futures	2108.6	2108.9	2080.4	2088.2	20662.0
2018-10-04	FBON	Futures	127.57	127.57	127.16	127.36	990.0
2018-10-04	FBTP	Futures	105.04	105.67	104.63	105.18	95363.0
2018-10-04	FBTS	Futures	102.012	102.171	101.703	101.909	82260.0
2018-10-04	FCE	Futures	4937.0	4939.2	4854.5	4874.8	91797.0
2018-10-04	FDAX	Futures	12901.8	12973.3	12784.0	12862.9	113472.0
2018-10-04	FDIV	Futures	144.69	144.82	144.6	144.82	7.0
2018-10-04	FDXM	Futures	12671.6	12748.1	12562.1	12640.1	57858.0
2018-10-04	FESX	Futures	2843.6	2845.3	2812.5	2825.9	1067406.0
2018-10-04	FEU3	Futures	99.001	99.001	99.001	99.001	101.0
2018-10-04	FGBL	Futures	151.2	151.67	150.96	151.25	1039039.0
2018-10-04	FGBM	Futures	130.16	130.32	130.03	130.15	683894.0
2018-10-04	FGBS	Futures	112.487	112.527	112.467	112.487	605927.0
2018-10-04	FGBX	Futures	174.12	175.47	173.56	174.28	89926.0
2018-10-04	FMWO	Futures	7242.8	7253.3	7186.1	7213.9	1146.0
2018-10-04	FOAT	Futures	139.02	139.33	138.82	139.03	266291.0
2018-10-04	FTDX	Futures	2787.6	2789.1	2745.9	2749.8	190.0
2018-10-04	FTI	Futures	511.53	512.46	502.53	504.75	32517.0
2018-10-04	FTUK	Futures	6683.1	6702.7	6579.8	6604.4	107045.0
2018-10-04	FVSA	Futures	263.11	282.09	262.25	267.43	35431.0
2018-10-04	FXXP	Futures	330.1	331.0	326.9	327.8	77915.0
2018-10-04	G	Futures	113.37	113.37	112.85	113.01	394031.0
2018-10-04	GF	Futures	328.112	328.112	325.147	326.551	1522.0

> showing 50 of 116 rows — these rows as CSV

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