PREVIEW / stock_daily / 2023-01-24

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-24.parquet
  size:    247 KB
  rows:    7,720
  symbols: 1,909

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-24	AAPL	Stock	140.31	143.16	140.3	142.53	66435100.0
2023-01-24	MSFT	Stock	242.5	243.95	240.44	242.04	40234400.0
2023-01-24	NVDA	Stock	18.827	19.495	18.82	19.265	496204000.0
2023-01-24	AMZN	Stock	96.93	98.09	96.0	96.32	66929500.0
2023-01-24	GOOGL	Stock	98.1	99.61	97.2	97.7	33078512.0
2023-01-24	META	Stock	141.69	145.0	141.36	143.14	21970200.0
2023-01-24	TSLA	Stock	143.0	146.5	141.1	143.89	158699100.0
2023-01-24	TLT	Stock	106.12	107.45	105.39	107.22	16417220.0
2023-01-24	ES	Stock	80.53	80.63	79.12	80.25	1159100.0
2023-01-24	CL	Stock	75.39	75.99	74.5	75.94	4219100.0
2023-01-24	A	Stock	156.27	158.51	154.46	155.69	1121500.0
2023-01-24	AA	Stock	51.22	54.06	51.2	52.87	5561500.0
2023-01-24	AAC-DELISTED	Stock	10.12	10.17	10.12	10.12	57820.0
2023-01-24	AACG	Stock	1.4	1.44	1.38	1.44	3700.0
2023-01-24	AACIW-DELISTED	Stock	0.1018	0.1389	0.1	0.1	22262.0
2023-01-24	AAIC-DELISTED	Stock	3.09	3.14	2.99	3.04	151725.0
2023-01-24	AAIC.C-DELISTED	Stock	21.9411	22.99	21.9411	22.45	4000.0
2023-01-24	AAL	Stock	16.01	16.43	15.96	16.02	21641500.0
2023-01-24	AAM.A-DELISTED	Stock	24.6441	24.89	24.58	24.87	8255.0
2023-01-24	AAM.B-DELISTED	Stock	24.5256	24.97	24.5256	24.9075	16462.0
2023-01-24	AAMC-DELISTED	Stock	9.1176	9.7588	8.5647	9.1176	79941.0
2023-01-24	AAME	Stock	2.55	2.56	2.44	2.51	7200.0
2023-01-24	AAMI	Stock	23.06	23.06	22.48	22.5	92600.0
2023-01-24	AAN-DELISTED	Stock	14.31	14.4	13.92	13.94	171500.0
2023-01-24	AAOI	Stock	2.22	2.34	2.21	2.22	81900.0
2023-01-24	AAON	Stock	49.2933	50.1333	48.7133	49.8667	180000.0
2023-01-24	AAP	Stock	149.14	151.91	147.11	147.27	851900.0
2023-01-24	AAT	Stock	27.0	27.23	26.92	27.07	295500.0
2023-01-24	AATC	Stock	4.07	4.15	4.07	4.08	15937.0
2023-01-24	AAU-DELISTED	Stock	0.2461	0.2485	0.2392	0.241	116935.0
2023-01-24	AAUAF-DELISTED	Stock	0.2461	0.2485	0.2392	0.241	119820.0
2023-01-24	AAWW-DELISTED	Stock	102.03	102.16	101.97	102.0	109444.0
2023-01-24	AAXJ	Stock	72.23	72.32	71.895	72.23	1487787.0
2023-01-24	AB	Stock	37.67	38.52	37.67	38.17	214600.0
2023-01-24	ABB-DELISTED	Stock	33.995	34.29	33.805	34.225	752146.0
2023-01-24	ABBNY-DELISTED	Stock	33.995	34.29	33.805	34.22	875986.0
2023-01-24	ABBV	Stock	148.08	148.87	146.44	147.69	5171400.0
2023-01-24	ABC-DELISTED	Stock	162.04	162.04	157.64	161.42	616701.0
2023-01-24	ABCB	Stock	48.08	48.29	47.51	47.77	245400.0
2023-01-24	ABCL	Stock	10.2	10.2	9.85	10.05	1264600.0
2023-01-24	ABCM-DELISTED	Stock	16.99	17.55	16.75	16.99	524429.0
2023-01-24	ABEO	Stock	2.58	2.65	2.58	2.6	172700.0
2023-01-24	ABEV	Stock	2.59	2.63	2.58	2.63	15615200.0
2023-01-24	ABG	Stock	189.88	191.86	188.68	189.04	93800.0
2023-01-24	ABGI-DELISTED	Stock	10.14	10.15	10.14	10.145	446899.0
2023-01-24	ABLV	Stock	10.22	10.22	10.21	10.21	5929.0
2023-01-24	ABM	Stock	44.34	45.68	44.34	45.19	238000.0
2023-01-24	ABNB	Stock	104.7	106.39	103.82	104.13	3514700.0
2023-01-24	ABOS	Stock	5.81	6.32	5.81	5.87	86500.0
2023-01-24	ABR	Stock	14.25	14.49	14.25	14.36	899700.0

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

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