PREVIEW / stock_daily / 2023-05-10

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-10.parquet
  size:    242 KB
  rows:    7,513
  symbols: 1,650

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-10	AAPL	Stock	173.02	174.03	171.9	173.56	53724500.0
2023-05-10	MSFT	Stock	308.62	313.0	307.67	312.31	30078000.0
2023-05-10	NVDA	Stock	29.005	29.113	28.461	28.885	369350000.0
2023-05-10	AMZN	Stock	108.1	110.67	108.05	110.19	78627600.0
2023-05-10	GOOGL	Stock	107.97	112.94	107.93	111.75	63153367.0
2023-05-10	META	Stock	236.17	236.75	230.72	233.08	19119000.0
2023-05-10	TSLA	Stock	172.55	174.43	166.68	168.54	119840700.0
2023-05-10	TLT	Stock	103.67	104.24	103.64	104.05	22886805.0
2023-05-10	ES	Stock	77.05	77.17	76.02	76.98	1844500.0
2023-05-10	CL	Stock	80.55	81.33	80.35	81.1	5094400.0
2023-05-10	A	Stock	128.71	128.9	126.16	128.06	1255700.0
2023-05-10	AA	Stock	37.14	37.22	35.38	36.14	2961200.0
2023-05-10	AAC-DELISTED	Stock	10.41	10.45	10.41	10.43	5771.0
2023-05-10	AACG	Stock	1.73	1.87	1.73	1.75	4800.0
2023-05-10	AACIU	Stock	10.27	10.27	10.24	10.24	400.0
2023-05-10	AAIC-DELISTED	Stock	2.67	2.67	2.59	2.6	17222.0
2023-05-10	AAL	Stock	14.67	14.7	14.05	14.34	21469100.0
2023-05-10	AAM.A-DELISTED	Stock	24.29	24.29	23.8854	24.0	10205.0
2023-05-10	AAM.B-DELISTED	Stock	23.5	24.3919	23.5	24.15	34676.0
2023-05-10	AAMC-DELISTED	Stock	25.5882	26.1471	24.8199	25.0588	72236.0
2023-05-10	AAME	Stock	2.2	2.23	2.2	2.2	1200.0
2023-05-10	AAMI	Stock	22.46	22.48	21.615	22.02	163800.0
2023-05-10	AAN-DELISTED	Stock	12.75	12.93	12.54	12.62	295700.0
2023-05-10	AAOI	Stock	1.85	1.92	1.81	1.85	238400.0
2023-05-10	AAON	Stock	64.92	65.2067	63.8933	64.76	260400.0
2023-05-10	AAP	Stock	127.31	127.31	124.6	125.8	751000.0
2023-05-10	AAT	Stock	19.18	19.29	18.67	18.94	304400.0
2023-05-10	AATC	Stock	4.0	4.02	3.95	4.02	2072.0
2023-05-10	AAU-DELISTED	Stock	0.127	0.127	0.1179	0.119	266761.0
2023-05-10	AAUAF-DELISTED	Stock	0.127	0.127	0.1179	0.119	259068.0
2023-05-10	AAXJ	Stock	66.44	66.62	66.11	66.45	309702.0
2023-05-10	AB	Stock	34.13	34.99	33.11	34.86	466300.0
2023-05-10	ABB-DELISTED	Stock	36.69	36.69	36.22	36.45	1980434.0
2023-05-10	ABBNY-DELISTED	Stock	36.69	36.69	36.22	36.46	2149563.0
2023-05-10	ABBV	Stock	146.52	146.98	145.15	146.42	4127300.0
2023-05-10	ABC-DELISTED	Stock	168.29	169.6	167.03	169.48	514026.0
2023-05-10	ABCB	Stock	30.05	30.54	28.81	29.23	371600.0
2023-05-10	ABCL	Stock	5.75	5.89	5.55	5.89	3066900.0
2023-05-10	ABCM-DELISTED	Stock	17.9	18.2059	17.12	17.68	918297.0
2023-05-10	ABEO	Stock	3.18	3.34	3.14	3.2	103000.0
2023-05-10	ABEV	Stock	2.88	2.9	2.85	2.88	14269000.0
2023-05-10	ABG	Stock	206.25	208.47	203.1	204.18	191900.0
2023-05-10	ABM	Stock	43.1	43.15	42.49	42.8	178000.0
2023-05-10	ABNB	Stock	109.85	115.51	109.37	113.19	34191000.0
2023-05-10	ABOS	Stock	5.75	6.67	5.48	6.59	410800.0
2023-05-10	ABR	Stock	12.52	12.55	12.1	12.23	3664100.0
2023-05-10	ABR.D	Stock	18.05	18.05	17.37	17.4514	8623.0
2023-05-10	ABR.E	Stock	17.01	17.5099	17.01	17.0838	10164.0
2023-05-10	ABR.F	Stock	18.45	18.58	18.168	18.25	27426.0
2023-05-10	ABSI	Stock	1.35	1.38	1.29	1.31	158700.0

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

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