PREVIEW / futures_daily / 2020-01-23

all futures daily files

  file:    by_date/futures_daily/2020/2020-01-23.parquet
  size:    10 KB
  rows:    119

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
2020-01-23	ES	Futures	3582.68	3593.21	3565.4	3592.13	1717046.0
2020-01-23	NQ	Futures	10541.11	10613.94	10497.23	10607.92	616950.0
2020-01-23	YM	Futures	30573.6	30613.5	30376.1	30589.3	232278.0
2020-01-23	CL	Futures	57.54	57.71	56.17	57.01	703995.0
2020-01-23	GC	Futures	1917.9	1928.5	1908.5	1925.9	361025.0
2020-01-23	ZN	Futures	128.396823	128.876898	128.396823	128.629118	1938652.0
2020-01-23	A6	Futures	0.70214	0.70604	0.70081	0.70204	113175.0
2020-01-23	AD	Futures	0.767	0.76776	0.76499	0.76756	79209.0
2020-01-23	ALI	Futures	2179.31	2179.61	2165.82	2171.51	52.0
2020-01-23	B	Futures	51.25	51.26	50.08	50.72	361905.0
2020-01-23	B6	Futures	1.3343	1.3356	1.3301	1.3323	75904.0
2020-01-23	BR	Futures	0.19356	0.19478	0.19348	0.19445	4620.0
2020-01-23	BTC	Futures	13135.0	13195.6	12566.5	12687.8	13847.0
2020-01-23	BZ	Futures	50.48	50.61	49.37	50.01	43330.0
2020-01-23	C	Futures	1896.0	1900.0	1866.0	1872.0	8894.0
2020-01-23	CB	Futures	236.105	236.399	235.161	235.161	27.0
2020-01-23	CC	Futures	1826.0	1830.0	1807.0	1813.0	17735.0
2020-01-23	CNH	Futures	6.8863	6.9116	6.8828	6.8997	388.0
2020-01-23	CSC	Futures	3.459	3.565	3.459	3.523	229.0
2020-01-23	CT	Futures	67.53	67.53	66.39	66.61	19121.0
2020-01-23	DC	Futures	29.11	29.74	29.11	29.38	635.0
2020-01-23	DX	Futures	94.444	94.72	94.327	94.617	18074.0
2020-01-23	E1	Futures	1.18392	1.18552	1.18118	1.18221	21725.0
2020-01-23	E6	Futures	1.19882	1.20054	1.19262	1.19462	233357.0
2020-01-23	E7	Futures	1.1928	1.1943	1.1864	1.1884	3463.0
2020-01-23	EBM	Futures	215.66	216.76	214.57	215.66	20977.0
2020-01-23	ED	Futures	95.3229	95.3423	95.3229	95.3326	321524.0
2020-01-23	ER	Futures	98.372	98.372	98.367	98.367	57627.0
2020-01-23	ESG	Futures	297.25	297.25	297.25	297.25	150.0
2020-01-23	EW	Futures	2190.0	2201.9	2173.7	2198.1	17453.0
2020-01-23	FBON	Futures	143.57	144.17	143.56	144.12	642.0
2020-01-23	FBTP	Futures	128.46	129.52	128.41	129.39	138021.0
2020-01-23	FBTS	Futures	108.057	108.249	108.028	108.23	80001.0
2020-01-23	FCE	Futures	5424.5	5457.5	5400.0	5409.5	83570.0
2020-01-23	FDAX	Futures	14236.4	14271.8	14145.9	14152.3	106293.0
2020-01-23	FDIV	Futures	159.22	159.22	158.06	158.06	124.0
2020-01-23	FDXM	Futures	14053.5	14092.1	13968.9	13974.6	56880.0
2020-01-23	FESX	Futures	3302.1	3314.5	3281.0	3282.8	1185568.0
2020-01-23	FGBL	Futures	164.68	165.33	164.62	165.27	770787.0
2020-01-23	FGBM	Futures	133.7	133.88	133.67	133.87	476469.0
2020-01-23	FGBS	Futures	112.624	112.654	112.608	112.649	373503.0
2020-01-23	FGBX	Futures	212.44	214.26	212.23	214.07	63854.0
2020-01-23	FMWO	Futures	8027.7	8031.1	7976.7	7977.8	2117.0
2020-01-23	FOAT	Futures	152.37	153.03	152.35	152.96	176060.0
2020-01-23	FTDX	Futures	3177.0	3205.6	3162.9	3184.0	75.0
2020-01-23	FTI	Futures	581.98	583.42	578.48	578.87	30491.0
2020-01-23	FTUK	Futures	7035.8	7045.2	6977.6	6979.5	94592.0
2020-01-23	FVSA	Futures	117.34	119.89	114.79	119.89	46839.0
2020-01-23	FXXP	Futures	382.7	384.0	381.0	381.5	61571.0
2020-01-23	G	Futures	121.97	122.34	121.81	122.3	204847.0

> showing 50 of 119 rows — these rows as CSV

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