PREVIEW / stock_daily / 2023-05-17

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-17.parquet
  size:    242 KB
  rows:    7,534
  symbols: 1,668

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-05-17	AAPL	Stock	171.71	172.93	170.42	172.69	57951600.0
2023-05-17	MSFT	Stock	312.29	314.43	310.74	314.0	24315000.0
2023-05-17	NVDA	Stock	29.584	30.199	29.43	30.178	432535000.0
2023-05-17	AMZN	Stock	114.89	115.83	114.22	115.5	65655200.0
2023-05-17	GOOGL	Stock	119.61	121.67	118.89	120.84	33323588.0
2023-05-17	META	Stock	238.45	243.84	238.14	242.49	21193100.0
2023-05-17	TSLA	Stock	168.41	174.5	167.19	173.86	125473600.0
2023-05-17	TLT	Stock	103.08	103.16	102.345	102.58	21340887.0
2023-05-17	ES	Stock	74.0	74.29	73.24	74.09	2725100.0
2023-05-17	CL	Stock	80.74	81.07	80.14	80.51	3083000.0
2023-05-17	A	Stock	127.04	127.79	125.78	127.77	1968200.0
2023-05-17	AA	Stock	36.95	37.35	36.192	36.74	4058300.0
2023-05-17	AAC-DELISTED	Stock	10.48	10.48	10.46	10.46	18440.0
2023-05-17	AACG	Stock	1.45	1.57	1.45	1.49	35400.0
2023-05-17	AACIW-DELISTED	Stock	0.11	0.11	0.1095	0.1095	1115.0
2023-05-17	AAIC-DELISTED	Stock	2.5501	2.6	2.54	2.59	36353.0
2023-05-17	AAIC.C-DELISTED	Stock	21.4	21.4	21.4	21.4	100.0
2023-05-17	AAL	Stock	14.4	15.01	14.37	14.91	34905500.0
2023-05-17	AAM.A-DELISTED	Stock	23.17	23.74	22.95	23.6517	7858.0
2023-05-17	AAM.B-DELISTED	Stock	23.0054	24.03	22.8473	23.9001	21660.0
2023-05-17	AAMC-DELISTED	Stock	25.6471	30.4412	25.4778	29.6206	120703.0
2023-05-17	AAME	Stock	2.18	2.22	2.18	2.22	2100.0
2023-05-17	AAMI	Stock	21.79	21.95	21.47	21.94	129200.0
2023-05-17	AAN-DELISTED	Stock	12.27	12.76	12.22	12.71	189500.0
2023-05-17	AAOI	Stock	1.81	1.81	1.72	1.74	116200.0
2023-05-17	AAON	Stock	61.1933	61.8667	60.9	60.9867	382200.0
2023-05-17	AAP	Stock	117.65	122.73	117.65	122.1	1190600.0
2023-05-17	AAT	Stock	18.48	18.91	18.31	18.73	508900.0
2023-05-17	AATC	Stock	4.3	4.3	4.1	4.1	9023.0
2023-05-17	AAU-DELISTED	Stock	0.1125	0.1177	0.1073	0.1159	200165.0
2023-05-17	AAUAF-DELISTED	Stock	0.1125	0.1177	0.1073	0.1165	201521.0
2023-05-17	AAXJ	Stock	65.92	66.33	65.86	66.3	813975.0
2023-05-17	AB	Stock	33.74	33.99	33.56	33.89	224400.0
2023-05-17	ABB-DELISTED	Stock	36.7	37.05	36.61	36.97	1082400.0
2023-05-17	ABBNY-DELISTED	Stock	36.7	37.05	36.61	36.97	1197877.0
2023-05-17	ABBV	Stock	143.02	143.52	140.52	143.35	5482000.0
2023-05-17	ABC-DELISTED	Stock	174.98	175.35	173.255	174.81	898428.0
2023-05-17	ABCB	Stock	29.8	32.01	29.71	31.9	658400.0
2023-05-17	ABCL	Stock	5.7	5.85	5.55	5.84	1965000.0
2023-05-17	ABCM-DELISTED	Stock	17.22	17.455	16.64	17.2	427223.0
2023-05-17	ABEO	Stock	3.01	3.1	2.96	2.96	56800.0
2023-05-17	ABEV	Stock	2.95	2.95	2.9	2.91	9675400.0
2023-05-17	ABG	Stock	199.69	207.28	196.59	205.67	235900.0
2023-05-17	ABLV	Stock	10.49	10.49	10.49	10.49	5107.0
2023-05-17	ABM	Stock	43.96	44.74	43.77	44.59	241000.0
2023-05-17	ABNB	Stock	106.07	109.93	104.94	108.33	6887400.0
2023-05-17	ABOS	Stock	5.57	5.77	5.38	5.45	97700.0
2023-05-17	ABR	Stock	12.62	12.96	12.57	12.87	4508700.0
2023-05-17	ABR.D	Stock	16.89	17.19	16.89	17.15	11369.0
2023-05-17	ABR.E	Stock	16.22	16.93	16.22	16.93	12571.0

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

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