PREVIEW / stock_daily / 2023-01-04

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-04.parquet
  size:    248 KB
  rows:    7,705
  symbols: 1,950

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-01-04	AAPL	Stock	126.89	128.66	125.08	126.36	89113600.0
2023-01-04	MSFT	Stock	232.28	232.87	225.96	229.1	50623400.0
2023-01-04	NVDA	Stock	14.567	14.853	14.241	14.749	431324000.0
2023-01-04	AMZN	Stock	86.55	86.98	83.36	85.14	68885100.0
2023-01-04	GOOGL	Stock	90.35	90.65	87.271	88.08	34854776.0
2023-01-04	META	Stock	127.38	129.05	125.85	127.37	32397100.0
2023-01-04	TSLA	Stock	109.11	114.59	107.52	113.64	180389000.0
2023-01-04	TLT	Stock	103.22	103.475	102.21	102.85	21678210.0
2023-01-04	ES	Stock	84.88	85.84	84.58	85.33	1502200.0
2023-01-04	CL	Stock	79.2	80.13	79.19	79.64	3976800.0
2023-01-04	A	Stock	151.65	153.04	150.24	151.67	1247400.0
2023-01-04	AA	Stock	44.77	45.9	44.371	45.13	3523400.0
2023-01-04	AAC-DELISTED	Stock	10.12	10.12	10.1	10.11	1526302.0
2023-01-04	AACG	Stock	1.28	1.28	1.25	1.27	1400.0
2023-01-04	AACIW-DELISTED	Stock	0.05	0.05	0.015	0.015	2795.0
2023-01-04	AAIC-DELISTED	Stock	2.95	2.9599	2.94	2.955	25192.0
2023-01-04	AAIC.C-DELISTED	Stock	21.145	21.35	21.03	21.29	3118.0
2023-01-04	AAL	Stock	12.86	13.61	12.86	13.59	34359100.0
2023-01-04	AAM.A-DELISTED	Stock	22.0	22.91	22.0	22.815	26097.0
2023-01-04	AAM.B-DELISTED	Stock	22.09	22.44	22.0305	22.44	10855.0
2023-01-04	AAMC-DELISTED	Stock	5.8912	6.0147	5.8824	6.0147	32541.0
2023-01-04	AAME	Stock	2.35	2.49	2.35	2.43	2800.0
2023-01-04	AAMI	Stock	20.72	20.76	19.98	20.06	400200.0
2023-01-04	AAN-DELISTED	Stock	12.06	12.71	11.93	12.7	335000.0
2023-01-04	AAOI	Stock	1.9	1.95	1.88	1.92	114900.0
2023-01-04	AAON	Stock	50.1667	50.38	46.9733	47.78	455100.0
2023-01-04	AAP	Stock	152.73	154.5	150.89	151.89	834200.0
2023-01-04	AAT	Stock	26.89	27.28	26.62	26.96	249700.0
2023-01-04	AATC	Stock	3.5	3.55	3.45	3.52	75699.0
2023-01-04	AAU-DELISTED	Stock	0.2588	0.2668	0.2531	0.257	184110.0
2023-01-04	AAUAF-DELISTED	Stock	0.2588	0.2668	0.2531	0.257	198968.0
2023-01-04	AAWW-DELISTED	Stock	101.1	101.5	101.1	101.3	185533.0
2023-01-04	AAXJ	Stock	67.05	67.97	66.71	67.92	515238.0
2023-01-04	AB	Stock	35.37	36.09	35.17	35.89	334400.0
2023-01-04	ABB-DELISTED	Stock	32.04	32.1	31.62	32.07	2040050.0
2023-01-04	ABBNY-DELISTED	Stock	32.04	32.1	31.62	32.07	2225350.0
2023-01-04	ABBV	Stock	162.4	164.28	161.51	163.69	4440400.0
2023-01-04	ABC-DELISTED	Stock	164.72	164.91	161.85	162.88	1396792.0
2023-01-04	ABCB	Stock	46.66	47.36	46.21	46.49	232500.0
2023-01-04	ABCL	Stock	9.58	9.6	9.25	9.37	1455700.0
2023-01-04	ABCM-DELISTED	Stock	15.54	17.01	15.54	17.0	499631.0
2023-01-04	ABEO	Stock	2.85	3.08	2.82	3.06	170100.0
2023-01-04	ABEV	Stock	2.59	2.65	2.58	2.61	25771600.0
2023-01-04	ABG	Stock	176.71	180.85	176.71	179.34	173900.0
2023-01-04	ABGI-DELISTED	Stock	10.09	10.1	10.09	10.09	32746.0
2023-01-04	ABLV	Stock	10.22	10.22	10.17	10.17	101453.0
2023-01-04	ABM	Stock	45.12	45.56	44.8	44.97	236000.0
2023-01-04	ABNB	Stock	85.89	88.84	84.79	88.72	4817100.0
2023-01-04	ABOS	Stock	5.19	5.57	5.19	5.46	42600.0
2023-01-04	ABR	Stock	13.75	13.94	13.68	13.81	1641100.0

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

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