PREVIEW / stock_daily / 2023-09-26

all stock daily files

  file:    by_date/stock_daily/2023/2023-09-26.parquet
  size:    237 KB
  rows:    7,399
  symbols: 1,397

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-09-26	AAPL	Stock	174.82	175.2	171.66	171.96	64588900.0
2023-09-26	MSFT	Stock	315.13	315.88	310.02	312.14	26297600.0
2023-09-26	NVDA	Stock	42.001	42.82	41.655	41.911	402282000.0
2023-09-26	AMZN	Stock	130.12	130.39	125.28	125.98	73048200.0
2023-09-26	GOOGL	Stock	129.77	130.3645	127.22	128.565	25718704.0
2023-09-26	META	Stock	297.66	300.3	296.01	298.96	19417200.0
2023-09-26	TSLA	Stock	242.98	249.55	241.66	244.12	101993600.0
2023-09-26	TLT	Stock	89.43	89.62	88.71	88.87	38104127.0
2023-09-26	ES	Stock	61.67	61.67	59.68	59.71	2234600.0
2023-09-26	CL	Stock	71.98	72.42	71.91	72.0	3789400.0
2023-09-26	A	Stock	110.88	112.25	110.68	110.73	1399800.0
2023-09-26	AA	Stock	26.36	26.75	25.59	25.86	6536800.0
2023-09-26	AAC-DELISTED	Stock	10.76	10.76	10.73	10.75	156816.0
2023-09-26	AACG	Stock	1.15	1.19	1.13	1.13	4400.0
2023-09-26	AACIW-DELISTED	Stock	0.0674	0.0674	0.0674	0.0674	101.0
2023-09-26	AACT	Stock	10.26	10.27	10.26	10.26	33400.0
2023-09-26	AAIC-DELISTED	Stock	4.33	4.35	4.22	4.23	128571.0
2023-09-26	AAIC.C-DELISTED	Stock	24.0	24.0001	23.9899	23.9899	1575.0
2023-09-26	AAL	Stock	12.83	13.04	12.69	12.7	25467700.0
2023-09-26	AAMC-DELISTED	Stock	4.1176	4.1353	4.0059	4.0059	12920.0
2023-09-26	AAME	Stock	1.9	1.9	1.83	1.89	2500.0
2023-09-26	AAMI	Stock	19.66	19.835	19.16	19.25	267400.0
2023-09-26	AAN-DELISTED	Stock	10.43	10.63	10.24	10.29	531200.0
2023-09-26	AAOI	Stock	9.4	9.83	9.35	9.75	1150800.0
2023-09-26	AAON	Stock	56.76	56.9	55.38	55.53	439400.0
2023-09-26	AAP	Stock	56.47	56.47	54.94	54.95	2108700.0
2023-09-26	AAT	Stock	18.82	19.06	18.7	18.87	447500.0
2023-09-26	AATC	Stock	6.12	6.12	6.12	6.12	208.0
2023-09-26	AAU-DELISTED	Stock	0.1252	0.1302	0.1252	0.129	101402.0
2023-09-26	AAUAF-DELISTED	Stock	0.1252	0.1302	0.1252	0.129	102922.0
2023-09-26	AAXJ	Stock	63.46	63.565	63.08	63.13	353313.0
2023-09-26	AB	Stock	31.07	31.43	30.84	30.88	222000.0
2023-09-26	ABAT	Stock	10.0	10.0	9.1	9.18	272227.0
2023-09-26	ABBNY-DELISTED	Stock	35.12	35.24	34.84	34.85	136027.0
2023-09-26	ABBV	Stock	154.4	154.6	153.33	153.91	3936300.0
2023-09-26	ABCB	Stock	37.27	38.05	36.4	37.24	344400.0
2023-09-26	ABCL	Stock	4.75	4.89	4.67	4.7	2347300.0
2023-09-26	ABCM-DELISTED	Stock	22.63	22.74	22.6	22.669	2453722.0
2023-09-26	ABEO	Stock	3.68	4.39	3.68	4.02	273000.0
2023-09-26	ABEV	Stock	2.6	2.63	2.57	2.57	26623900.0
2023-09-26	ABG	Stock	221.53	225.25	220.98	221.56	113900.0
2023-09-26	ABLLW	Stock	0.2797	0.325	0.2797	0.325	8731.0
2023-09-26	ABLV	Stock	3.22	3.49	3.178	3.27	46400.0
2023-09-26	ABM	Stock	39.15	39.58	38.95	38.96	494900.0
2023-09-26	ABNB	Stock	132.78	133.94	131.17	132.28	4194000.0
2023-09-26	ABOS	Stock	4.23	4.41	4.22	4.29	217100.0
2023-09-26	ABR	Stock	14.67	15.0	14.65	14.73	2398000.0
2023-09-26	ABR.D	Stock	18.11	18.33	18.0	18.0	15233.0
2023-09-26	ABR.E	Stock	18.1001	18.11	17.75	17.75	3560.0
2023-09-26	ABR.F	Stock	19.75	19.8	19.3677	19.5	11658.0

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

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