PREVIEW / stock_daily / 2023-12-27

all stock daily files

  file:    by_date/stock_daily/2023/2023-12-27.parquet
  size:    236 KB
  rows:    7,369
  symbols: 1,229

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-27	AAPL	Stock	192.49	193.5	191.09	193.15	48087700.0
2023-12-27	MSFT	Stock	373.69	375.06	372.81	374.07	14905400.0
2023-12-27	NVDA	Stock	49.511	49.68	49.085	49.417	233648000.0
2023-12-27	AMZN	Stock	153.56	154.78	153.12	153.34	31434700.0
2023-12-27	GOOGL	Stock	141.59	142.08	139.886	140.37	19628618.0
2023-12-27	META	Stock	356.07	359.0	355.31	357.83	13207900.0
2023-12-27	TSLA	Stock	258.35	263.34	257.52	261.44	106494400.0
2023-12-27	TLT	Stock	99.78	100.53	99.5	100.51	45082814.0
2023-12-27	ES	Stock	61.43	61.63	61.02	61.36	1318500.0
2023-12-27	CL	Stock	78.69	79.24	78.53	79.1	3268700.0
2023-12-27	A	Stock	139.78	140.16	139.08	139.82	1182300.0
2023-12-27	AA	Stock	34.23	35.035	33.75	34.81	5798100.0
2023-12-27	AACG	Stock	0.85	1.19	0.85	1.05	101600.0
2023-12-27	AACIW-DELISTED	Stock	0.025	0.025	0.025	0.025	500.0
2023-12-27	AACT	Stock	10.42	10.42	10.42	10.42	67500.0
2023-12-27	AAGR-DELISTED	Stock	1.25	1.43	1.2	1.23	1802404.0
2023-12-27	AAGRW-DELISTED	Stock	0.02	0.025	0.0189	0.0237	40500.0
2023-12-27	AAL	Stock	14.1	14.18	13.91	13.99	23428500.0
2023-12-27	AAMC-DELISTED	Stock	4.44	4.8	4.359	4.53	34400.0
2023-12-27	AAME	Stock	2.1	2.18	2.01	2.16	7200.0
2023-12-27	AAMI	Stock	19.03	19.26	18.72	19.18	494000.0
2023-12-27	AAN-DELISTED	Stock	11.25	11.38	11.1	11.18	230400.0
2023-12-27	AAOI	Stock	22.88	22.95	21.85	22.52	1974100.0
2023-12-27	AAON	Stock	74.44	75.24	73.88	74.21	215100.0
2023-12-27	AAP	Stock	61.22	61.56	60.9	61.56	1287900.0
2023-12-27	AAT	Stock	23.07	23.13	22.79	22.87	191100.0
2023-12-27	AATC	Stock	6.75	6.94	6.75	6.94	6639.0
2023-12-27	AAU-DELISTED	Stock	0.145	0.1463	0.145	0.1454	235684.0
2023-12-27	AAUAF-DELISTED	Stock	0.145	0.1463	0.145	0.1454	237072.0
2023-12-27	AAXJ	Stock	65.71	65.83	65.53	65.73	1208181.0
2023-12-27	AB	Stock	31.23	31.86	31.2	31.33	283000.0
2023-12-27	ABAT	Stock	5.0	5.065	4.87	4.925	337663.0
2023-12-27	ABBNY-DELISTED	Stock	43.81	44.36	43.72	44.17	111303.0
2023-12-27	ABBV	Stock	154.05	154.97	153.72	154.88	3747400.0
2023-12-27	ABCB	Stock	53.7	53.84	52.94	53.74	216300.0
2023-12-27	ABCL	Stock	5.82	5.89	5.7	5.8	1013700.0
2023-12-27	ABEO	Stock	5.16	5.19	5.0	5.12	576400.0
2023-12-27	ABEV	Stock	2.81	2.85	2.81	2.84	5165100.0
2023-12-27	ABG	Stock	224.43	226.72	221.53	223.99	160500.0
2023-12-27	ABLLW	Stock	0.62	0.62	0.5601	0.61	15145.0
2023-12-27	ABLV	Stock	2.75	2.85	2.7	2.85	39200.0
2023-12-27	ABLVW	Stock	0.0252	0.0262	0.01	0.0198	35572.0
2023-12-27	ABM	Stock	45.73	45.94	45.08	45.36	464900.0
2023-12-27	ABNB	Stock	139.135	139.135	136.05	136.55	3989600.0
2023-12-27	ABOS	Stock	3.74	3.85	3.67	3.84	327900.0
2023-12-27	ABR	Stock	16.2	16.35	16.01	16.09	3409800.0
2023-12-27	ABR.D	Stock	17.9	18.025	17.65	17.73	59057.0
2023-12-27	ABR.E	Stock	17.8	17.85	17.61	17.68	16361.0
2023-12-27	ABR.F	Stock	18.78	18.9426	18.71	18.81	13910.0
2023-12-27	ABSI	Stock	4.17	5.226	4.05	4.79	3308700.0

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

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