PREVIEW / futures_daily / 2019-04-22

all futures daily files

  file:    by_date/futures_daily/2019/2019-04-22.parquet
  size:    9 KB
  rows:    87

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
2019-04-22	ES	Futures	3141.96	3149.52	3131.43	3146.01	706067.0
2019-04-22	NQ	Futures	8889.55	8925.84	8837.12	8912.02	253668.0
2019-04-22	YM	Futures	28040.9	28108.4	27917.4	27986.0	122912.0
2019-04-22	CL	Futures	65.78	67.75	65.76	67.3	763527.0
2019-04-22	GC	Futures	1590.6	1595.5	1587.8	1590.1	136438.0
2019-04-22	ZN	Futures	122.451104	122.497722	122.249091	122.26463	610997.0
2019-04-22	A6	Futures	0.73766	0.73817	0.73559	0.7359	31425.0
2019-04-22	AD	Futures	0.75625	0.75913	0.7562	0.75868	39604.0
2019-04-22	B	Futures	52.39	54.28	52.34	53.93	305172.0
2019-04-22	B6	Futures	1.3339	1.3352	1.3329	1.3336	27178.0
2019-04-22	BR	Futures	0.20284	0.20348	0.20284	0.20304	1023.0
2019-04-22	BTC	Futures	8150.4	8420.8	8119.5	8335.8	9800.0
2019-04-22	BZ	Futures	52.34	54.12	52.23	53.78	48893.0
2019-04-22	CB	Futures	278.125	278.364	277.527	278.274	42.0
2019-04-22	CC	Futures	1599.0	1610.0	1566.0	1577.0	11825.0
2019-04-22	CNH	Futures	6.719	6.7288	6.7094	6.7214	588.0
2019-04-22	CSC	Futures	2.898	2.913	2.884	2.91	67.0
2019-04-22	CT	Futures	82.44	82.66	81.75	81.95	4322.0
2019-04-22	DC	Futures	24.35	24.58	24.32	24.57	251.0
2019-04-22	DX	Futures	93.058	93.072	92.9	92.933	6230.0
2019-04-22	E1	Futures	1.15571	1.15664	1.15442	1.15442	14229.0
2019-04-22	E6	Futures	1.23953	1.24194	1.23898	1.24156	70476.0
2019-04-22	E7	Futures	1.2326	1.2357	1.2326	1.2354	1746.0
2019-04-22	ED	Futures	95.1257	95.1404	95.1209	95.1404	260460.0
2019-04-22	ER	Futures	98.416	98.416	98.416	98.416	0.0
2019-04-22	EW	Futures	2079.7	2080.8	2061.9	2069.2	6368.0
2019-04-22	GF	Futures	314.79	315.622	312.604	313.957	4360.0
2019-04-22	GSCI	Futures	516.8	516.8	515.22	515.22	61.0
2019-04-22	HE	Futures	89.762	89.861	87.614	87.91	635.0
2019-04-22	HG	Futures	3.3596	3.3648	3.3207	3.3298	26726.0
2019-04-22	HH	Futures	17.256	17.263	17.14	17.222	9031.0
2019-04-22	HO	Futures	1.3762	1.4143	1.3762	1.4009	56411.0
2019-04-22	HRC	Futures	1587.5	1587.5	1587.5	1587.5	0.0
2019-04-22	J1	Futures	0.0105743	0.010579	0.010569	0.0105737	50471.0
2019-04-22	J7	Futures	0.010532	0.010534	0.010525	0.01053	173.0
2019-04-22	JB	Futures	140.17	140.23	140.15	140.19	321.0
2019-04-22	KC	Futures	99.98	102.9	99.6	100.31	20393.0
2019-04-22	KE	Futures	638.22	638.22	624.17	625.69	13991.0
2019-04-22	LBS	Futures	529.3	532.4	519.1	523.8	379.0
2019-04-22	LE	Futures	179.714	179.824	177.257	178.32	23984.0
2019-04-22	MFS	Futures	1972.4	1976.3	1970.5	1974.0	10728.0
2019-04-22	MGC	Futures	1556.9	1561.9	1554.4	1556.7	5516.0
2019-04-22	MME	Futures	1121.5	1123.6	1108.9	1114.2	29622.0
2019-04-22	MP	Futures	0.03899	0.03905	0.03883	0.03885	27656.0
2019-04-22	N6	Futures	0.6647	0.66539	0.6636	0.6637	10974.0
2019-04-22	NG	Futures	22.021	22.383	21.933	22.286	105447.0
2019-04-22	NIY	Futures	19998.7	20070.8	19895.1	20034.8	17547.0
2019-04-22	NKD	Futures	21055.0	21088.1	20899.0	21045.5	5680.0
2019-04-22	NOK	Futures	0.119911	0.120053	0.119829	0.120012	22.0
2019-04-22	OJ	Futures	100.81	101.0	99.78	99.92	373.0

> showing 50 of 87 rows — these rows as CSV

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