PREVIEW / stock_daily / 2023-11-21

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-21.parquet
  size:    234 KB
  rows:    7,367
  symbols: 1,301

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-21	AAPL	Stock	191.41	191.52	189.74	190.64	38134500.0
2023-11-21	MSFT	Stock	375.67	376.22	371.12	373.07	28423100.0
2023-11-21	NVDA	Stock	50.126	50.517	49.222	49.944	565747000.0
2023-11-21	AMZN	Stock	143.91	144.05	141.5	143.9	71226000.0
2023-11-21	GOOGL	Stock	136.29	137.18	135.96	136.97	22635272.0
2023-11-21	META	Stock	338.33	339.9	335.9	336.98	12027900.0
2023-11-21	TSLA	Stock	235.04	243.62	233.34	241.2	122288000.0
2023-11-21	TLT	Stock	90.5	90.8	89.885	90.55	27720966.0
2023-11-21	ES	Stock	58.41	59.03	57.99	58.82	2660800.0
2023-11-21	CL	Stock	75.65	76.59	75.39	76.57	3669500.0
2023-11-21	A	Stock	121.46	124.68	121.23	123.92	6085800.0
2023-11-21	AA	Stock	26.28	26.625	26.17	26.39	2881900.0
2023-11-21	AACG	Stock	0.98	0.98	0.91	0.91	900.0
2023-11-21	AACIW-DELISTED	Stock	0.063	0.063	0.0512	0.0512	683.0
2023-11-21	AACT	Stock	10.36	10.4	10.36	10.36	108800.0
2023-11-21	AAIC-DELISTED	Stock	4.62	4.66	4.61	4.63	177923.0
2023-11-21	AAIC.C-DELISTED	Stock	24.0999	24.1	24.0999	24.1	1550.0
2023-11-21	AAL	Stock	12.3	12.33	12.05	12.13	24497700.0
2023-11-21	AAMC-DELISTED	Stock	2.75	2.9	2.75	2.87	32000.0
2023-11-21	AAME	Stock	1.87	1.89	1.87	1.89	1800.0
2023-11-21	AAMI	Stock	17.6	17.71	17.39	17.68	197500.0
2023-11-21	AAN-DELISTED	Stock	8.9	8.998	8.8	8.85	228300.0
2023-11-21	AAOI	Stock	14.15	14.325	13.15	13.33	1900100.0
2023-11-21	AAON	Stock	62.71	64.13	62.42	63.5	288900.0
2023-11-21	AAP	Stock	52.45	52.59	50.61	50.99	1824900.0
2023-11-21	AAT	Stock	18.85	18.94	18.56	18.62	363100.0
2023-11-21	AATC	Stock	6.38	6.54	6.38	6.54	2942.0
2023-11-21	AAU-DELISTED	Stock	0.1405	0.1423	0.14	0.14	108892.0
2023-11-21	AAUAF-DELISTED	Stock	0.1405	0.1423	0.14	0.14	109469.0
2023-11-21	AAXJ	Stock	66.06	66.25	65.76	65.87	695654.0
2023-11-21	AB	Stock	28.32	28.52	28.0	28.2	354100.0
2023-11-21	ABAT	Stock	4.1	4.2	3.98	4.11	143576.0
2023-11-21	ABBNY-DELISTED	Stock	38.28	38.42	38.13	38.17	241988.0
2023-11-21	ABBV	Stock	138.73	139.36	137.83	138.73	4690800.0
2023-11-21	ABCB	Stock	42.83	43.0	42.21	42.28	207300.0
2023-11-21	ABCL	Stock	4.58	4.58	4.32	4.34	1444200.0
2023-11-21	ABCM-DELISTED	Stock	23.92	23.94	23.92	23.93	6555579.0
2023-11-21	ABEO	Stock	4.22	4.25	4.15	4.17	32100.0
2023-11-21	ABEV	Stock	2.78	2.78	2.72	2.73	9911400.0
2023-11-21	ABG	Stock	210.01	210.03	204.67	205.7	107600.0
2023-11-21	ABLLW	Stock	0.29	0.36	0.29	0.34	581916.0
2023-11-21	ABLV	Stock	2.89	3.146	2.89	3.12	36200.0
2023-11-21	ABM	Stock	41.19	41.31	40.9	40.93	211600.0
2023-11-21	ABNB	Stock	128.0	128.05	124.93	126.82	4587100.0
2023-11-21	ABOS	Stock	2.36	2.405	2.26	2.34	394800.0
2023-11-21	ABR	Stock	12.36	12.54	12.19	12.19	5438500.0
2023-11-21	ABR.D	Stock	16.1798	16.47	16.1798	16.3	216920.0
2023-11-21	ABR.E	Stock	16.34	16.5	16.295	16.5	2808.0
2023-11-21	ABR.F	Stock	17.2499	17.5	17.2001	17.3	20677.0
2023-11-21	ABSI	Stock	1.41	1.42	1.33	1.36	200500.0

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

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