PREVIEW / futures_daily / 2019-07-31

all futures daily files

  file:    by_date/futures_daily/2019/2019-07-31.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-31	ES	Futures	3254.7	3259.56	3191.85	3218.02	1951108.0
2019-07-31	NQ	Futures	9201.96	9212.04	8959.9	9057.18	556437.0
2019-07-31	YM	Futures	28569.1	28621.6	28028.3	28198.4	239800.0
2019-07-31	CL	Futures	59.53	60.02	58.99	59.77	614001.0
2019-07-31	GC	Futures	1780.9	1785.9	1754.5	1773.6	419577.0
2019-07-31	ZN	Futures	126.771575	127.113739	126.429412	126.833787	2403170.0
2019-07-31	A6	Futures	0.7082	0.71088	0.70398	0.70481	148198.0
2019-07-31	AD	Futures	0.7671	0.76977	0.76337	0.76458	108014.0
2019-07-31	ALI	Futures	2231.52	2231.52	2212.89	2212.89	16.0
2019-07-31	B	Futures	48.93	49.36	48.41	49.07	321715.0
2019-07-31	B6	Futures	1.243	1.2531	1.2413	1.2441	166159.0
2019-07-31	BR	Futures	0.20954	0.21262	0.20858	0.20978	6218.0
2019-07-31	BTC	Futures	13389.7	14174.4	13334.6	13926.6	2198.0
2019-07-31	BZ	Futures	48.35	48.72	47.78	48.44	34287.0
2019-07-31	C	Futures	1733.0	1739.0	1709.0	1718.0	7304.0
2019-07-31	CB	Futures	278.908	278.908	277.858	277.858	55.0
2019-07-31	CC	Futures	1584.0	1588.0	1553.0	1562.0	19434.0
2019-07-31	CNH	Futures	6.8945	6.9117	6.8889	6.9117	315.0
2019-07-31	CSC	Futures	3.114	3.114	3.078	3.087	69.0
2019-07-31	CT	Futures	61.79	62.55	61.79	62.43	10.0
2019-07-31	DC	Futures	26.13	26.17	25.88	25.95	365.0
2019-07-31	DX	Futures	94.167	94.784	94.119	94.604	27893.0
2019-07-31	E1	Futures	1.17606	1.17791	1.17014	1.17223	30548.0
2019-07-31	E6	Futures	1.2214	1.22216	1.21109	1.21387	239383.0
2019-07-31	E7	Futures	1.2152	1.2159	1.2049	1.2076	5095.0
2019-07-31	EBM	Futures	203.25	203.53	200.94	201.23	22584.0
2019-07-31	ED	Futures	95.2649	95.299	95.1918	95.2162	665972.0
2019-07-31	ER	Futures	98.533	98.543	98.529	98.538	68144.0
2019-07-31	EW	Futures	2087.9	2094.4	2055.1	2067.1	21326.0
2019-07-31	FBON	Futures	143.86	144.62	143.86	144.53	852.0
2019-07-31	FBTP	Futures	125.22	125.68	125.1	125.58	70392.0
2019-07-31	FBTS	Futures	107.657	107.743	107.58	107.724	39747.0
2019-07-31	FCE	Futures	5035.9	5046.0	4974.9	5027.3	95934.0
2019-07-31	FDAX	Futures	12771.1	12863.3	12673.7	12830.1	114187.0
2019-07-31	FDIV	Futures	144.56	145.02	144.47	144.79	21.0
2019-07-31	FDXM	Futures	12611.2	12704.8	12517.6	12672.1	50702.0
2019-07-31	FESX	Futures	3016.9	3032.6	2987.2	3023.0	1001298.0
2019-07-31	FGBL	Futures	166.03	166.67	165.94	166.47	594157.0
2019-07-31	FGBM	Futures	134.83	135.04	134.81	135.0	324805.0
2019-07-31	FGBS	Futures	113.111	113.142	113.096	113.131	177920.0
2019-07-31	FGBX	Futures	213.48	216.31	213.28	215.36	54798.0
2019-07-31	FMWO	Futures	7426.0	7426.0	7311.8	7415.6	2404.0
2019-07-31	FOAT	Futures	153.02	153.6	153.0	153.49	103117.0
2019-07-31	FTDX	Futures	2858.2	2881.9	2853.2	2876.9	59.0
2019-07-31	FTI	Futures	542.66	543.27	534.3	540.02	26561.0
2019-07-31	FTUK	Futures	7007.8	7014.7	6885.4	6957.4	122595.0
2019-07-31	FVSA	Futures	172.51	183.02	170.65	173.74	41942.0
2019-07-31	FXXP	Futures	344.9	345.2	341.2	344.7	53623.0
2019-07-31	G	Futures	122.07	122.31	121.84	122.15	231459.0
2019-07-31	GF	Futures	280.77	281.31	276.355	277.728	2594.0

> showing 50 of 119 rows — these rows as CSV

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