PREVIEW / stock_daily / 2023-04-28

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-28.parquet
  size:    243 KB
  rows:    7,544
  symbols: 1,669

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-28	AAPL	Stock	168.49	169.85	167.88	169.68	55209200.0
2023-04-28	MSFT	Stock	304.01	308.93	303.31	307.26	36446700.0
2023-04-28	NVDA	Stock	27.225	27.758	27.071	27.749	292216000.0
2023-04-28	AMZN	Stock	107.73	109.48	104.33	105.45	130565000.0
2023-04-28	GOOGL	Stock	107.04	107.35	105.09	107.34	36139847.0
2023-04-28	META	Stock	239.01	240.43	235.75	240.32	39554000.0
2023-04-28	TSLA	Stock	160.9	165.0	157.32	164.31	122515800.0
2023-04-28	TLT	Stock	106.21	106.76	105.86	106.46	26954077.0
2023-04-28	ES	Stock	77.6	78.33	77.11	77.61	2322000.0
2023-04-28	CL	Stock	79.07	81.49	79.07	79.8	9633400.0
2023-04-28	A	Stock	133.45	136.93	133.45	135.43	2032800.0
2023-04-28	AA	Stock	36.08	37.236	35.775	37.14	3835100.0
2023-04-28	AAC-DELISTED	Stock	10.35	10.38	10.35	10.37	15570.0
2023-04-28	AACG	Stock	1.8	1.83	1.8	1.81	11600.0
2023-04-28	AACIW-DELISTED	Stock	0.1068	0.1068	0.0978	0.0983	700.0
2023-04-28	AAIC-DELISTED	Stock	2.64	2.64	2.58	2.61	35076.0
2023-04-28	AAIC.C-DELISTED	Stock	20.7	21.48	20.7	21.48	1744.0
2023-04-28	AAL	Stock	12.94	13.7	12.85	13.64	45057400.0
2023-04-28	AAM.A-DELISTED	Stock	24.65	24.93	24.44	24.62	57303.0
2023-04-28	AAM.B-DELISTED	Stock	24.59	25.37	24.5	25.36	93548.0
2023-04-28	AAMC-DELISTED	Stock	25.2353	27.5176	24.3971	24.4147	51881.0
2023-04-28	AAME	Stock	2.18	2.18	2.18	2.18	1400.0
2023-04-28	AAMI	Stock	22.27	23.36	22.27	22.58	208100.0
2023-04-28	AAN-DELISTED	Stock	13.35	13.86	13.3	13.35	350700.0
2023-04-28	AAOI	Stock	1.97	1.98	1.88	1.94	107200.0
2023-04-28	AAON	Stock	65.9667	66.68	65.0733	65.3333	483600.0
2023-04-28	AAP	Stock	124.9	126.1	124.29	125.53	675100.0
2023-04-28	AAT	Stock	18.3	18.93	18.04	18.2	409300.0
2023-04-28	AATC	Stock	4.01	4.01	3.9	3.9	16015.0
2023-04-28	AAU-DELISTED	Stock	0.1238	0.1282	0.12	0.1201	307400.0
2023-04-28	AAUAF-DELISTED	Stock	0.1238	0.1282	0.12	0.12	312980.0
2023-04-28	AAXJ	Stock	66.4	66.775	66.36	66.71	401756.0
2023-04-28	AB	Stock	34.99	35.55	34.59	34.96	255200.0
2023-04-28	ABB-DELISTED	Stock	35.84	36.15	35.83	36.095	1777667.0
2023-04-28	ABBNY-DELISTED	Stock	35.84	36.15	35.83	36.09	1933492.0
2023-04-28	ABBV	Stock	147.97	151.39	147.44	151.12	7123800.0
2023-04-28	ABC-DELISTED	Stock	167.09	167.79	165.615	166.86	653867.0
2023-04-28	ABCB	Stock	32.75	33.89	32.49	33.5	1297000.0
2023-04-28	ABCL	Stock	6.65	6.94	6.61	6.78	1237900.0
2023-04-28	ABCM-DELISTED	Stock	16.01	16.5	15.9	16.28	575368.0
2023-04-28	ABEO	Stock	3.13	3.19	3.03	3.07	80600.0
2023-04-28	ABEV	Stock	2.77	2.81	2.77	2.8	17819700.0
2023-04-28	ABG	Stock	191.93	197.27	191.61	193.46	198400.0
2023-04-28	ABM	Stock	41.7	42.62	41.7	42.58	261400.0
2023-04-28	ABNB	Stock	114.6	120.47	113.0	119.67	4974300.0
2023-04-28	ABOS	Stock	3.82	4.035	3.82	3.86	59400.0
2023-04-28	ABR	Stock	10.98	11.48	10.96	11.47	4471500.0
2023-04-28	ABR.D	Stock	17.675	18.1	17.6723	17.92	33775.0
2023-04-28	ABR.E	Stock	17.42	17.95	17.42	17.92	25189.0
2023-04-28	ABR.F	Stock	18.21	18.3	17.96	18.22	43495.0

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

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