PREVIEW / futures_daily / 2019-07-29

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-29.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
2019-07-29	ES	Futures	3260.91	3266.57	3253.9	3260.64	823572.0
2019-07-29	NQ	Futures	9230.75	9247.15	9155.05	9212.04	301214.0
2019-07-29	YM	Futures	28500.8	28618.4	28468.3	28558.6	111350.0
2019-07-29	CL	Futures	57.35	58.26	56.95	58.03	529742.0
2019-07-29	GC	Futures	1766.3	1777.3	1760.9	1768.0	174169.0
2019-07-29	ZN	Futures	126.724917	126.911551	126.693811	126.864893	867368.0
2019-07-29	A6	Futures	0.71191	0.71263	0.71047	0.71119	57793.0
2019-07-29	AD	Futures	0.76594	0.76731	0.76529	0.7665	46784.0
2019-07-29	ALI	Futures	2235.49	2248.62	2235.49	2248.62	48.0
2019-07-29	B	Futures	47.7	48.14	47.41	47.99	237965.0
2019-07-29	B6	Futures	1.2668	1.2669	1.2494	1.2506	133181.0
2019-07-29	BR	Futures	0.21026	0.21114	0.20974	0.21066	9650.0
2019-07-29	BTC	Futures	13183.1	13561.8	12659.9	13121.2	3073.0
2019-07-29	BZ	Futures	47.12	47.52	46.8	47.37	19794.0
2019-07-29	C	Futures	1721.0	1735.0	1714.0	1733.0	3930.0
2019-07-29	CB	Futures	281.126	281.126	277.975	278.879	73.0
2019-07-29	CC	Futures	1589.0	1599.0	1576.0	1587.0	17625.0
2019-07-29	CNH	Futures	6.8854	6.9015	6.8813	6.8947	338.0
2019-07-29	CSC	Futures	3.137	3.137	3.122	3.125	97.0
2019-07-29	CT	Futures	62.74	62.98	62.03	62.98	23.0
2019-07-29	DC	Futures	26.41	26.43	26.29	26.33	250.0
2019-07-29	DX	Futures	94.086	94.264	94.009	94.159	9307.0
2019-07-29	E1	Futures	1.17246	1.17548	1.17234	1.1749	15639.0
2019-07-29	E6	Futures	1.21862	1.22113	1.21693	1.22069	136746.0
2019-07-29	E7	Futures	1.2124	1.2146	1.2105	1.2143	2056.0
2019-07-29	EBM	Futures	202.38	203.53	201.52	202.38	15838.0
2019-07-29	ED	Futures	95.2454	95.2795	95.2454	95.2746	282497.0
2019-07-29	ER	Futures	98.533	98.538	98.529	98.533	52545.0
2019-07-29	EW	Futures	2083.5	2088.0	2072.1	2076.0	10710.0
2019-07-29	FBON	Futures	143.58	143.93	143.58	143.6	502.0
2019-07-29	FBTP	Futures	125.42	125.83	125.13	125.26	56459.0
2019-07-29	FBTS	Futures	107.705	107.791	107.647	107.667	32522.0
2019-07-29	FCE	Futures	5101.1	5123.4	5088.3	5101.5	46755.0
2019-07-29	FDAX	Futures	13060.2	13126.5	13026.5	13076.5	69839.0
2019-07-29	FDIV	Futures	147.48	148.36	147.48	148.13	80.0
2019-07-29	FDXM	Futures	12904.5	12964.8	12867.1	12915.4	28806.0
2019-07-29	FESX	Futures	3072.8	3085.9	3062.3	3077.2	468520.0
2019-07-29	FGBL	Futures	165.75	165.99	165.71	165.89	390571.0
2019-07-29	FGBM	Futures	134.77	134.85	134.75	134.8	181879.0
2019-07-29	FGBS	Futures	113.081	113.106	113.076	113.101	116409.0
2019-07-29	FGBX	Futures	212.29	213.34	212.17	212.93	27114.0
2019-07-29	FMWO	Futures	7454.8	7465.2	7438.7	7450.2	846.0
2019-07-29	FOAT	Futures	152.83	153.12	152.77	153.01	63509.0
2019-07-29	FTDX	Futures	2904.1	2924.8	2900.6	2913.5	60.0
2019-07-29	FTI	Futures	546.08	549.83	545.03	546.94	15832.0
2019-07-29	FTUK	Futures	6920.0	7060.4	6909.4	7047.9	150301.0
2019-07-29	FVSA	Futures	169.41	169.41	164.47	165.09	30465.0
2019-07-29	FXXP	Futures	348.3	350.7	348.1	349.4	33114.0
2019-07-29	G	Futures	121.68	122.07	121.58	121.82	142416.0
2019-07-29	GF	Futures	282.046	282.389	278.955	279.249	3915.0

> showing 50 of 119 rows — these rows as CSV

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