PREVIEW / stock_daily / 2023-03-14

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-14.parquet
  size:    245 KB
  rows:    7,599
  symbols: 1,763

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-03-14	AAPL	Stock	151.28	153.4	150.1	152.59	73695900.0
2023-03-14	MSFT	Stock	256.75	261.07	255.86	260.79	33620300.0
2023-03-14	NVDA	Stock	23.496	24.219	23.46	24.063	474910000.0
2023-03-14	AMZN	Stock	93.83	95.07	92.71	94.88	60912700.0
2023-03-14	GOOGL	Stock	92.56	94.36	92.44	93.97	36050214.0
2023-03-14	META	Stock	187.58	194.32	186.56	194.02	41642600.0
2023-03-14	TSLA	Stock	177.31	183.8	177.14	183.26	143717900.0
2023-03-14	TLT	Stock	105.14	105.61	103.75	104.09	38417777.0
2023-03-14	ES	Stock	75.12	76.58	75.12	75.93	2602200.0
2023-03-14	CL	Stock	71.7	72.32	71.38	72.24	5098000.0
2023-03-14	A	Stock	138.44	139.6	136.43	138.4	1255400.0
2023-03-14	AA	Stock	45.83	46.23	43.92	44.59	4197000.0
2023-03-14	AAC-DELISTED	Stock	10.27	10.27	10.26	10.27	5789.0
2023-03-14	AACG	Stock	1.94	2.0	1.81	1.92	40400.0
2023-03-14	AACIU	Stock	10.0	10.0	10.0	10.0	100.0
2023-03-14	AACIW-DELISTED	Stock	0.1025	0.1025	0.1025	0.1025	550.0
2023-03-14	AAIC-DELISTED	Stock	2.75	2.83	2.75	2.81	83362.0
2023-03-14	AAIC.C-DELISTED	Stock	21.7499	21.75	21.7499	21.75	200.0
2023-03-14	AAL	Stock	15.05	15.32	14.49	14.66	35258900.0
2023-03-14	AAM.A-DELISTED	Stock	21.4	23.1943	21.1919	22.1601	30235.0
2023-03-14	AAM.B-DELISTED	Stock	21.25	24.0	21.25	22.83	52658.0
2023-03-14	AAMC-DELISTED	Stock	16.1765	16.7647	16.1735	16.1735	65348.0
2023-03-14	AAME	Stock	2.43	2.51	2.32	2.35	12200.0
2023-03-14	AAMI	Stock	23.17	23.49	22.77	22.95	134700.0
2023-03-14	AAN-DELISTED	Stock	10.83	10.865	10.4	10.5	296800.0
2023-03-14	AAOI	Stock	2.72	2.75	2.65	2.66	109600.0
2023-03-14	AAON	Stock	59.7	60.9267	59.22	60.4133	844650.0
2023-03-14	AAP	Stock	125.21	126.14	121.05	121.7	2150700.0
2023-03-14	AAT	Stock	20.21	20.21	18.68	18.96	906900.0
2023-03-14	AATC	Stock	4.19	4.19	4.19	4.19	405.0
2023-03-14	AAU-DELISTED	Stock	0.192	0.1976	0.1905	0.193	243945.0
2023-03-14	AAUAF-DELISTED	Stock	0.192	0.1976	0.1905	0.193	244516.0
2023-03-14	AAWW-DELISTED	Stock	100.15	100.21	99.2	99.27	826032.0
2023-03-14	AAXJ	Stock	64.68	65.2	64.68	65.11	553133.0
2023-03-14	AB	Stock	36.89	37.23	35.7	35.71	277500.0
2023-03-14	ABB-DELISTED	Stock	33.63	33.8	33.4213	33.765	1919917.0
2023-03-14	ABBNY-DELISTED	Stock	33.63	33.8	33.4213	33.76	2095390.0
2023-03-14	ABBV	Stock	151.95	153.99	151.46	153.85	6644100.0
2023-03-14	ABC-DELISTED	Stock	149.36	150.58	147.48	149.36	606555.0
2023-03-14	ABCB	Stock	39.6	41.61	36.59	36.74	1303300.0
2023-03-14	ABCL	Stock	7.65	7.79	7.41	7.57	1721100.0
2023-03-14	ABCM-DELISTED	Stock	14.99	15.15	14.39	14.4	1189490.0
2023-03-14	ABEO	Stock	2.58	2.8	2.55	2.6	102100.0
2023-03-14	ABEV	Stock	2.62	2.68	2.61	2.65	27304400.0
2023-03-14	ABG	Stock	214.05	216.46	198.99	201.6	340600.0
2023-03-14	ABM	Stock	45.05	45.45	44.18	44.57	390100.0
2023-03-14	ABNB	Stock	118.94	119.1	114.91	116.36	5416400.0
2023-03-14	ABOS	Stock	4.42	4.48	4.25	4.32	229600.0
2023-03-14	ABR	Stock	13.28	13.44	11.74	12.12	15547900.0
2023-03-14	ABR.D	Stock	17.74	18.02	16.375	16.6	125722.0

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

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