PREVIEW / futures_daily / 2018-09-04

all futures daily files

  file:    by_date/futures_daily/2018/2018-09-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-09-04	ES	Futures	3156.74	3163.26	3133.94	3147.78	1605954.0
2018-09-04	NQ	Futures	8942.47	8970.16	8845.41	8906.03	470667.0
2018-09-04	YM	Futures	27418.1	27480.3	27203.2	27380.2	180653.0
2018-09-04	CL	Futures	72.8	74.37	71.95	72.78	785981.0
2018-09-04	GC	Futures	1528.9	1533.2	1514.7	1519.8	421469.0
2018-09-04	ZN	Futures	119.665465	119.758698	119.385764	119.401303	115787.0
2018-09-04	A6	Futures	0.7395	0.74423	0.73621	0.73847	179509.0
2018-09-04	AD	Futures	0.77533	0.7766	0.76692	0.76875	107355.0
2018-09-04	B	Futures	56.99	58.11	56.44	56.98	320446.0
2018-09-04	B6	Futures	1.3335	1.3352	1.3224	1.327	185192.0
2018-09-04	BR	Futures	0.18292	0.18292	0.18003	0.18178	1366.0
2018-09-04	BTC	Futures	10383.1	10597.6	10283.0	10511.8	5305.0
2018-09-04	BZ	Futures	56.44	57.85	56.12	56.73	36059.0
2018-09-04	C	Futures	1535.0	1553.0	1523.0	1549.0	1366.0
2018-09-04	CB	Futures	264.358	265.559	263.757	264.388	41.0
2018-09-04	CC	Futures	1596.0	1631.0	1589.0	1629.0	25181.0
2018-09-04	CNH	Futures	6.9288	6.9367	6.898	6.9208	271.0
2018-09-04	CSC	Futures	3.349	3.361	3.349	3.353	71.0
2018-09-04	CT	Futures	92.79	93.15	91.47	92.88	12.0
2018-09-04	DC	Futures	27.46	27.55	27.41	27.48	228.0
2018-09-04	DX	Futures	90.074	90.619	90.055	90.335	22201.0
2018-09-04	E1	Futures	1.23432	1.23552	1.22488	1.22739	49640.0
2018-09-04	E6	Futures	1.29832	1.30173	1.29065	1.29625	347935.0
2018-09-04	E7	Futures	1.2916	1.295	1.2841	1.2897	4314.0
2018-09-04	EBM	Futures	211.33	212.11	208.45	209.24	2528.0
2018-09-04	ED	Futures	95.0838	95.0959	95.0838	95.0862	226757.0
2018-09-04	ER	Futures	98.367	98.372	98.367	98.367	33563.0
2018-09-04	EW	Futures	2169.1	2172.6	2149.7	2161.2	16744.0
2018-09-04	FBON	Futures	128.81	129.18	128.78	129.03	2199.0
2018-09-04	FBTP	Futures	104.35	105.81	104.35	105.56	224155.0
2018-09-04	FBTS	Futures	101.437	102.169	101.437	101.965	121870.0
2018-09-04	FCE	Futures	4876.1	4893.2	4795.0	4813.9	84764.0
2018-09-04	FDAX	Futures	12894.7	12963.2	12707.6	12757.8	118493.0
2018-09-04	FDIV	Futures	147.51	147.51	145.63	145.85	99.0
2018-09-04	FDXM	Futures	12732.6	12797.6	12544.7	12594.8	50686.0
2018-09-04	FESX	Futures	2835.5	2845.5	2791.2	2804.6	1187877.0
2018-09-04	FEU3	Futures	99.016	99.021	99.016	99.021	950.0
2018-09-04	FGBL	Futures	153.79	153.8	153.4	153.47	1477235.0
2018-09-04	FGBM	Futures	131.29	131.29	131.12	131.14	1074271.0
2018-09-04	FGBS	Futures	112.678	112.678	112.638	112.643	720299.0
2018-09-04	FGBX	Futures	178.54	178.64	177.72	177.84	123178.0
2018-09-04	FMWO	Futures	7248.8	7252.3	7177.8	7194.1	1681.0
2018-09-04	FOAT	Futures	141.03	141.14	140.9	141.04	276087.0
2018-09-04	FTDX	Futures	2978.9	2994.1	2921.6	2926.0	249.0
2018-09-04	FTI	Futures	519.32	521.04	511.8	513.29	32914.0
2018-09-04	FTUK	Futures	6666.0	6707.8	6620.5	6640.6	94819.0
2018-09-04	FVSA	Futures	267.4	282.21	264.79	277.85	48463.0
2018-09-04	FXXP	Futures	331.3	332.1	327.4	328.3	62329.0
2018-09-04	G	Futures	115.18	115.42	115.04	115.09	213016.0
2018-09-04	GF	Futures	310.897	316.046	309.545	315.63	1844.0

> showing 50 of 116 rows — these rows as CSV

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