PREVIEW / stock_daily / 2022-11-21

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-21.parquet
  size:    251 KB
  rows:    7,821
  symbols: 2,074

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-11-21	AAPL	Stock	150.16	150.37	147.72	148.01	58724100.0
2022-11-21	MSFT	Stock	241.43	244.67	241.19	242.05	26394700.0
2022-11-21	NVDA	Stock	15.147	15.477	15.08	15.317	404739000.0
2022-11-21	AMZN	Stock	93.97	95.02	90.59	92.46	84330300.0
2022-11-21	GOOGL	Stock	97.29	98.4	95.355	95.6	21647387.0
2022-11-21	META	Stock	111.52	112.37	109.19	109.86	24351100.0
2022-11-21	TSLA	Stock	175.85	176.77	167.54	167.87	92882700.0
2022-11-21	TLT	Stock	100.69	100.815	99.8	100.06	15534009.0
2022-11-21	ES	Stock	79.86	80.68	79.86	80.4	1126200.0
2022-11-21	CL	Stock	76.7	77.29	76.34	76.92	4228200.0
2022-11-21	A	Stock	145.62	147.16	144.43	145.14	1691900.0
2022-11-21	AA	Stock	46.13	46.89	44.51	46.63	5378100.0
2022-11-21	AAC-DELISTED	Stock	10.0	10.0	9.99	10.0	3175.0
2022-11-21	AACG	Stock	1.72	1.78	1.68	1.7	3700.0
2022-11-21	AACIW-DELISTED	Stock	0.04	0.04	0.03	0.03	9533.0
2022-11-21	AAIC-DELISTED	Stock	3.0	3.1	3.0	3.02	19226.0
2022-11-21	AAIC.C-DELISTED	Stock	21.7	21.7	21.7	21.7	1200.0
2022-11-21	AAL	Stock	14.02	14.27	13.8	13.85	25708400.0
2022-11-21	AAM.A-DELISTED	Stock	24.61	24.65	24.4511	24.59	4707.0
2022-11-21	AAM.B-DELISTED	Stock	24.61	24.7	24.12	24.52	14503.0
2022-11-21	AAMC-DELISTED	Stock	5.5588	5.5882	5.5	5.5147	5685.0
2022-11-21	AAME	Stock	2.89	2.92	2.86	2.86	9300.0
2022-11-21	AAMI	Stock	19.31	19.63	19.27	19.55	127200.0
2022-11-21	AAN-DELISTED	Stock	10.96	11.2	10.85	11.04	507700.0
2022-11-21	AAOI	Stock	2.12	2.28	2.09	2.25	260000.0
2022-11-21	AAON	Stock	52.6467	53.56	52.5733	53.28	144450.0
2022-11-21	AAP	Stock	147.61	150.01	146.37	148.24	1564800.0
2022-11-21	AAQC-DELISTED	Stock	10.045	10.045	10.02	10.02	9865.0
2022-11-21	AAT	Stock	28.82	28.9	28.1	28.34	235200.0
2022-11-21	AATC	Stock	4.74	4.95	4.68	4.89	49831.0
2022-11-21	AAU-DELISTED	Stock	0.24	0.2499	0.2322	0.2372	157533.0
2022-11-21	AAUAF-DELISTED	Stock	0.24	0.2499	0.2322	0.2362	160462.0
2022-11-21	AAWW-DELISTED	Stock	100.32	100.965	100.3	100.76	157296.0
2022-11-21	AAXJ	Stock	62.92	63.02	62.58	62.74	377015.0
2022-11-21	AB	Stock	39.3	40.09	39.16	40.0	314000.0
2022-11-21	ABB-DELISTED	Stock	30.58	30.8195	30.51	30.68	1357188.0
2022-11-21	ABBNY-DELISTED	Stock	30.58	30.8195	30.51	30.68	1593970.0
2022-11-21	ABBV	Stock	155.4	158.63	154.43	157.11	6492100.0
2022-11-21	ABC-DELISTED	Stock	162.0	163.165	159.82	160.32	892713.0
2022-11-21	ABCB	Stock	51.87	52.5	51.58	52.36	228100.0
2022-11-21	ABCL	Stock	13.97	14.175	13.741	14.06	1351600.0
2022-11-21	ABCM-DELISTED	Stock	16.34	16.34	16.0525	16.19	131428.0
2022-11-21	ABEO	Stock	4.2	4.26	3.99	4.12	227400.0
2022-11-21	ABEV	Stock	2.9	2.95	2.86	2.92	19433700.0
2022-11-21	ABG	Stock	177.51	181.47	176.76	179.49	196200.0
2022-11-21	ABGI-DELISTED	Stock	10.0	10.0	10.0	10.0	212860.0
2022-11-21	ABM	Stock	45.15	46.3	45.15	45.89	174500.0
2022-11-21	ABMD-DELISTED	Stock	377.05	378.0	376.05	376.64	685249.0
2022-11-21	ABNB	Stock	97.01	97.85	93.92	95.71	5145700.0
2022-11-21	ABOS	Stock	6.11	6.39	6.051	6.35	79100.0

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

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