PREVIEW / futures_daily / 2020-03-24

all futures daily files

  file:    by_date/futures_daily/2020/2020-03-24.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
2020-03-24	ES	Futures	2471.06	2708.4	2468.02	2697.61	2639522.0
2020-03-24	NQ	Futures	8031.67	8681.13	8031.67	8661.07	556553.0
2020-03-24	YM	Futures	19830.1	22098.7	19830.1	21989.8	287349.0
2020-03-24	CL	Futures	23.66	24.94	22.88	23.8	659697.0
2020-03-24	GC	Futures	1906.7	2070.3	1902.7	2024.9	418776.0
2020-03-24	ZN	Futures	136.420039	136.636137	135.262367	135.787178	1401549.0
2020-03-24	A6	Futures	0.59792	0.61415	0.5972	0.60789	87256.0
2020-03-24	AD	Futures	0.69901	0.7055	0.6978	0.69952	61114.0
2020-03-24	ALI	Futures	1909.34	1926.33	1908.13	1908.13	25.0
2020-03-24	B	Futures	23.58	24.37	22.7	23.09	198906.0
2020-03-24	B6	Futures	1.1748	1.1999	1.1668	1.1948	89160.0
2020-03-24	BR	Futures	0.16095	0.16095	0.16062	0.16062	25.0
2020-03-24	BTC	Futures	9199.0	9787.6	9071.3	9567.8	1186.0
2020-03-24	BZ	Futures	22.88	23.71	22.1	22.48	30946.0
2020-03-24	C	Futures	1707.0	1735.0	1697.0	1705.0	5347.0
2020-03-24	CB	Futures	203.073	204.551	198.11	198.528	71.0
2020-03-24	CC	Futures	1490.0	1506.0	1466.0	1490.0	18253.0
2020-03-24	CNH	Futures	7.0555	7.0555	7.0025	7.0227	1170.0
2020-03-24	CSC	Futures	3.029	3.038	3.003	3.013	91.0
2020-03-24	CT	Futures	50.1	52.83	49.26	50.92	23556.0
2020-03-24	DC	Futures	24.6	24.68	24.38	24.46	244.0
2020-03-24	DX	Futures	99.434	99.516	98.201	98.87	20689.0
2020-03-24	E1	Futures	1.16187	1.17713	1.16142	1.16392	45431.0
2020-03-24	E6	Futures	1.15785	1.17488	1.15715	1.16069	196644.0
2020-03-24	E7	Futures	1.1521	1.1687	1.1515	1.1547	11379.0
2020-03-24	EBM	Futures	216.97	218.93	215.57	218.09	24729.0
2020-03-24	ED	Futures	96.1938	96.2373	96.1454	96.1599	259918.0
2020-03-24	ER	Futures	98.338	98.342	98.333	98.333	74232.0
2020-03-24	EW	Futures	1294.7	1431.6	1288.9	1422.3	11962.0
2020-03-24	FBON	Futures	139.73	139.92	138.58	138.58	103.0
2020-03-24	FBTP	Futures	125.81	126.04	125.2	125.58	74489.0
2020-03-24	FBTS	Futures	107.162	107.21	107.037	107.095	43718.0
2020-03-24	FCE	Futures	3929.1	4143.6	3894.3	4097.2	94021.0
2020-03-24	FDAX	Futures	9386.6	10279.2	9371.2	10157.1	143420.0
2020-03-24	FDXM	Futures	9452.7	10329.4	9420.8	10205.6	75112.0
2020-03-24	FESX	Futures	2246.8	2451.5	2246.8	2419.4	2250972.0
2020-03-24	FEU3	Futures	99.07	99.075	99.07	99.075	150.0
2020-03-24	FGBL	Futures	166.35	166.59	165.43	165.51	454546.0
2020-03-24	FGBM	Futures	133.84	133.96	133.58	133.62	235315.0
2020-03-24	FGBS	Futures	112.835	112.85	112.704	112.719	173475.0
2020-03-24	FGBX	Futures	226.01	226.61	221.62	221.79	31878.0
2020-03-24	FMWO	Futures	5764.5	6055.1	5743.3	6026.9	8378.0
2020-03-24	FOAT	Futures	150.75	150.8	149.61	149.74	95492.0
2020-03-24	FTDX	Futures	2426.4	2508.3	2426.4	2491.2	171.0
2020-03-24	FTI	Futures	413.03	433.19	410.22	431.64	49055.0
2020-03-24	FTUK	Futures	4738.8	5107.1	4725.6	5027.4	176178.0
2020-03-24	FVSA	Futures	354.23	387.08	324.07	339.37	31234.0
2020-03-24	FXXP	Futures	265.5	277.2	262.0	274.2	96889.0
2020-03-24	G	Futures	123.72	124.08	123.39	123.57	189962.0
2020-03-24	GF	Futures	270.088	270.088	268.634	270.088	1495.0

> showing 50 of 119 rows — these rows as CSV

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