PREVIEW / stock_daily / 2023-10-13

all stock daily files

  file:    by_date/stock_daily/2023/2023-10-13.parquet
  size:    235 KB
  rows:    7,379
  symbols: 1,367

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-10-13	AAPL	Stock	181.42	181.93	178.14	178.85	51427100.0
2023-10-13	MSFT	Stock	332.38	333.83	326.36	327.73	21072400.0
2023-10-13	NVDA	Stock	46.96	47.116	45.28	45.461	474115000.0
2023-10-13	AMZN	Stock	132.98	133.31	128.95	129.79	45786600.0
2023-10-13	GOOGL	Stock	139.38	140.0	136.615	137.36	23435599.0
2023-10-13	META	Stock	323.53	325.05	312.37	314.69	21341000.0
2023-10-13	TSLA	Stock	258.9	259.6	250.22	251.12	102073800.0
2023-10-13	TLT	Stock	87.6	87.83	87.17	87.61	44203089.0
2023-10-13	ES	Stock	54.42	55.09	53.72	55.03	4951000.0
2023-10-13	CL	Stock	69.87	71.03	69.8	70.95	3898000.0
2023-10-13	A	Stock	108.02	110.61	106.82	110.51	2807600.0
2023-10-13	AA	Stock	27.0	27.25	26.33	26.58	4532500.0
2023-10-13	AAC-DELISTED	Stock	10.78	10.78	10.76	10.78	12981.0
2023-10-13	AACG	Stock	1.1	1.14	1.1	1.1	8300.0
2023-10-13	AACIW-DELISTED	Stock	0.088	0.088	0.088	0.088	190.0
2023-10-13	AACT	Stock	10.29	10.29	10.29	10.29	22000.0
2023-10-13	AAIC-DELISTED	Stock	4.44	4.44	4.345	4.37	58275.0
2023-10-13	AAIC.C-DELISTED	Stock	24.0	24.0	23.9	23.94	1598.0
2023-10-13	AAL	Stock	11.87	12.04	11.68	11.72	48056300.0
2023-10-13	AAMC-DELISTED	Stock	3.9	4.0	3.8941	3.9471	17510.0
2023-10-13	AAME	Stock	1.9	1.9	1.72	1.85	8900.0
2023-10-13	AAMI	Stock	17.59	17.59	17.05	17.31	138900.0
2023-10-13	AAN-DELISTED	Stock	9.63	9.7	9.35	9.37	369700.0
2023-10-13	AAOI	Stock	7.85	7.88	7.18	7.55	1938700.0
2023-10-13	AAON	Stock	57.7	57.7	55.98	56.16	257500.0
2023-10-13	AAP	Stock	49.9	50.79	49.28	50.75	1403300.0
2023-10-13	AAT	Stock	18.56	18.57	18.05	18.29	207600.0
2023-10-13	AATC	Stock	5.57	5.57	5.57	5.57	191.0
2023-10-13	AAU-DELISTED	Stock	0.1328	0.14	0.13	0.136	469390.0
2023-10-13	AAUAF-DELISTED	Stock	0.1328	0.14	0.13	0.136	470831.0
2023-10-13	AAXJ	Stock	63.92	64.135	63.63	63.78	551151.0
2023-10-13	AB	Stock	29.95	30.17	29.08	29.4	265800.0
2023-10-13	ABAT	Stock	7.18	7.54	6.85	7.54	235987.0
2023-10-13	ABBNY-DELISTED	Stock	36.8501	36.88	36.42	36.53	313500.0
2023-10-13	ABBV	Stock	148.95	149.66	147.34	147.96	4304700.0
2023-10-13	ABCB	Stock	38.9	38.96	37.62	37.66	180400.0
2023-10-13	ABCL	Stock	4.04	4.28	3.94	4.26	2615700.0
2023-10-13	ABCM-DELISTED	Stock	22.67	22.765	22.6	22.6	10809276.0
2023-10-13	ABEO	Stock	4.24	4.3	4.13	4.14	67700.0
2023-10-13	ABEV	Stock	2.55	2.58	2.51	2.55	12525500.0
2023-10-13	ABG	Stock	212.42	216.36	210.05	212.4	204700.0
2023-10-13	ABLLW	Stock	0.36	0.368	0.3375	0.3399	3226.0
2023-10-13	ABLV	Stock	3.2	3.24	2.99	3.0	17800.0
2023-10-13	ABM	Stock	43.98	44.33	43.43	44.03	425100.0
2023-10-13	ABNB	Stock	127.61	129.84	123.55	124.08	4926500.0
2023-10-13	ABOS	Stock	3.82	3.82	3.66	3.74	249100.0
2023-10-13	ABR	Stock	14.41	14.46	13.97	14.23	2602900.0
2023-10-13	ABR.D	Stock	17.22	17.26	16.9501	16.97	12217.0
2023-10-13	ABR.E	Stock	17.01	17.21	16.65	16.75	11278.0
2023-10-13	ABR.F	Stock	18.05	18.05	17.8	17.9	12666.0

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

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