PREVIEW / stock_daily / 2020-11-11

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-11.parquet
  size:    230 KB
  rows:    6,984
  symbols: 2,472

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-11	AAPL	Stock	117.19	119.63	116.44	119.49	112295000.0
2020-11-11	MSFT	Stock	212.39	218.04	212.2	216.55	29440800.0
2020-11-11	NVDA	Stock	13.0538	13.435	12.9482	13.418	404744000.0
2020-11-11	AMZN	Stock	153.089	156.9575	152.5	156.8695	87338000.0
2020-11-11	GOOGL	Stock	87.42	88.145	87.153	87.3615	31838120.0
2020-11-11	META	Stock	273.47	278.4	272.48	276.48	14957000.0
2020-11-11	TSLA	Stock	138.8167	139.5667	136.86	139.0433	52073100.0
2020-11-11	TLT	Stock	155.02	155.94	154.97	155.72	5888233.0
2020-11-11	ES	Stock	94.08	95.01	93.4	94.42	1140100.0
2020-11-11	CL	Stock	84.0	85.25	83.44	84.93	3896900.0
2020-11-11	A	Stock	111.14	111.79	108.84	109.41	1792800.0
2020-11-11	AA	Stock	16.21	16.34	15.685	15.89	5780600.0
2020-11-11	AACG	Stock	1.14	1.16	1.14	1.14	20400.0
2020-11-11	AACQ-DELISTED	Stock	9.7	9.75	9.7	9.74	1900.0
2020-11-11	AACQU-DELISTED	Stock	10.08	10.12	10.08	10.12	3084.0
2020-11-11	AACQW-DELISTED	Stock	1.159	1.175	1.15	1.1602	38842.0
2020-11-11	AAIC-DELISTED	Stock	2.91	2.91	2.76	2.8	257808.0
2020-11-11	AAIC.C-DELISTED	Stock	19.219	19.219	19.219	19.219	250.0
2020-11-11	AAL	Stock	12.4	12.46	11.93	12.04	81359600.0
2020-11-11	AAM.A-DELISTED	Stock	26.36	26.44	26.26	26.36	19374.0
2020-11-11	AAM.B-DELISTED	Stock	27.18	27.24	26.91	26.95	19788.0
2020-11-11	AAMC-DELISTED	Stock	6.7647	6.8118	6.3971	6.7	23280.0
2020-11-11	AAME	Stock	2.17	2.2	2.08	2.18	3400.0
2020-11-11	AAMI	Stock	16.86	17.97	16.835	17.37	1646000.0
2020-11-11	AAOI	Stock	7.43	7.75	7.35	7.65	674600.0
2020-11-11	AAON	Stock	43.5467	43.82	41.9133	43.6067	204600.0
2020-11-11	AAP	Stock	156.78	158.8	153.21	156.52	1132700.0
2020-11-11	AAT	Stock	26.72	26.72	25.43	25.86	457700.0
2020-11-11	AAU-DELISTED	Stock	1.06	1.13	1.01	1.12	353727.0
2020-11-11	AAUAF-DELISTED	Stock	1.06	1.13	1.01	1.09	373535.0
2020-11-11	AAWW-DELISTED	Stock	51.38	53.53	51.01	51.61	467449.0
2020-11-11	AAXJ	Stock	83.06	83.83	82.89	83.72	989119.0
2020-11-11	AAXN-DELISTED	Stock	119.42	121.77	117.58	118.3	348147.0
2020-11-11	AB	Stock	31.82	31.9	31.26	31.68	317900.0
2020-11-11	ABB-DELISTED	Stock	27.12	27.135	26.92	27.04	831596.0
2020-11-11	ABBNY-DELISTED	Stock	27.12	27.135	26.92	27.03	904836.0
2020-11-11	ABBV	Stock	99.15	99.87	97.77	98.15	9476500.0
2020-11-11	ABC-DELISTED	Stock	110.41	111.25	107.035	107.33	667618.0
2020-11-11	ABCB	Stock	35.18	35.61	32.9	33.45	312000.0
2020-11-11	ABCM-DELISTED	Stock	18.84	18.98	18.53	18.59	204901.0
2020-11-11	ABEO	Stock	31.0	33.0	30.5	32.5	212312.0
2020-11-11	ABEV	Stock	2.78	2.83	2.76	2.79	28664200.0
2020-11-11	ABG	Stock	127.29	127.29	120.37	122.57	148400.0
2020-11-11	ABM	Stock	41.06	41.06	38.43	39.0	344500.0
2020-11-11	ABMD-DELISTED	Stock	272.08	273.15	268.1246	269.36	122447.0
2020-11-11	ABR	Stock	13.54	13.75	13.09	13.34	6215900.0
2020-11-11	ABR.A-DELISTED	Stock	25.89	26.09	25.89	26.0	600.0
2020-11-11	ABR.B-DELISTED	Stock	25.79	25.82	25.79	25.79	2939.0
2020-11-11	ABR.C-DELISTED	Stock	26.44	26.66	26.06	26.12	9845.0
2020-11-11	ABST-DELISTED	Stock	10.58	11.07	10.5	10.82	63329.0

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

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