PREVIEW / futures_daily / 2018-04-03

all futures daily files

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

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-04-03	ES	Futures	2807.03	2847.81	2798.6	2841.83	2220246.0
2018-04-03	NQ	Futures	7497.5	7604.01	7433.71	7571.83	681282.0
2018-04-03	YM	Futures	24869.7	25292.2	24802.3	25264.8	359073.0
2018-04-03	CL	Futures	63.16	64.13	63.13	63.78	527289.0
2018-04-03	GC	Futures	1717.1	1719.2	1701.4	1707.3	288392.0
2018-04-03	ZN	Futures	120.346597	120.362106	119.896848	119.943374	1518112.0
2018-04-03	A6	Futures	0.78764	0.79247	0.78692	0.7898	85974.0
2018-04-03	AD	Futures	0.78429	0.79274	0.78389	0.79097	90895.0
2018-04-03	B	Futures	49.16	49.76	49.15	49.51	232257.0
2018-04-03	B6	Futures	1.4595	1.4635	1.4565	1.4602	90696.0
2018-04-03	BR	Futures	0.22909	0.22928	0.22692	0.22734	43.0
2018-04-03	BTC	Futures	9905.6	10679.6	9891.4	10594.4	2274.0
2018-04-03	BZ	Futures	48.54	49.09	48.49	48.87	22815.0
2018-04-03	C	Futures	1660.0	1665.0	1598.0	1618.0	14701.0
2018-04-03	CB	Futures	284.027	285.447	284.027	285.386	9.0
2018-04-03	CC	Futures	1908.0	1912.0	1817.0	1833.0	35684.0
2018-04-03	CNH	Futures	6.3898	6.3898	6.3795	6.3803	47.0
2018-04-03	CSC	Futures	3.325	3.325	3.321	3.325	56.0
2018-04-03	CT	Futures	93.07	95.19	93.07	94.28	22369.0
2018-04-03	DC	Futures	26.4	26.56	26.39	26.55	84.0
2018-04-03	DX	Futures	84.627	84.83	84.425	84.749	19800.0
2018-04-03	E1	Futures	1.26873	1.27114	1.26259	1.26355	22948.0
2018-04-03	E6	Futures	1.39347	1.3973	1.38789	1.38958	213519.0
2018-04-03	E7	Futures	1.3858	1.3898	1.3805	1.3822	3361.0
2018-04-03	EBM	Futures	175.86	179.08	175.59	178.54	31099.0
2018-04-03	ED	Futures	95.0181	95.0181	94.9889	94.9938	310734.0
2018-04-03	ER	Futures	98.337	98.342	98.332	98.337	46561.0
2018-04-03	EW	Futures	1947.6	1978.4	1946.1	1972.0	31159.0
2018-04-03	FBON	Futures	130.67	130.7	130.39	130.51	403.0
2018-04-03	FBTP	Futures	115.86	115.9	115.34	115.54	84885.0
2018-04-03	FBTS	Futures	104.297	104.297	104.223	104.25	45392.0
2018-04-03	FCE	Futures	4516.9	4555.7	4497.5	4533.6	77042.0
2018-04-03	FDAX	Futures	12448.3	12546.5	12378.6	12487.2	125570.0
2018-04-03	FDXM	Futures	12333.3	12435.3	12268.4	12376.1	45975.0
2018-04-03	FESX	Futures	2708.1	2729.8	2696.5	2719.0	1069461.0
2018-04-03	FEU3	Futures	99.021	99.026	99.021	99.021	52.0
2018-04-03	FGBL	Futures	150.16	150.2	149.69	149.91	702828.0
2018-04-03	FGBM	Futures	129.86	129.86	129.67	129.71	408600.0
2018-04-03	FGBS	Futures	112.573	112.578	112.542	112.547	272856.0
2018-04-03	FGBX	Futures	171.73	171.73	170.33	171.05	48271.0
2018-04-03	FMWO	Futures	6764.6	6810.2	6729.6	6772.8	1670.0
2018-04-03	FOAT	Futures	139.47	139.52	138.91	139.14	149899.0
2018-04-03	FTDX	Futures	2434.1	2446.0	2417.3	2437.6	292.0
2018-04-03	FTI	Futures	480.65	486.52	479.91	483.91	30124.0
2018-04-03	FTUK	Futures	6086.4	6169.5	6086.4	6144.7	120401.0
2018-04-03	FVSA	Futures	456.6	460.17	434.01	443.52	22846.0
2018-04-03	FXXP	Futures	312.9	314.4	311.0	313.2	62988.0
2018-04-03	G	Futures	114.48	114.48	114.15	114.27	188073.0
2018-04-03	GF	Futures	287.552	289.512	283.958	284.285	2009.0
2018-04-03	GSCI	Futures	511.02	512.39	510.16	510.85	885.0

> showing 50 of 112 rows — these rows as CSV

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