PREVIEW / stock_daily / 2023-08-18

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-18.parquet
  size:    237 KB
  rows:    7,373
  symbols: 1,445

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-08-18	AAPL	Stock	172.3	175.1	171.96	174.49	61114200.0
2023-08-18	MSFT	Stock	314.49	318.38	311.55	316.48	24744800.0
2023-08-18	NVDA	Stock	42.635	43.578	41.66	43.299	583768000.0
2023-08-18	AMZN	Stock	131.62	134.07	131.15	133.22	48469400.0
2023-08-18	GOOGL	Stock	128.51	129.25	126.3824	127.46	30504769.0
2023-08-18	META	Stock	279.03	285.69	274.38	283.25	34061200.0
2023-08-18	TSLA	Stock	214.12	217.58	212.36	215.49	135813700.0
2023-08-18	TLT	Stock	93.43	94.19	93.3015	93.77	24181708.0
2023-08-18	ES	Stock	64.32	64.89	64.28	64.47	1680600.0
2023-08-18	CL	Stock	73.62	74.67	73.53	74.55	3681500.0
2023-08-18	A	Stock	120.19	120.73	119.04	119.25	1803900.0
2023-08-18	AA	Stock	28.45	29.0	28.23	28.97	7344100.0
2023-08-18	AAC-DELISTED	Stock	10.65	10.66	10.62	10.66	137607.0
2023-08-18	AACG	Stock	1.31	1.31	1.22	1.25	8700.0
2023-08-18	AACIW-DELISTED	Stock	0.09	0.0913	0.075	0.075	1510.0
2023-08-18	AACT	Stock	10.21	10.21	10.21	10.21	200.0
2023-08-18	AAIC-DELISTED	Stock	4.35	4.41	4.3305	4.39	54890.0
2023-08-18	AAIC.C-DELISTED	Stock	23.9	24.0	23.9	23.9003	2703.0
2023-08-18	AAL	Stock	14.83	15.15	14.8	15.04	20774600.0
2023-08-18	AAM.A-DELISTED	Stock	25.25	25.25	25.2	25.2	19386.0
2023-08-18	AAM.B-DELISTED	Stock	25.22	25.2532	25.22	25.22	14260.0
2023-08-18	AAMC-DELISTED	Stock	5.8941	6.0529	5.7588	5.8471	60860.0
2023-08-18	AAME	Stock	1.72	1.98	1.72	1.8	3200.0
2023-08-18	AAMI	Stock	20.39	20.91	20.39	20.81	159100.0
2023-08-18	AAN-DELISTED	Stock	12.25	12.53	12.25	12.46	172700.0
2023-08-18	AAOI	Stock	12.59	13.24	11.85	12.8	2909500.0
2023-08-18	AAON	Stock	60.3	62.07	60.0	61.75	416200.0
2023-08-18	AAP	Stock	69.0	70.94	68.68	69.83	1921500.0
2023-08-18	AAT	Stock	20.67	20.99	20.67	20.9	180400.0
2023-08-18	AATC	Stock	5.7	5.72	5.6875	5.72	11552.0
2023-08-18	AAU-DELISTED	Stock	0.1208	0.1209	0.12	0.1201	197327.0
2023-08-18	AAUAF-DELISTED	Stock	0.1208	0.1209	0.12	0.1201	183203.0
2023-08-18	AAXJ	Stock	63.91	64.2	63.7	64.07	1447725.0
2023-08-18	AB	Stock	29.81	31.04	29.75	30.71	347900.0
2023-08-18	ABBNY-DELISTED	Stock	36.64	37.06	36.63	37.0	370679.0
2023-08-18	ABBV	Stock	150.29	150.93	149.23	150.14	4050900.0
2023-08-18	ABC-DELISTED	Stock	179.78	181.76	179.47	180.48	820528.0
2023-08-18	ABCB	Stock	40.76	41.53	40.13	41.13	208900.0
2023-08-18	ABCL	Stock	5.42	5.595	5.41	5.49	1483600.0
2023-08-18	ABCM-DELISTED	Stock	21.51	21.8298	21.465	21.755	711709.0
2023-08-18	ABEO	Stock	3.62	4.1	3.54	3.79	340300.0
2023-08-18	ABEV	Stock	2.82	2.87	2.82	2.86	6939500.0
2023-08-18	ABG	Stock	216.43	222.44	215.5	221.37	100400.0
2023-08-18	ABLLW	Stock	0.2871	0.3437	0.26	0.29	462773.0
2023-08-18	ABLV	Stock	6.38	6.5	4.91	5.5	907920.0
2023-08-18	ABLVW	Stock	0.091	0.091	0.0552	0.0798	1144.0
2023-08-18	ABM	Stock	44.76	45.44	44.57	45.33	304700.0
2023-08-18	ABNB	Stock	124.93	126.08	123.38	125.06	5907800.0
2023-08-18	ABOS	Stock	6.29	6.435	6.209	6.29	340700.0
2023-08-18	ABR	Stock	14.85	15.14	14.7	15.05	3519800.0

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

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