PREVIEW / stock_daily / 2022-01-21

all stock daily files

  file:    by_date/stock_daily/2022/2022-01-21.parquet
  size:    265 KB
  rows:    8,162
  symbols: 2,677

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
2022-01-21	AAPL	Stock	164.42	166.33	162.3	162.41	122848900.0
2022-01-21	MSFT	Stock	302.69	304.11	295.61	296.03	57984400.0
2022-01-21	NVDA	Stock	23.507	24.823	23.263	23.374	718958000.0
2022-01-21	AMZN	Stock	149.95	150.9	142.0705	142.643	163972000.0
2022-01-21	GOOGL	Stock	132.5935	134.8655	130.0865	130.3515	55651420.0
2022-01-21	META	Stock	314.81	318.31	303.04	303.17	28710700.0
2022-01-21	TSLA	Stock	332.1133	334.85	313.5	314.6333	103416000.0
2022-01-21	TLT	Stock	143.4	144.1	142.67	143.63	28916580.0
2022-01-21	ES	Stock	87.43	88.46	86.78	87.11	2010000.0
2022-01-21	CL	Stock	83.61	84.7	83.1	83.67	5690900.0
2022-01-21	A	Stock	139.54	140.49	137.49	137.51	1878600.0
2022-01-21	AA	Stock	60.02	60.15	56.04	56.21	11025000.0
2022-01-21	AAC-DELISTED	Stock	9.74	9.74	9.72	9.73	1160837.0
2022-01-21	AACG	Stock	1.81	1.81	1.72	1.75	88200.0
2022-01-21	AACIU	Stock	9.99	9.99	9.99	9.99	420.0
2022-01-21	AACIW-DELISTED	Stock	0.4101	0.4102	0.3439	0.3439	15012.0
2022-01-21	AAIC-DELISTED	Stock	3.49	3.49	3.4	3.41	137645.0
2022-01-21	AAIC.C-DELISTED	Stock	25.1011	25.1011	24.83	25.04	2540.0
2022-01-21	AAL	Stock	16.77	16.78	16.09	16.3	52547500.0
2022-01-21	AAM.A-DELISTED	Stock	25.39	25.49	25.32	25.32	156790.0
2022-01-21	AAM.B-DELISTED	Stock	26.75	26.75	26.239	26.26	169400.0
2022-01-21	AAME	Stock	2.43	2.48	2.28	2.28	17600.0
2022-01-21	AAMI	Stock	22.4	22.54	21.84	21.84	745500.0
2022-01-21	AAN-DELISTED	Stock	21.33	22.24	21.0	21.32	259300.0
2022-01-21	AAOI	Stock	3.96	4.03	3.85	3.86	464800.0
2022-01-21	AAON	Stock	43.4467	45.3933	43.3533	43.7733	313650.0
2022-01-21	AAP	Stock	229.3	230.55	224.94	226.15	660500.0
2022-01-21	AAQC-DELISTED	Stock	9.7178	9.7178	9.71	9.71	8406.0
2022-01-21	AAT	Stock	35.93	36.25	35.52	35.55	258900.0
2022-01-21	AATC	Stock	6.04	6.08	6.0	6.04	12138.0
2022-01-21	AAU-DELISTED	Stock	0.31	0.31	0.2771	0.2851	571192.0
2022-01-21	AAUAF-DELISTED	Stock	0.31	0.31	0.2771	0.285	575782.0
2022-01-21	AAWW-DELISTED	Stock	77.44	79.14	76.6	78.27	492630.0
2022-01-21	AAXJ	Stock	83.69	83.8	82.54	82.6	692433.0
2022-01-21	AB	Stock	49.35	49.43	47.04	47.84	635600.0
2022-01-21	ABB-DELISTED	Stock	36.69	36.89	36.355	36.38	2234625.0
2022-01-21	ABBNY-DELISTED	Stock	36.69	36.89	36.355	36.39	2408738.0
2022-01-21	ABBV	Stock	133.06	134.25	131.67	131.98	7583000.0
2022-01-21	ABC-DELISTED	Stock	133.62	134.11	131.0	131.42	460878.0
2022-01-21	ABCB	Stock	50.63	51.59	49.97	50.29	663000.0
2022-01-21	ABCL	Stock	9.12	9.12	8.51	8.64	2611400.0
2022-01-21	ABCM-DELISTED	Stock	17.36	17.36	16.79	16.84	115927.0
2022-01-21	ABEO	Stock	6.5	6.5	5.75	5.75	133612.0
2022-01-21	ABEV	Stock	2.67	2.75	2.66	2.67	23004500.0
2022-01-21	ABG	Stock	156.95	160.43	153.43	157.25	482300.0
2022-01-21	ABGI-DELISTED	Stock	9.72	9.7202	9.72	9.72	1000.0
2022-01-21	ABM	Stock	41.94	42.8	41.27	41.27	512100.0
2022-01-21	ABMD-DELISTED	Stock	297.93	307.27	297.88	304.57	593872.0
2022-01-21	ABNB	Stock	156.815	160.2	152.41	156.73	7242300.0
2022-01-21	ABOS	Stock	5.2	5.387	4.97	5.18	205500.0

> showing 50 of 8,162 rows — these rows as CSV

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