PREVIEW / stock_daily / 2023-01-30

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-30.parquet
  size:    249 KB
  rows:    7,746
  symbols: 1,921

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-30	AAPL	Stock	144.96	145.55	142.85	143.0	64015300.0
2023-01-30	MSFT	Stock	244.51	245.6	242.2	242.71	25867400.0
2023-01-30	NVDA	Stock	19.95	20.14	19.15	19.162	488611000.0
2023-01-30	AMZN	Stock	101.09	101.74	99.01	100.55	70691900.0
2023-01-30	GOOGL	Stock	97.48	98.29	96.395	96.94	27226198.0
2023-01-30	META	Stock	149.41	151.12	146.95	147.06	28040100.0
2023-01-30	TSLA	Stock	178.05	179.77	166.5	166.66	230878800.0
2023-01-30	TLT	Stock	106.46	107.16	106.19	106.32	11459667.0
2023-01-30	ES	Stock	80.78	81.99	80.62	81.37	1607400.0
2023-01-30	CL	Stock	72.2	73.73	72.05	72.88	9191600.0
2023-01-30	A	Stock	154.5	155.52	150.88	151.74	1401100.0
2023-01-30	AA	Stock	51.91	52.13	50.28	50.34	4370000.0
2023-01-30	AAC-DELISTED	Stock	10.16	10.17	10.15	10.16	23271.0
2023-01-30	AACG	Stock	1.38	1.46	1.38	1.45	7000.0
2023-01-30	AACIU	Stock	10.49	10.8245	10.45	10.45	661.0
2023-01-30	AACIW-DELISTED	Stock	0.139	0.139	0.139	0.139	110.0
2023-01-30	AAIC-DELISTED	Stock	3.01	3.04	3.0	3.01	77891.0
2023-01-30	AAIC.C-DELISTED	Stock	22.9	22.9	21.4	22.545	2317.0
2023-01-30	AAL	Stock	16.29	16.6	15.91	15.96	23586000.0
2023-01-30	AAM.A-DELISTED	Stock	24.64	24.87	24.64	24.87	4197.0
2023-01-30	AAM.B-DELISTED	Stock	24.35	24.76	24.35	24.76	7744.0
2023-01-30	AAMC-DELISTED	Stock	10.3794	10.7206	10.1471	10.2618	20587.0
2023-01-30	AAME	Stock	2.48	2.57	2.48	2.57	6000.0
2023-01-30	AAMI	Stock	22.6	22.9	22.32	22.72	123600.0
2023-01-30	AAN-DELISTED	Stock	14.19	14.4	14.095	14.22	133400.0
2023-01-30	AAOI	Stock	2.39	2.44	2.33	2.33	143200.0
2023-01-30	AAON	Stock	49.38	49.8	48.84	48.98	273600.0
2023-01-30	AAP	Stock	147.68	152.01	147.68	149.88	961500.0
2023-01-30	AAT	Stock	27.59	27.8	27.58	27.79	143700.0
2023-01-30	AATC	Stock	4.15	4.18	4.13	4.17	7061.0
2023-01-30	AAU-DELISTED	Stock	0.24	0.2404	0.2305	0.2337	159436.0
2023-01-30	AAUAF-DELISTED	Stock	0.24	0.2404	0.2305	0.2356	163106.0
2023-01-30	AAWW-DELISTED	Stock	102.21	102.25	102.075	102.25	201938.0
2023-01-30	AAXJ	Stock	71.73	71.84	71.28	71.32	867475.0
2023-01-30	AB	Stock	37.88	38.1	37.25	37.46	219700.0
2023-01-30	ABB-DELISTED	Stock	34.44	34.675	34.38	34.395	1095068.0
2023-01-30	ABBNY-DELISTED	Stock	34.44	34.675	34.38	34.4	1205159.0
2023-01-30	ABBV	Stock	145.87	147.12	145.26	145.65	4573400.0
2023-01-30	ABC-DELISTED	Stock	164.46	166.275	164.3889	165.37	776528.0
2023-01-30	ABCB	Stock	46.19	46.85	45.71	45.78	321700.0
2023-01-30	ABCL	Stock	10.67	10.78	10.27	10.4	1283300.0
2023-01-30	ABCM-DELISTED	Stock	16.08	16.15	13.86	13.89	1459255.0
2023-01-30	ABEO	Stock	2.65	2.67	2.52	2.52	104300.0
2023-01-30	ABEV	Stock	2.66	2.67	2.61	2.62	17063500.0
2023-01-30	ABG	Stock	211.75	219.92	211.75	214.18	245200.0
2023-01-30	ABM	Stock	45.41	46.08	45.38	45.44	122400.0
2023-01-30	ABNB	Stock	114.13	115.08	109.275	109.48	5469900.0
2023-01-30	ABOS	Stock	5.47	5.585	5.3	5.33	50400.0
2023-01-30	ABR	Stock	14.8	14.85	14.53	14.61	1518400.0
2023-01-30	ABR.D	Stock	19.91	20.1	19.7894	19.938	16746.0

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

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