PREVIEW / futures_daily / 2020-04-23

all futures daily files

  file:    by_date/futures_daily/2020/2020-04-23.parquet
  size:    10 KB
  rows:    120

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-04-23	ES	Futures	3087.65	3138.82	3068.01	3076.86	1703918.0
2020-04-23	NQ	Futures	9900.94	10073.19	9837.03	9857.95	435112.0
2020-04-23	YM	Futures	24942.4	25366.0	24788.7	24901.8	211387.0
2020-04-23	CL	Futures	10.57	13.59	9.94	12.28	833584.0
2020-04-23	GC	Futures	2105.9	2139.5	2098.7	2116.7	201884.0
2020-04-23	ZN	Futures	137.346176	137.485097	137.176384	137.33074	1105020.0
2020-04-23	A6	Futures	0.6496	0.65823	0.64549	0.65627	69681.0
2020-04-23	AD	Futures	0.71548	0.72414	0.71381	0.72166	56765.0
2020-04-23	ALI	Futures	1839.16	1845.43	1831.69	1834.68	122.0
2020-04-23	B	Futures	16.0	17.79	15.37	16.34	256303.0
2020-04-23	B6	Futures	1.2523	1.2606	1.2497	1.2544	71933.0
2020-04-23	BR	Futures	0.14874	0.15128	0.14731	0.14886	2510.0
2020-04-23	BTC	Futures	10092.6	11071.4	9993.3	10695.5	8039.0
2020-04-23	BZ	Futures	15.83	17.22	14.91	15.85	44993.0
2020-04-23	C	Futures	1828.0	1846.0	1828.0	1840.0	1957.0
2020-04-23	CB	Futures	139.416	140.029	135.791	135.791	8.0
2020-04-23	CC	Futures	1545.0	1560.0	1537.0	1544.0	13086.0
2020-04-23	CNH	Futures	7.0375	7.0413	7.0173	7.0229	306.0
2020-04-23	CSC	Futures	2.186	2.301	2.186	2.237	150.0
2020-04-23	CT	Futures	54.44	55.79	53.93	54.76	2374.0
2020-04-23	DC	Futures	17.46	18.43	17.29	18.0	461.0
2020-04-23	DX	Futures	97.273	97.519	96.814	97.215	22225.0
2020-04-23	E1	Futures	1.17337	1.17531	1.16711	1.16836	20411.0
2020-04-23	E6	Futures	1.16462	1.16714	1.15731	1.16048	177571.0
2020-04-23	E7	Futures	1.1585	1.161	1.151	1.1545	9548.0
2020-04-23	EBM	Futures	228.45	229.29	222.99	223.13	18643.0
2020-04-23	ED	Futures	96.2469	96.2614	96.2373	96.2518	214116.0
2020-04-23	ER	Futures	98.122	98.171	98.117	98.156	155308.0
2020-04-23	ESG	Futures	255.02	255.08	251.92	251.92	75.0
2020-04-23	EW	Futures	1598.4	1640.6	1590.0	1614.1	9718.0
2020-04-23	FBON	Futures	136.13	136.94	135.9	136.78	827.0
2020-04-23	FBTP	Futures	120.69	122.12	120.52	121.41	114559.0
2020-04-23	FBTS	Futures	105.95	106.335	105.94	106.191	72310.0
2020-04-23	FCE	Futures	4265.2	4327.2	4227.4	4282.6	39109.0
2020-04-23	FDAX	Futures	10981.0	11216.8	10909.6	11139.6	87562.0
2020-04-23	FDIV	Futures	114.68	117.05	114.68	117.05	200.0
2020-04-23	FDXM	Futures	11051.0	11271.0	10961.7	11192.8	60844.0
2020-04-23	FESX	Futures	2560.7	2614.9	2547.0	2591.9	1060757.0
2020-04-23	FEU3	Futures	98.877	98.892	98.858	98.892	2.0
2020-04-23	FGBL	Futures	167.05	167.66	166.5	167.29	571166.0
2020-04-23	FGBM	Futures	134.29	134.5	134.13	134.4	347796.0
2020-04-23	FGBS	Futures	112.8	112.875	112.769	112.84	283479.0
2020-04-23	FGBX	Futures	225.46	226.59	223.32	225.76	39320.0
2020-04-23	FMWO	Futures	6838.6	6942.1	6812.7	6919.8	2014.0
2020-04-23	FOAT	Futures	150.77	151.6	150.34	151.47	138823.0
2020-04-23	FTDX	Futures	2940.5	2986.0	2938.0	2983.5	142.0
2020-04-23	FTI	Futures	476.27	481.57	469.57	476.96	26383.0
2020-04-23	FTUK	Futures	5416.9	5497.5	5394.2	5477.2	89073.0
2020-04-23	FVSA	Futures	357.83	362.78	339.37	345.23	8888.0
2020-04-23	FXXP	Futures	303.9	308.2	301.8	306.6	74741.0

> showing 50 of 120 rows — these rows as CSV

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