PREVIEW / stock_daily / 2020-11-24

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-24.parquet
  size:    236 KB
  rows:    7,131
  symbols: 2,564

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-24	AAPL	Stock	113.91	115.85	112.59	115.17	113874200.0
2020-11-24	MSFT	Stock	209.59	214.25	208.86	213.86	33979700.0
2020-11-24	NVDA	Stock	13.1425	13.162	12.885	12.9577	346500000.0
2020-11-24	AMZN	Stock	155.025	156.7125	154.313	155.903	72042000.0
2020-11-24	GOOGL	Stock	86.375	88.3238	86.0365	88.195	28006120.0
2020-11-24	META	Stock	268.49	277.82	267.87	276.92	16930400.0
2020-11-24	TSLA	Stock	180.1333	186.6633	175.4	185.1267	160945500.0
2020-11-24	TLT	Stock	159.99	160.0218	159.01	159.17	10892973.0
2020-11-24	ES	Stock	88.56	88.76	86.91	87.47	1375400.0
2020-11-24	CL	Stock	84.95	85.65	84.12	84.71	4223200.0
2020-11-24	A	Stock	118.96	118.96	111.43	114.68	5559900.0
2020-11-24	AA	Stock	20.24	21.0	20.025	20.82	7384100.0
2020-11-24	AACG	Stock	1.18	1.25	1.18	1.21	190400.0
2020-11-24	AACQ-DELISTED	Stock	9.8956	9.93	9.82	9.91	607380.0
2020-11-24	AACQU-DELISTED	Stock	10.3	10.3	10.24	10.28	35641.0
2020-11-24	AACQW-DELISTED	Stock	1.27	1.3225	1.24	1.28	61819.0
2020-11-24	AAIC-DELISTED	Stock	3.15	3.42	3.15	3.34	492700.0
2020-11-24	AAIC.C-DELISTED	Stock	20.7	20.7	20.5235	20.7	5068.0
2020-11-24	AAL	Stock	14.32	14.97	14.08	14.82	156501000.0
2020-11-24	AAM.A-DELISTED	Stock	26.64	26.67	26.6	26.6	9176.0
2020-11-24	AAM.B-DELISTED	Stock	27.57	27.64	27.45	27.45	3398.0
2020-11-24	AAMC-DELISTED	Stock	6.7655	6.7655	6.6235	6.6618	2499.0
2020-11-24	AAME	Stock	2.15	2.25	2.09	2.09	12500.0
2020-11-24	AAMI	Stock	18.68	18.755	18.25	18.48	589900.0
2020-11-24	AAOI	Stock	7.9	7.95	7.62	7.91	868200.0
2020-11-24	AAON	Stock	44.7733	45.2467	44.2267	44.5333	244500.0
2020-11-24	AAP	Stock	147.13	150.44	146.19	149.83	1109400.0
2020-11-24	AAT	Stock	31.12	31.54	30.69	31.38	543900.0
2020-11-24	AAU-DELISTED	Stock	0.99	1.0	0.9286	0.996	946792.0
2020-11-24	AAUAF-DELISTED	Stock	0.99	1.0	0.9286	0.976	983576.0
2020-11-24	AAWW-DELISTED	Stock	54.14	56.85	54.0	56.33	366205.0
2020-11-24	AAXJ	Stock	86.68	87.02	86.17	86.99	2530411.0
2020-11-24	AAXN-DELISTED	Stock	127.54	130.4099	126.01	127.34	292643.0
2020-11-24	AB	Stock	32.02	32.26	31.61	32.15	318900.0
2020-11-24	ABB-DELISTED	Stock	26.65	26.87	26.54	26.83	4498710.0
2020-11-24	ABBNY-DELISTED	Stock	26.65	26.87	26.54	26.83	4984415.0
2020-11-24	ABBV	Stock	102.88	104.82	102.58	103.96	9322200.0
2020-11-24	ABC-DELISTED	Stock	101.0	103.8	100.31	103.1	803981.0
2020-11-24	ABCB	Stock	35.39	36.5	34.7	35.82	593400.0
2020-11-24	ABCM-DELISTED	Stock	18.72	19.0601	18.69	18.91	58190.0
2020-11-24	ABEO	Stock	33.75	35.75	33.75	34.75	51480.0
2020-11-24	ABEV	Stock	2.77	2.84	2.76	2.78	30423400.0
2020-11-24	ABG	Stock	122.56	128.76	121.43	126.58	162400.0
2020-11-24	ABM	Stock	39.76	41.17	39.13	41.11	508800.0
2020-11-24	ABMD-DELISTED	Stock	265.78	267.66	260.5	265.65	129652.0
2020-11-24	ABR	Stock	13.71	13.95	13.6	13.77	1386700.0
2020-11-24	ABR.A-DELISTED	Stock	25.44	25.52	25.3484	25.51	12659.0
2020-11-24	ABR.B-DELISTED	Stock	25.2	25.39	25.2	25.39	232.0
2020-11-24	ABR.C-DELISTED	Stock	25.77	25.835	25.68	25.78	4019.0
2020-11-24	ABST-DELISTED	Stock	10.11	10.12	9.83	9.93	118643.0

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

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