PREVIEW / stock_daily / 2021-01-08

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-08.parquet
  size:    242 KB
  rows:    7,297
  symbols: 2,649

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-01-08	AAPL	Stock	132.43	132.63	130.23	132.05	105158200.0
2021-01-08	MSFT	Stock	218.68	220.58	217.03	219.62	22956200.0
2021-01-08	NVDA	Stock	13.3625	13.421	13.042	13.2768	292528000.0
2021-01-08	AMZN	Stock	159.0	159.532	157.11	159.135	70754000.0
2021-01-08	GOOGL	Stock	88.858	89.9678	88.061	89.8915	35484520.0
2021-01-08	META	Stock	268.31	268.95	263.18	267.57	18528300.0
2021-01-08	TSLA	Stock	285.3333	294.83	279.4633	293.34	225166500.0
2021-01-08	TLT	Stock	151.48	151.96	150.66	151.32	13622819.0
2021-01-08	ES	Stock	88.53	90.46	88.42	90.33	1621400.0
2021-01-08	CL	Stock	82.09	82.61	81.82	82.35	5569300.0
2021-01-08	A	Stock	126.49	127.64	125.85	127.06	1577200.0
2021-01-08	AA	Stock	25.3	25.47	24.52	24.99	2967700.0
2021-01-08	AACG	Stock	1.27	1.28	1.22	1.24	18600.0
2021-01-08	AACQ-DELISTED	Stock	10.54	10.58	10.45	10.5299	739032.0
2021-01-08	AACQU-DELISTED	Stock	11.17	11.23	11.1399	11.185	9283.0
2021-01-08	AACQW-DELISTED	Stock	2.01	2.0616	1.96	1.98	276230.0
2021-01-08	AAIC-DELISTED	Stock	4.05	4.0566	3.92	3.97	199399.0
2021-01-08	AAIC.C-DELISTED	Stock	21.36	21.36	21.17	21.2	670.0
2021-01-08	AAL	Stock	15.43	15.53	15.0	15.13	55656400.0
2021-01-08	AAM.A-DELISTED	Stock	26.45	26.51	26.27	26.51	6436.0
2021-01-08	AAM.B-DELISTED	Stock	27.05	27.05	26.821	26.92	5058.0
2021-01-08	AAMC-DELISTED	Stock	6.8324	6.8324	6.5853	6.5853	2237.0
2021-01-08	AAME	Stock	2.36	2.45	2.31	2.41	27300.0
2021-01-08	AAMI	Stock	19.9	20.17	19.33	19.94	718600.0
2021-01-08	AAN-DELISTED	Stock	21.75	21.75	20.09	20.19	487900.0
2021-01-08	AAOI	Stock	10.11	10.42	9.93	10.19	1473400.0
2021-01-08	AAON	Stock	46.9733	47.3	45.68	46.2067	377100.0
2021-01-08	AAP	Stock	168.31	171.07	168.1	170.06	864500.0
2021-01-08	AAT	Stock	28.26	28.3	27.93	28.22	202600.0
2021-01-08	AAU-DELISTED	Stock	0.5394	0.5394	0.4859	0.5071	2298604.0
2021-01-08	AAUAF-DELISTED	Stock	0.5394	0.5394	0.4859	0.5087	2346211.0
2021-01-08	AAWW-DELISTED	Stock	51.51	51.99	50.2659	50.78	501280.0
2021-01-08	AAXJ	Stock	94.27	95.14	93.841	95.14	1811364.0
2021-01-08	AAXN-DELISTED	Stock	124.89	128.28	123.6	125.49	326967.0
2021-01-08	AB	Stock	35.19	35.31	34.63	34.89	405600.0
2021-01-08	ABB-DELISTED	Stock	30.29	30.44	29.9572	30.27	2680636.0
2021-01-08	ABBNY-DELISTED	Stock	30.29	30.44	29.9572	30.26	3318116.0
2021-01-08	ABBV	Stock	106.84	107.53	105.76	107.27	5345900.0
2021-01-08	ABC-DELISTED	Stock	110.07	112.48	109.54	109.96	1435622.0
2021-01-08	ABCB	Stock	43.4	43.4	41.92	42.75	512400.0
2021-01-08	ABCL	Stock	39.32	42.48	38.78	39.72	1076600.0
2021-01-08	ABCM-DELISTED	Stock	19.57	20.29	19.5482	19.63	111960.0
2021-01-08	ABEO	Stock	45.0	45.0	42.75	44.0	42516.0
2021-01-08	ABEV	Stock	3.07	3.13	3.03	3.07	27721400.0
2021-01-08	ABG	Stock	163.08	165.76	158.52	161.81	108600.0
2021-01-08	ABM	Stock	41.07	41.09	40.14	40.75	287300.0
2021-01-08	ABMD-DELISTED	Stock	325.04	330.8	320.465	324.0	190305.0
2021-01-08	ABNB	Stock	153.45	155.54	147.25	149.77	4615600.0
2021-01-08	ABR	Stock	14.41	14.41	13.75	14.21	1767300.0
2021-01-08	ABR.A-DELISTED	Stock	25.54	25.57	25.54	25.57	1090.0

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

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