PREVIEW / stock_daily / 2023-12-19

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-19.parquet
  size:    238 KB
  rows:    7,384
  symbols: 1,257

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-19	AAPL	Stock	196.16	196.95	195.89	196.94	40714100.0
2023-12-19	MSFT	Stock	371.49	373.26	369.84	373.26	20603700.0
2023-12-19	NVDA	Stock	49.424	49.7	48.895	49.604	464444000.0
2023-12-19	AMZN	Stock	154.4	155.12	152.69	153.79	43171300.0
2023-12-19	GOOGL	Stock	136.84	137.47	136.08	136.65	25476753.0
2023-12-19	META	Stock	345.58	353.6	345.12	350.36	17729400.0
2023-12-19	TSLA	Stock	253.48	258.34	253.01	257.22	106737400.0
2023-12-19	TLT	Stock	98.855	99.26	98.66	98.89	30018415.0
2023-12-19	ES	Stock	62.41	62.41	61.38	61.6	2339600.0
2023-12-19	CL	Stock	78.01	78.56	77.83	78.13	3370700.0
2023-12-19	A	Stock	138.51	139.89	137.32	139.79	1523300.0
2023-12-19	AA	Stock	31.19	33.0	30.91	32.42	7967200.0
2023-12-19	AACG	Stock	0.87	0.87	0.83	0.85	22100.0
2023-12-19	AACT	Stock	10.41	10.615	10.41	10.44	54100.0
2023-12-19	AAGR-DELISTED	Stock	0.4611	0.95	0.458	0.77	11649903.0
2023-12-19	AAGRW-DELISTED	Stock	0.033	0.041	0.033	0.036	11836.0
2023-12-19	AAL	Stock	14.38	14.45	14.28	14.3	22574300.0
2023-12-19	AAMC-DELISTED	Stock	5.0	5.08	4.7	4.7	23300.0
2023-12-19	AAME	Stock	2.03	2.03	2.03	2.03	2600.0
2023-12-19	AAMI	Stock	19.65	19.92	19.645	19.71	128400.0
2023-12-19	AAN-DELISTED	Stock	11.19	11.28	11.01	11.19	315000.0
2023-12-19	AAOI	Stock	22.92	24.08	22.12	23.01	2993400.0
2023-12-19	AAON	Stock	71.1	72.51	71.1	72.36	611400.0
2023-12-19	AAP	Stock	61.07	61.9	60.34	60.86	1868900.0
2023-12-19	AAT	Stock	22.76	22.95	22.66	22.67	522000.0
2023-12-19	AATC	Stock	7.212	7.25	6.77	7.21	16306.0
2023-12-19	AAU-DELISTED	Stock	0.147	0.15	0.145	0.1483	225547.0
2023-12-19	AAUAF-DELISTED	Stock	0.147	0.15	0.145	0.1482	227352.0
2023-12-19	AAXJ	Stock	65.94	66.41	65.94	66.35	697997.0
2023-12-19	AB	Stock	32.25	32.95	32.04	32.75	570600.0
2023-12-19	ABAT	Stock	5.92	6.35	5.675	6.31	1337587.0
2023-12-19	ABBNY-DELISTED	Stock	43.48	43.79	43.45	43.72	412114.0
2023-12-19	ABBV	Stock	153.59	154.48	152.45	153.6	5476700.0
2023-12-19	ABCB	Stock	51.51	52.92	51.5	52.48	629700.0
2023-12-19	ABCL	Stock	5.37	5.74	5.361	5.68	1724300.0
2023-12-19	ABEO	Stock	4.79	4.79	4.62	4.72	208300.0
2023-12-19	ABEV	Stock	2.98	3.0	2.97	2.98	9883500.0
2023-12-19	ABG	Stock	225.48	227.45	222.67	225.55	346000.0
2023-12-19	ABLLW	Stock	0.56	0.58	0.55	0.57	34824.0
2023-12-19	ABLV	Stock	2.899	2.899	2.899	2.899	800.0
2023-12-19	ABM	Stock	46.04	46.83	46.03	46.63	387400.0
2023-12-19	ABNB	Stock	147.5	148.61	146.68	146.91	5090400.0
2023-12-19	ABOS	Stock	2.84	3.2	2.84	3.2	525800.0
2023-12-19	ABR	Stock	15.53	16.23	15.51	16.1	6612600.0
2023-12-19	ABR.D	Stock	17.858	18.15	17.858	18.11	39972.0
2023-12-19	ABR.E	Stock	18.02	18.72	18.02	18.72	5405.0
2023-12-19	ABR.F	Stock	18.69	18.74	18.55	18.72	39563.0
2023-12-19	ABSI	Stock	3.01	3.16	2.78	3.14	1204700.0
2023-12-19	ABT	Stock	108.15	108.72	107.43	108.42	4675100.0
2023-12-19	ABTC	Stock	433.5	472.5	406.5	465.0	203.73333333333332

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

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