PREVIEW / futures_daily / 2018-04-24

all futures daily files

  file:    by_date/futures_daily/2018/2018-04-24.parquet
  size:    9 KB
  rows:    111

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-24	ES	Futures	2905.71	2923.66	2844.82	2865.75	2329880.0
2018-04-24	NQ	Futures	7795.96	7862.68	7569.49	7639.13	626789.0
2018-04-24	YM	Futures	25735.6	25913.7	25056.2	25264.8	342249.0
2018-04-24	CL	Futures	69.2	69.63	67.79	67.95	832296.0
2018-04-24	GC	Futures	1693.0	1703.7	1689.8	1701.8	277648.0
2018-04-24	ZN	Futures	118.423533	118.56311	118.23743	118.439042	1500561.0
2018-04-24	A6	Futures	0.78167	0.78363	0.77931	0.78136	118024.0
2018-04-24	AD	Futures	0.78829	0.79046	0.78743	0.7892	63874.0
2018-04-24	B	Futures	54.58	54.86	53.56	53.69	330603.0
2018-04-24	B6	Futures	1.4467	1.4519	1.4448	1.4502	98926.0
2018-04-24	BR	Futures	0.22033	0.22208	0.21835	0.21904	4414.0
2018-04-24	BTC	Futures	12561.3	13305.6	12554.3	13298.5	473.0
2018-04-24	BZ	Futures	53.74	54.14	52.88	52.99	46897.0
2018-04-24	C	Futures	1663.0	1698.0	1655.0	1684.0	3551.0
2018-04-24	CB	Futures	298.975	302.064	298.975	300.828	35.0
2018-04-24	CC	Futures	1981.0	2068.0	1981.0	2052.0	28228.0
2018-04-24	CNH	Futures	6.415	6.415	6.4014	6.4014	46.0
2018-04-24	CSC	Futures	3.446	3.446	3.438	3.444	15.0
2018-04-24	CT	Futures	95.62	96.11	92.49	92.66	28929.0
2018-04-24	DC	Futures	27.78	27.94	27.78	27.84	182.0
2018-04-24	DX	Futures	85.537	85.684	85.33	85.388	24268.0
2018-04-24	E1	Futures	1.23646	1.2385	1.23296	1.23597	25009.0
2018-04-24	E6	Futures	1.38051	1.38491	1.37775	1.38395	212938.0
2018-04-24	E7	Futures	1.3736	1.3774	1.3704	1.3765	2941.0
2018-04-24	EBM	Futures	175.05	175.86	174.52	175.59	23772.0
2018-04-24	ED	Futures	94.9403	94.95	94.9354	94.9403	303426.0
2018-04-24	ER	Futures	98.337	98.342	98.337	98.342	30842.0
2018-04-24	EW	Futures	2015.6	2030.5	1982.6	1999.2	19242.0
2018-04-24	FBON	Futures	129.24	129.44	129.06	129.25	311.0
2018-04-24	FBTP	Futures	115.68	116.16	115.46	115.85	116997.0
2018-04-24	FBTS	Futures	104.232	104.26	104.204	104.232	42399.0
2018-04-24	FCE	Futures	4800.4	4814.6	4758.0	4807.5	63192.0
2018-04-24	FDAX	Futures	13109.1	13154.8	12871.7	13040.5	116558.0
2018-04-24	FDXM	Futures	12986.2	13037.7	12756.6	12924.4	40026.0
2018-04-24	FESX	Futures	2867.2	2875.6	2830.6	2861.4	886559.0
2018-04-24	FEU3	Futures	99.03	99.03	99.021	99.021	50.0
2018-04-24	FGBL	Futures	148.57	148.72	148.15	148.46	759532.0
2018-04-24	FGBM	Futures	129.24	129.31	129.12	129.22	377773.0
2018-04-24	FGBS	Futures	112.452	112.472	112.432	112.447	324601.0
2018-04-24	FGBX	Futures	167.53	167.91	166.58	167.41	54457.0
2018-04-24	FMWO	Futures	6971.3	7000.5	6890.7	6965.5	890.0
2018-04-24	FOAT	Futures	137.94	138.09	137.56	137.81	122534.0
2018-04-24	FTDX	Futures	2605.3	2605.3	2553.8	2591.4	197.0
2018-04-24	FTI	Futures	505.91	509.15	503.38	508.64	27392.0
2018-04-24	FTUK	Futures	6509.6	6523.8	6446.9	6508.3	111633.0
2018-04-24	FVSA	Futures	340.97	367.38	334.09	338.68	20007.0
2018-04-24	FXXP	Futures	327.5	328.0	323.7	326.6	54482.0
2018-04-24	G	Futures	112.92	113.01	112.43	112.66	248225.0
2018-04-24	GF	Futures	302.787	305.799	301.065	301.603	3301.0
2018-04-24	GSCI	Futures	533.22	533.22	529.44	529.56	10.0

> showing 50 of 111 rows — these rows as CSV

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