PREVIEW / stock_daily / 2023-03-15

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-15.parquet
  size:    244 KB
  rows:    7,581
  symbols: 1,737

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-03-15	AAPL	Stock	151.19	153.25	149.92	152.99	77167900.0
2023-03-15	MSFT	Stock	259.98	266.48	259.21	265.44	46028000.0
2023-03-15	NVDA	Stock	23.761	24.286	23.36	24.228	524486000.0
2023-03-15	AMZN	Stock	93.22	96.67	93.07	96.2	70731800.0
2023-03-15	GOOGL	Stock	93.22	96.93	92.64	96.11	50622050.0
2023-03-15	META	Stock	192.95	197.78	190.84	197.75	42123600.0
2023-03-15	TSLA	Stock	180.8	182.34	176.03	180.45	145995600.0
2023-03-15	TLT	Stock	106.78	107.71	105.345	106.1	45164118.0
2023-03-15	ES	Stock	75.8	77.64	75.15	76.82	2439600.0
2023-03-15	CL	Stock	71.55	73.06	71.55	72.93	5993500.0
2023-03-15	A	Stock	135.93	135.93	132.2	134.03	2016700.0
2023-03-15	AA	Stock	42.33	42.47	38.85	39.77	9434500.0
2023-03-15	AAC-DELISTED	Stock	10.26	10.27	10.26	10.265	9362.0
2023-03-15	AACG	Stock	1.8	1.99	1.8	1.99	24000.0
2023-03-15	AACIW-DELISTED	Stock	0.11	0.11	0.1099	0.1099	2000.0
2023-03-15	AAIC-DELISTED	Stock	2.75	2.84	2.7393	2.78	95337.0
2023-03-15	AAIC.C-DELISTED	Stock	21.9779	21.9779	21.0549	21.95	2600.0
2023-03-15	AAL	Stock	14.24	14.42	13.51	13.86	41843700.0
2023-03-15	AAM.A-DELISTED	Stock	22.15	22.96	21.4	21.4	20185.0
2023-03-15	AAM.B-DELISTED	Stock	22.97	24.0111	21.01	21.85	18508.0
2023-03-15	AAMC-DELISTED	Stock	15.8824	16.0265	15.0324	15.5471	108936.0
2023-03-15	AAME	Stock	2.35	2.5	2.26	2.47	13000.0
2023-03-15	AAMI	Stock	22.34	22.82	22.045	22.54	187600.0
2023-03-15	AAN-DELISTED	Stock	10.25	10.34	9.96	10.2	323700.0
2023-03-15	AAOI	Stock	2.6	2.6	2.4	2.44	222200.0
2023-03-15	AAON	Stock	59.0733	59.8867	58.4667	58.8733	839850.0
2023-03-15	AAP	Stock	119.94	122.75	119.9	121.77	1843500.0
2023-03-15	AAT	Stock	18.48	19.02	18.28	18.82	1274100.0
2023-03-15	AATC	Stock	4.12	4.18	4.12	4.15	3751.0
2023-03-15	AAU-DELISTED	Stock	0.1925	0.1956	0.1812	0.1865	449870.0
2023-03-15	AAUAF-DELISTED	Stock	0.1925	0.1956	0.1812	0.1865	439287.0
2023-03-15	AAWW-DELISTED	Stock	102.41	102.46	102.39	102.45	2239042.0
2023-03-15	AAXJ	Stock	63.85	64.09	63.43	64.05	873214.0
2023-03-15	AB	Stock	35.0	35.31	34.68	35.08	456900.0
2023-03-15	ABB-DELISTED	Stock	32.21	32.33	31.605	31.99	2218807.0
2023-03-15	ABBNY-DELISTED	Stock	32.21	32.33	31.605	31.99	2480347.0
2023-03-15	ABBV	Stock	152.18	154.38	151.73	154.06	6304600.0
2023-03-15	ABC-DELISTED	Stock	148.09	150.08	147.48	149.61	901768.0
2023-03-15	ABCB	Stock	34.77	36.93	34.28	36.79	1360800.0
2023-03-15	ABCL	Stock	7.43	7.47	7.235	7.43	1570000.0
2023-03-15	ABCM-DELISTED	Stock	14.26	14.3008	13.75	14.02	894944.0
2023-03-15	ABEO	Stock	2.6	2.74	2.49	2.62	102100.0
2023-03-15	ABEV	Stock	2.62	2.66	2.61	2.65	12863700.0
2023-03-15	ABG	Stock	194.2	199.42	189.07	199.29	353400.0
2023-03-15	ABM	Stock	43.68	44.5	43.27	44.25	613500.0
2023-03-15	ABNB	Stock	113.86	114.32	111.51	113.58	6305100.0
2023-03-15	ABOS	Stock	4.3	4.46	4.11	4.11	145200.0
2023-03-15	ABR	Stock	11.51	11.61	11.08	11.53	10201300.0
2023-03-15	ABR.D	Stock	16.49	16.96	16.3	16.65	35083.0
2023-03-15	ABR.E	Stock	15.9	16.53	15.9	16.45	138469.0

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

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