PREVIEW / stock_daily / 2023-05-11

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-11.parquet
  size:    242 KB
  rows:    7,529
  symbols: 1,654

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-11	AAPL	Stock	173.85	174.59	172.17	173.75	49514700.0
2023-05-11	MSFT	Stock	310.1	311.12	306.26	310.11	31680200.0
2023-05-11	NVDA	Stock	28.896	28.95	28.246	28.578	322149000.0
2023-05-11	AMZN	Stock	111.03	113.28	110.49	112.18	74924800.0
2023-05-11	GOOGL	Stock	115.395	117.92	114.41	116.57	78900029.0
2023-05-11	META	Stock	233.05	238.21	232.3	235.79	20449000.0
2023-05-11	TSLA	Stock	168.7	173.57	166.79	172.08	103889900.0
2023-05-11	TLT	Stock	105.295	105.52	104.72	105.15	19147223.0
2023-05-11	ES	Stock	76.96	77.16	75.93	76.25	1732000.0
2023-05-11	CL	Stock	81.37	81.67	80.91	81.63	3243300.0
2023-05-11	A	Stock	127.17	127.7	125.47	127.66	1580600.0
2023-05-11	AA	Stock	35.4	35.93	35.06	35.33	3272400.0
2023-05-11	AAC-DELISTED	Stock	10.45	10.45	10.42	10.42	12423.0
2023-05-11	AACG	Stock	1.73	1.75	1.7	1.71	14700.0
2023-05-11	AAIC-DELISTED	Stock	2.63	2.63	2.56	2.56	14199.0
2023-05-11	AAL	Stock	14.26	14.29	14.02	14.07	17049600.0
2023-05-11	AAM.A-DELISTED	Stock	24.0	24.35	23.4169	23.435	11622.0
2023-05-11	AAM.B-DELISTED	Stock	24.6	24.6	23.12	23.16	10657.0
2023-05-11	AAMC-DELISTED	Stock	25.3706	25.3706	24.3971	24.6618	47546.0
2023-05-11	AAME	Stock	2.24	2.25	2.2	2.22	2600.0
2023-05-11	AAMI	Stock	21.73	21.955	21.66	21.67	75500.0
2023-05-11	AAN-DELISTED	Stock	12.53	12.615	12.24	12.56	263900.0
2023-05-11	AAOI	Stock	1.85	1.85	1.71	1.71	137000.0
2023-05-11	AAON	Stock	64.76	64.76	63.4	63.86	301200.0
2023-05-11	AAP	Stock	125.02	125.42	123.31	124.17	676300.0
2023-05-11	AAT	Stock	18.94	18.94	18.56	18.86	357500.0
2023-05-11	AATC	Stock	4.0	4.03	4.0	4.0	1418.0
2023-05-11	AAU-DELISTED	Stock	0.109	0.119	0.1057	0.1149	1024069.0
2023-05-11	AAUAF-DELISTED	Stock	0.109	0.119	0.1057	0.1128	1032922.0
2023-05-11	AAXJ	Stock	66.15	66.195	65.7	66.16	514673.0
2023-05-11	AB	Stock	34.72	35.08	34.43	34.78	194400.0
2023-05-11	ABB-DELISTED	Stock	36.46	36.775	36.35	36.73	2713102.0
2023-05-11	ABBNY-DELISTED	Stock	36.46	36.775	36.35	36.73	2935724.0
2023-05-11	ABBV	Stock	147.29	147.57	145.19	146.59	4300400.0
2023-05-11	ABC-DELISTED	Stock	168.92	172.15	168.92	171.44	778483.0
2023-05-11	ABCB	Stock	29.09	29.57	28.63	29.02	472500.0
2023-05-11	ABCL	Stock	5.89	5.94	5.7	5.74	2448600.0
2023-05-11	ABCM-DELISTED	Stock	17.5	18.0	17.34	17.84	1053777.0
2023-05-11	ABEO	Stock	3.29	3.29	2.91	2.97	165300.0
2023-05-11	ABEV	Stock	2.88	2.92	2.87	2.9	22658200.0
2023-05-11	ABG	Stock	201.55	205.54	201.4	203.61	206100.0
2023-05-11	ABM	Stock	42.52	43.28	42.48	43.24	182600.0
2023-05-11	ABNB	Stock	113.14	114.46	111.04	111.2	9579400.0
2023-05-11	ABOS	Stock	6.59	6.59	5.48	5.73	317800.0
2023-05-11	ABR	Stock	12.21	12.25	11.97	12.18	3624100.0
2023-05-11	ABR.D	Stock	17.53	17.76	17.498	17.5	20181.0
2023-05-11	ABR.E	Stock	17.3599	17.63	17.23	17.255	15235.0
2023-05-11	ABR.F	Stock	18.27	18.3	18.11	18.13	8386.0
2023-05-11	ABSI	Stock	1.29	1.389	1.22	1.24	380900.0
2023-05-11	ABST-DELISTED	Stock	11.33	11.4	11.32	11.37	26177272.0

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

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