PREVIEW / stock_daily / 2023-01-27

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-27.parquet
  size:    247 KB
  rows:    7,661
  symbols: 1,875

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-01-27	AAPL	Stock	143.16	147.23	143.08	145.93	70555800.0
2023-01-27	MSFT	Stock	248.99	249.83	246.83	248.16	26498900.0
2023-01-27	NVDA	Stock	19.462	20.628	19.405	20.365	542142000.0
2023-01-27	AMZN	Stock	99.53	103.49	99.53	102.24	87775600.0
2023-01-27	GOOGL	Stock	97.31	100.32	97.31	99.37	33879753.0
2023-01-27	META	Stock	148.24	153.19	147.39	151.74	35771900.0
2023-01-27	TSLA	Stock	162.43	180.68	161.17	177.9	306590600.0
2023-01-27	TLT	Stock	106.19	106.96	106.11	106.71	11845473.0
2023-01-27	ES	Stock	80.08	81.23	79.56	80.94	1558400.0
2023-01-27	CL	Stock	72.85	73.04	70.94	71.59	13482900.0
2023-01-27	A	Stock	155.75	156.96	154.81	155.69	646200.0
2023-01-27	AA	Stock	51.39	53.46	50.98	52.75	4772500.0
2023-01-27	AAC-DELISTED	Stock	10.17	10.17	10.16	10.16	34746.0
2023-01-27	AACG	Stock	1.4	1.47	1.36	1.42	6000.0
2023-01-27	AACIW-DELISTED	Stock	0.1194	0.1225	0.0997	0.0997	5400.0
2023-01-27	AAIC-DELISTED	Stock	3.04	3.05	3.0	3.04	149089.0
2023-01-27	AAIC.C-DELISTED	Stock	22.5	22.5	22.4	22.4	800.0
2023-01-27	AAL	Stock	16.54	16.81	16.37	16.43	26257000.0
2023-01-27	AAM.A-DELISTED	Stock	24.85	24.89	24.796	24.88	8825.0
2023-01-27	AAM.B-DELISTED	Stock	24.28	24.85	24.28	24.775	12801.0
2023-01-27	AAMC-DELISTED	Stock	9.5088	10.5853	9.5088	10.3824	48181.0
2023-01-27	AAME	Stock	2.55	2.55	2.55	2.55	800.0
2023-01-27	AAMI	Stock	22.48	22.86	22.46	22.76	84000.0
2023-01-27	AAN-DELISTED	Stock	13.92	14.44	13.92	14.33	163300.0
2023-01-27	AAOI	Stock	2.23	2.43	2.175	2.37	107900.0
2023-01-27	AAON	Stock	49.14	50.32	49.14	49.6667	317250.0
2023-01-27	AAP	Stock	147.46	147.64	144.2	147.44	1199600.0
2023-01-27	AAT	Stock	27.12	27.82	27.12	27.76	108800.0
2023-01-27	AATC	Stock	4.11	4.18	4.11	4.18	14433.0
2023-01-27	AAU-DELISTED	Stock	0.2342	0.2435	0.233	0.2352	300326.0
2023-01-27	AAUAF-DELISTED	Stock	0.2342	0.2435	0.233	0.2372	304653.0
2023-01-27	AAWW-DELISTED	Stock	102.03	102.034	101.9	101.92	139179.0
2023-01-27	AAXJ	Stock	72.85	73.025	72.53	72.83	1107061.0
2023-01-27	AB	Stock	37.8	38.59	37.74	37.86	215700.0
2023-01-27	ABB-DELISTED	Stock	34.42	34.7832	34.3849	34.64	1297698.0
2023-01-27	ABBNY-DELISTED	Stock	34.42	34.7832	34.3849	34.64	1450569.0
2023-01-27	ABBV	Stock	147.31	147.68	146.01	146.28	4591500.0
2023-01-27	ABC-DELISTED	Stock	165.61	166.655	163.67	164.03	1083193.0
2023-01-27	ABCB	Stock	45.5	46.9	45.41	46.46	570200.0
2023-01-27	ABCL	Stock	10.46	10.845	10.39	10.76	1247700.0
2023-01-27	ABCM-DELISTED	Stock	16.67	16.67	16.35	16.42	244847.0
2023-01-27	ABEO	Stock	2.62	2.71	2.61	2.65	196800.0
2023-01-27	ABEV	Stock	2.67	2.69	2.64	2.65	14107300.0
2023-01-27	ABG	Stock	204.85	217.31	201.98	214.84	445500.0
2023-01-27	ABGI-DELISTED	Stock	10.15	10.15	10.15	10.15	55399.0
2023-01-27	ABM	Stock	45.82	46.27	45.57	45.85	170900.0
2023-01-27	ABNB	Stock	108.86	117.12	108.735	115.94	9548500.0
2023-01-27	ABOS	Stock	5.45	5.81	5.3	5.45	58600.0
2023-01-27	ABR	Stock	14.74	14.92	14.65	14.89	1533700.0
2023-01-27	ABR.D	Stock	19.85	19.9999	19.83	19.88	16818.0

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

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