PREVIEW / stock_daily / 2022-12-15

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-15.parquet
  size:    251 KB
  rows:    7,810
  symbols: 2,035

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
2022-12-15	AAPL	Stock	141.11	141.8	136.03	136.5	98931900.0
2022-12-15	MSFT	Stock	253.72	254.2	247.34	249.01	35560400.0
2022-12-15	NVDA	Stock	17.146	17.32	16.7	16.952	478542000.0
2022-12-15	AMZN	Stock	89.89	89.97	87.47	88.45	84802900.0
2022-12-15	GOOGL	Stock	93.13	93.64	90.01	90.86	40107033.0
2022-12-15	META	Stock	118.33	118.63	114.01	116.15	34531000.0
2022-12-15	TSLA	Stock	153.44	160.93	153.28	157.67	122334500.0
2022-12-15	TLT	Stock	108.39	109.12	108.16	108.32	20255470.0
2022-12-15	ES	Stock	84.79	85.07	83.66	84.13	1770700.0
2022-12-15	CL	Stock	78.51	78.86	77.22	77.88	4021200.0
2022-12-15	A	Stock	152.81	153.04	150.24	150.86	1483900.0
2022-12-15	AA	Stock	44.4	44.66	43.01	43.27	4300100.0
2022-12-15	AAC-DELISTED	Stock	10.06	10.08	10.06	10.08	847544.0
2022-12-15	AACG	Stock	1.39	1.5	1.39	1.48	3700.0
2022-12-15	AAIC-DELISTED	Stock	2.91	2.98	2.91	2.96	20725.0
2022-12-15	AAIC.C-DELISTED	Stock	21.0	21.345	21.0	21.25	4758.0
2022-12-15	AAL	Stock	13.16	13.31	12.8	12.93	26158300.0
2022-12-15	AAM.A-DELISTED	Stock	23.4	23.4	23.17	23.35	10409.0
2022-12-15	AAM.B-DELISTED	Stock	22.82	23.1	22.82	23.0	31564.0
2022-12-15	AAMC-DELISTED	Stock	6.1765	6.3618	6.1471	6.2235	9908.0
2022-12-15	AAME	Stock	2.42	2.46	2.41	2.41	5400.0
2022-12-15	AAMI	Stock	19.02	19.02	18.195	18.62	219100.0
2022-12-15	AAN-DELISTED	Stock	11.9	12.26	11.83	12.12	355800.0
2022-12-15	AAOI	Stock	2.13	2.16	2.12	2.12	194400.0
2022-12-15	AAON	Stock	52.44	52.44	51.5533	52.18	208950.0
2022-12-15	AAP	Stock	140.86	143.41	140.13	143.23	1063200.0
2022-12-15	AAT	Stock	27.39	27.48	27.11	27.21	416000.0
2022-12-15	AATC	Stock	5.0	5.0955	5.0	5.03	8480.0
2022-12-15	AAU-DELISTED	Stock	0.2444	0.2467	0.24	0.2401	144700.0
2022-12-15	AAUAF-DELISTED	Stock	0.2444	0.2467	0.24	0.24	146446.0
2022-12-15	AAWW-DELISTED	Stock	100.55	100.75	100.52	100.55	136381.0
2022-12-15	AAXJ	Stock	66.06	66.17	64.78	64.88	833686.0
2022-12-15	AB	Stock	38.59	38.59	37.99	38.17	471500.0
2022-12-15	ABB-DELISTED	Stock	31.04	31.07	30.425	30.5	1929316.0
2022-12-15	ABBNY-DELISTED	Stock	31.04	31.07	30.425	30.49	2114046.0
2022-12-15	ABBV	Stock	163.89	164.61	161.95	163.1	5268300.0
2022-12-15	ABC-DELISTED	Stock	164.34	165.79	163.74	165.65	1270976.0
2022-12-15	ABCB	Stock	47.28	48.27	46.45	46.82	394400.0
2022-12-15	ABCL	Stock	11.14	11.3	10.24	10.4	4483100.0
2022-12-15	ABCM-DELISTED	Stock	15.76	15.76	15.3155	15.625	938088.0
2022-12-15	ABEO	Stock	2.95	3.01	2.8	2.85	173900.0
2022-12-15	ABEV	Stock	2.81	2.86	2.77	2.8	27998400.0
2022-12-15	ABG	Stock	175.43	176.96	169.45	170.36	276900.0
2022-12-15	ABGI-DELISTED	Stock	10.04	10.07	10.04	10.07	19653.0
2022-12-15	ABM	Stock	43.93	45.7	43.84	44.82	758000.0
2022-12-15	ABMD-DELISTED	Stock	380.12	380.5	380.11	380.18	598132.0
2022-12-15	ABNB	Stock	91.52	92.71	89.52	90.61	5332000.0
2022-12-15	ABOS	Stock	5.66	5.775	5.25	5.27	97700.0
2022-12-15	ABR	Stock	13.72	13.78	13.52	13.69	1401100.0
2022-12-15	ABR.D	Stock	16.99	17.14	16.75	16.7956	48552.0

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

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