PREVIEW / stock_daily / 2020-11-06

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-06.parquet
  size:    227 KB
  rows:    6,950
  symbols: 2,459

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-06	AAPL	Stock	118.32	119.2	116.13	118.69	114457900.0
2020-11-06	MSFT	Stock	222.26	224.36	218.03	223.72	25231900.0
2020-11-06	NVDA	Stock	14.1098	14.5888	13.895	14.562	383348000.0
2020-11-06	AMZN	Stock	165.232	166.1	161.6	165.5685	92946000.0
2020-11-06	GOOGL	Stock	87.567	88.4248	86.834	87.9865	28621680.0
2020-11-06	META	Stock	293.95	294.6	288.06	293.41	13891000.0
2020-11-06	TSLA	Stock	145.3667	145.5233	141.4267	143.3167	65118000.0
2020-11-06	TLT	Stock	159.618	159.915	158.94	159.41	12408432.0
2020-11-06	ES	Stock	92.38	94.09	91.63	92.78	1166500.0
2020-11-06	CL	Stock	83.08	83.55	82.45	83.03	3481300.0
2020-11-06	A	Stock	110.76	113.35	110.33	112.54	1036600.0
2020-11-06	AA	Stock	14.3	14.54	14.0	14.44	4255800.0
2020-11-06	AACG	Stock	1.14	1.19	1.13	1.16	57900.0
2020-11-06	AACQ-DELISTED	Stock	9.78	9.78	9.72	9.73	8922.0
2020-11-06	AACQU-DELISTED	Stock	10.06	10.08	10.06	10.07	5400.0
2020-11-06	AACQW-DELISTED	Stock	1.18	1.1801	1.11	1.1677	20011.0
2020-11-06	AAIC-DELISTED	Stock	2.68	2.71	2.63	2.63	234054.0
2020-11-06	AAIC.C-DELISTED	Stock	18.98	19.15	18.58	19.15	7150.0
2020-11-06	AAL	Stock	11.44	11.51	11.28	11.46	36703700.0
2020-11-06	AAM.A-DELISTED	Stock	26.31	26.31	26.1	26.18	10444.0
2020-11-06	AAM.B-DELISTED	Stock	27.0	27.0	26.84	26.9	29247.0
2020-11-06	AAMC-DELISTED	Stock	6.4882	6.7235	6.1412	6.3971	38349.0
2020-11-06	AAME	Stock	2.15	2.15	2.15	2.15	400.0
2020-11-06	AAMI	Stock	15.2	15.23	14.8	14.89	624900.0
2020-11-06	AAOI	Stock	8.114	8.5	7.59	7.69	2623100.0
2020-11-06	AAON	Stock	41.3733	42.46	39.78	42.36	244950.0
2020-11-06	AAP	Stock	156.05	157.54	154.32	156.38	725600.0
2020-11-06	AAT	Stock	21.78	21.93	20.81	20.96	392700.0
2020-11-06	AAU-DELISTED	Stock	1.19	1.24	1.12	1.21	842548.0
2020-11-06	AAUAF-DELISTED	Stock	1.19	1.24	1.12	1.21	931673.0
2020-11-06	AAWW-DELISTED	Stock	63.55	63.99	59.63	60.6	376489.0
2020-11-06	AAXJ	Stock	83.53	84.09	83.1601	83.81	1856670.0
2020-11-06	AAXN-DELISTED	Stock	116.01	127.49	116.0	122.61	1420983.0
2020-11-06	AB	Stock	30.75	30.75	30.03	30.13	399000.0
2020-11-06	ABB-DELISTED	Stock	26.64	26.84	26.525	26.75	1225222.0
2020-11-06	ABBNY-DELISTED	Stock	26.64	26.84	26.525	26.75	1307233.0
2020-11-06	ABBV	Stock	92.98	93.65	91.71	92.85	7006900.0
2020-11-06	ABC-DELISTED	Stock	105.26	106.44	103.77	104.01	672995.0
2020-11-06	ABCB	Stock	30.31	30.6	29.37	29.41	384500.0
2020-11-06	ABCM-DELISTED	Stock	19.61	20.61	19.57	20.09	148585.0
2020-11-06	ABEO	Stock	25.75	26.5	25.75	25.75	32704.0
2020-11-06	ABEV	Stock	2.42	2.5	2.41	2.48	23997700.0
2020-11-06	ABG	Stock	115.77	116.99	113.56	114.19	126300.0
2020-11-06	ABM	Stock	37.4	37.45	36.49	36.82	216200.0
2020-11-06	ABMD-DELISTED	Stock	273.21	274.68	264.98	271.97	133724.0
2020-11-06	ABR	Stock	12.98	13.17	12.7	12.93	1362100.0
2020-11-06	ABR.A-DELISTED	Stock	25.88	25.9	25.88	25.9	200.0
2020-11-06	ABR.B-DELISTED	Stock	25.62	25.65	25.577	25.63	1776.0
2020-11-06	ABR.C-DELISTED	Stock	26.07	26.1	25.89	26.03	1100.0
2020-11-06	ABST-DELISTED	Stock	12.1	12.1	11.5836	11.79	16055.0

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

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