PREVIEW / stock_daily / 2023-08-25

all stock daily files

  file:    by_date/stock_daily/2023/2023-08-25.parquet
  size:    236 KB
  rows:    7,337
  symbols: 1,416

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-25	AAPL	Stock	177.38	179.15	175.82	178.61	51449600.0
2023-08-25	MSFT	Stock	321.47	325.36	318.8	322.98	21684100.0
2023-08-25	NVDA	Stock	47.012	47.805	45.024	46.018	925341000.0
2023-08-25	AMZN	Stock	132.47	133.87	130.58	133.26	44147500.0
2023-08-25	GOOGL	Stock	129.54	130.76	127.25	129.88	26762891.0
2023-08-25	META	Stock	286.13	288.39	276.03	285.5	23701400.0
2023-08-25	TSLA	Stock	231.31	239.0	230.35	238.59	106612200.0
2023-08-25	TLT	Stock	94.66	95.51	94.51	95.22	23865213.0
2023-08-25	ES	Stock	64.2	65.7	64.04	65.17	2271700.0
2023-08-25	CL	Stock	73.48	74.11	73.25	73.83	2663300.0
2023-08-25	A	Stock	119.8	120.82	118.52	119.68	1273300.0
2023-08-25	AA	Stock	28.82	29.075	27.76	28.23	5398300.0
2023-08-25	AAC-DELISTED	Stock	10.69	10.69	10.67	10.69	9656.0
2023-08-25	AACG	Stock	1.23	1.23	1.23	1.23	1100.0
2023-08-25	AACIW-DELISTED	Stock	0.0781	0.0781	0.0781	0.0781	100.0
2023-08-25	AACT	Stock	10.2	10.23	10.19	10.22	3901300.0
2023-08-25	AAIC-DELISTED	Stock	4.46	4.49	4.42	4.47	26857.0
2023-08-25	AAIC.C-DELISTED	Stock	23.95	23.95	23.84	23.84	1500.0
2023-08-25	AAL	Stock	14.65	14.71	14.42	14.58	15560800.0
2023-08-25	AAM.A-DELISTED	Stock	25.31	25.335	25.31	25.33	36349.0
2023-08-25	AAM.B-DELISTED	Stock	25.31	25.33	25.31	25.32	7844.0
2023-08-25	AAMC-DELISTED	Stock	4.8824	5.3529	4.8824	5.05	64430.0
2023-08-25	AAME	Stock	1.96	2.04	1.92	2.0	1900.0
2023-08-25	AAMI	Stock	21.24	21.36	20.86	21.17	71100.0
2023-08-25	AAN-DELISTED	Stock	11.95	12.08	11.79	11.87	122800.0
2023-08-25	AAOI	Stock	13.8	14.09	12.79	12.99	2317700.0
2023-08-25	AAON	Stock	60.25	61.09	59.56	60.7	170600.0
2023-08-25	AAP	Stock	67.64	67.72	63.09	64.08	5347300.0
2023-08-25	AAT	Stock	20.94	21.12	20.78	20.79	113100.0
2023-08-25	AATC	Stock	6.0	6.08	5.91	6.06	9628.0
2023-08-25	AAU-DELISTED	Stock	0.121	0.1235	0.1195	0.1209	366986.0
2023-08-25	AAUAF-DELISTED	Stock	0.121	0.1235	0.1195	0.12	367740.0
2023-08-25	AAXJ	Stock	64.75	64.87	64.24	64.8	353554.0
2023-08-25	AB	Stock	30.06	30.84	30.06	30.37	195800.0
2023-08-25	ABBNY-DELISTED	Stock	37.21	37.49	36.975	37.22	137797.0
2023-08-25	ABBV	Stock	147.02	147.67	146.2	146.69	3275100.0
2023-08-25	ABC-DELISTED	Stock	179.09	180.005	178.63	179.48	704900.0
2023-08-25	ABCB	Stock	39.83	40.11	38.74	39.44	231500.0
2023-08-25	ABCL	Stock	5.51	5.59	5.395	5.51	1317000.0
2023-08-25	ABCM-DELISTED	Stock	22.5	24.52	22.22	23.35	6660901.0
2023-08-25	ABEO	Stock	3.93	4.04	3.88	3.93	51700.0
2023-08-25	ABEV	Stock	2.85	2.87	2.78	2.86	22352700.0
2023-08-25	ABG	Stock	219.15	220.82	214.49	218.7	102400.0
2023-08-25	ABLLW	Stock	0.3599	0.38	0.35	0.37	148059.0
2023-08-25	ABLV	Stock	5.0	5.15	4.7	4.7	88548.0
2023-08-25	ABM	Stock	45.62	45.96	45.47	45.54	239100.0
2023-08-25	ABNB	Stock	125.04	126.6	124.19	125.79	2415200.0
2023-08-25	ABOS	Stock	6.07	6.31	5.9	6.3	260900.0
2023-08-25	ABR	Stock	15.49	15.69	15.23	15.55	1837200.0
2023-08-25	ABR.E	Stock	18.5	18.5	18.5	18.5	569.0

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

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