PREVIEW / stock_daily / 2020-11-16

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-16.parquet
  size:    232 KB
  rows:    7,049
  symbols: 2,515

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-16	AAPL	Stock	118.92	120.99	118.15	120.3	91183000.0
2020-11-16	MSFT	Stock	214.87	217.74	214.52	217.23	24953300.0
2020-11-16	NVDA	Stock	13.1725	13.6495	13.156	13.5153	413776000.0
2020-11-16	AMZN	Stock	154.66	157.135	153.6345	156.553	76174000.0
2020-11-16	GOOGL	Stock	88.207	89.717	88.0665	88.7015	25467860.0
2020-11-16	META	Stock	275.05	279.41	274.63	278.96	12970400.0
2020-11-16	TSLA	Stock	136.31	137.4833	134.6967	136.03	80515800.0
2020-11-16	TLT	Stock	157.73	158.28	157.61	157.78	6310397.0
2020-11-16	ES	Stock	94.21	94.54	92.45	94.43	1002800.0
2020-11-16	CL	Stock	85.38	85.94	85.21	85.93	3701500.0
2020-11-16	A	Stock	111.0	111.49	109.47	110.27	1656100.0
2020-11-16	AA	Stock	17.21	17.66	16.76	17.66	6564800.0
2020-11-16	AACG	Stock	1.15	1.15	1.11	1.12	17100.0
2020-11-16	AACQ-DELISTED	Stock	9.763	9.79	9.74	9.79	320718.0
2020-11-16	AACQU-DELISTED	Stock	10.18	10.18	10.12	10.16	216494.0
2020-11-16	AACQW-DELISTED	Stock	1.24	1.24	1.15	1.166	28267.0
2020-11-16	AAIC-DELISTED	Stock	2.9	3.0	2.89	2.94	322940.0
2020-11-16	AAIC.C-DELISTED	Stock	19.55	19.75	19.5	19.67	2781.0
2020-11-16	AAL	Stock	12.87	12.96	12.41	12.79	104867800.0
2020-11-16	AAM.A-DELISTED	Stock	26.385	26.54	26.36	26.49	34789.0
2020-11-16	AAM.B-DELISTED	Stock	27.0828	27.41	26.95	27.41	23070.0
2020-11-16	AAMC-DELISTED	Stock	6.7529	7.4647	6.7529	6.7647	12719.0
2020-11-16	AAME	Stock	2.17	2.23	2.02	2.12	17700.0
2020-11-16	AAMI	Stock	18.12	18.28	17.92	18.15	429300.0
2020-11-16	AAOI	Stock	7.64	7.7	7.24	7.51	963600.0
2020-11-16	AAON	Stock	43.8933	45.16	43.3933	44.6533	289350.0
2020-11-16	AAP	Stock	155.5	156.06	150.32	151.06	1306200.0
2020-11-16	AAT	Stock	27.64	28.46	27.25	28.23	417400.0
2020-11-16	AAU-DELISTED	Stock	1.13	1.187	1.1132	1.135	387616.0
2020-11-16	AAUAF-DELISTED	Stock	1.13	1.187	1.1132	1.15	405003.0
2020-11-16	AAWW-DELISTED	Stock	55.47	56.12	54.32	55.16	445995.0
2020-11-16	AAXJ	Stock	85.16	85.67	85.08	85.32	1816507.0
2020-11-16	AAXN-DELISTED	Stock	122.1	122.1	117.695	119.33	393331.0
2020-11-16	AB	Stock	32.16	32.3	31.74	32.01	347500.0
2020-11-16	ABB-DELISTED	Stock	27.15	27.399	27.12	27.26	1258145.0
2020-11-16	ABBNY-DELISTED	Stock	27.15	27.399	27.12	27.27	1501579.0
2020-11-16	ABBV	Stock	99.96	100.54	98.33	98.36	8611300.0
2020-11-16	ABC-DELISTED	Stock	109.08	110.56	107.7701	109.04	822182.0
2020-11-16	ABCB	Stock	34.95	35.49	34.39	35.16	412100.0
2020-11-16	ABCM-DELISTED	Stock	18.42	18.7	18.38	18.5	82362.0
2020-11-16	ABEO	Stock	33.5	34.25	31.75	32.25	86792.0
2020-11-16	ABEV	Stock	2.82	2.87	2.78	2.87	19108900.0
2020-11-16	ABG	Stock	123.31	127.21	120.38	125.4	337400.0
2020-11-16	ABM	Stock	39.46	40.12	38.98	39.67	464600.0
2020-11-16	ABMD-DELISTED	Stock	273.82	275.11	269.29	273.15	140143.0
2020-11-16	ABR	Stock	12.94	13.18	12.76	13.05	2099600.0
2020-11-16	ABR.A-DELISTED	Stock	25.5199	25.52	25.2877	25.3	15818.0
2020-11-16	ABR.C-DELISTED	Stock	25.83	25.87	25.8	25.81	6900.0
2020-11-16	ABST-DELISTED	Stock	10.5	10.5	10.05	10.15	175949.0
2020-11-16	ABT	Stock	112.05	113.75	111.59	113.67	4144900.0

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

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