PREVIEW / stock_daily / 2023-11-07

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-07.parquet
  size:    234 KB
  rows:    7,362
  symbols: 1,331

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-11-07	AAPL	Stock	179.18	182.44	178.97	181.82	70530000.0
2023-11-07	MSFT	Stock	359.4	362.46	357.63	360.53	25833900.0
2023-11-07	NVDA	Stock	45.719	46.218	45.158	45.955	343165000.0
2023-11-07	AMZN	Stock	140.55	143.37	140.5	142.71	53553500.0
2023-11-07	GOOGL	Stock	130.71	131.91	129.88	130.97	29757276.0
2023-11-07	META	Stock	317.06	321.0	315.12	318.82	14055600.0
2023-11-07	TSLA	Stock	219.98	223.12	215.72	222.18	116900100.0
2023-11-07	TLT	Stock	87.61	88.5	87.59	88.06	37834193.0
2023-11-07	ES	Stock	56.37	57.64	55.63	56.35	3137900.0
2023-11-07	CL	Stock	75.08	75.56	74.76	75.23	3275000.0
2023-11-07	A	Stock	106.84	110.81	106.55	110.54	2142300.0
2023-11-07	AA	Stock	25.22	25.595	24.82	25.54	4852900.0
2023-11-07	AACG	Stock	0.92	1.0	0.92	0.96	1900.0
2023-11-07	AACIW-DELISTED	Stock	0.0646	0.0646	0.0501	0.0504	13933.0
2023-11-07	AACT	Stock	10.32	10.33	10.32	10.33	835800.0
2023-11-07	AAIC-DELISTED	Stock	4.45	4.5	4.435	4.5	45056.0
2023-11-07	AAIC.C-DELISTED	Stock	23.7001	23.97	23.7001	23.97	900.0
2023-11-07	AAL	Stock	11.72	11.84	11.61	11.75	27819600.0
2023-11-07	AAMC-DELISTED	Stock	3.56	3.61	3.52	3.52	12000.0
2023-11-07	AAME	Stock	1.84	1.84	1.72	1.72	5100.0
2023-11-07	AAMI	Stock	16.48	16.57	16.11	16.25	325200.0
2023-11-07	AAN-DELISTED	Stock	7.51	7.56	7.25	7.31	540100.0
2023-11-07	AAOI	Stock	9.7	10.26	9.33	9.89	1634300.0
2023-11-07	AAON	Stock	59.0	61.91	58.34	58.82	770600.0
2023-11-07	AAP	Stock	56.43	58.84	56.02	58.38	1641300.0
2023-11-07	AAT	Stock	19.63	19.75	19.04	19.1	356000.0
2023-11-07	AATC	Stock	5.655	5.66	5.655	5.66	384.0
2023-11-07	AAU-DELISTED	Stock	0.14	0.1425	0.14	0.1401	98736.0
2023-11-07	AAUAF-DELISTED	Stock	0.14	0.1426	0.14	0.1401	102080.0
2023-11-07	AAXJ	Stock	64.24	64.63	64.02	64.57	679309.0
2023-11-07	AB	Stock	28.13	28.31	27.8	27.8	304000.0
2023-11-07	ABAT	Stock	4.45	4.45	4.21	4.3	195403.0
2023-11-07	ABBNY-DELISTED	Stock	34.44	34.5435	34.32	34.36	128213.0
2023-11-07	ABBV	Stock	141.52	142.18	140.57	142.16	5024400.0
2023-11-07	ABCB	Stock	41.17	41.29	40.47	40.68	446800.0
2023-11-07	ABCL	Stock	4.44	4.525	4.385	4.4	1195600.0
2023-11-07	ABCM-DELISTED	Stock	23.28	23.33	23.1	23.2	10729758.0
2023-11-07	ABEO	Stock	4.48	4.66	4.36	4.4	37000.0
2023-11-07	ABEV	Stock	2.76	2.78	2.75	2.77	9414500.0
2023-11-07	ABG	Stock	203.93	203.93	199.99	202.66	98200.0
2023-11-07	ABLLW	Stock	0.33	0.3362	0.2919	0.329	27577.0
2023-11-07	ABLV	Stock	1.94	1.95	1.85	1.86	29400.0
2023-11-07	ABM	Stock	40.21	40.21	39.45	39.91	412200.0
2023-11-07	ABNB	Stock	118.25	122.18	118.1	121.08	5163900.0
2023-11-07	ABOS	Stock	2.07	2.145	2.02	2.09	540200.0
2023-11-07	ABR	Stock	12.48	12.7	12.37	12.62	4291900.0
2023-11-07	ABR.D	Stock	16.28	16.5	16.24	16.34	16921.0
2023-11-07	ABR.E	Stock	16.6299	16.6299	16.21	16.21	1995.0
2023-11-07	ABR.F	Stock	17.8	18.0	17.6	17.6	4809.0
2023-11-07	ABSI	Stock	1.37	1.425	1.32	1.4	192300.0

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

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