PREVIEW / stock_daily / 2023-01-19

all stock daily files

  file:    by_date/stock_daily/2023/2023-01-19.parquet
  size:    248 KB
  rows:    7,687
  symbols: 1,900

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-19	AAPL	Stock	134.08	136.25	133.77	135.27	58280400.0
2023-01-19	MSFT	Stock	233.78	235.52	230.68	231.93	28623000.0
2023-01-19	NVDA	Stock	17.036	17.197	16.731	16.765	452932000.0
2023-01-19	AMZN	Stock	94.74	95.44	92.86	93.68	69002700.0
2023-01-19	GOOGL	Stock	90.72	93.605	90.63	93.05	37000395.0
2023-01-19	META	Stock	132.49	137.45	132.14	136.15	28625200.0
2023-01-19	TSLA	Stock	127.26	129.99	124.31	127.17	170291900.0
2023-01-19	TLT	Stock	108.1	108.37	107.44	107.95	17194653.0
2023-01-19	ES	Stock	81.18	81.3	79.73	79.78	1444100.0
2023-01-19	CL	Stock	75.77	76.53	75.19	75.2	4436400.0
2023-01-19	A	Stock	153.58	154.92	152.14	152.87	1017400.0
2023-01-19	AA	Stock	51.14	53.145	49.52	49.52	12142700.0
2023-01-19	AAC-DELISTED	Stock	10.12	10.14	10.12	10.125	978940.0
2023-01-19	AACG	Stock	1.41	1.41	1.35	1.35	18900.0
2023-01-19	AACIW-DELISTED	Stock	0.14	0.14	0.0794	0.0794	45995.0
2023-01-19	AAIC-DELISTED	Stock	3.02	3.02	2.985	3.01	45615.0
2023-01-19	AAL	Stock	16.41	16.49	16.01	16.28	32630200.0
2023-01-19	AAM.A-DELISTED	Stock	24.065	24.64	24.065	24.53	5741.0
2023-01-19	AAM.B-DELISTED	Stock	24.18	24.546	24.18	24.546	3913.0
2023-01-19	AAMC-DELISTED	Stock	8.4059	9.0882	8.4059	8.8176	29349.0
2023-01-19	AAME	Stock	2.58	2.6	2.46	2.47	8000.0
2023-01-19	AAMI	Stock	21.64	22.175	21.42	22.03	154900.0
2023-01-19	AAN-DELISTED	Stock	13.67	13.84	13.291	13.65	272800.0
2023-01-19	AAOI	Stock	2.32	2.35	2.239	2.29	57000.0
2023-01-19	AAON	Stock	49.7333	50.0267	48.4733	48.74	262800.0
2023-01-19	AAP	Stock	146.0	146.22	143.15	143.27	882100.0
2023-01-19	AAT	Stock	27.43	27.53	27.22	27.28	213000.0
2023-01-19	AATC	Stock	4.0	4.005	3.97	4.0	40984.0
2023-01-19	AAU-DELISTED	Stock	0.24	0.245	0.2366	0.2371	256809.0
2023-01-19	AAUAF-DELISTED	Stock	0.24	0.245	0.2366	0.2369	261601.0
2023-01-19	AAWW-DELISTED	Stock	101.87	101.93	101.71	101.82	429973.0
2023-01-19	AAXJ	Stock	70.37	70.755	70.3	70.57	562928.0
2023-01-19	AB	Stock	37.76	37.83	36.35	36.48	220500.0
2023-01-19	ABB-DELISTED	Stock	33.8	33.86	33.36	33.475	1102619.0
2023-01-19	ABBNY-DELISTED	Stock	33.8	33.86	33.36	33.47	1233667.0
2023-01-19	ABBV	Stock	148.95	150.54	147.33	148.71	7169900.0
2023-01-19	ABC-DELISTED	Stock	162.96	164.504	162.31	162.93	904625.0
2023-01-19	ABCB	Stock	46.68	47.02	46.11	46.92	245500.0
2023-01-19	ABCL	Stock	10.22	10.38	10.035	10.16	930800.0
2023-01-19	ABCM-DELISTED	Stock	16.0	16.0453	15.67	15.78	235922.0
2023-01-19	ABEO	Stock	2.6	2.6	2.49	2.54	227100.0
2023-01-19	ABEV	Stock	2.63	2.65	2.6	2.6	27426900.0
2023-01-19	ABG	Stock	182.89	184.07	178.87	184.04	145000.0
2023-01-19	ABGI-DELISTED	Stock	10.14	10.14	10.14	10.14	53720.0
2023-01-19	ABM	Stock	45.2	45.2	44.19	44.59	227500.0
2023-01-19	ABNB	Stock	99.84	100.52	97.57	99.1	4996700.0
2023-01-19	ABOS	Stock	5.8	6.604	5.57	5.57	35200.0
2023-01-19	ABR	Stock	14.01	14.17	13.95	14.17	1148400.0
2023-01-19	ABR.D	Stock	20.1224	20.295	20.0	20.0	58850.0
2023-01-19	ABR.E	Stock	19.8	19.88	19.75	19.789	4999.0

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

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