PREVIEW / stock_daily / 2021-01-22

all stock daily files

  file:    by_date/stock_daily/2021/2021-01-22.parquet
  size:    243 KB
  rows:    7,349
  symbols: 2,679

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-22	AAPL	Stock	136.28	139.85	135.02	139.07	114459400.0
2021-01-22	MSFT	Stock	227.08	230.07	225.8	225.95	30172700.0
2021-01-22	NVDA	Stock	13.74	13.8418	13.6273	13.7125	246820000.0
2021-01-22	AMZN	Stock	165.2155	166.0955	164.158	164.6115	56438000.0
2021-01-22	GOOGL	Stock	94.573	95.2195	93.8248	94.628	32743900.0
2021-01-22	META	Stock	272.01	278.47	272.0	274.5	21954000.0
2021-01-22	TSLA	Stock	278.1033	282.6667	276.2067	282.2133	60199500.0
2021-01-22	TLT	Stock	151.85	152.01	151.42	151.88	9507150.0
2021-01-22	ES	Stock	86.55	88.01	86.12	87.41	1221000.0
2021-01-22	CL	Stock	78.78	78.92	77.9	78.19	4816300.0
2021-01-22	A	Stock	127.08	127.8	126.3	126.33	1438700.0
2021-01-22	AA	Stock	19.4	20.04	19.17	19.4	11183400.0
2021-01-22	AACG	Stock	1.48	1.49	1.3	1.35	80800.0
2021-01-22	AACQ-DELISTED	Stock	10.86	11.16	10.86	11.01	1026387.0
2021-01-22	AACQU-DELISTED	Stock	11.75	12.0	11.75	11.87	110345.0
2021-01-22	AACQW-DELISTED	Stock	2.57	2.67	2.5	2.56	406707.0
2021-01-22	AAIC-DELISTED	Stock	3.82	3.85	3.8	3.84	116295.0
2021-01-22	AAIC.C-DELISTED	Stock	21.5	21.5	21.49	21.5	909.0
2021-01-22	AAL	Stock	15.57	15.84	15.46	15.82	39126600.0
2021-01-22	AAM.A-DELISTED	Stock	26.41	26.5	26.4	26.5	4594.0
2021-01-22	AAM.B-DELISTED	Stock	26.87	26.9402	26.85	26.85	13271.0
2021-01-22	AAMC-DELISTED	Stock	6.1647	6.4353	6.1647	6.3206	9561.0
2021-01-22	AAME	Stock	2.45	2.46	2.36	2.4	8400.0
2021-01-22	AAMI	Stock	20.56	20.87	20.18	20.8	256600.0
2021-01-22	AAN-DELISTED	Stock	19.93	20.7	19.52	20.7	299300.0
2021-01-22	AAOI	Stock	10.35	10.54	10.155	10.47	489600.0
2021-01-22	AAON	Stock	47.5067	48.7533	47.2867	48.4933	244050.0
2021-01-22	AAP	Stock	165.59	166.45	163.15	163.76	660100.0
2021-01-22	AAT	Stock	28.65	29.04	28.2	28.98	149500.0
2021-01-22	AAU-DELISTED	Stock	0.62	0.624	0.5799	0.58	2495300.0
2021-01-22	AAUAF-DELISTED	Stock	0.62	0.624	0.5799	0.58	2563790.0
2021-01-22	AAWW-DELISTED	Stock	52.36	53.7	51.01	53.53	208349.0
2021-01-22	AAXJ	Stock	97.55	98.36	97.448	98.14	607514.0
2021-01-22	AAXN-DELISTED	Stock	161.08	171.73	160.85	170.34	483866.0
2021-01-22	AB	Stock	35.42	36.14	35.4	36.03	288700.0
2021-01-22	ABB-DELISTED	Stock	30.2	30.49	30.04	30.43	1457013.0
2021-01-22	ABBNY-DELISTED	Stock	30.2	30.49	30.04	30.43	1725833.0
2021-01-22	ABBV	Stock	110.65	111.6	109.48	110.86	5185500.0
2021-01-22	ABC-DELISTED	Stock	104.66	108.72	104.66	107.75	1295278.0
2021-01-22	ABCB	Stock	42.62	44.46	42.18	44.32	400600.0
2021-01-22	ABCL	Stock	50.04	51.358	49.08	50.5	694500.0
2021-01-22	ABCM-DELISTED	Stock	23.17	23.9	22.49	23.59	66248.0
2021-01-22	ABEO	Stock	49.25	53.0	48.0	53.0	93488.0
2021-01-22	ABEV	Stock	2.87	2.9	2.75	2.8	34246800.0
2021-01-22	ABG	Stock	164.68	166.88	160.33	162.45	171200.0
2021-01-22	ABM	Stock	38.56	39.73	38.31	39.69	307300.0
2021-01-22	ABMD-DELISTED	Stock	347.91	349.4	345.015	347.32	108813.0
2021-01-22	ABNB	Stock	178.09	185.307	175.19	181.87	7136800.0
2021-01-22	ABR	Stock	14.55	14.69	14.41	14.63	1465600.0
2021-01-22	ABR.A-DELISTED	Stock	25.77	25.87	25.767	25.86	2054.0

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

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