PREVIEW / futures_daily / 2020-09-04

all futures daily files

  file:    by_date/futures_daily/2020/2020-09-04.parquet
  size:    10 KB
  rows:    121

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-09-04	ES	Futures	3888.62	3921.83	3768.18	3846.69	2994363.0
2020-09-04	NQ	Futures	13631.71	13745.45	12931.85	13403.94	1202274.0
2020-09-04	YM	Futures	30329.9	30641.8	29624.8	30086.7	389756.0
2020-09-04	CL	Futures	29.83	30.28	28.46	28.76	444184.0
2020-09-04	GC	Futures	2288.8	2310.8	2269.4	2284.4	304742.0
2020-09-04	ZN	Futures	138.589645	138.60513	137.93928	137.954765	7549.0
2020-09-04	A6	Futures	0.74796	0.75084	0.74292	0.75073	114043.0
2020-09-04	AD	Futures	0.77306	0.77819	0.77246	0.77814	82911.0
2020-09-04	ALI	Futures	2138.53	2139.13	2121.56	2136.45	148.0
2020-09-04	B	Futures	27.89	28.39	26.96	27.19	270957.0
2020-09-04	B6	Futures	1.3482	1.3525	1.3379	1.3496	114100.0
2020-09-04	BR	Futures	0.14804	0.14804	0.14785	0.14785	493.0
2020-09-04	BTC	Futures	14554.9	14561.6	13373.5	14338.9	15668.0
2020-09-04	BZ	Futures	27.36	27.77	26.38	26.6	32210.0
2020-09-04	C	Futures	1621.0	1642.0	1611.0	1612.0	1548.0
2020-09-04	CB	Futures	176.573	176.573	174.819	174.819	7.0
2020-09-04	CC	Futures	1730.0	1743.0	1698.0	1704.0	17520.0
2020-09-04	CNH	Futures	6.7458	6.7501	6.7359	6.7359	889.0
2020-09-04	CSC	Futures	3.295	3.295	3.276	3.276	36.0
2020-09-04	CT	Futures	64.15	64.85	64.15	64.85	2.0
2020-09-04	DC	Futures	26.63	26.69	26.36	26.52	136.0
2020-09-04	DX	Futures	89.663	90.068	89.508	89.56	25875.0
2020-09-04	E1	Futures	1.24897	1.24954	1.23966	1.24534	26480.0
2020-09-04	E6	Futures	1.27158	1.2734	1.26428	1.27185	220600.0
2020-09-04	E7	Futures	1.2655	1.2671	1.258	1.2655	7969.0
2020-09-04	EBM	Futures	227.24	227.54	226.04	226.64	1175.0
2020-09-04	ED	Futures	96.4354	96.4378	96.4306	96.433	170170.0
2020-09-04	ER	Futures	98.406	98.411	98.401	98.406	65361.0
2020-09-04	ESG	Futures	315.44	315.44	310.43	312.51	39.0
2020-09-04	EW	Futures	2031.5	2057.9	1976.1	2016.7	25386.0
2020-09-04	FBON	Futures	146.78	146.86	146.39	146.5	2234.0
2020-09-04	FBTP	Futures	133.36	133.59	132.83	132.91	136032.0
2020-09-04	FBTS	Futures	109.016	109.074	108.938	108.958	71230.0
2020-09-04	FCE	Futures	4865.4	4931.6	4793.4	4830.4	93263.0
2020-09-04	FDAX	Futures	13751.0	13945.9	13539.0	13595.9	104514.0
2020-09-04	FDIV	Futures	150.95	150.95	149.05	149.05	2743.0
2020-09-04	FDXM	Futures	13712.5	13894.6	13489.1	13546.8	103037.0
2020-09-04	FESX	Futures	3019.5	3073.0	2984.4	2998.3	1280347.0
2020-09-04	FEU3	Futures	99.154	99.159	99.154	99.159	100.0
2020-09-04	FGBL	Futures	169.05	169.15	168.51	168.91	615880.0
2020-09-04	FGBM	Futures	135.03	135.05	134.86	134.96	487751.0
2020-09-04	FGBS	Futures	112.795	112.81	112.759	112.79	445572.0
2020-09-04	FGBX	Futures	229.26	229.32	226.44	228.02	67495.0
2020-09-04	FMWO	Futures	8503.1	8577.7	8267.2	8302.8	7561.0
2020-09-04	FOAT	Futures	156.56	156.76	156.27	156.47	189046.0
2020-09-04	FTDX	Futures	3074.6	3139.5	3030.7	3046.0	162.0
2020-09-04	FTI	Futures	510.86	514.63	498.41	503.28	44868.0
2020-09-04	FTUK	Futures	5462.9	5580.6	5459.6	5467.6	156985.0
2020-09-04	FVSA	Futures	256.87	263.51	213.3	253.55	56728.0
2020-09-04	FXXP	Futures	337.1	340.8	331.7	333.4	90396.0

> showing 50 of 121 rows — these rows as CSV

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