PREVIEW / stock_daily / 2023-08-04

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-04.parquet
  size:    238 KB
  rows:    7,366
  symbols: 1,474

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-04	AAPL	Stock	185.52	187.38	181.92	181.99	115799700.0
2023-08-04	MSFT	Stock	331.88	335.14	327.24	327.78	23727700.0
2023-08-04	NVDA	Stock	44.985	45.642	44.393	44.68	362666000.0
2023-08-04	AMZN	Stock	141.06	143.63	139.32	139.57	152938700.0
2023-08-04	GOOGL	Stock	129.28	131.51	127.91	128.11	26147158.0
2023-08-04	META	Stock	314.96	318.41	310.2	310.73	17600200.0
2023-08-04	TSLA	Stock	260.97	264.77	253.11	253.86	99242600.0
2023-08-04	TLT	Stock	95.15	96.68	95.13	96.53	42071834.0
2023-08-04	ES	Stock	68.32	68.83	67.01	67.24	1731400.0
2023-08-04	CL	Stock	76.45	77.16	76.21	76.26	4574900.0
2023-08-04	A	Stock	125.44	127.17	125.08	126.3	1819500.0
2023-08-04	AA	Stock	34.55	34.93	33.755	33.95	3815100.0
2023-08-04	AAC-DELISTED	Stock	10.65	10.65	10.63	10.64	7187.0
2023-08-04	AACG	Stock	1.36	1.37	1.32	1.32	2900.0
2023-08-04	AACIW-DELISTED	Stock	0.06	0.0601	0.06	0.0601	15045.0
2023-08-04	AACT	Stock	10.18	10.18	10.18	10.18	231900.0
2023-08-04	AAIC-DELISTED	Stock	4.44	4.56	4.44	4.52	227475.0
2023-08-04	AAIC.C-DELISTED	Stock	23.4	23.48	23.4	23.48	600.0
2023-08-04	AAL	Stock	16.1	16.18	15.78	15.84	23503400.0
2023-08-04	AAM.A-DELISTED	Stock	23.7	23.8227	23.63	23.79	8872.0
2023-08-04	AAM.B-DELISTED	Stock	23.4457	24.99	23.4457	24.345	14548.0
2023-08-04	AAMC-DELISTED	Stock	23.9412	24.1176	23.5	23.5471	36890.0
2023-08-04	AAME	Stock	1.79	1.92	1.79	1.92	1500.0
2023-08-04	AAMI	Stock	20.17	20.94	20.04	20.6	153600.0
2023-08-04	AAN-DELISTED	Stock	13.23	13.68	13.09	13.6	317800.0
2023-08-04	AAOI	Stock	8.37	11.29	8.05	11.01	31716600.0
2023-08-04	AAON	Stock	69.4	69.98	63.8333	65.3333	1152000.0
2023-08-04	AAP	Stock	71.99	72.02	70.6	71.01	1294300.0
2023-08-04	AAT	Stock	22.36	22.73	22.3	22.5	608600.0
2023-08-04	AATC	Stock	4.78	4.78	4.67	4.67	3134.0
2023-08-04	AAU-DELISTED	Stock	0.15	0.15	0.1451	0.1471	58135.0
2023-08-04	AAUAF-DELISTED	Stock	0.15	0.15	0.1451	0.149	57691.0
2023-08-04	AAXJ	Stock	68.54	68.82	68.13	68.17	679269.0
2023-08-04	AB	Stock	31.77	32.08	31.49	31.59	210900.0
2023-08-04	ABBNY-DELISTED	Stock	39.23	39.73	39.21	39.29	129387.0
2023-08-04	ABBV	Stock	148.97	150.57	147.16	147.73	4231200.0
2023-08-04	ABC-DELISTED	Stock	187.185	188.51	184.0	185.33	4744331.0
2023-08-04	ABCB	Stock	44.08	44.84	43.72	44.55	258500.0
2023-08-04	ABCL	Stock	6.52	6.87	5.92	6.04	5580300.0
2023-08-04	ABCM-DELISTED	Stock	22.97	23.11	22.82	22.945	746356.0
2023-08-04	ABEO	Stock	3.17	3.29	3.1	3.14	99600.0
2023-08-04	ABEV	Stock	2.99	3.04	2.97	2.98	13265200.0
2023-08-04	ABG	Stock	223.64	224.19	219.84	221.43	129700.0
2023-08-04	ABLLW	Stock	0.2299	0.2397	0.215	0.215	5002.0
2023-08-04	ABLV	Stock	8.4	10.38	7.385	9.1299	141581.0
2023-08-04	ABM	Stock	45.46	45.97	45.29	45.56	219600.0
2023-08-04	ABNB	Stock	140.47	145.32	137.62	140.17	8621800.0
2023-08-04	ABOS	Stock	7.16	7.62	7.14	7.3	689600.0
2023-08-04	ABR	Stock	16.55	16.79	16.53	16.71	3821100.0
2023-08-04	ABR.D	Stock	19.05	19.05	18.78	19.05	23230.0

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

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