PREVIEW / stock_daily / 2023-04-12

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-12.parquet
  size:    245 KB
  rows:    7,632
  symbols: 1,753

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-12	AAPL	Stock	161.22	162.06	159.78	160.1	50133100.0
2023-04-12	MSFT	Stock	284.79	287.01	281.96	283.49	27403400.0
2023-04-12	NVDA	Stock	27.37	27.468	26.448	26.495	446259000.0
2023-04-12	AMZN	Stock	100.4	100.51	97.71	97.83	56735000.0
2023-04-12	GOOGL	Stock	106.58	106.75	104.34	104.64	24370274.0
2023-04-12	META	Stock	214.84	216.84	212.58	214.0	18972200.0
2023-04-12	TSLA	Stock	190.74	191.58	180.31	180.54	150256300.0
2023-04-12	TLT	Stock	107.05	107.165	105.88	106.89	20563001.0
2023-04-12	ES	Stock	80.41	80.48	79.49	79.77	1868300.0
2023-04-12	CL	Stock	76.02	76.6	75.62	76.05	4438400.0
2023-04-12	A	Stock	140.19	141.35	137.82	138.36	1058400.0
2023-04-12	AA	Stock	41.18	41.25	39.375	39.64	5256000.0
2023-04-12	AAC-DELISTED	Stock	10.36	10.36	10.33	10.35	358388.0
2023-04-12	AACG	Stock	1.97	1.98	1.88	1.88	13000.0
2023-04-12	AACIW-DELISTED	Stock	0.1069	0.1069	0.0988	0.0998	7302.0
2023-04-12	AAIC-DELISTED	Stock	2.72	2.72	2.66	2.66	22747.0
2023-04-12	AAIC.C-DELISTED	Stock	21.59	21.59	21.0701	21.335	650.0
2023-04-12	AAL	Stock	13.85	13.85	12.91	13.0	96958800.0
2023-04-12	AAM.A-DELISTED	Stock	23.49	23.49	23.07	23.4	13533.0
2023-04-12	AAM.B-DELISTED	Stock	23.27	23.9799	23.15	23.27	23429.0
2023-04-12	AAMC-DELISTED	Stock	20.6324	20.6324	20.0059	20.0882	10591.0
2023-04-12	AAME	Stock	2.44	2.49	2.43	2.45	9600.0
2023-04-12	AAMI	Stock	23.25	23.51	23.12	23.28	89400.0
2023-04-12	AAN-DELISTED	Stock	10.86	10.935	10.45	10.47	317400.0
2023-04-12	AAOI	Stock	2.25	2.35	2.25	2.3	105400.0
2023-04-12	AAON	Stock	63.4	64.6	63.18	64.3267	320700.0
2023-04-12	AAP	Stock	123.1	123.38	120.24	121.34	1056300.0
2023-04-12	AAT	Stock	18.37	18.37	17.59	17.69	542500.0
2023-04-12	AATC	Stock	3.97	3.97	3.9	3.9105	2029.0
2023-04-12	AAU-DELISTED	Stock	0.194	0.1968	0.187	0.188	178914.0
2023-04-12	AAUAF-DELISTED	Stock	0.194	0.1968	0.187	0.188	181158.0
2023-04-12	AAXJ	Stock	68.3	68.3	67.25	67.36	457571.0
2023-04-12	AB	Stock	35.77	35.98	34.14	34.2	265500.0
2023-04-12	ABB-DELISTED	Stock	34.36	34.69	34.265	34.45	1581033.0
2023-04-12	ABBNY-DELISTED	Stock	34.36	34.69	34.265	34.45	1773195.0
2023-04-12	ABBV	Stock	162.12	163.48	161.6	162.36	4005000.0
2023-04-12	ABC-DELISTED	Stock	166.0	166.65	164.39	165.44	513889.0
2023-04-12	ABCB	Stock	34.55	34.76	33.31	33.5	352100.0
2023-04-12	ABCL	Stock	7.345	7.46	7.205	7.29	1184200.0
2023-04-12	ABCM-DELISTED	Stock	13.25	13.57	12.975	13.53	530725.0
2023-04-12	ABEO	Stock	3.03	3.03	2.88	2.91	57500.0
2023-04-12	ABEV	Stock	2.95	3.0	2.95	2.97	19120900.0
2023-04-12	ABG	Stock	207.83	207.95	200.21	203.77	184800.0
2023-04-12	ABM	Stock	44.27	44.34	43.51	43.69	322200.0
2023-04-12	ABNB	Stock	114.8	115.84	111.4	112.42	6068700.0
2023-04-12	ABOS	Stock	3.79	3.99	3.7	3.85	72200.0
2023-04-12	ABR	Stock	10.83	10.85	10.54	10.62	4772000.0
2023-04-12	ABR.D	Stock	18.29	18.8	18.28	18.52	27139.0
2023-04-12	ABR.E	Stock	18.04	18.1499	17.65	17.95	7279.0
2023-04-12	ABR.F	Stock	18.15	18.47	18.12	18.34	24041.0

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

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