PREVIEW / stock_daily / 2023-08-21

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-21.parquet
  size:    239 KB
  rows:    7,468
  symbols: 1,478

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-21	AAPL	Stock	175.07	176.13	173.74	175.84	46311900.0
2023-08-21	MSFT	Stock	317.93	322.77	317.04	321.88	24040000.0
2023-08-21	NVDA	Stock	44.494	47.065	44.222	46.967	692573000.0
2023-08-21	AMZN	Stock	133.74	135.19	132.71	134.68	41442500.0
2023-08-21	GOOGL	Stock	127.175	128.725	126.56	128.37	25248729.0
2023-08-21	META	Stock	283.45	290.5	281.85	289.9	20181500.0
2023-08-21	TSLA	Stock	221.55	232.13	220.58	231.28	135702700.0
2023-08-21	TLT	Stock	92.66	92.76	92.23	92.52	29254118.0
2023-08-21	ES	Stock	64.38	64.66	63.3	63.85	1646800.0
2023-08-21	CL	Stock	74.3	74.38	73.51	73.8	3157300.0
2023-08-21	A	Stock	119.5	119.57	117.71	118.86	2249300.0
2023-08-21	AA	Stock	29.0	29.07	28.03	28.59	4701400.0
2023-08-21	AAC-DELISTED	Stock	10.65	10.66	10.635	10.65	42237.0
2023-08-21	AACG	Stock	1.27	1.28	1.21	1.21	10700.0
2023-08-21	AACT	Stock	10.22	10.225	10.21	10.21	1900.0
2023-08-21	AAIC-DELISTED	Stock	4.39	4.4	4.36	4.38	37251.0
2023-08-21	AAIC.C-DELISTED	Stock	23.9	24.1414	23.89	24.1414	3252.0
2023-08-21	AAL	Stock	15.06	15.2	14.95	15.16	23656300.0
2023-08-21	AAM.A-DELISTED	Stock	25.22	25.25	25.2	25.21	49259.0
2023-08-21	AAM.B-DELISTED	Stock	25.22	25.2346	25.2	25.22	15853.0
2023-08-21	AAMC-DELISTED	Stock	5.5882	5.7294	5.1147	5.2412	202300.0
2023-08-21	AAME	Stock	1.85	1.94	1.76	1.91	6200.0
2023-08-21	AAMI	Stock	20.7	20.96	20.6	20.8	172300.0
2023-08-21	AAN-DELISTED	Stock	12.52	12.71	12.28	12.5	334500.0
2023-08-21	AAOI	Stock	13.49	15.59	13.36	15.44	7897900.0
2023-08-21	AAON	Stock	61.76	62.03	61.23	61.97	293300.0
2023-08-21	AAP	Stock	69.68	69.99	67.26	68.2	2499400.0
2023-08-21	AAT	Stock	20.89	20.95	20.54	20.62	277800.0
2023-08-21	AATC	Stock	5.71	5.87	5.67	5.71	17096.0
2023-08-21	AAU-DELISTED	Stock	0.126	0.126	0.12	0.1207	37452.0
2023-08-21	AAUAF-DELISTED	Stock	0.126	0.126	0.12	0.1207	38451.0
2023-08-21	AAXJ	Stock	63.8	64.2	63.76	64.16	852505.0
2023-08-21	AB	Stock	30.54	31.28	30.12	30.2	367500.0
2023-08-21	ABBNY-DELISTED	Stock	36.94	37.07	36.8	36.98	106100.0
2023-08-21	ABBV	Stock	149.71	150.35	148.88	150.16	3944800.0
2023-08-21	ABC-DELISTED	Stock	180.66	181.33	179.76	180.99	717172.0
2023-08-21	ABCB	Stock	41.25	41.5	40.24	40.63	179500.0
2023-08-21	ABCL	Stock	5.5	5.68	5.45	5.58	1248800.0
2023-08-21	ABCM-DELISTED	Stock	21.73	22.815	21.54	22.21	1317412.0
2023-08-21	ABEO	Stock	3.8	4.11	3.75	3.79	216800.0
2023-08-21	ABEV	Stock	2.84	2.87	2.83	2.85	5699400.0
2023-08-21	ABG	Stock	220.7	223.14	218.03	219.87	105000.0
2023-08-21	ABLLW	Stock	0.2772	0.396	0.2651	0.3001	308149.0
2023-08-21	ABLV	Stock	4.9	5.65	4.9	5.1	170504.0
2023-08-21	ABLVW	Stock	0.0351	0.0699	0.0351	0.05	78080.0
2023-08-21	ABM	Stock	45.14	45.35	44.95	45.13	248100.0
2023-08-21	ABNB	Stock	126.155	126.54	123.49	124.0	4876000.0
2023-08-21	ABOS	Stock	6.29	6.63	6.12	6.59	411100.0
2023-08-21	ABR	Stock	15.1	15.27	15.0	15.23	2636800.0
2023-08-21	ABR.D	Stock	18.08	18.86	17.94	18.59	11644.0

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

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