PREVIEW / stock_daily / 2019-12-04

all stock daily files

  file:    by_date/stock_daily/2019/2019-12-04.parquet
  size:    222 KB
  rows:    6,622
  symbols: 2,458

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-12-04	AAPL	Stock	65.2675	65.8275	65.17	65.435	67181600.0
2019-12-04	MSFT	Stock	150.14	150.18	149.2	149.85	17574700.0
2019-12-04	NVDA	Stock	5.2755	5.298	5.2068	5.2355	273424000.0
2019-12-04	AMZN	Stock	88.7005	89.4545	88.011	88.0345	53402000.0
2019-12-04	GOOGL	Stock	65.305	66.2135	65.1526	65.947	35527840.0
2019-12-04	META	Stock	200.0	200.03	198.05	198.71	8456300.0
2019-12-04	TSLA	Stock	22.5167	22.524	22.19	22.202	82995000.0
2019-12-04	TLT	Stock	140.34	140.5	139.21	139.8	8588810.0
2019-12-04	ES	Stock	81.94	83.08	81.76	83.02	2277300.0
2019-12-04	CL	Stock	67.12	68.16	67.12	68.08	3279000.0
2019-12-04	A	Stock	80.3	81.0	80.18	80.93	1690900.0
2019-12-04	AA	Stock	19.97	20.15	19.76	19.76	4574700.0
2019-12-04	AACG	Stock	1.76	1.79	1.74	1.76	2000.0
2019-12-04	AAIC-DELISTED	Stock	5.83	5.855	5.81	5.85	231559.0
2019-12-04	AAIC.C-DELISTED	Stock	22.209	22.209	22.06	22.11	9728.0
2019-12-04	AAL	Stock	27.42	27.76	27.22	27.38	4805300.0
2019-12-04	AAM.A-DELISTED	Stock	26.1	26.14	26.1	26.1363	21373.0
2019-12-04	AAM.B-DELISTED	Stock	26.3	26.4663	26.3	26.37	33005.0
2019-12-04	AAMC-DELISTED	Stock	3.8971	3.9221	3.7206	3.8529	30947.0
2019-12-04	AAME	Stock	1.7	1.79	1.51	1.62	11200.0
2019-12-04	AAMI	Stock	9.5	9.58	9.46	9.55	272200.0
2019-12-04	AAOI	Stock	10.42	10.73	10.32	10.39	544500.0
2019-12-04	AAON	Stock	31.9	32.8867	31.9	32.2467	257400.0
2019-12-04	AAP	Stock	152.62	153.93	152.0	152.33	2822700.0
2019-12-04	AAT	Stock	47.1	47.6	46.85	47.51	266200.0
2019-12-04	AAU-DELISTED	Stock	0.54	0.55	0.53	0.53	248131.0
2019-12-04	AAUAF-DELISTED	Stock	0.54	0.55	0.53	0.53	257239.0
2019-12-04	AAWW-DELISTED	Stock	25.0	25.7786	24.53	24.76	216756.0
2019-12-04	AAXJ	Stock	69.47	69.56	69.39	69.43	529142.0
2019-12-04	AAXN-DELISTED	Stock	74.22	75.65	72.57	72.74	667332.0
2019-12-04	AB	Stock	28.35	28.78	28.35	28.69	282900.0
2019-12-04	ABB-DELISTED	Stock	22.24	22.31	22.14	22.145	1550573.0
2019-12-04	ABBNY-DELISTED	Stock	22.24	22.31	22.14	22.14	1617341.0
2019-12-04	ABBV	Stock	86.18	87.55	86.12	87.2	6174600.0
2019-12-04	ABC-DELISTED	Stock	87.64	88.965	87.56	88.35	510369.0
2019-12-04	ABCB	Stock	42.97	43.6	42.87	43.13	352900.0
2019-12-04	ABDC-DELISTED	Stock	8.994	9.02	8.983	9.01	24784.0
2019-12-04	ABEO	Stock	81.5	82.25	72.75	74.75	46868.0
2019-12-04	ABEOW-DELISTED	Stock	0.08	0.08	0.08	0.08	4970.0
2019-12-04	ABEV	Stock	4.27	4.4	4.27	4.32	16058300.0
2019-12-04	ABG	Stock	109.38	112.13	109.38	109.84	187100.0
2019-12-04	ABIL-DELISTED	Stock	0.58	0.682	0.5311	0.5811	1642690.0
2019-12-04	ABM	Stock	37.82	38.41	37.53	37.56	239300.0
2019-12-04	ABMD-DELISTED	Stock	193.24	194.56	188.645	193.82	280257.0
2019-12-04	ABR	Stock	14.86	14.97	14.86	14.92	873300.0
2019-12-04	ABR.A-DELISTED	Stock	26.27	26.27	26.11	26.2	768.0
2019-12-04	ABR.B-DELISTED	Stock	25.94	25.959	25.66	25.7595	2300.0
2019-12-04	ABT	Stock	84.5	85.34	84.44	85.18	3953400.0
2019-12-04	ABTC	Stock	363000.0	405000.0	336000.0	349200.0	33.4
2019-12-04	ABTS	Stock	33.75	33.75	33.75	33.75	46.7

> showing 50 of 6,622 rows — these rows as CSV

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