PREVIEW / stock_daily / 2023-09-21

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-21.parquet
  size:    236 KB
  rows:    7,365
  symbols: 1,390

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-09-21	AAPL	Stock	174.55	176.3	173.86	173.93	63047900.0
2023-09-21	MSFT	Stock	319.26	325.35	315.0	319.53	35529500.0
2023-09-21	NVDA	Stock	41.583	42.1	40.98	41.017	450736000.0
2023-09-21	AMZN	Stock	131.94	132.24	129.31	129.33	70234800.0
2023-09-21	GOOGL	Stock	131.44	132.23	130.07	130.44	31503910.0
2023-09-21	META	Stock	295.7	300.26	293.27	295.73	21300500.0
2023-09-21	TSLA	Stock	257.85	260.86	254.21	255.7	119531000.0
2023-09-21	TLT	Stock	91.285	91.365	90.69	90.7	59958747.0
2023-09-21	ES	Stock	63.85	64.83	63.39	64.01	3097100.0
2023-09-21	CL	Stock	73.85	73.98	73.2	73.22	3315200.0
2023-09-21	A	Stock	112.03	112.2	109.5	109.73	1327900.0
2023-09-21	AA	Stock	28.68	28.68	27.86	27.87	5487500.0
2023-09-21	AAC-DELISTED	Stock	10.74	10.74	10.73	10.74	10827.0
2023-09-21	AACG	Stock	1.2	1.2	1.14	1.14	1400.0
2023-09-21	AACIW-DELISTED	Stock	0.0755	0.0755	0.057	0.0596	44403.0
2023-09-21	AACT	Stock	10.27	10.27	10.265	10.265	1300.0
2023-09-21	AAIC-DELISTED	Stock	4.43	4.46	4.29	4.3	147169.0
2023-09-21	AAIC.C-DELISTED	Stock	23.9	24.38	23.9	23.996	1900.0
2023-09-21	AAL	Stock	12.95	13.27	12.93	13.06	24911700.0
2023-09-21	AAM.A-DELISTED	Stock	25.01	25.04	25.01	25.01	33814.0
2023-09-21	AAM.B-DELISTED	Stock	25.01	25.03	25.01	25.0257	12762.0
2023-09-21	AAMC-DELISTED	Stock	4.0765	4.3647	4.0765	4.1647	57460.0
2023-09-21	AAME	Stock	2.03	2.03	1.87	1.94	8200.0
2023-09-21	AAMI	Stock	20.08	20.34	19.68	20.23	165500.0
2023-09-21	AAN-DELISTED	Stock	9.94	10.67	9.92	10.66	737800.0
2023-09-21	AAOI	Stock	9.51	9.654	9.0	9.31	2280100.0
2023-09-21	AAON	Stock	60.47	60.47	56.67	56.68	542800.0
2023-09-21	AAP	Stock	59.71	59.85	58.04	58.24	1752800.0
2023-09-21	AAT	Stock	20.15	20.15	19.25	19.26	382500.0
2023-09-21	AATC	Stock	6.14	6.14	6.0	6.1	6202.0
2023-09-21	AAU-DELISTED	Stock	0.1261	0.1345	0.125	0.1337	349126.0
2023-09-21	AAUAF-DELISTED	Stock	0.1261	0.1345	0.125	0.1337	349225.0
2023-09-21	AAXJ	Stock	63.51	63.705	63.43	63.43	478710.0
2023-09-21	AB	Stock	31.85	32.39	31.56	31.86	224300.0
2023-09-21	ABAT	Stock	11.8	13.78	10.29	11.15	942250.0
2023-09-21	ABBNY-DELISTED	Stock	36.1001	36.28	36.0	36.04	381930.0
2023-09-21	ABBV	Stock	153.68	154.85	152.66	153.43	3660300.0
2023-09-21	ABCB	Stock	37.92	38.02	36.91	37.41	440600.0
2023-09-21	ABCL	Stock	5.05	5.07	4.91	4.91	1740700.0
2023-09-21	ABCM-DELISTED	Stock	22.68	22.69	22.56	22.59	7002581.0
2023-09-21	ABEO	Stock	3.73	3.8	3.6	3.61	133100.0
2023-09-21	ABEV	Stock	2.69	2.7	2.64	2.65	14422900.0
2023-09-21	ABG	Stock	224.49	228.54	222.5	225.23	137400.0
2023-09-21	ABLLW	Stock	0.3737	0.4	0.2702	0.299	265382.0
2023-09-21	ABLV	Stock	3.5	3.6	2.99	3.11	11100.0
2023-09-21	ABM	Stock	40.45	40.61	40.02	40.09	479300.0
2023-09-21	ABNB	Stock	135.555	135.98	132.39	132.75	8514300.0
2023-09-21	ABOS	Stock	4.86	4.86	4.7	4.73	196100.0
2023-09-21	ABR	Stock	15.35	15.4	14.87	14.87	5640500.0
2023-09-21	ABR.D	Stock	18.55	18.6277	18.4	18.6	9692.0

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

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