PREVIEW / stock_daily / 2020-11-19

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-19.parquet
  size:    232 KB
  rows:    7,054
  symbols: 2,528

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-11-19	AAPL	Stock	117.59	119.06	116.81	118.64	74113000.0
2020-11-19	MSFT	Stock	211.38	213.03	209.93	212.42	24792700.0
2020-11-19	NVDA	Stock	13.2128	13.4875	13.1	13.4402	565936000.0
2020-11-19	AMZN	Stock	155.2655	156.25	154.046	155.851	60206000.0
2020-11-19	GOOGL	Stock	86.6615	88.1745	86.501	87.9285	20106800.0
2020-11-19	META	Stock	271.02	273.47	269.19	272.94	12963700.0
2020-11-19	TSLA	Stock	164.0	169.5367	162.5233	166.4233	187425900.0
2020-11-19	TLT	Stock	159.97	160.72	159.84	160.09	10623316.0
2020-11-19	ES	Stock	89.51	89.83	87.35	88.19	1765700.0
2020-11-19	CL	Stock	84.99	85.64	84.7	85.38	4400800.0
2020-11-19	A	Stock	106.74	108.96	105.19	108.68	1886400.0
2020-11-19	AA	Stock	18.3	18.99	18.19	18.93	5024600.0
2020-11-19	AACG	Stock	1.17	1.22	1.16	1.16	64500.0
2020-11-19	AACQ-DELISTED	Stock	9.815	9.89	9.8	9.87	123871.0
2020-11-19	AACQU-DELISTED	Stock	10.1799	10.25	10.17	10.23	131998.0
2020-11-19	AACQW-DELISTED	Stock	1.16	1.23	1.15	1.195	87745.0
2020-11-19	AAIC-DELISTED	Stock	3.02	3.0299	2.95	3.0	95858.0
2020-11-19	AAIC.C-DELISTED	Stock	19.73	19.95	19.73	19.95	2675.0
2020-11-19	AAL	Stock	12.73	13.04	12.63	12.79	58809400.0
2020-11-19	AAM.A-DELISTED	Stock	26.5	26.59	26.5	26.55	21519.0
2020-11-19	AAM.B-DELISTED	Stock	27.49	27.62	27.49	27.55	13612.0
2020-11-19	AAMC-DELISTED	Stock	6.7235	6.7647	6.6176	6.6912	7531.0
2020-11-19	AAME	Stock	2.19	2.19	2.1	2.15	1500.0
2020-11-19	AAMI	Stock	18.15	18.35	18.1	18.24	349800.0
2020-11-19	AAOI	Stock	7.54	7.78	7.415	7.77	929300.0
2020-11-19	AAON	Stock	44.6133	44.94	43.3067	43.84	232950.0
2020-11-19	AAP	Stock	147.54	147.54	144.07	146.08	1706700.0
2020-11-19	AAT	Stock	27.93	28.95	27.7	28.93	258100.0
2020-11-19	AAU-DELISTED	Stock	1.06	1.12	1.06	1.1	421063.0
2020-11-19	AAUAF-DELISTED	Stock	1.06	1.12	1.06	1.11	453282.0
2020-11-19	AAWW-DELISTED	Stock	55.74	56.0	53.93	54.6	467147.0
2020-11-19	AAXJ	Stock	84.59	85.21	84.43	85.09	1424376.0
2020-11-19	AAXN-DELISTED	Stock	119.66	124.4628	119.405	123.19	407900.0
2020-11-19	AB	Stock	31.39	31.74	31.11	31.69	182500.0
2020-11-19	ABB-DELISTED	Stock	27.17	27.18	26.795	26.92	1735506.0
2020-11-19	ABBNY-DELISTED	Stock	27.17	27.18	26.795	26.92	1902698.0
2020-11-19	ABBV	Stock	98.76	100.15	98.59	99.67	7550300.0
2020-11-19	ABC-DELISTED	Stock	102.65	102.91	100.4	101.9	1138270.0
2020-11-19	ABCB	Stock	34.01	34.29	33.23	34.16	222100.0
2020-11-19	ABCM-DELISTED	Stock	18.33	19.3	18.33	19.055	108778.0
2020-11-19	ABEO	Stock	37.0	37.25	32.5	33.5	75840.0
2020-11-19	ABEV	Stock	2.79	2.85	2.77	2.8	20143300.0
2020-11-19	ABG	Stock	123.63	124.55	120.09	120.85	109900.0
2020-11-19	ABM	Stock	38.18	38.36	37.53	38.25	204700.0
2020-11-19	ABMD-DELISTED	Stock	265.66	272.3	262.52	270.6	112499.0
2020-11-19	ABR	Stock	13.13	13.33	13.0	13.32	1055300.0
2020-11-19	ABR.A-DELISTED	Stock	25.37	25.4488	25.34	25.405	2020.0
2020-11-19	ABR.B-DELISTED	Stock	25.34	25.45	25.25	25.25	1293.0
2020-11-19	ABR.C-DELISTED	Stock	25.98	25.98	25.38	25.635	2063.0
2020-11-19	ABST-DELISTED	Stock	9.45	9.58	9.36	9.54	170175.0

> showing 50 of 7,054 rows — these rows as CSV

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