PREVIEW / stock_daily / 2023-07-27

all stock daily files

  file:    by_date/stock_daily/2023/2023-07-27.parquet
  size:    241 KB
  rows:    7,470
  symbols: 1,532

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-07-27	AAPL	Stock	196.02	197.2	192.55	193.22	47460200.0
2023-07-27	MSFT	Stock	340.48	341.33	329.05	330.72	39635300.0
2023-07-27	NVDA	Stock	46.519	47.395	45.75	45.9	455976000.0
2023-07-27	AMZN	Stock	131.0	132.63	127.79	128.25	52610700.0
2023-07-27	GOOGL	Stock	131.67	133.24	128.79	129.4	44952074.0
2023-07-27	META	Stock	325.12	325.35	309.84	311.71	64229200.0
2023-07-27	TSLA	Stock	268.31	269.13	255.3	255.71	103697300.0
2023-07-27	TLT	Stock	100.71	100.925	98.91	99.3	44794390.0
2023-07-27	ES	Stock	73.14	73.87	72.01	72.27	1781600.0
2023-07-27	CL	Stock	77.93	78.39	77.09	77.11	5637200.0
2023-07-27	A	Stock	129.87	130.0	126.64	126.66	2582500.0
2023-07-27	AA	Stock	35.06	35.13	33.9	33.91	6002500.0
2023-07-27	AAC-DELISTED	Stock	10.58	10.6	10.58	10.6	151678.0
2023-07-27	AACG	Stock	1.34	1.37	1.32	1.35	4600.0
2023-07-27	AACIW-DELISTED	Stock	0.0652	0.0688	0.064	0.0688	850.0
2023-07-27	AACT	Stock	10.17	10.19	10.17	10.19	3500.0
2023-07-27	AAIC-DELISTED	Stock	4.71	4.79	4.65	4.65	64347.0
2023-07-27	AAIC.C-DELISTED	Stock	23.39	23.4607	23.39	23.39	1200.0
2023-07-27	AAL	Stock	16.55	16.69	16.34	16.57	24395800.0
2023-07-27	AAM.A-DELISTED	Stock	23.46	23.9145	23.46	23.6	5716.0
2023-07-27	AAM.B-DELISTED	Stock	23.739	24.2	23.5701	23.7484	10373.0
2023-07-27	AAMC-DELISTED	Stock	23.0353	23.4941	21.5647	22.2647	100640.0
2023-07-27	AAME	Stock	1.93	1.94	1.85	1.87	4100.0
2023-07-27	AAMI	Stock	21.72	21.8	21.44	21.59	202000.0
2023-07-27	AAN-DELISTED	Stock	15.73	15.805	15.27	15.38	202100.0
2023-07-27	AAOI	Stock	8.01	8.22	6.16	6.19	4212900.0
2023-07-27	AAON	Stock	67.6667	68.0	65.6133	66.68	408000.0
2023-07-27	AAP	Stock	73.25	74.49	72.25	72.64	2305200.0
2023-07-27	AAT	Stock	22.5	22.74	22.15	22.2	309100.0
2023-07-27	AATC	Stock	4.4875	4.8999	4.4	4.5101	45177.0
2023-07-27	AAU-DELISTED	Stock	0.146	0.1576	0.1459	0.1468	155706.0
2023-07-27	AAUAF-DELISTED	Stock	0.146	0.1576	0.1459	0.1468	157286.0
2023-07-27	AAXJ	Stock	69.5	69.5	68.56	68.66	243119.0
2023-07-27	AB	Stock	34.19	34.25	32.91	32.91	683200.0
2023-07-27	ABBNY-DELISTED	Stock	41.015	41.03	40.31	40.33	160609.0
2023-07-27	ABBV	Stock	144.48	151.37	144.48	148.85	13664400.0
2023-07-27	ABC-DELISTED	Stock	187.81	189.09	186.74	187.3	824849.0
2023-07-27	ABCB	Stock	42.13	42.32	40.64	41.58	697500.0
2023-07-27	ABCL	Stock	7.79	7.89	7.51	7.52	1101900.0
2023-07-27	ABCM-DELISTED	Stock	23.5	23.63	23.29	23.35	1611032.0
2023-07-27	ABEO	Stock	3.44	3.49	3.3	3.35	316700.0
2023-07-27	ABEV	Stock	3.14	3.15	3.06	3.07	13193500.0
2023-07-27	ABG	Stock	224.3	224.55	218.53	221.17	180000.0
2023-07-27	ABLLW	Stock	0.2523	0.31	0.245	0.245	56945.0
2023-07-27	ABLV	Stock	10.64	10.7	10.62	10.67	95163.0
2023-07-27	ABM	Stock	45.16	45.79	44.86	45.03	970900.0
2023-07-27	ABNB	Stock	151.89	153.175	147.555	148.5	5426000.0
2023-07-27	ABOS	Stock	7.29	7.45	7.12	7.21	775900.0
2023-07-27	ABR	Stock	16.6	16.72	16.14	16.15	3853000.0
2023-07-27	ABR.D	Stock	18.92	19.425	18.8501	19.0	21127.0

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

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