PREVIEW / stock_daily / 2023-03-17

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-17.parquet
  size:    244 KB
  rows:    7,546
  symbols: 1,724

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-03-17	AAPL	Stock	156.08	156.74	154.28	155.0	98944600.0
2023-03-17	MSFT	Stock	278.26	283.33	276.32	279.43	69527400.0
2023-03-17	NVDA	Stock	25.982	26.399	25.668	25.725	848547000.0
2023-03-17	AMZN	Stock	99.79	100.66	97.46	98.95	87300200.0
2023-03-17	GOOGL	Stock	100.26	102.835	100.1	101.62	61028547.0
2023-03-17	META	Stock	200.56	201.9	195.43	195.61	50141100.0
2023-03-17	TSLA	Stock	184.52	186.22	177.33	180.13	133197100.0
2023-03-17	TLT	Stock	106.65	107.73	106.46	106.85	38128985.0
2023-03-17	ES	Stock	76.43	76.93	75.37	75.91	4695700.0
2023-03-17	CL	Stock	73.05	73.05	71.83	72.2	9106100.0
2023-03-17	A	Stock	136.89	136.92	132.73	133.18	2046000.0
2023-03-17	AA	Stock	40.61	40.75	38.901	39.15	10292000.0
2023-03-17	AAC-DELISTED	Stock	10.3	10.3	10.27	10.3	61477.0
2023-03-17	AACG	Stock	1.88	1.96	1.88	1.9	15700.0
2023-03-17	AACIW-DELISTED	Stock	0.0969	0.1099	0.0677	0.1099	2730.0
2023-03-17	AAIC-DELISTED	Stock	2.83	2.83	2.71	2.72	68517.0
2023-03-17	AAL	Stock	13.95	14.17	13.67	13.98	31268800.0
2023-03-17	AAM.A-DELISTED	Stock	21.43	22.1343	21.15	21.3	29542.0
2023-03-17	AAM.B-DELISTED	Stock	22.1	22.1	20.925	21.34	22090.0
2023-03-17	AAMC-DELISTED	Stock	15.4382	15.488	14.6765	14.6765	29532.0
2023-03-17	AAME	Stock	2.49	2.49	2.44	2.49	2000.0
2023-03-17	AAMI	Stock	22.47	22.49	21.68	21.73	718300.0
2023-03-17	AAN-DELISTED	Stock	9.88	9.94	9.39	9.46	657700.0
2023-03-17	AAOI	Stock	2.47	2.55	2.3	2.36	341300.0
2023-03-17	AAON	Stock	60.58	60.6	59.1467	59.5533	918000.0
2023-03-17	AAP	Stock	122.01	122.01	117.89	119.4	4335100.0
2023-03-17	AAT	Stock	18.46	18.58	17.33	17.4	2191600.0
2023-03-17	AATC	Stock	4.15	4.15	4.07	4.07	4169.0
2023-03-17	AAU-DELISTED	Stock	0.2	0.2139	0.1919	0.2065	412471.0
2023-03-17	AAUAF-DELISTED	Stock	0.2	0.2139	0.1919	0.2064	415487.0
2023-03-17	AAWW-DELISTED	Stock	102.48	102.5	102.47	102.48	1397528.0
2023-03-17	AAXJ	Stock	64.94	65.15	64.56	64.77	324051.0
2023-03-17	AB	Stock	34.85	35.35	34.77	34.98	515600.0
2023-03-17	ABB-DELISTED	Stock	32.07	32.24	31.825	31.99	1929394.0
2023-03-17	ABBNY-DELISTED	Stock	32.07	32.24	31.825	31.99	2121237.0
2023-03-17	ABBV	Stock	155.78	156.07	151.88	154.22	42756400.0
2023-03-17	ABC-DELISTED	Stock	151.86	152.55	150.4	152.01	2243357.0
2023-03-17	ABCB	Stock	37.36	37.7	35.51	35.79	1572200.0
2023-03-17	ABCL	Stock	7.45	7.57	7.295	7.39	3021900.0
2023-03-17	ABCM-DELISTED	Stock	14.3	14.3	13.7	13.92	1078125.0
2023-03-17	ABEO	Stock	2.55	2.55	2.35	2.39	325800.0
2023-03-17	ABEV	Stock	2.65	2.71	2.65	2.69	16728500.0
2023-03-17	ABG	Stock	200.88	200.88	190.76	196.04	693000.0
2023-03-17	ABM	Stock	44.52	44.58	43.46	43.73	1145500.0
2023-03-17	ABNB	Stock	119.715	119.96	116.55	118.15	5513600.0
2023-03-17	ABOS	Stock	4.09	4.09	3.85	3.87	127500.0
2023-03-17	ABR	Stock	11.79	11.79	11.07	11.19	7068600.0
2023-03-17	ABR.D	Stock	16.64	16.64	16.2	16.25	38887.0
2023-03-17	ABR.E	Stock	16.22	16.22	15.9	16.0	26562.0
2023-03-17	ABR.F	Stock	18.33	18.46	17.6	17.67	10556.0

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

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