PREVIEW / stock_daily / 2021-04-22

all stock daily files

  file:    by_date/stock_daily/2021/2021-04-22.parquet
  size:    254 KB
  rows:    7,756
  symbols: 2,926

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
2021-04-22	AAPL	Stock	133.04	134.15	131.41	131.94	84566500.0
2021-04-22	MSFT	Stock	260.21	261.78	255.64	257.17	25606200.0
2021-04-22	NVDA	Stock	15.375	15.4385	14.7835	14.8502	277788000.0
2021-04-22	AMZN	Stock	168.584	168.6435	165.0725	165.452	51612000.0
2021-04-22	GOOGL	Stock	113.77	114.4441	112.016	112.626	24145520.0
2021-04-22	META	Stock	301.33	302.92	296.04	296.52	16375400.0
2021-04-22	TSLA	Stock	247.1667	251.2567	239.3467	239.8967	106770900.0
2021-04-22	TLT	Stock	140.0	140.39	139.2	140.39	14156678.0
2021-04-22	ES	Stock	89.32	89.39	88.09	88.22	1711400.0
2021-04-22	CL	Stock	80.93	81.63	80.72	81.05	4036400.0
2021-04-22	A	Stock	134.03	135.46	133.83	134.53	1732700.0
2021-04-22	AA	Stock	34.2	34.33	33.16	33.21	5436600.0
2021-04-22	AAC-DELISTED	Stock	9.78	9.82	9.78	9.8	65003.0
2021-04-22	AACG	Stock	2.76	2.95	2.72	2.75	58500.0
2021-04-22	AACQ-DELISTED	Stock	10.05	10.05	9.955	10.0	633949.0
2021-04-22	AACQU-DELISTED	Stock	10.5	10.5	10.42	10.5	5817.0
2021-04-22	AACQW-DELISTED	Stock	1.56	1.7008	1.5	1.56	222750.0
2021-04-22	AAIC-DELISTED	Stock	4.07	4.07	3.99	4.05	171570.0
2021-04-22	AAIC.C-DELISTED	Stock	23.8899	23.8899	23.8899	23.8899	100.0
2021-04-22	AAL	Stock	21.58	21.61	20.04	20.07	72635100.0
2021-04-22	AAM.A-DELISTED	Stock	26.1	26.1	26.02	26.07	27005.0
2021-04-22	AAM.B-DELISTED	Stock	26.95	26.97	26.9	26.9	20709.0
2021-04-22	AAMC-DELISTED	Stock	5.2765	5.4353	5.2529	5.2529	26255.0
2021-04-22	AAME	Stock	3.88	4.18	3.81	4.16	554600.0
2021-04-22	AAMI	Stock	23.08	23.23	22.8	22.97	571600.0
2021-04-22	AAN-DELISTED	Stock	25.08	25.62	24.27	24.29	287100.0
2021-04-22	AAOI	Stock	7.9	8.09	7.81	8.01	427600.0
2021-04-22	AAON	Stock	46.3667	46.68	46.0867	46.4533	156000.0
2021-04-22	AAP	Stock	199.0	201.12	197.15	200.3	983100.0
2021-04-22	AAT	Stock	33.93	34.17	33.71	33.73	194600.0
2021-04-22	AAU-DELISTED	Stock	0.5	0.5975	0.4911	0.551	10229790.0
2021-04-22	AAUAF-DELISTED	Stock	0.5	0.5975	0.4911	0.5581	10345928.0
2021-04-22	AAWW-DELISTED	Stock	66.49	66.98	65.5001	66.05	407725.0
2021-04-22	AAXJ	Stock	93.8347	93.8495	92.945	93.26	663949.0
2021-04-22	AB	Stock	40.7	41.63	40.61	41.53	369300.0
2021-04-22	ABB-DELISTED	Stock	32.54	32.56	32.245	32.32	1571413.0
2021-04-22	ABBNY-DELISTED	Stock	32.54	32.56	32.245	32.32	1821909.0
2021-04-22	ABBV	Stock	110.65	111.09	109.61	110.05	5046000.0
2021-04-22	ABC-DELISTED	Stock	121.48	121.48	119.845	120.81	483763.0
2021-04-22	ABCB	Stock	49.34	49.95	48.63	48.69	389300.0
2021-04-22	ABCL	Stock	29.5	29.98	28.26	29.23	439000.0
2021-04-22	ABCM-DELISTED	Stock	20.19	20.4844	20.08	20.38	42522.0
2021-04-22	ABEO	Stock	38.75	43.5	38.0	42.0	89000.0
2021-04-22	ABEV	Stock	2.93	2.96	2.89	2.95	22852200.0
2021-04-22	ABG	Stock	208.21	210.69	203.87	205.98	149300.0
2021-04-22	ABGI-DELISTED	Stock	9.91	9.95	9.91	9.95	7913.0
2021-04-22	ABM	Stock	52.53	53.82	52.3	52.98	471700.0
2021-04-22	ABMD-DELISTED	Stock	340.89	345.947	339.18	343.12	87852.0
2021-04-22	ABNB	Stock	168.49	176.92	168.43	170.71	3856500.0
2021-04-22	ABR	Stock	16.52	16.82	16.35	16.63	1161200.0

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

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