PREVIEW / futures_daily / 2019-07-23

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-23.parquet
  size:    10 KB
  rows:    117

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-23	ES	Futures	3225.03	3246.34	3223.68	3245.8	1056909.0
2019-07-23	NQ	Futures	9125.98	9194.19	9104.68	9191.89	357765.0
2019-07-23	YM	Futures	28533.4	28726.6	28517.6	28690.9	137719.0
2019-07-23	CL	Futures	57.32	58.64	56.88	57.93	521876.0
2019-07-23	GC	Futures	1774.8	1781.6	1760.6	1769.5	386682.0
2019-07-23	ZN	Futures	126.973763	127.020422	126.693811	126.771575	1078947.0
2019-07-23	A6	Futures	0.72497	0.72507	0.72086	0.72158	77846.0
2019-07-23	AD	Futures	0.76912	0.76917	0.7664	0.76816	62110.0
2019-07-23	ALI	Futures	2274.27	2274.27	2274.27	2274.27	0.0
2019-07-23	B	Futures	47.56	48.46	47.11	47.99	272729.0
2019-07-23	B6	Futures	1.2765	1.2773	1.2706	1.2732	89134.0
2019-07-23	BR	Futures	0.21222	0.21222	0.21118	0.21126	368.0
2019-07-23	BTC	Futures	14404.9	14516.8	13802.9	14208.9	3685.0
2019-07-23	BZ	Futures	46.98	47.84	46.51	47.38	31220.0
2019-07-23	C	Futures	1750.0	1758.0	1739.0	1744.0	3400.0
2019-07-23	CB	Futures	282.409	284.393	282.409	282.409	41.0
2019-07-23	CC	Futures	1676.0	1680.0	1646.0	1649.0	16184.0
2019-07-23	CNH	Futures	6.8856	6.8898	6.8833	6.887	693.0
2019-07-23	CSC	Futures	3.129	3.132	3.114	3.125	48.0
2019-07-23	CT	Futures	62.01	62.5	61.74	62.5	10.0
2019-07-23	DC	Futures	26.24	26.45	26.24	26.39	144.0
2019-07-23	DX	Futures	93.397	93.835	93.378	93.795	22827.0
2019-07-23	E1	Futures	1.18638	1.18661	1.18209	1.18267	18422.0
2019-07-23	E6	Futures	1.22822	1.22822	1.22118	1.22167	174305.0
2019-07-23	E7	Futures	1.2217	1.2217	1.2147	1.2153	3058.0
2019-07-23	EBM	Futures	201.23	201.52	199.5	200.94	21152.0
2019-07-23	ED	Futures	95.299	95.3038	95.2746	95.2892	318381.0
2019-07-23	ER	Futures	98.533	98.538	98.529	98.533	86814.0
2019-07-23	EW	Futures	2037.9	2058.5	2036.1	2057.7	12132.0
2019-07-23	FBON	Futures	143.12	143.36	142.69	143.27	146.0
2019-07-23	FBTP	Futures	124.58	125.08	124.42	124.96	76431.0
2019-07-23	FBTS	Futures	107.571	107.705	107.542	107.676	41951.0
2019-07-23	FCE	Futures	5080.1	5136.6	5075.6	5117.5	82459.0
2019-07-23	FDAX	Futures	12949.1	13207.1	12949.1	13158.1	134922.0
2019-07-23	FDIV	Futures	147.81	149.29	147.81	149.29	120.0
2019-07-23	FDXM	Futures	12785.9	13044.9	12785.9	12996.0	45759.0
2019-07-23	FESX	Futures	3043.1	3090.2	3043.1	3083.3	974671.0
2019-07-23	FGBL	Futures	165.08	165.42	165.03	165.36	397220.0
2019-07-23	FGBM	Futures	134.77	134.86	134.72	134.82	277825.0
2019-07-23	FGBS	Futures	113.137	113.152	113.116	113.142	175137.0
2019-07-23	FGBX	Futures	209.73	210.66	209.47	210.41	31244.0
2019-07-23	FMWO	Futures	7421.4	7446.8	7413.3	7423.7	2526.0
2019-07-23	FOAT	Futures	152.17	152.49	152.11	152.41	85428.0
2019-07-23	FTDX	Futures	2865.6	2884.3	2856.7	2875.5	146.0
2019-07-23	FTI	Futures	544.65	551.44	544.65	549.26	26323.0
2019-07-23	FTUK	Futures	6885.4	6955.6	6879.4	6928.8	92954.0
2019-07-23	FVSA	Futures	172.51	173.74	168.18	170.65	27272.0
2019-07-23	FXXP	Futures	346.9	350.7	346.9	350.1	46429.0
2019-07-23	G	Futures	121.01	121.48	121.0	121.46	185897.0
2019-07-23	GF	Futures	278.66	279.347	276.551	279.053	3281.0

> showing 50 of 117 rows — these rows as CSV

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