PREVIEW / stock_daily / 2020-11-10

all stock daily files

  file:    by_date/stock_daily/2020/2020-11-10.parquet
  size:    231 KB
  rows:    7,003
  symbols: 2,484

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-10	AAPL	Stock	115.55	117.59	114.13	115.97	138023400.0
2020-11-10	MSFT	Stock	214.5	216.5	209.72	211.01	44045100.0
2020-11-10	NVDA	Stock	13.6065	13.6065	12.6283	12.77	644068000.0
2020-11-10	AMZN	Stock	154.751	155.7	150.974	151.751	131820000.0
2020-11-10	GOOGL	Stock	86.4885	87.969	85.806	86.886	43021160.0
2020-11-10	META	Stock	273.1	274.0	264.0	272.43	29067700.0
2020-11-10	TSLA	Stock	140.03	140.03	132.01	136.7867	90852600.0
2020-11-10	TLT	Stock	154.96	155.81	154.78	155.16	12560977.0
2020-11-10	ES	Stock	94.19	94.44	92.8	93.66	1739800.0
2020-11-10	CL	Stock	81.89	83.76	81.39	83.35	4494500.0
2020-11-10	A	Stock	112.82	112.91	108.99	110.2	2124800.0
2020-11-10	AA	Stock	15.89	16.16	15.51	15.99	4843500.0
2020-11-10	AACG	Stock	1.15	1.16	1.13	1.15	25400.0
2020-11-10	AACQ-DELISTED	Stock	9.75	9.75	9.72	9.75	21571.0
2020-11-10	AACQU-DELISTED	Stock	10.09	10.12	10.075	10.12	15410.0
2020-11-10	AACQW-DELISTED	Stock	1.21	1.21	1.1	1.19	12295.0
2020-11-10	AAIC-DELISTED	Stock	2.81	2.94	2.75	2.915	237927.0
2020-11-10	AAIC.C-DELISTED	Stock	19.157	19.3145	18.7	19.0	4578.0
2020-11-10	AAL	Stock	12.85	13.02	12.34	12.38	127529300.0
2020-11-10	AAM.A-DELISTED	Stock	26.39	26.45	26.3	26.3	17835.0
2020-11-10	AAM.B-DELISTED	Stock	27.06	27.3178	27.06	27.1	13458.0
2020-11-10	AAMC-DELISTED	Stock	6.4706	6.6912	6.4559	6.4706	16884.0
2020-11-10	AAME	Stock	2.09	2.29	2.05	2.2	13800.0
2020-11-10	AAMI	Stock	16.26	16.41	15.99	16.23	392900.0
2020-11-10	AAOI	Stock	7.7	7.735	7.2	7.4	1074000.0
2020-11-10	AAON	Stock	42.5067	44.7533	41.42	43.7133	473850.0
2020-11-10	AAP	Stock	153.25	158.86	150.7	155.42	1716600.0
2020-11-10	AAT	Stock	25.34	26.94	25.2	26.79	623600.0
2020-11-10	AAU-DELISTED	Stock	1.15	1.19	1.07	1.08	428711.0
2020-11-10	AAUAF-DELISTED	Stock	1.15	1.19	1.07	1.07	456387.0
2020-11-10	AAWW-DELISTED	Stock	52.41	53.3254	50.25	51.25	635216.0
2020-11-10	AAXJ	Stock	83.85	83.99	82.76	83.2	1832474.0
2020-11-10	AAXN-DELISTED	Stock	123.01	125.175	116.795	119.0	767281.0
2020-11-10	AB	Stock	31.0	32.08	30.98	31.88	373800.0
2020-11-10	ABB-DELISTED	Stock	27.0	27.27	26.93	27.07	1426196.0
2020-11-10	ABBNY-DELISTED	Stock	27.0	27.27	26.93	27.07	1597973.0
2020-11-10	ABBV	Stock	96.01	99.13	95.63	98.87	12267200.0
2020-11-10	ABC-DELISTED	Stock	106.95	111.0134	106.5	110.1	844215.0
2020-11-10	ABCB	Stock	34.46	35.09	33.79	34.98	415800.0
2020-11-10	ABCM-DELISTED	Stock	18.3	19.2	18.02	19.05	484892.0
2020-11-10	ABEO	Stock	26.5	29.5	26.25	28.75	87276.0
2020-11-10	ABEV	Stock	2.69	2.87	2.68	2.86	60455800.0
2020-11-10	ABG	Stock	122.99	129.57	122.75	127.18	292600.0
2020-11-10	ABM	Stock	40.2	41.32	39.84	40.94	541800.0
2020-11-10	ABMD-DELISTED	Stock	277.91	279.54	262.31	269.12	198396.0
2020-11-10	ABR	Stock	13.48	14.39	13.42	14.14	1922600.0
2020-11-10	ABR.A-DELISTED	Stock	26.02	26.15	26.015	26.15	1100.0
2020-11-10	ABR.B-DELISTED	Stock	25.62	25.82	25.58	25.8	2745.0
2020-11-10	ABR.C-DELISTED	Stock	26.3	26.4399	26.25	26.3	8464.0
2020-11-10	ABST-DELISTED	Stock	11.45	11.45	10.1	10.4	197128.0

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

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