PREVIEW / stock_daily / 2023-05-09

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-09.parquet
  size:    241 KB
  rows:    7,506
  symbols: 1,637

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-05-09	AAPL	Stock	173.05	173.54	171.6	171.77	45326900.0
2023-05-09	MSFT	Stock	308.0	310.04	306.31	307.0	21340800.0
2023-05-09	NVDA	Stock	28.899	28.973	28.45	28.571	314869000.0
2023-05-09	AMZN	Stock	105.48	106.79	105.16	106.62	44089400.0
2023-05-09	GOOGL	Stock	108.39	110.15	107.19	107.35	36360141.0
2023-05-09	META	Stock	231.46	235.88	231.08	233.37	16865600.0
2023-05-09	TSLA	Stock	168.95	169.82	166.56	169.15	88965000.0
2023-05-09	TLT	Stock	103.5	103.64	103.0	103.05	19182506.0
2023-05-09	ES	Stock	76.69	76.69	75.82	76.45	1473300.0
2023-05-09	CL	Stock	81.02	81.2	80.55	80.64	3363500.0
2023-05-09	A	Stock	128.5	128.5	125.36	127.35	3437100.0
2023-05-09	AA	Stock	36.1	36.92	35.71	36.51	3445000.0
2023-05-09	AAC-DELISTED	Stock	10.41	10.43	10.4	10.43	1182922.0
2023-05-09	AACG	Stock	1.77	1.81	1.76	1.81	8100.0
2023-05-09	AACIU	Stock	10.25	10.325	10.25	10.325	600.0
2023-05-09	AACIW-DELISTED	Stock	0.095	0.1099	0.095	0.1099	202.0
2023-05-09	AAIC-DELISTED	Stock	2.59	2.64	2.58	2.63	27700.0
2023-05-09	AAIC.C-DELISTED	Stock	21.38	21.4	21.38	21.4	300.0
2023-05-09	AAL	Stock	14.38	14.56	14.21	14.47	19682700.0
2023-05-09	AAM.A-DELISTED	Stock	24.155	24.7059	23.5604	23.91	16502.0
2023-05-09	AAM.B-DELISTED	Stock	24.87	24.87	23.95	24.28	9729.0
2023-05-09	AAMC-DELISTED	Stock	25.7324	25.7353	24.75	25.1765	39661.0
2023-05-09	AAME	Stock	2.16	2.21	2.16	2.21	1100.0
2023-05-09	AAMI	Stock	22.21	22.35	21.96	22.16	78400.0
2023-05-09	AAN-DELISTED	Stock	12.28	12.72	12.2	12.58	290500.0
2023-05-09	AAOI	Stock	1.77	1.83	1.68	1.8	184500.0
2023-05-09	AAON	Stock	64.6667	65.1267	63.7933	64.4533	396000.0
2023-05-09	AAP	Stock	125.4	126.58	124.05	125.52	754400.0
2023-05-09	AAT	Stock	18.69	18.97	18.42	18.85	501600.0
2023-05-09	AATC	Stock	4.0	4.045	4.0	4.02	3066.0
2023-05-09	AAU-DELISTED	Stock	0.1219	0.1247	0.1204	0.1227	308469.0
2023-05-09	AAUAF-DELISTED	Stock	0.1219	0.127	0.1204	0.127	308396.0
2023-05-09	AAXJ	Stock	66.28	66.57	66.26	66.47	294636.0
2023-05-09	AB	Stock	34.23	34.29	33.41	33.89	187000.0
2023-05-09	ABB-DELISTED	Stock	36.16	36.615	36.15	36.57	1456110.0
2023-05-09	ABBNY-DELISTED	Stock	36.16	36.615	36.15	36.57	1603696.0
2023-05-09	ABBV	Stock	147.41	148.46	146.27	146.83	4201600.0
2023-05-09	ABC-DELISTED	Stock	169.52	173.64	168.14	168.33	777777.0
2023-05-09	ABCB	Stock	29.4	29.69	28.75	29.33	290300.0
2023-05-09	ABCL	Stock	5.7	5.765	5.53	5.66	2847500.0
2023-05-09	ABCM-DELISTED	Stock	17.92	18.38	17.5	17.63	1441699.0
2023-05-09	ABEO	Stock	3.08	3.19	3.08	3.18	30600.0
2023-05-09	ABEV	Stock	2.86	2.9	2.85	2.86	11007100.0
2023-05-09	ABG	Stock	199.9	205.06	198.43	202.07	207800.0
2023-05-09	ABM	Stock	42.26	42.72	41.83	42.59	159400.0
2023-05-09	ABNB	Stock	126.6	128.96	125.01	127.07	15410300.0
2023-05-09	ABOS	Stock	5.02	5.84	4.84	5.73	517200.0
2023-05-09	ABR	Stock	12.2	12.42	11.99	12.31	3554400.0
2023-05-09	ABR.D	Stock	17.67	17.721	17.42	17.45	6811.0
2023-05-09	ABR.E	Stock	17.48	17.51	16.66	16.925	16213.0

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

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