PREVIEW / futures_daily / 2018-06-25

all futures daily files

  file:    by_date/futures_daily/2018/2018-06-25.parquet
  size:    10 KB
  rows:    115

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-06-25	ES	Futures	2994.37	2995.46	2933.01	2956.63	2206994.0
2018-06-25	NQ	Futures	8421.02	8421.02	8156.07	8247.01	598963.0
2018-06-25	YM	Futures	25919.8	25936.6	25369.8	25582.6	310488.0
2018-06-25	CL	Futures	69.64	70.34	68.66	68.96	816207.0
2018-06-25	GC	Futures	1624.2	1627.0	1615.6	1620.0	201565.0
2018-06-25	ZN	Futures	119.199296	119.478997	119.199296	119.370225	1504375.0
2018-06-25	A6	Futures	0.76542	0.76552	0.7609	0.76172	96007.0
2018-06-25	AD	Futures	0.76459	0.76459	0.7613	0.76221	67801.0
2018-06-25	B	Futures	55.32	55.32	54.28	54.99	305342.0
2018-06-25	B6	Futures	1.3744	1.3764	1.3692	1.3752	79237.0
2018-06-25	BFX	Futures	4294.1	4294.1	4294.1	4294.1	6.0
2018-06-25	BR	Futures	0.19999	0.20075	0.19995	0.20064	14.0
2018-06-25	BTC	Futures	8761.3	9046.2	8654.4	8910.9	1059.0
2018-06-25	BZ	Futures	54.81	54.99	54.01	54.7	30908.0
2018-06-25	C	Futures	1675.0	1680.0	1665.0	1669.0	1986.0
2018-06-25	CB	Futures	278.249	278.249	275.971	277.05	86.0
2018-06-25	CC	Futures	1796.0	1806.0	1771.0	1778.0	16529.0
2018-06-25	CNH	Futures	6.6196	6.6434	6.6176	6.6357	273.0
2018-06-25	CSC	Futures	3.333	3.337	3.272	3.284	242.0
2018-06-25	CT	Futures	97.11	97.75	96.04	96.7	20.0
2018-06-25	DC	Futures	26.38	26.41	25.81	25.9	446.0
2018-06-25	DX	Futures	89.17	89.373	88.9	88.97	16304.0
2018-06-25	E1	Futures	1.21831	1.22118	1.21687	1.22094	16715.0
2018-06-25	E6	Futures	1.31308	1.31828	1.30872	1.31722	217497.0
2018-06-25	E7	Futures	1.3064	1.3115	1.3022	1.3105	4295.0
2018-06-25	EBM	Futures	182.56	182.82	181.25	182.03	8027.0
2018-06-25	ED	Futures	94.9815	94.9913	94.9767	94.9864	169589.0
2018-06-25	ER	Futures	98.352	98.357	98.352	98.352	22818.0
2018-06-25	EW	Futures	2112.4	2112.6	2070.9	2081.1	23874.0
2018-06-25	FBON	Futures	128.49	128.74	128.44	128.65	509.0
2018-06-25	FBTP	Futures	107.17	107.18	106.04	106.41	62029.0
2018-06-25	FBTS	Futures	102.318	102.318	101.873	102.049	36920.0
2018-06-25	FCE	Futures	4806.9	4817.3	4736.4	4745.8	81579.0
2018-06-25	FDAX	Futures	13061.4	13090.7	12788.6	12828.3	121487.0
2018-06-25	FDXM	Futures	12893.6	12923.5	12625.2	12664.5	47297.0
2018-06-25	FESX	Futures	2844.7	2852.2	2799.6	2809.6	1000319.0
2018-06-25	FGBL	Futures	152.97	153.19	152.66	152.86	510179.0
2018-06-25	FGBM	Futures	131.28	131.34	131.13	131.23	278383.0
2018-06-25	FGBS	Futures	112.789	112.804	112.759	112.784	326916.0
2018-06-25	FGBX	Futures	175.15	175.81	174.35	174.93	43919.0
2018-06-25	FMWO	Futures	7010.0	7017.0	6928.5	6941.3	2186.0
2018-06-25	FOAT	Futures	140.63	140.72	140.3	140.43	96549.0
2018-06-25	FTDX	Futures	2736.7	2740.7	2652.4	2675.9	359.0
2018-06-25	FTI	Futures	513.58	515.1	503.29	504.44	36654.0
2018-06-25	FTUK	Futures	6762.2	6779.5	6612.1	6629.9	120075.0
2018-06-25	FVSA	Futures	301.28	339.18	297.39	325.58	38370.0
2018-06-25	FXXP	Futures	329.3	330.1	323.7	324.6	44057.0
2018-06-25	G	Futures	115.39	115.54	115.03	115.27	135121.0
2018-06-25	GF	Futures	305.712	306.437	300.637	301.983	7786.0
2018-06-25	GSCI	Futures	526.14	526.14	521.71	521.99	69.0

> showing 50 of 115 rows — these rows as CSV

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