PREVIEW / futures_daily / 2023-06-27

all futures daily files

  file:    by_date/futures_daily/2023/2023-06-27.parquet
  size:    10 KB
  rows:    130

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
2023-06-27	ES	Futures	4738.72	4791.79	4734.12	4785.29	1512256.0
2023-06-27	NQ	Futures	16275.81	16564.94	16261.86	16534.58	569198.0
2023-06-27	YM	Futures	36135.9	36380.4	36028.6	36328.3	149650.0
2023-06-27	CL	Futures	60.31	60.88	58.58	58.75	384752.0
2023-06-27	GC	Futures	2124.7	2133.0	2110.5	2114.9	180436.0
2023-06-27	ZN	Futures	115.219223	115.425965	114.773931	114.837544	1476874.0
2023-06-27	A6	Futures	0.6777	0.68231	0.67719	0.67917	86197.0
2023-06-27	AD	Futures	0.76916	0.77138	0.76689	0.7677	69177.0
2023-06-27	ALI	Futures	2394.41	2445.43	2389.42	2438.22	2434.0
2023-06-27	B	Futures	65.22	65.78	63.37	63.53	458819.0
2023-06-27	B6	Futures	1.2738	1.2786	1.273	1.2777	84764.0
2023-06-27	BFX	Futures	3851.5	3851.5	3851.5	3851.5	0.0
2023-06-27	BR	Futures	0.19357	0.19357	0.19222	0.1924	44.0
2023-06-27	BTC	Futures	40841.3	42162.4	40841.3	41632.6	5565.0
2023-06-27	BZ	Futures	65.06	65.63	63.26	63.41	28677.0
2023-06-27	C	Futures	2002.0	2024.0	1999.0	2016.0	2597.0
2023-06-27	CB	Futures	231.449	231.449	229.545	229.926	93.0
2023-06-27	CC	Futures	1890.0	1898.0	1881.0	1889.0	15802.0
2023-06-27	CNH	Futures	6.9308	6.9338	6.8932	6.9116	307.0
2023-06-27	CSC	Futures	1.884	1.885	1.86	1.862	217.0
2023-06-27	CT	Futures	96.64	96.64	95.07	95.36	17.0
2023-06-27	DC	Futures	17.5	17.5	16.99	17.05	267.0
2023-06-27	DX	Futures	100.445	100.504	100.028	100.192	10819.0
2023-06-27	E1	Futures	1.19498	1.19901	1.19281	1.19822	15295.0
2023-06-27	E6	Futures	1.12099	1.128	1.12032	1.12626	143883.0
2023-06-27	E7	Futures	1.121	1.1281	1.1204	1.1264	4346.0
2023-06-27	EBM	Futures	354.4	355.5	345.25	346.34	38222.0
2023-06-27	ER	Futures	97.766	97.777	97.756	97.761	182050.0
2023-06-27	ESG	Futures	410.72	415.32	410.67	415.06	478.0
2023-06-27	EW	Futures	2706.6	2749.6	2697.7	2745.8	8804.0
2023-06-27	FBON	Futures	123.71	123.85	123.19	123.22	65.0
2023-06-27	FBTP	Futures	115.3	115.58	114.95	115.05	146672.0
2023-06-27	FBTS	Futures	106.098	106.108	105.886	105.896	135950.0
2023-06-27	FCE	Futures	7864.0	7909.7	7807.9	7867.8	47356.0
2023-06-27	FDAX	Futures	16886.9	16990.6	16808.5	16915.4	52005.0
2023-06-27	FDIV	Futures	184.18	184.18	184.18	184.18	0.0
2023-06-27	FDXM	Futures	16956.0	17061.2	16878.4	16984.7	30577.0
2023-06-27	FDXS	Futures	16836.8	16954.0	16769.2	16875.9	18235.0
2023-06-27	FESX	Futures	4370.2	4412.7	4353.0	4389.4	590399.0
2023-06-27	FEU3	Futures	97.756	97.756	97.756	97.756	0.0
2023-06-27	FGBL	Futures	136.51	136.69	135.76	135.84	708295.0
2023-06-27	FGBM	Futures	119.11	119.11	118.57	118.6	540700.0
2023-06-27	FGBS	Futures	107.545	107.545	107.33	107.34	387258.0
2023-06-27	FGBX	Futures	143.81	145.04	143.08	143.3	73552.0
2023-06-27	FMWO	Futures	10187.7	10269.4	10152.0	10203.4	4131.0
2023-06-27	FOAT	Futures	127.74	127.97	127.15	127.23	158882.0
2023-06-27	FSMX	Futures	28126.6	28174.4	28014.2	28174.4	131.0
2023-06-27	FTDX	Futures	3320.7	3320.7	3287.0	3287.6	28.0
2023-06-27	FTI	Futures	799.3	805.13	794.99	800.38	13651.0
2023-06-27	FTUK	Futures	7601.7	7631.1	7558.5	7599.1	75611.0

> showing 50 of 130 rows — these rows as CSV

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