PREVIEW / stock_daily / 2023-10-04

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-04.parquet
  size:    235 KB
  rows:    7,379
  symbols: 1,377

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-10-04	AAPL	Stock	171.09	174.21	170.97	173.66	53020300.0
2023-10-04	MSFT	Stock	314.03	320.04	314.0	318.96	20720100.0
2023-10-04	NVDA	Stock	43.742	44.143	43.292	44.041	361821000.0
2023-10-04	AMZN	Stock	126.06	127.36	125.68	127.0	44203900.0
2023-10-04	GOOGL	Stock	132.79	135.57	132.53	135.24	26752295.0
2023-10-04	META	Stock	298.73	306.9	298.5	305.58	16880500.0
2023-10-04	TSLA	Stock	248.14	261.86	247.6	261.16	129721600.0
2023-10-04	TLT	Stock	85.77	86.31	85.37	86.26	56281598.0
2023-10-04	ES	Stock	56.11	56.31	55.08	56.11	2767700.0
2023-10-04	CL	Stock	70.54	70.93	70.0	70.56	2777200.0
2023-10-04	A	Stock	110.41	111.89	109.38	111.67	1541700.0
2023-10-04	AA	Stock	27.73	27.81	26.37	27.16	5335500.0
2023-10-04	AAC-DELISTED	Stock	10.7414	10.75	10.74	10.75	10563.0
2023-10-04	AACG	Stock	1.12	1.12	1.1	1.1	5900.0
2023-10-04	AACIW-DELISTED	Stock	0.0755	0.0755	0.0755	0.0755	150.0
2023-10-04	AACT	Stock	10.3	10.3	10.275	10.275	5000.0
2023-10-04	AAIC-DELISTED	Stock	4.17	4.205	4.09	4.18	55558.0
2023-10-04	AAIC.C-DELISTED	Stock	23.62	23.6501	23.585	23.6501	3104.0
2023-10-04	AAL	Stock	12.4	12.82	12.34	12.73	49738100.0
2023-10-04	AAMC-DELISTED	Stock	3.8588	4.1529	3.8247	4.0	20740.0
2023-10-04	AAME	Stock	1.87	1.87	1.83	1.83	1000.0
2023-10-04	AAMI	Stock	18.49	18.49	18.13	18.22	216000.0
2023-10-04	AAN-DELISTED	Stock	9.88	9.92	9.72	9.82	250600.0
2023-10-04	AAOI	Stock	10.34	10.55	8.79	8.91	3012400.0
2023-10-04	AAON	Stock	55.78	56.51	54.84	56.24	223600.0
2023-10-04	AAP	Stock	53.53	53.89	51.95	52.38	1778100.0
2023-10-04	AAT	Stock	18.19	18.45	18.11	18.41	222200.0
2023-10-04	AATC	Stock	5.6	5.78	5.57	5.7	11135.0
2023-10-04	AAU-DELISTED	Stock	0.138	0.1479	0.13	0.136	183194.0
2023-10-04	AAUAF-DELISTED	Stock	0.138	0.1479	0.13	0.136	200069.0
2023-10-04	AAXJ	Stock	62.43	62.5	62.17	62.34	835861.0
2023-10-04	AB	Stock	30.24	30.75	29.91	30.57	186900.0
2023-10-04	ABAT	Stock	7.49	7.49	7.15	7.15	150428.0
2023-10-04	ABBNY-DELISTED	Stock	35.77	35.77	35.28	35.66	144042.0
2023-10-04	ABBV	Stock	146.57	148.08	146.31	147.69	3159600.0
2023-10-04	ABCB	Stock	37.05	37.47	36.45	37.39	300200.0
2023-10-04	ABCL	Stock	4.38	4.45	4.33	4.43	1248700.0
2023-10-04	ABCM-DELISTED	Stock	22.7	22.8	22.67	22.75	2401659.0
2023-10-04	ABEO	Stock	4.25	4.35	4.14	4.17	65500.0
2023-10-04	ABEV	Stock	2.51	2.56	2.51	2.55	12380400.0
2023-10-04	ABG	Stock	212.69	217.1	211.75	214.32	75300.0
2023-10-04	ABLLW	Stock	0.3899	0.3899	0.36	0.36	1100.0
2023-10-04	ABLV	Stock	3.37	3.4	3.27	3.335	3500.0
2023-10-04	ABM	Stock	39.1	40.34	39.0	40.32	505400.0
2023-10-04	ABNB	Stock	128.75	130.22	127.295	127.41	5822000.0
2023-10-04	ABOS	Stock	4.17	4.195	4.065	4.17	261300.0
2023-10-04	ABR	Stock	13.76	13.82	13.29	13.55	5739300.0
2023-10-04	ABR.D	Stock	17.13	17.46	17.13	17.38	10158.0
2023-10-04	ABR.E	Stock	16.95	17.1	16.8501	17.1	10553.0
2023-10-04	ABR.F	Stock	18.4	18.4	17.95	18.15	10068.0

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

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