PREVIEW / futures_daily / 2022-04-18

all futures daily files

  file:    by_date/futures_daily/2022/2022-04-18.parquet
  size:    9 KB
  rows:    97

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
2022-04-18	ES	Futures	4938.19	4956.47	4899.39	4934.54	1149765.0
2022-04-18	NQ	Futures	15962.48	16089.45	15775.76	15980.58	492103.0
2022-04-18	YM	Futures	37623.2	37799.5	37415.2	37561.9	138271.0
2022-04-18	CL	Futures	84.91	87.1	84.09	85.83	202719.0
2022-04-18	GC	Futures	2300.7	2329.2	2295.9	2309.9	138130.0
2022-04-18	ZN	Futures	122.579384	122.803215	122.131723	122.419505	889306.0
2022-04-18	A6	Futures	0.75791	0.75862	0.75233	0.75304	43323.0
2022-04-18	AD	Futures	0.80316	0.80336	0.80073	0.80255	34389.0
2022-04-18	ALI	Futures	3777.45	3777.45	3777.45	3777.45	0.0
2022-04-18	B	Futures	84.04	85.93	82.84	84.67	132154.0
2022-04-18	B6	Futures	1.3247	1.3249	1.3187	1.3192	36087.0
2022-04-18	BR	Futures	0.17727	0.17943	0.17706	0.17921	203.0
2022-04-18	BTC	Futures	55915.6	57273.4	53666.4	56681.5	5796.0
2022-04-18	BZ	Futures	82.01	84.16	81.16	82.94	13187.0
2022-04-18	CB	Futures	215.364	215.364	213.414	213.804	30.0
2022-04-18	CC	Futures	1598.0	1598.0	1562.0	1570.0	19870.0
2022-04-18	CNH	Futures	6.0628	6.0631	6.0482	6.0531	260.0
2022-04-18	CSC	Futures	3.255	3.293	3.242	3.252	112.0
2022-04-18	CT	Futures	140.49	143.79	140.49	143.2	5539.0
2022-04-18	DC	Futures	32.11	32.43	31.86	31.99	463.0
2022-04-18	DX	Futures	96.879	97.245	96.859	97.164	10331.0
2022-04-18	E1	Futures	1.18165	1.18377	1.17976	1.18088	13720.0
2022-04-18	E6	Futures	1.14482	1.14641	1.14086	1.14239	61374.0
2022-04-18	E7	Futures	1.14	1.14	1.1343	1.1358	1260.0
2022-04-18	ED	Futures	95.7126	95.732	95.7028	95.7223	78058.0
2022-04-18	ER	Futures	98.445	98.445	98.445	98.445	0.0
2022-04-18	ESG	Futures	415.3	417.47	413.45	415.37	115.0
2022-04-18	EW	Futures	2857.8	2869.3	2840.3	2854.3	13230.0
2022-04-18	GF	Futures	227.609	228.176	224.636	225.344	5281.0
2022-04-18	HE	Futures	94.807	98.129	94.807	97.981	241.0
2022-04-18	HG	Futures	5.2508	5.3612	5.1907	5.3187	16553.0
2022-04-18	HH	Futures	20.852	22.61	20.852	22.03	9112.0
2022-04-18	HO	Futures	2.2403	2.2785	2.176	2.2138	30558.0
2022-04-18	HRC	Futures	2082.3	2082.3	2080.9	2080.9	2.0
2022-04-18	J1	Futures	0.0090793	0.0090994	0.0090432	0.0090455	80528.0
2022-04-18	J7	Futures	0.009088	0.009096	0.009041	0.009043	308.0
2022-04-18	JB	Futures	137.59	137.64	137.53	137.6	517.0
2022-04-18	KC	Futures	186.52	187.6	182.95	185.86	7035.0
2022-04-18	KE	Futures	1325.04	1370.39	1325.04	1360.63	8477.0
2022-04-18	KRW	Futures	0.0008066	0.0008066	0.0008049	0.0008051	8.0
2022-04-18	LBS	Futures	1758.7	1830.6	1726.6	1830.0	187.0
2022-04-18	LE	Futures	148.855	149.371	147.089	147.551	19640.0
2022-04-18	M2K	Futures	2216.3	2220.2	2189.4	2201.5	70115.0
2022-04-18	MBT	Futures	47326.2	48657.1	45551.7	48148.4	16259.0
2022-04-18	MCL	Futures	100.19	103.0	99.47	101.52	52084.0
2022-04-18	MES	Futures	4823.4	4839.61	4783.86	4818.19	874146.0
2022-04-18	MET	Futures	3602.1	3622.1	3393.7	3540.9	23528.0
2022-04-18	MFS	Futures	2196.7	2215.9	2195.9	2200.0	23151.0
2022-04-18	MGC	Futures	2234.6	2263.8	2232.1	2245.1	47836.0
2022-04-18	MME	Futures	1151.3	1152.9	1140.1	1147.3	59099.0

> showing 50 of 97 rows — these rows as CSV

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