PREVIEW / stock_daily / 2022-11-22

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-22.parquet
  size:    251 KB
  rows:    7,852
  symbols: 2,098

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-11-22	AAPL	Stock	148.13	150.42	146.93	150.18	51804100.0
2022-11-22	MSFT	Stock	243.59	245.31	240.71	245.03	19665700.0
2022-11-22	NVDA	Stock	15.328	16.058	15.122	16.038	472866000.0
2022-11-22	AMZN	Stock	92.62	93.35	90.87	93.2	62192000.0
2022-11-22	GOOGL	Stock	95.95	97.22	94.05	97.05	23438480.0
2022-11-22	META	Stock	109.86	111.62	108.32	111.44	29029000.0
2022-11-22	TSLA	Stock	168.63	170.92	166.19	169.91	78452300.0
2022-11-22	TLT	Stock	100.65	101.62	100.5319	101.48	18103116.0
2022-11-22	ES	Stock	80.9	82.03	80.43	81.01	1269600.0
2022-11-22	CL	Stock	77.22	77.39	76.09	76.37	4288800.0
2022-11-22	A	Stock	151.98	157.44	151.98	156.86	3512500.0
2022-11-22	AA	Stock	47.72	49.42	46.94	49.36	5593300.0
2022-11-22	AAC-DELISTED	Stock	9.99	10.01	9.99	10.005	10538.0
2022-11-22	AACG	Stock	1.68	1.68	1.68	1.68	600.0
2022-11-22	AACIW-DELISTED	Stock	0.0201	0.03	0.02	0.03	7200.0
2022-11-22	AAIC-DELISTED	Stock	3.05	3.07	3.0	3.03	68031.0
2022-11-22	AAL	Stock	13.85	14.03	13.36	13.98	26387000.0
2022-11-22	AAM.A-DELISTED	Stock	24.59	24.59	24.07	24.08	14540.0
2022-11-22	AAM.B-DELISTED	Stock	24.33	24.61	23.595	24.05	16815.0
2022-11-22	AAMC-DELISTED	Stock	5.5294	5.6618	5.5294	5.6618	5542.0
2022-11-22	AAME	Stock	2.88	2.92	2.85	2.85	2700.0
2022-11-22	AAMI	Stock	19.55	19.71	19.44	19.62	108900.0
2022-11-22	AAN-DELISTED	Stock	11.22	11.84	11.11	11.69	573000.0
2022-11-22	AAOI	Stock	2.2	2.32	2.18	2.28	110400.0
2022-11-22	AAON	Stock	53.3533	53.5067	52.3467	53.0333	225300.0
2022-11-22	AAP	Stock	149.52	151.4	148.5	149.55	1592200.0
2022-11-22	AAQC-DELISTED	Stock	10.02	10.036	10.02	10.025	53061.0
2022-11-22	AAT	Stock	28.44	28.67	28.11	28.31	477100.0
2022-11-22	AATC	Stock	4.89	5.03	4.8	5.0	73331.0
2022-11-22	AAU-DELISTED	Stock	0.237	0.24	0.23	0.2348	191993.0
2022-11-22	AAUAF-DELISTED	Stock	0.237	0.24	0.23	0.2304	195896.0
2022-11-22	AAWW-DELISTED	Stock	100.96	100.97	100.48	100.8	109408.0
2022-11-22	AAXJ	Stock	62.5	62.93	62.47	62.89	473766.0
2022-11-22	AB	Stock	40.0	41.58	39.78	41.17	490100.0
2022-11-22	ABB-DELISTED	Stock	30.99	31.18	30.89	31.15	748017.0
2022-11-22	ABBNY-DELISTED	Stock	30.99	31.18	30.89	31.15	871096.0
2022-11-22	ABBV	Stock	157.69	159.88	157.56	159.79	5351100.0
2022-11-22	ABC-DELISTED	Stock	162.42	165.49	161.99	164.74	917426.0
2022-11-22	ABCB	Stock	52.73	53.17	52.52	52.95	263100.0
2022-11-22	ABCL	Stock	14.1	14.1	13.78	13.98	1288900.0
2022-11-22	ABCM-DELISTED	Stock	15.44	15.87	15.19	15.75	353203.0
2022-11-22	ABEO	Stock	4.16	4.24	4.04	4.11	157200.0
2022-11-22	ABEV	Stock	2.94	2.94	2.85	2.87	43557900.0
2022-11-22	ABG	Stock	181.74	183.2	179.58	179.82	135500.0
2022-11-22	ABGI-DELISTED	Stock	10.01	10.01	10.01	10.01	108.0
2022-11-22	ABLV	Stock	10.1	10.18	10.09	10.09	1750.0
2022-11-22	ABM	Stock	46.01	46.08	45.49	45.71	147400.0
2022-11-22	ABMD-DELISTED	Stock	376.82	378.28	376.6	377.99	406684.0
2022-11-22	ABNB	Stock	93.53	95.37	92.98	95.28	5951600.0
2022-11-22	ABOS	Stock	6.38	6.38	5.86	6.31	100900.0

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

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