PREVIEW / stock_daily / 2023-11-28

all stock daily files

  file:    by_date/stock_daily/2023/2023-11-28.parquet
  size:    236 KB
  rows:    7,388
  symbols: 1,294

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-11-28	AAPL	Stock	189.78	191.08	189.4	190.4	38415400.0
2023-11-28	MSFT	Stock	378.35	383.0	378.16	382.7	20453100.0
2023-11-28	NVDA	Stock	48.236	48.323	47.473	47.821	401491000.0
2023-11-28	AMZN	Stock	146.98	147.6	145.53	147.03	42711700.0
2023-11-28	GOOGL	Stock	136.08	137.25	135.4222	137.2	18730032.0
2023-11-28	META	Stock	333.4	339.38	333.4	338.99	12637200.0
2023-11-28	TSLA	Stock	236.68	247.0	234.01	246.72	148549900.0
2023-11-28	TLT	Stock	90.91	91.53	90.785	91.48	44989267.0
2023-11-28	ES	Stock	59.1	60.23	58.81	59.93	2586800.0
2023-11-28	CL	Stock	77.3	78.0	77.08	77.87	3471200.0
2023-11-28	A	Stock	124.64	126.27	124.1	124.71	1949800.0
2023-11-28	AA	Stock	26.22	26.29	25.64	26.08	4382400.0
2023-11-28	AACG	Stock	0.87	0.96	0.8	0.95	4000.0
2023-11-28	AACIW-DELISTED	Stock	0.05	0.05	0.0351	0.0351	500.0
2023-11-28	AACT	Stock	10.37	10.37	10.36	10.36	299600.0
2023-11-28	AAIC-DELISTED	Stock	4.65	4.68	4.63	4.67	51771.0
2023-11-28	AAIC.C-DELISTED	Stock	24.14	24.36	24.1347	24.15	4700.0
2023-11-28	AAL	Stock	12.19	12.26	11.95	12.17	33964600.0
2023-11-28	AAMC-DELISTED	Stock	3.04	3.2	3.04	3.1	14200.0
2023-11-28	AAME	Stock	2.07	2.09	2.0	2.0	3200.0
2023-11-28	AAMI	Stock	17.66	17.97	17.46	17.71	89800.0
2023-11-28	AAN-DELISTED	Stock	8.97	9.07	8.885	8.99	280400.0
2023-11-28	AAOI	Stock	14.61	15.2	13.88	14.61	2960500.0
2023-11-28	AAON	Stock	63.52	63.83	61.86	61.91	316800.0
2023-11-28	AAP	Stock	50.86	51.76	50.55	51.64	1423500.0
2023-11-28	AAT	Stock	18.95	19.58	18.78	19.57	384500.0
2023-11-28	AATC	Stock	6.32	6.445	6.255	6.33	17177.0
2023-11-28	AAU-DELISTED	Stock	0.14	0.1425	0.14	0.1411	94235.0
2023-11-28	AAUAF-DELISTED	Stock	0.14	0.1425	0.14	0.1411	99432.0
2023-11-28	AAXJ	Stock	65.58	65.92	65.54	65.84	594840.0
2023-11-28	AB	Stock	27.86	28.68	27.71	28.26	358500.0
2023-11-28	ABAT	Stock	4.1	4.33	3.95	4.3	348167.0
2023-11-28	ABBNY-DELISTED	Stock	38.53	38.708	38.44	38.5	160817.0
2023-11-28	ABBV	Stock	139.05	139.66	137.92	138.08	5347200.0
2023-11-28	ABCB	Stock	42.25	42.43	41.86	42.09	179500.0
2023-11-28	ABCL	Stock	4.6	4.8	4.4	4.73	2338400.0
2023-11-28	ABCM-DELISTED	Stock	23.94	23.96	23.94	23.95	4888870.0
2023-11-28	ABEO	Stock	4.93	5.01	4.66	4.96	331100.0
2023-11-28	ABEV	Stock	2.78	2.82	2.77	2.79	6458800.0
2023-11-28	ABG	Stock	208.8	211.94	206.39	209.18	112800.0
2023-11-28	ABLLW	Stock	0.38	0.4	0.38	0.3849	6242.0
2023-11-28	ABLV	Stock	2.8	2.92	2.8	2.84	9100.0
2023-11-28	ABM	Stock	40.5	41.3	40.23	40.83	496100.0
2023-11-28	ABNB	Stock	128.79	129.54	125.85	127.56	4024400.0
2023-11-28	ABOS	Stock	2.36	2.36	2.19	2.26	320900.0
2023-11-28	ABR	Stock	12.12	12.13	11.77	12.06	7220300.0
2023-11-28	ABR.D	Stock	16.7	16.8099	16.615	16.76	13369.0
2023-11-28	ABR.E	Stock	16.81	16.85	16.52	16.62	13905.0
2023-11-28	ABR.F	Stock	18.6	18.66	18.5	18.61	12337.0
2023-11-28	ABSI	Stock	1.4	1.52	1.35	1.52	423100.0

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

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