PREVIEW / stock_daily / 2022-12-16

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-16.parquet
  size:    249 KB
  rows:    7,710
  symbols: 1,971

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-16	AAPL	Stock	136.69	137.65	133.73	134.51	160156900.0
2022-12-16	MSFT	Stock	248.55	249.84	243.51	244.69	86102000.0
2022-12-16	NVDA	Stock	16.864	17.041	16.41	16.571	478232000.0
2022-12-16	AMZN	Stock	88.27	89.35	86.73	87.86	146144100.0
2022-12-16	GOOGL	Stock	90.76	91.33	89.52	90.26	58011847.0
2022-12-16	META	Stock	120.23	123.31	118.82	119.43	67064000.0
2022-12-16	TSLA	Stock	159.64	160.99	150.04	150.23	139032200.0
2022-12-16	TLT	Stock	106.6	107.83	106.31	107.11	20838343.0
2022-12-16	ES	Stock	83.4	83.65	81.7	82.78	3362000.0
2022-12-16	CL	Stock	77.47	78.12	77.25	77.76	9426200.0
2022-12-16	A	Stock	149.61	149.95	147.91	149.3	2436700.0
2022-12-16	AA	Stock	42.57	43.57	42.221	42.72	7334800.0
2022-12-16	AAC-DELISTED	Stock	10.07	10.08	10.07	10.075	843282.0
2022-12-16	AACG	Stock	1.86	1.86	1.47	1.54	8400.0
2022-12-16	AAIC-DELISTED	Stock	2.92	2.96	2.91	2.94	40487.0
2022-12-16	AAL	Stock	12.97	13.1	12.59	12.81	26395000.0
2022-12-16	AAM.A-DELISTED	Stock	23.35	23.5219	23.05	23.34	20724.0
2022-12-16	AAM.B-DELISTED	Stock	22.85	23.46	22.77	23.43	31241.0
2022-12-16	AAMC-DELISTED	Stock	5.6029	5.6029	5.6029	5.6029	3539.0
2022-12-16	AAME	Stock	2.46	2.61	2.44	2.59	9700.0
2022-12-16	AAMI	Stock	18.34	18.72	18.23	18.62	1032100.0
2022-12-16	AAN-DELISTED	Stock	11.87	12.09	11.805	11.9	1165600.0
2022-12-16	AAOI	Stock	2.15	2.2	2.12	2.15	157400.0
2022-12-16	AAON	Stock	51.48	51.9533	50.44	50.8933	1265850.0
2022-12-16	AAP	Stock	141.44	142.33	138.79	140.16	1603700.0
2022-12-16	AAT	Stock	26.81	26.98	26.36	26.78	1396800.0
2022-12-16	AATC	Stock	5.07	5.1052	5.0	5.03	6580.0
2022-12-16	AAU-DELISTED	Stock	0.24	0.247	0.24	0.2412	157394.0
2022-12-16	AAUAF-DELISTED	Stock	0.24	0.247	0.24	0.24	159642.0
2022-12-16	AAWW-DELISTED	Stock	100.3	100.64	99.87	100.06	1350835.0
2022-12-16	AAXJ	Stock	65.17	65.44	64.92	64.94	971381.0
2022-12-16	AB	Stock	37.58	38.19	36.9	37.68	608700.0
2022-12-16	ABB-DELISTED	Stock	30.13	30.32	29.985	30.235	1382576.0
2022-12-16	ABBNY-DELISTED	Stock	30.13	30.32	29.985	30.23	1549100.0
2022-12-16	ABBV	Stock	162.05	163.32	160.48	160.48	18905500.0
2022-12-16	ABC-DELISTED	Stock	165.05	167.07	164.4494	166.67	2178387.0
2022-12-16	ABCB	Stock	46.58	47.3	46.06	46.08	894000.0
2022-12-16	ABCL	Stock	10.17	10.39	9.95	10.21	3225000.0
2022-12-16	ABCM-DELISTED	Stock	15.42	15.7	15.34	15.54	914411.0
2022-12-16	ABEO	Stock	2.8	2.88	2.65	2.66	292600.0
2022-12-16	ABEV	Stock	2.79	2.82	2.76	2.76	23367500.0
2022-12-16	ABG	Stock	167.34	169.52	165.94	167.1	405900.0
2022-12-16	ABGI-DELISTED	Stock	10.06	10.0601	10.06	10.0601	3554.0
2022-12-16	ABM	Stock	44.15	44.64	43.71	43.89	1222300.0
2022-12-16	ABMD-DELISTED	Stock	380.75	381.45	380.75	381.08	1218760.0
2022-12-16	ABNB	Stock	89.86	91.29	88.56	89.57	6830200.0
2022-12-16	ABOS	Stock	5.34	5.74	5.18	5.72	154000.0
2022-12-16	ABR	Stock	13.52	13.65	13.36	13.5	2449800.0
2022-12-16	ABR.D	Stock	16.91	17.1	16.61	16.711	20143.0
2022-12-16	ABR.E	Stock	16.85	16.91	16.62	16.7	3700.0

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

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