PREVIEW / stock_daily / 2023-04-20

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-20.parquet
  size:    243 KB
  rows:    7,529
  symbols: 1,682

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
2023-04-20	AAPL	Stock	166.09	167.87	165.56	166.65	52456400.0
2023-04-20	MSFT	Stock	285.25	289.03	285.08	286.11	23244400.0
2023-04-20	NVDA	Stock	27.671	28.03	27.0	27.104	427713000.0
2023-04-20	AMZN	Stock	103.53	105.25	103.21	103.81	57696900.0
2023-04-20	GOOGL	Stock	103.91	106.25	103.8684	105.29	27820794.0
2023-04-20	META	Stock	213.48	216.75	212.77	213.07	16475400.0
2023-04-20	TSLA	Stock	166.17	169.7	160.56	162.99	210970800.0
2023-04-20	TLT	Stock	104.83	105.28	104.753	104.99	16450090.0
2023-04-20	ES	Stock	79.11	79.14	78.22	78.61	1276800.0
2023-04-20	CL	Stock	75.35	76.46	75.23	76.36	7763200.0
2023-04-20	A	Stock	136.86	137.05	134.87	135.53	1325900.0
2023-04-20	AA	Stock	40.0	42.23	39.62	40.23	9331200.0
2023-04-20	AAC-DELISTED	Stock	10.36	10.38	10.35	10.36	14532.0
2023-04-20	AACG	Stock	1.9	1.95	1.9	1.92	1500.0
2023-04-20	AACIW-DELISTED	Stock	0.1009	0.1009	0.1009	0.1009	133.0
2023-04-20	AAIC-DELISTED	Stock	2.63	2.66	2.61	2.61	17996.0
2023-04-20	AAIC.C-DELISTED	Stock	21.2384	21.2384	21.2384	21.2384	100.0
2023-04-20	AAL	Stock	13.47	13.7	13.31	13.32	24240100.0
2023-04-20	AAM.A-DELISTED	Stock	23.82	24.0399	23.61	23.85	7341.0
2023-04-20	AAM.B-DELISTED	Stock	24.3	24.5	23.74	24.38	6138.0
2023-04-20	AAMC-DELISTED	Stock	25.2956	26.35	24.1603	24.4059	58963.0
2023-04-20	AAME	Stock	2.33	2.35	2.32	2.34	5200.0
2023-04-20	AAMI	Stock	23.6	23.8	23.46	23.76	82300.0
2023-04-20	AAN-DELISTED	Stock	10.25	10.44	10.2	10.32	316400.0
2023-04-20	AAOI	Stock	2.18	2.3	2.12	2.12	129300.0
2023-04-20	AAON	Stock	65.3067	66.6333	65.0933	66.1733	603900.0
2023-04-20	AAP	Stock	127.83	129.22	127.5	128.37	1139600.0
2023-04-20	AAT	Stock	18.19	18.38	18.09	18.18	422100.0
2023-04-20	AATC	Stock	4.11	4.11	4.05	4.05	8496.0
2023-04-20	AAU-DELISTED	Stock	0.15	0.168	0.15	0.1602	206628.0
2023-04-20	AAUAF-DELISTED	Stock	0.15	0.168	0.15	0.158	209758.0
2023-04-20	AAXJ	Stock	67.41	67.85	67.19	67.37	696672.0
2023-04-20	AB	Stock	35.35	36.97	35.35	36.35	286400.0
2023-04-20	ABB-DELISTED	Stock	35.09	35.31	35.08	35.21	962711.0
2023-04-20	ABBNY-DELISTED	Stock	35.09	35.31	35.08	35.21	1096292.0
2023-04-20	ABBV	Stock	161.18	161.77	160.58	161.74	3808100.0
2023-04-20	ABC-DELISTED	Stock	164.36	166.07	163.98	165.94	842321.0
2023-04-20	ABCB	Stock	34.55	34.71	34.03	34.58	283800.0
2023-04-20	ABCL	Stock	7.1	7.23	7.06	7.12	1195200.0
2023-04-20	ABCM-DELISTED	Stock	15.74	15.78	15.29	15.64	412629.0
2023-04-20	ABEO	Stock	3.14	3.14	3.0	3.09	58900.0
2023-04-20	ABEV	Stock	2.86	2.92	2.86	2.88	10228200.0
2023-04-20	ABG	Stock	203.6	207.33	201.36	204.88	224500.0
2023-04-20	ABM	Stock	42.77	42.89	42.38	42.71	247800.0
2023-04-20	ABNB	Stock	118.37	119.7	117.82	118.4	4369700.0
2023-04-20	ABOS	Stock	3.98	4.0	3.925	4.0	19200.0
2023-04-20	ABR	Stock	10.9	10.95	10.73	10.93	3501200.0
2023-04-20	ABR.D	Stock	17.6354	17.6399	17.3301	17.49	3053.0
2023-04-20	ABR.E	Stock	16.895	16.97	16.8101	16.9	4382.0
2023-04-20	ABR.F	Stock	17.74	17.74	17.5	17.61	15003.0

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

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