PREVIEW / stock_daily / 2023-08-29

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-29.parquet
  size:    238 KB
  rows:    7,429
  symbols: 1,457

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-08-29	AAPL	Stock	179.7	184.9	179.5	184.12	53003900.0
2023-08-29	MSFT	Stock	321.88	328.98	321.88	328.41	19284600.0
2023-08-29	NVDA	Stock	46.666	49.081	46.391	48.784	701397000.0
2023-08-29	AMZN	Stock	133.38	135.14	133.25	134.91	38646100.0
2023-08-29	GOOGL	Stock	132.24	136.57	132.24	134.57	43075556.0
2023-08-29	META	Stock	288.58	299.15	288.18	297.99	20844500.0
2023-08-29	TSLA	Stock	238.58	257.48	237.77	257.18	134047600.0
2023-08-29	TLT	Stock	94.97	96.51	94.94	96.31	28478118.0
2023-08-29	ES	Stock	65.25	65.89	65.08	65.33	1090800.0
2023-08-29	CL	Stock	73.51	73.67	72.45	73.47	3566500.0
2023-08-29	A	Stock	120.13	122.29	119.61	122.02	838300.0
2023-08-29	AA	Stock	28.54	29.62	28.34	29.61	6315800.0
2023-08-29	AAC-DELISTED	Stock	10.69	10.69	10.68	10.69	9066.0
2023-08-29	AACG	Stock	1.22	1.25	1.22	1.24	4500.0
2023-08-29	AACT	Stock	10.21	10.21	10.21	10.21	50000.0
2023-08-29	AAIC-DELISTED	Stock	4.58	4.64	4.51	4.62	32858.0
2023-08-29	AAIC.C-DELISTED	Stock	23.8965	23.8965	23.8965	23.8965	106.0
2023-08-29	AAL	Stock	14.74	14.99	14.69	14.9	22186400.0
2023-08-29	AAM.A-DELISTED	Stock	25.32	25.35	25.32	25.34	20029.0
2023-08-29	AAM.B-DELISTED	Stock	25.33	25.34	25.32	25.3204	8767.0
2023-08-29	AAMC-DELISTED	Stock	5.2471	5.5882	5.0059	5.2294	65280.0
2023-08-29	AAME	Stock	2.15	2.15	2.03	2.12	9300.0
2023-08-29	AAMI	Stock	21.1	21.188	20.93	20.98	120800.0
2023-08-29	AAN-DELISTED	Stock	11.76	12.075	11.76	12.03	227500.0
2023-08-29	AAOI	Stock	13.0	14.67	12.81	14.1	3660000.0
2023-08-29	AAON	Stock	60.6	62.93	60.35	62.76	332700.0
2023-08-29	AAP	Stock	65.7	67.17	65.1	66.94	1885700.0
2023-08-29	AAT	Stock	21.27	21.58	21.13	21.53	188600.0
2023-08-29	AATC	Stock	6.0	6.065	5.985	6.065	6517.0
2023-08-29	AAU-DELISTED	Stock	0.129	0.129	0.122	0.1259	66849.0
2023-08-29	AAUAF-DELISTED	Stock	0.129	0.129	0.122	0.1259	66685.0
2023-08-29	AAXJ	Stock	65.7	66.5	65.55	66.48	766835.0
2023-08-29	AB	Stock	31.26	31.95	31.21	31.56	269200.0
2023-08-29	ABBNY-DELISTED	Stock	37.71	38.3	37.65	38.29	310614.0
2023-08-29	ABBV	Stock	147.99	148.91	146.5	147.59	3419100.0
2023-08-29	ABC-DELISTED	Stock	180.93	180.93	179.24	180.04	521369.0
2023-08-29	ABCB	Stock	40.13	40.42	39.91	40.26	194900.0
2023-08-29	ABCL	Stock	5.47	5.71	5.42	5.66	1116500.0
2023-08-29	ABCM-DELISTED	Stock	22.42	22.75	22.37	22.67	22031957.0
2023-08-29	ABEO	Stock	4.06	4.3	4.0	4.11	180100.0
2023-08-29	ABEV	Stock	2.88	2.92	2.88	2.9	7273600.0
2023-08-29	ABG	Stock	222.53	225.92	220.3	225.6	101500.0
2023-08-29	ABLLW	Stock	0.42	0.5	0.4	0.455	147105.0
2023-08-29	ABLV	Stock	4.51	4.89	4.21	4.45	48878.0
2023-08-29	ABLVW	Stock	0.0595	0.0595	0.0595	0.0595	3004.0
2023-08-29	ABM	Stock	45.49	45.72	45.27	45.62	197100.0
2023-08-29	ABNB	Stock	126.55	132.88	126.0	132.25	5622900.0
2023-08-29	ABOS	Stock	6.2	6.35	6.18	6.25	249000.0
2023-08-29	ABR	Stock	15.8	16.19	15.71	16.01	2135300.0
2023-08-29	ABR.D	Stock	18.581	18.67	18.49	18.535	6137.0

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

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