PREVIEW / stock_daily / 2022-12-06

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-06.parquet
  size:    249 KB
  rows:    7,723
  symbols: 2,038

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-06	AAPL	Stock	147.07	147.3	141.92	142.91	64727200.0
2022-12-06	MSFT	Stock	250.82	251.86	243.78	245.12	22463700.0
2022-12-06	NVDA	Stock	16.53	16.573	15.819	15.987	352694000.0
2022-12-06	AMZN	Stock	90.5	91.04	87.9	88.25	75503600.0
2022-12-06	GOOGL	Stock	99.3	99.78	96.42	96.98	24910655.0
2022-12-06	META	Stock	119.91	120.55	113.74	114.12	43689200.0
2022-12-06	TSLA	Stock	181.22	183.65	175.33	179.82	92150800.0
2022-12-06	TLT	Stock	106.5	107.39	106.19	106.95	21754513.0
2022-12-06	ES	Stock	83.73	84.37	82.88	84.36	1884000.0
2022-12-06	CL	Stock	77.22	77.67	76.69	77.21	3020100.0
2022-12-06	A	Stock	152.15	153.0	149.91	151.35	1172300.0
2022-12-06	AA	Stock	47.3	48.8	47.05	48.31	4103100.0
2022-12-06	AAC-DELISTED	Stock	10.07	10.08	10.06	10.06	7976531.0
2022-12-06	AACG	Stock	1.57	1.57	1.39	1.46	16400.0
2022-12-06	AACIW-DELISTED	Stock	0.02	0.035	0.02	0.035	30447.0
2022-12-06	AAIC-DELISTED	Stock	3.02	3.0501	2.97	2.97	39046.0
2022-12-06	AAIC.C-DELISTED	Stock	21.5	21.7	21.5	21.545	3036.0
2022-12-06	AAL	Stock	14.14	14.34	14.0	14.33	20781500.0
2022-12-06	AAM.A-DELISTED	Stock	23.95	23.96	23.56	23.74	10569.0
2022-12-06	AAM.B-DELISTED	Stock	24.49	24.83	24.42	24.65	11575.0
2022-12-06	AAMC-DELISTED	Stock	6.5	7.1412	5.8824	6.7353	77897.0
2022-12-06	AAME	Stock	2.7	2.7	2.66	2.66	2700.0
2022-12-06	AAMI	Stock	20.7	20.94	20.25	20.4	130200.0
2022-12-06	AAN-DELISTED	Stock	12.39	12.6	12.055	12.27	229600.0
2022-12-06	AAOI	Stock	2.28	2.28	2.05	2.1	205700.0
2022-12-06	AAON	Stock	52.5333	52.5333	50.8333	51.62	201150.0
2022-12-06	AAP	Stock	147.96	148.97	143.72	145.53	1336700.0
2022-12-06	AAQC-DELISTED	Stock	10.075	10.075	10.075	10.075	300.0
2022-12-06	AAT	Stock	27.22	27.4	27.04	27.17	198300.0
2022-12-06	AATC	Stock	5.1	5.2	5.09	5.2	23781.0
2022-12-06	AAU-DELISTED	Stock	0.2439	0.2454	0.2273	0.2399	226960.0
2022-12-06	AAUAF-DELISTED	Stock	0.2439	0.2454	0.2273	0.2364	230139.0
2022-12-06	AAWW-DELISTED	Stock	100.38	100.79	100.255	100.54	119827.0
2022-12-06	AAXJ	Stock	66.71	66.71	66.15	66.3	519527.0
2022-12-06	AB	Stock	39.68	40.0	39.19	39.48	335300.0
2022-12-06	ABB-DELISTED	Stock	31.25	31.35	30.81	30.955	738696.0
2022-12-06	ABBNY-DELISTED	Stock	31.25	31.35	30.81	30.95	882226.0
2022-12-06	ABBV	Stock	164.03	164.39	161.55	163.72	5480400.0
2022-12-06	ABC-DELISTED	Stock	171.36	172.0	168.54	169.41	606007.0
2022-12-06	ABCB	Stock	50.56	50.85	49.92	50.31	379200.0
2022-12-06	ABCL	Stock	11.99	11.99	11.4	11.51	1486000.0
2022-12-06	ABCM-DELISTED	Stock	15.52	15.98	15.37	15.81	332658.0
2022-12-06	ABEO	Stock	3.74	3.81	3.48	3.53	320500.0
2022-12-06	ABEV	Stock	3.02	3.06	2.99	3.0	21769900.0
2022-12-06	ABG	Stock	177.93	181.41	176.47	180.44	145200.0
2022-12-06	ABGI-DELISTED	Stock	10.05	10.05	10.05	10.05	56100.0
2022-12-06	ABM	Stock	45.99	46.2	45.51	45.69	246800.0
2022-12-06	ABMD-DELISTED	Stock	378.0	378.19	376.97	378.0	532293.0
2022-12-06	ABNB	Stock	98.25	98.5	91.9	93.12	8380900.0
2022-12-06	ABOS	Stock	5.58	5.62	5.3	5.38	158900.0

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

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