PREVIEW / stock_daily / 2023-04-10

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-10.parquet
  size:    243 KB
  rows:    7,548
  symbols: 1,688

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-04-10	AAPL	Stock	161.42	162.03	160.08	162.03	47716900.0
2023-04-10	MSFT	Stock	289.21	289.6	284.71	289.39	23103000.0
2023-04-10	NVDA	Stock	26.823	27.621	26.669	27.579	395279000.0
2023-04-10	AMZN	Stock	100.96	102.2	99.57	102.17	37261200.0
2023-04-10	GOOGL	Stock	106.98	107.59	105.12	106.44	27067355.0
2023-04-10	META	Stock	214.71	215.66	210.66	214.75	16106100.0
2023-04-10	TSLA	Stock	179.94	185.1	176.11	184.51	142154600.0
2023-04-10	TLT	Stock	107.64	107.7618	106.56	106.78	19134399.0
2023-04-10	ES	Stock	80.41	80.53	79.44	80.46	1179900.0
2023-04-10	CL	Stock	75.17	75.33	74.62	75.14	2735100.0
2023-04-10	A	Stock	137.38	138.08	135.86	138.02	1104600.0
2023-04-10	AA	Stock	39.16	40.15	39.0	39.78	2452000.0
2023-04-10	AAC-DELISTED	Stock	10.32	10.36	10.32	10.345	271429.0
2023-04-10	AACG	Stock	1.83	1.9	1.81	1.83	17500.0
2023-04-10	AACIW-DELISTED	Stock	0.107	0.107	0.107	0.107	180.0
2023-04-10	AAIC-DELISTED	Stock	2.73	2.74	2.71	2.71	18372.0
2023-04-10	AAIC.C-DELISTED	Stock	21.3	21.3	21.25	21.25	5044.0
2023-04-10	AAL	Stock	13.98	14.17	13.91	14.15	18832300.0
2023-04-10	AAM.A-DELISTED	Stock	22.7396	23.05	22.6237	23.0099	11318.0
2023-04-10	AAM.B-DELISTED	Stock	23.18	23.3496	22.3401	23.08	7366.0
2023-04-10	AAMC-DELISTED	Stock	18.7515	20.8559	18.7515	20.2279	69754.0
2023-04-10	AAME	Stock	2.44	2.48	2.44	2.48	2100.0
2023-04-10	AAMI	Stock	22.23	22.93	22.23	22.79	124200.0
2023-04-10	AAN-DELISTED	Stock	9.9	10.485	9.9	10.21	854000.0
2023-04-10	AAOI	Stock	2.12	2.235	2.11	2.22	62900.0
2023-04-10	AAON	Stock	61.3667	63.0933	60.5533	62.84	647550.0
2023-04-10	AAP	Stock	120.09	121.54	119.93	120.39	918700.0
2023-04-10	AAT	Stock	18.54	18.65	17.74	18.22	574500.0
2023-04-10	AATC	Stock	3.945	3.945	3.93	3.94	4399.0
2023-04-10	AAU-DELISTED	Stock	0.19	0.1998	0.1888	0.19	138626.0
2023-04-10	AAUAF-DELISTED	Stock	0.19	0.1998	0.1888	0.19	140539.0
2023-04-10	AAXJ	Stock	67.72	67.91	67.49	67.9	815393.0
2023-04-10	AB	Stock	33.86	34.57	33.86	34.21	584300.0
2023-04-10	ABB-DELISTED	Stock	32.91	33.168	32.54	33.14	920822.0
2023-04-10	ABBNY-DELISTED	Stock	32.91	33.168	32.54	33.15	1054356.0
2023-04-10	ABBV	Stock	161.71	162.06	160.21	161.28	3309500.0
2023-04-10	ABC-DELISTED	Stock	165.85	167.455	165.79	166.42	453502.0
2023-04-10	ABCB	Stock	34.05	35.03	34.01	34.76	487300.0
2023-04-10	ABCL	Stock	7.2	7.24	7.065	7.2	1533000.0
2023-04-10	ABCM-DELISTED	Stock	12.77	13.2	12.72	13.08	275408.0
2023-04-10	ABEO	Stock	2.84	2.84	2.73	2.83	54300.0
2023-04-10	ABEV	Stock	2.82	2.84	2.8	2.82	12889300.0
2023-04-10	ABG	Stock	193.14	200.2	191.56	196.46	154700.0
2023-04-10	ABM	Stock	43.69	44.15	43.56	43.91	296200.0
2023-04-10	ABNB	Stock	108.69	112.63	108.4	112.6	5406400.0
2023-04-10	ABOS	Stock	3.77	3.925	3.7	3.83	269800.0
2023-04-10	ABR	Stock	10.91	10.95	10.26	10.66	9976000.0
2023-04-10	ABR.D	Stock	18.13	18.13	17.8	17.9287	17880.0
2023-04-10	ABR.E	Stock	17.7	18.05	17.58	17.8404	61025.0
2023-04-10	ABR.F	Stock	18.05	18.2777	17.92	17.96	60965.0

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

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