PREVIEW / stock_daily / 2023-05-12

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-12.parquet
  size:    239 KB
  rows:    7,461
  symbols: 1,626

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-12	AAPL	Stock	173.62	174.06	171.0	172.57	45497800.0
2023-05-12	MSFT	Stock	310.55	310.65	306.6	308.97	19758100.0
2023-05-12	NVDA	Stock	28.529	28.78	28.046	28.34	274222000.0
2023-05-12	AMZN	Stock	112.16	112.64	109.32	110.26	49810100.0
2023-05-12	GOOGL	Stock	116.68	118.03	116.11	117.51	41102330.0
2023-05-12	META	Stock	236.74	236.96	231.45	233.81	16155300.0
2023-05-12	TSLA	Stock	176.07	177.38	167.23	167.98	157577100.0
2023-05-12	TLT	Stock	105.05	105.25	104.25	104.27	14198538.0
2023-05-12	ES	Stock	76.62	77.28	76.62	77.08	1803500.0
2023-05-12	CL	Stock	81.47	82.05	81.31	81.98	3483800.0
2023-05-12	A	Stock	128.68	128.68	126.53	127.49	1422600.0
2023-05-12	AA	Stock	35.44	35.5	35.03	35.37	1978200.0
2023-05-12	AAC-DELISTED	Stock	10.47	10.47	10.42	10.44	23899.0
2023-05-12	AACG	Stock	1.7	1.7	1.55	1.6	25200.0
2023-05-12	AAIC-DELISTED	Stock	2.53	2.62	2.53	2.6	23067.0
2023-05-12	AAL	Stock	14.19	14.2	13.87	14.02	16707500.0
2023-05-12	AAM.A-DELISTED	Stock	23.83	23.83	23.09	23.65	15742.0
2023-05-12	AAM.B-DELISTED	Stock	23.84	23.97	22.73	23.0	19950.0
2023-05-12	AAMC-DELISTED	Stock	24.8706	24.8706	22.4706	22.6471	79516.0
2023-05-12	AAME	Stock	2.23	2.23	2.23	2.23	200.0
2023-05-12	AAMI	Stock	21.81	22.23	21.43	21.65	102500.0
2023-05-12	AAN-DELISTED	Stock	12.65	12.77	12.35	12.45	241700.0
2023-05-12	AAOI	Stock	1.72	1.76	1.66	1.69	88000.0
2023-05-12	AAON	Stock	63.9333	64.7133	62.4533	63.1267	451050.0
2023-05-12	AAP	Stock	124.71	124.71	121.62	122.86	755200.0
2023-05-12	AAT	Stock	19.02	19.17	18.64	18.78	408600.0
2023-05-12	AATC	Stock	4.025	4.06	3.975	4.0	6984.0
2023-05-12	AAU-DELISTED	Stock	0.1128	0.1162	0.1076	0.113	372013.0
2023-05-12	AAUAF-DELISTED	Stock	0.1128	0.1162	0.1076	0.113	375922.0
2023-05-12	AAXJ	Stock	65.63	65.63	65.03	65.16	588045.0
2023-05-12	AB	Stock	34.76	35.15	34.0	34.17	565100.0
2023-05-12	ABB-DELISTED	Stock	36.85	37.07	36.755	36.935	1628805.0
2023-05-12	ABBNY-DELISTED	Stock	36.85	37.07	36.755	36.93	1779157.0
2023-05-12	ABBV	Stock	146.79	147.6	146.07	147.15	3526200.0
2023-05-12	ABC-DELISTED	Stock	171.83	171.87	169.67	170.98	1576448.0
2023-05-12	ABCB	Stock	29.24	29.35	28.39	29.04	518000.0
2023-05-12	ABCL	Stock	5.77	5.78	5.64	5.74	1693800.0
2023-05-12	ABCM-DELISTED	Stock	17.82	17.97	17.14	17.3	405563.0
2023-05-12	ABEO	Stock	2.96	3.05	2.9	2.97	100500.0
2023-05-12	ABEV	Stock	2.89	2.93	2.88	2.91	15427000.0
2023-05-12	ABG	Stock	205.35	205.47	198.25	199.47	251100.0
2023-05-12	ABM	Stock	43.41	43.65	42.77	43.38	203900.0
2023-05-12	ABNB	Stock	111.36	111.56	104.21	105.275	14740400.0
2023-05-12	ABOS	Stock	5.8	5.93	5.476	5.6	136700.0
2023-05-12	ABR	Stock	12.3	12.47	12.18	12.42	2704000.0
2023-05-12	ABR.D	Stock	17.3832	17.7399	17.31	17.52	14086.0
2023-05-12	ABR.E	Stock	17.38	17.38	17.2	17.2	2324.0
2023-05-12	ABR.F	Stock	18.11	18.16	17.9	17.9	12886.0
2023-05-12	ABSI	Stock	1.24	1.31	1.24	1.25	679900.0
2023-05-12	ABST-DELISTED	Stock	11.37	11.38	11.305	11.31	5759622.0

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

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