PREVIEW / stock_daily / 2023-04-11

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-11.parquet
  size:    245 KB
  rows:    7,629
  symbols: 1,743

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-11	AAPL	Stock	162.35	162.36	160.51	160.8	47644200.0
2023-04-11	MSFT	Stock	285.75	285.98	281.64	282.83	27276600.0
2023-04-11	NVDA	Stock	27.724	27.79	27.126	27.169	314378000.0
2023-04-11	AMZN	Stock	100.8	101.0	99.01	99.92	60417800.0
2023-04-11	GOOGL	Stock	106.55	106.73	104.68	105.35	26311803.0
2023-04-11	META	Stock	215.48	216.02	213.41	213.85	16710100.0
2023-04-11	TSLA	Stock	186.69	189.19	185.65	186.79	115770900.0
2023-04-11	TLT	Stock	107.05	107.09	106.51	107.0	13971249.0
2023-04-11	ES	Stock	80.29	80.49	79.88	80.25	1907100.0
2023-04-11	CL	Stock	75.58	76.21	75.3	76.02	7115700.0
2023-04-11	A	Stock	138.87	139.93	138.15	138.52	1241100.0
2023-04-11	AA	Stock	40.52	41.18	40.15	40.63	4282000.0
2023-04-11	AAC-DELISTED	Stock	10.35	10.3599	10.34	10.35	191587.0
2023-04-11	AACG	Stock	1.9	1.97	1.85	1.97	8700.0
2023-04-11	AACIW-DELISTED	Stock	0.1066	0.1066	0.0783	0.0799	2900.0
2023-04-11	AAIC-DELISTED	Stock	2.71	2.73	2.68	2.69	46554.0
2023-04-11	AAIC.C-DELISTED	Stock	21.3	21.3	21.08	21.08	919.0
2023-04-11	AAL	Stock	14.22	14.51	14.08	14.32	17518200.0
2023-04-11	AAM.A-DELISTED	Stock	23.06	23.52	23.0	23.52	23917.0
2023-04-11	AAM.B-DELISTED	Stock	23.18	23.4999	23.18	23.43	6157.0
2023-04-11	AAMC-DELISTED	Stock	20.5559	20.8824	19.8574	20.1647	32382.0
2023-04-11	AAME	Stock	2.43	2.46	2.43	2.44	800.0
2023-04-11	AAMI	Stock	22.87	23.28	22.57	23.11	85700.0
2023-04-11	AAN-DELISTED	Stock	10.21	10.78	10.21	10.6	363600.0
2023-04-11	AAOI	Stock	2.22	2.31	2.18	2.28	69000.0
2023-04-11	AAON	Stock	63.2133	63.54	62.5733	63.12	463500.0
2023-04-11	AAP	Stock	120.99	123.26	120.51	122.18	1183200.0
2023-04-11	AAT	Stock	18.43	18.47	18.04	18.15	798600.0
2023-04-11	AATC	Stock	3.93	3.932	3.9	3.93	7036.0
2023-04-11	AAU-DELISTED	Stock	0.1898	0.1995	0.188	0.191	177677.0
2023-04-11	AAUAF-DELISTED	Stock	0.1898	0.1995	0.188	0.191	181346.0
2023-04-11	AAXJ	Stock	68.15	68.41	68.07	68.13	308951.0
2023-04-11	AB	Stock	34.16	35.6	34.16	35.51	234600.0
2023-04-11	ABB-DELISTED	Stock	33.5	33.975	33.49	33.865	1552849.0
2023-04-11	ABBNY-DELISTED	Stock	33.5	33.975	33.49	33.87	1726598.0
2023-04-11	ABBV	Stock	161.49	162.59	161.19	161.38	2875800.0
2023-04-11	ABC-DELISTED	Stock	167.34	167.34	166.09	166.55	472893.0
2023-04-11	ABCB	Stock	34.83	35.1	34.24	34.3	473000.0
2023-04-11	ABCL	Stock	7.22	7.415	7.065	7.28	1963200.0
2023-04-11	ABCM-DELISTED	Stock	13.02	13.31	12.88	13.14	468318.0
2023-04-11	ABEO	Stock	2.89	2.96	2.81	2.91	73900.0
2023-04-11	ABEV	Stock	2.92	2.95	2.9	2.91	15673300.0
2023-04-11	ABG	Stock	199.97	206.0	199.36	205.36	269000.0
2023-04-11	ABLV	Stock	10.35	10.35	10.35	10.35	786.0
2023-04-11	ABM	Stock	44.11	44.34	43.91	43.93	257300.0
2023-04-11	ABNB	Stock	113.56	114.8	112.59	114.25	4845400.0
2023-04-11	ABOS	Stock	3.8	3.85	3.75	3.77	135300.0
2023-04-11	ABR	Stock	10.67	10.84	10.61	10.75	3409200.0
2023-04-11	ABR.D	Stock	18.0497	18.85	17.88	18.4	76167.0
2023-04-11	ABR.E	Stock	17.84	18.0	17.7522	17.9505	40633.0

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

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