PREVIEW / stock_daily / 2023-08-08

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-08.parquet
  size:    239 KB
  rows:    7,424
  symbols: 1,476

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-08	AAPL	Stock	179.69	180.27	177.58	179.8	67823000.0
2023-08-08	MSFT	Stock	326.96	328.75	323.0	326.05	22327600.0
2023-08-08	NVDA	Stock	44.853	45.242	44.056	44.664	353843000.0
2023-08-08	AMZN	Stock	140.62	140.84	138.42	139.94	51710500.0
2023-08-08	GOOGL	Stock	130.62	131.51	129.545	131.4	23535181.0
2023-08-08	META	Stock	314.4	317.89	310.11	312.64	15183500.0
2023-08-08	TSLA	Stock	247.45	250.92	245.01	249.7	96642200.0
2023-08-08	TLT	Stock	96.86	97.37	96.44	96.69	24010511.0
2023-08-08	ES	Stock	67.05	67.19	66.14	66.94	1677700.0
2023-08-08	CL	Stock	77.02	77.13	76.18	76.33	3796200.0
2023-08-08	A	Stock	126.69	128.63	125.07	128.35	2525200.0
2023-08-08	AA	Stock	33.02	33.35	32.68	33.23	5366300.0
2023-08-08	AAC-DELISTED	Stock	10.63	10.65	10.62	10.63	41020.0
2023-08-08	AACG	Stock	1.25	1.29	1.12	1.22	23400.0
2023-08-08	AACIW-DELISTED	Stock	0.0683	0.0684	0.0683	0.0684	200.0
2023-08-08	AACT	Stock	10.18	10.2	10.18	10.2	58700.0
2023-08-08	AAIC-DELISTED	Stock	4.58	4.58	4.452	4.52	283703.0
2023-08-08	AAL	Stock	15.8	16.22	15.77	16.18	25107600.0
2023-08-08	AAM.A-DELISTED	Stock	23.727	24.34	23.727	24.1	34284.0
2023-08-08	AAM.B-DELISTED	Stock	24.0035	24.5906	23.9862	24.17	3769.0
2023-08-08	AAMC-DELISTED	Stock	24.8824	25.8765	22.2059	23.6235	70040.0
2023-08-08	AAME	Stock	1.95	1.97	1.82	1.82	21900.0
2023-08-08	AAMI	Stock	20.33	20.33	19.835	19.96	143600.0
2023-08-08	AAN-DELISTED	Stock	13.55	13.98	13.383	13.79	216700.0
2023-08-08	AAOI	Stock	11.63	12.2	11.34	12.19	5693600.0
2023-08-08	AAON	Stock	62.2	64.36	61.6667	64.26	533850.0
2023-08-08	AAP	Stock	70.15	71.18	69.33	70.56	1563700.0
2023-08-08	AAT	Stock	22.59	22.69	22.31	22.52	278200.0
2023-08-08	AATC	Stock	4.76	4.76	4.75	4.75	4426.0
2023-08-08	AAU-DELISTED	Stock	0.148	0.15	0.1434	0.145	113273.0
2023-08-08	AAUAF-DELISTED	Stock	0.148	0.15	0.1434	0.145	115357.0
2023-08-08	AAXJ	Stock	67.02	67.23	66.71	67.19	626374.0
2023-08-08	AB	Stock	30.39	30.82	29.14	30.34	573900.0
2023-08-08	ABBNY-DELISTED	Stock	38.92	39.12	38.7101	39.06	232628.0
2023-08-08	ABBV	Stock	150.78	151.75	148.92	149.62	4013400.0
2023-08-08	ABC-DELISTED	Stock	186.19	188.91	184.93	185.37	2191380.0
2023-08-08	ABCB	Stock	44.03	44.97	43.44	44.6	298800.0
2023-08-08	ABCL	Stock	5.86	5.925	5.7	5.89	1998200.0
2023-08-08	ABCM-DELISTED	Stock	22.45	22.98	22.35	22.495	2082926.0
2023-08-08	ABEO	Stock	3.0	3.02	2.83	2.98	91800.0
2023-08-08	ABEV	Stock	2.93	2.96	2.92	2.94	8490000.0
2023-08-08	ABG	Stock	221.22	221.71	218.38	219.59	107300.0
2023-08-08	ABLLW	Stock	0.2051	0.23	0.205	0.22	18611.0
2023-08-08	ABLV	Stock	9.0	9.39	8.255	8.95	66168.0
2023-08-08	ABM	Stock	45.35	45.98	45.07	45.88	439700.0
2023-08-08	ABNB	Stock	140.52	140.52	137.03	139.55	4685800.0
2023-08-08	ABOS	Stock	6.97	7.23	6.73	7.0	941700.0
2023-08-08	ABR	Stock	16.51	16.64	16.32	16.51	2482400.0
2023-08-08	ABR.D	Stock	18.72	18.79	18.6	18.78	9140.0
2023-08-08	ABR.E	Stock	18.98	18.99	18.98	18.99	1606.0

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

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