PREVIEW / stock_daily / 2023-01-05

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-05.parquet
  size:    247 KB
  rows:    7,704
  symbols: 1,950

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-05	AAPL	Stock	127.13	127.77	124.76	125.02	80962700.0
2023-01-05	MSFT	Stock	227.2	227.55	221.76	222.31	39585600.0
2023-01-05	NVDA	Stock	14.491	14.564	14.148	14.265	389168000.0
2023-01-05	AMZN	Stock	85.33	85.42	83.07	83.12	67930800.0
2023-01-05	GOOGL	Stock	87.47	87.57	85.9	86.2	27194375.0
2023-01-05	META	Stock	126.13	128.52	124.54	126.94	25447100.0
2023-01-05	TSLA	Stock	110.51	111.75	107.16	110.34	157986300.0
2023-01-05	TLT	Stock	101.87	103.288	101.78	103.28	14771117.0
2023-01-05	ES	Stock	84.58	85.09	83.02	83.75	1210300.0
2023-01-05	CL	Stock	79.52	79.81	78.44	78.54	2295600.0
2023-01-05	A	Stock	150.0	153.07	148.77	152.11	1714600.0
2023-01-05	AA	Stock	45.3	45.99	44.14	45.49	3835700.0
2023-01-05	AAC-DELISTED	Stock	10.12	10.12	10.11	10.115	121324.0
2023-01-05	AACG	Stock	1.24	1.37	1.24	1.32	2300.0
2023-01-05	AACIU	Stock	10.14	10.14	10.14	10.14	503.0
2023-01-05	AACIW-DELISTED	Stock	0.025	0.0328	0.0191	0.0191	40626.0
2023-01-05	AAIC-DELISTED	Stock	2.96	2.96	2.93	2.95	21624.0
2023-01-05	AAL	Stock	13.5	14.01	13.42	13.99	27378000.0
2023-01-05	AAM.A-DELISTED	Stock	22.58	23.34	22.58	23.2579	13786.0
2023-01-05	AAM.B-DELISTED	Stock	22.27	23.42	22.27	23.42	9598.0
2023-01-05	AAMC-DELISTED	Stock	6.1735	6.8824	6.1735	6.825	23797.0
2023-01-05	AAME	Stock	2.42	2.47	2.42	2.47	900.0
2023-01-05	AAMI	Stock	19.99	20.225	19.69	20.17	106000.0
2023-01-05	AAN-DELISTED	Stock	12.58	12.77	12.33	12.75	211200.0
2023-01-05	AAOI	Stock	1.92	1.92	1.87	1.88	57800.0
2023-01-05	AAON	Stock	47.46	47.9733	46.94	47.0	252450.0
2023-01-05	AAP	Stock	150.45	154.44	149.88	153.16	795700.0
2023-01-05	AAT	Stock	26.8	27.03	26.26	26.4	250800.0
2023-01-05	AATC	Stock	3.52	3.65	3.51	3.63	37785.0
2023-01-05	AAU-DELISTED	Stock	0.2625	0.27	0.2601	0.2679	133429.0
2023-01-05	AAUAF-DELISTED	Stock	0.2625	0.27	0.2601	0.2679	136343.0
2023-01-05	AAWW-DELISTED	Stock	101.28	101.66	101.1	101.28	143683.0
2023-01-05	AAXJ	Stock	67.52	67.725	67.24	67.56	1115721.0
2023-01-05	AB	Stock	35.61	35.7	35.26	35.52	160900.0
2023-01-05	ABB-DELISTED	Stock	31.78	31.855	31.635	31.82	1384154.0
2023-01-05	ABBNY-DELISTED	Stock	31.78	31.855	31.635	31.82	1570291.0
2023-01-05	ABBV	Stock	163.09	164.49	162.34	163.49	3516000.0
2023-01-05	ABC-DELISTED	Stock	162.47	163.41	161.22	163.11	947055.0
2023-01-05	ABCB	Stock	46.07	46.32	45.37	46.01	169200.0
2023-01-05	ABCL	Stock	9.3	9.685	9.03	9.65	1661500.0
2023-01-05	ABCM-DELISTED	Stock	16.71	17.19	16.44	16.79	968909.0
2023-01-05	ABEO	Stock	3.06	3.2	2.97	3.08	238000.0
2023-01-05	ABEV	Stock	2.63	2.66	2.62	2.64	23601400.0
2023-01-05	ABG	Stock	177.96	181.51	175.42	180.24	128600.0
2023-01-05	ABGI-DELISTED	Stock	10.09	10.1	10.09	10.1	30199.0
2023-01-05	ABM	Stock	44.97	45.68	44.48	45.62	288500.0
2023-01-05	ABNB	Stock	88.48	88.5	86.75	87.71	3419000.0
2023-01-05	ABOS	Stock	5.51	5.77	5.41	5.73	77400.0
2023-01-05	ABR	Stock	13.75	13.8	13.54	13.66	1157900.0
2023-01-05	ABR.D	Stock	18.2	18.5617	17.991	18.3995	8503.0

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

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