PREVIEW / stock_daily / 2023-12-15

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-15.parquet
  size:    239 KB
  rows:    7,368
  symbols: 1,265

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-12-15	AAPL	Stock	197.53	198.4	197.0	197.57	128256700.0
2023-12-15	MSFT	Stock	366.85	372.4	366.28	370.73	78478200.0
2023-12-15	NVDA	Stock	48.194	49.404	48.12	48.89	479948000.0
2023-12-15	AMZN	Stock	148.38	150.57	147.88	149.97	110039100.0
2023-12-15	GOOGL	Stock	131.62	133.51	131.18	132.6	50847113.0
2023-12-15	META	Stock	331.99	338.66	331.22	334.92	30001600.0
2023-12-15	TSLA	Stock	251.21	254.13	248.3	253.5	135720800.0
2023-12-15	TLT	Stock	98.69	99.35	98.58	99.15	59941256.0
2023-12-15	ES	Stock	62.3	62.84	60.91	61.82	6718600.0
2023-12-15	CL	Stock	75.86	77.01	75.5	76.98	10223900.0
2023-12-15	A	Stock	137.24	138.9	136.28	136.78	4876000.0
2023-12-15	AA	Stock	29.93	32.5	29.67	31.1	19183200.0
2023-12-15	AACG	Stock	0.89	0.89	0.85	0.85	6600.0
2023-12-15	AACIW-DELISTED	Stock	0.025	0.025	0.017	0.025	3890.0
2023-12-15	AACT	Stock	10.41	10.645	10.41	10.41	102900.0
2023-12-15	AAGR-DELISTED	Stock	0.66	0.665	0.58	0.598	1166436.0
2023-12-15	AAGRW-DELISTED	Stock	0.036	0.04	0.03	0.0329	45780.0
2023-12-15	AAL	Stock	14.63	14.67	14.41	14.49	34725700.0
2023-12-15	AAMC-DELISTED	Stock	5.51	5.92	4.84	4.96	74800.0
2023-12-15	AAME	Stock	2.06	2.08	1.98	1.98	7700.0
2023-12-15	AAMI	Stock	19.93	19.98	19.4	19.45	470800.0
2023-12-15	AAN-DELISTED	Stock	11.81	11.85	11.07	11.09	744800.0
2023-12-15	AAOI	Stock	23.71	23.95	20.82	21.725	4257600.0
2023-12-15	AAON	Stock	71.72	72.16	70.21	71.11	1063600.0
2023-12-15	AAP	Stock	64.11	64.6	61.89	62.72	2408100.0
2023-12-15	AAT	Stock	23.4	23.57	22.89	23.0	1035900.0
2023-12-15	AATC	Stock	6.85	7.05	6.85	6.85	1568.0
2023-12-15	AAU-DELISTED	Stock	0.1465	0.1465	0.145	0.1451	146396.0
2023-12-15	AAUAF-DELISTED	Stock	0.1465	0.1465	0.145	0.1451	148156.0
2023-12-15	AAXJ	Stock	66.36	66.41	65.77	65.84	689899.0
2023-12-15	AB	Stock	31.8	32.2	31.44	32.02	738300.0
2023-12-15	ABAT	Stock	4.69	5.27	4.68	5.07	3105143.0
2023-12-15	ABBNY-DELISTED	Stock	43.21	43.62	43.2	43.26	474000.0
2023-12-15	ABBV	Stock	154.74	155.89	153.11	154.04	15203000.0
2023-12-15	ABCB	Stock	52.63	53.22	51.72	52.16	1303100.0
2023-12-15	ABCL	Stock	5.58	5.61	5.3	5.43	2436400.0
2023-12-15	ABEO	Stock	4.75	4.88	4.66	4.87	241900.0
2023-12-15	ABEV	Stock	2.91	2.92	2.87	2.88	9296500.0
2023-12-15	ABG	Stock	236.45	237.39	229.52	233.17	424500.0
2023-12-15	ABLLW	Stock	0.58	0.58	0.5	0.5	12552.0
2023-12-15	ABLV	Stock	3.0	3.0	2.88	2.965	9500.0
2023-12-15	ABM	Stock	46.83	46.99	45.45	45.91	1634400.0
2023-12-15	ABNB	Stock	147.26	148.73	145.86	146.6	7771000.0
2023-12-15	ABOS	Stock	3.01	3.07	2.82	2.88	890400.0
2023-12-15	ABR	Stock	15.82	15.88	15.24	15.38	7740700.0
2023-12-15	ABR.D	Stock	17.7298	17.9	17.51	17.6	33931.0
2023-12-15	ABR.E	Stock	18.0683	18.4	18.0	18.3	16763.0
2023-12-15	ABR.F	Stock	18.84	18.84	18.6	18.64	22241.0
2023-12-15	ABSI	Stock	2.76	2.92	2.61	2.73	1583900.0
2023-12-15	ABT	Stock	107.86	107.97	106.51	107.29	13316300.0

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

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