PREVIEW / stock_daily / 2023-02-16

all stock daily files

  file:    by_date/stock_daily/2023/2023-02-16.parquet
  size:    249 KB
  rows:    7,708
  symbols: 1,870

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-02-16	AAPL	Stock	153.51	156.33	153.35	153.71	68167900.0
2023-02-16	MSFT	Stock	264.02	266.74	261.9	262.15	29603600.0
2023-02-16	NVDA	Stock	22.133	22.55	21.927	22.002	412026000.0
2023-02-16	AMZN	Stock	99.21	100.63	98.1	98.15	56339200.0
2023-02-16	GOOGL	Stock	95.37	97.68	94.74	95.51	42462618.0
2023-02-16	META	Stock	172.75	175.85	171.79	172.44	25827500.0
2023-02-16	TSLA	Stock	210.78	217.65	201.84	202.04	229586500.0
2023-02-16	TLT	Stock	102.07	102.22	101.33	101.59	19267327.0
2023-02-16	ES	Stock	78.96	79.37	78.54	78.72	2185000.0
2023-02-16	CL	Stock	72.32	72.97	71.74	72.77	4701800.0
2023-02-16	A	Stock	148.81	150.16	147.23	148.28	1101700.0
2023-02-16	AA	Stock	48.29	50.44	48.05	48.77	5437500.0
2023-02-16	AAC-DELISTED	Stock	10.2	10.22	10.2	10.22	191299.0
2023-02-16	AACG	Stock	1.85	2.04	1.85	2.0	87200.0
2023-02-16	AACIW-DELISTED	Stock	0.124	0.124	0.0605	0.1	45606.0
2023-02-16	AAIC-DELISTED	Stock	2.99	3.02	2.98	3.01	27483.0
2023-02-16	AAL	Stock	16.59	16.67	16.36	16.39	15054700.0
2023-02-16	AAM.A-DELISTED	Stock	24.28	24.7	24.28	24.7	2650.0
2023-02-16	AAM.B-DELISTED	Stock	24.77	25.01	24.625	24.795	25965.0
2023-02-16	AAMC-DELISTED	Stock	11.1941	12.3088	11.1941	11.9235	66293.0
2023-02-16	AAME	Stock	2.27	2.42	2.26	2.42	4000.0
2023-02-16	AAMI	Stock	25.69	26.32	25.69	26.02	87900.0
2023-02-16	AAN-DELISTED	Stock	14.87	15.15	14.75	14.87	165600.0
2023-02-16	AAOI	Stock	2.85	3.06	2.83	2.95	417400.0
2023-02-16	AAON	Stock	52.0	53.1867	51.6667	52.4533	230850.0
2023-02-16	AAP	Stock	150.16	152.08	148.55	150.19	1369300.0
2023-02-16	AAT	Stock	26.22	26.56	26.1	26.36	339900.0
2023-02-16	AATC	Stock	4.45	4.47	4.26	4.35	18122.0
2023-02-16	AAU-DELISTED	Stock	0.224	0.2297	0.22	0.2235	159852.0
2023-02-16	AAUAF-DELISTED	Stock	0.224	0.2297	0.22	0.2235	162585.0
2023-02-16	AAWW-DELISTED	Stock	102.2	102.235	101.85	101.94	279887.0
2023-02-16	AAXJ	Stock	68.6	69.0803	68.28	68.72	610813.0
2023-02-16	AB	Stock	41.9	41.98	40.83	40.85	392200.0
2023-02-16	ABB-DELISTED	Stock	33.87	34.235	33.78	34.01	807124.0
2023-02-16	ABBNY-DELISTED	Stock	33.87	34.235	33.78	34.01	904015.0
2023-02-16	ABBV	Stock	149.11	150.5	148.73	149.53	3757500.0
2023-02-16	ABC-DELISTED	Stock	158.15	160.85	157.46	160.53	1126593.0
2023-02-16	ABCB	Stock	49.1	49.26	48.53	48.55	362700.0
2023-02-16	ABCL	Stock	9.85	10.06	9.475	9.5	2520800.0
2023-02-16	ABCM-DELISTED	Stock	14.69	14.715	13.99	14.485	485822.0
2023-02-16	ABEO	Stock	2.35	2.4	2.32	2.34	107600.0
2023-02-16	ABEV	Stock	2.49	2.5	2.44	2.5	21219100.0
2023-02-16	ABG	Stock	229.7	235.28	226.6	233.51	211900.0
2023-02-16	ABLV	Stock	10.26	10.275	10.26	10.275	36100.0
2023-02-16	ABM	Stock	48.21	49.0	48.0	48.83	240800.0
2023-02-16	ABNB	Stock	135.65	144.63	134.73	139.42	18705800.0
2023-02-16	ABOS	Stock	5.62	5.88	5.405	5.51	95400.0
2023-02-16	ABR	Stock	14.83	15.0	14.79	14.89	2194100.0
2023-02-16	ABR.D	Stock	20.54	20.54	20.2142	20.3001	2957.0
2023-02-16	ABR.E	Stock	19.976	20.3	19.976	20.195	12394.0

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

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