PREVIEW / stock_daily / 2022-08-22

all stock daily files

  file:    by_date/stock_daily/2022/2022-08-22.parquet
  size:    251 KB
  rows:    7,811
  symbols: 2,192

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-08-22	AAPL	Stock	169.69	169.86	167.14	167.57	69026800.0
2022-08-22	MSFT	Stock	282.08	282.46	277.22	277.75	25061100.0
2022-08-22	NVDA	Stock	17.49	17.558	16.966	17.034	409593000.0
2022-08-22	AMZN	Stock	135.72	136.32	132.85	133.22	50461500.0
2022-08-22	GOOGL	Stock	115.2	115.63	113.85	114.24	21456648.0
2022-08-22	META	Stock	165.49	165.49	162.26	163.05	19499700.0
2022-08-22	TSLA	Stock	291.9133	292.4	286.2967	289.9133	55843200.0
2022-08-22	TLT	Stock	112.86	112.96	112.13	112.66	10457236.0
2022-08-22	ES	Stock	93.41	93.55	91.76	92.26	1054300.0
2022-08-22	CL	Stock	82.99	83.07	81.9	81.96	4144100.0
2022-08-22	A	Stock	135.3	136.03	133.56	133.94	1250700.0
2022-08-22	AA	Stock	50.0	50.95	49.06	50.27	4339800.0
2022-08-22	AAC-DELISTED	Stock	9.87	9.88	9.87	9.87	13040.0
2022-08-22	AACG	Stock	2.61	2.61	2.3	2.36	74300.0
2022-08-22	AACIW-DELISTED	Stock	0.149	0.15	0.1	0.14	51455.0
2022-08-22	AAIC-DELISTED	Stock	3.28	3.28	3.24	3.25	8370.0
2022-08-22	AAIC.C-DELISTED	Stock	20.6	20.72	20.6	20.7	8718.0
2022-08-22	AAL	Stock	13.78	13.92	13.61	13.71	25120700.0
2022-08-22	AAM.A-DELISTED	Stock	25.28	25.42	25.0	25.0	6758.0
2022-08-22	AAM.B-DELISTED	Stock	25.35	25.476	25.19	25.19	5185.0
2022-08-22	AAME	Stock	2.9	3.1	2.85	3.1	10100.0
2022-08-22	AAMI	Stock	19.18	19.18	18.59	18.63	156800.0
2022-08-22	AAN-DELISTED	Stock	13.75	13.9	13.58	13.76	294100.0
2022-08-22	AAOI	Stock	2.5	2.5	2.37	2.47	157700.0
2022-08-22	AAON	Stock	40.46	40.58	39.4867	39.9	142950.0
2022-08-22	AAP	Stock	204.99	204.99	198.22	198.48	792000.0
2022-08-22	AAT	Stock	29.45	29.45	28.76	28.89	172500.0
2022-08-22	AATC	Stock	5.3	5.4359	5.23	5.27	33501.0
2022-08-22	AAU-DELISTED	Stock	0.21	0.2278	0.21	0.2161	160573.0
2022-08-22	AAUAF-DELISTED	Stock	0.21	0.2293	0.21	0.2293	172879.0
2022-08-22	AAWW-DELISTED	Stock	100.01	100.1	99.79	99.9	511927.0
2022-08-22	AAXJ	Stock	66.82	67.05	66.69	66.74	502162.0
2022-08-22	AB	Stock	43.73	43.91	43.36	43.53	185300.0
2022-08-22	ABB-DELISTED	Stock	28.79	28.81	28.391	28.45	1443896.0
2022-08-22	ABBNY-DELISTED	Stock	28.79	28.81	28.3901	28.44	1591095.0
2022-08-22	ABBV	Stock	141.97	142.66	139.96	140.34	4023500.0
2022-08-22	ABC-DELISTED	Stock	151.5	152.0	148.67	149.09	323760.0
2022-08-22	ABCB	Stock	49.37	49.6	48.48	48.54	207500.0
2022-08-22	ABCL	Stock	11.22	11.46	10.61	11.01	2563500.0
2022-08-22	ABCM-DELISTED	Stock	15.39	15.53	15.11	15.15	138777.0
2022-08-22	ABEO	Stock	4.03	4.11	3.88	4.01	96400.0
2022-08-22	ABEV	Stock	2.97	2.97	2.92	2.94	28408800.0
2022-08-22	ABG	Stock	181.81	184.21	180.31	181.43	128900.0
2022-08-22	ABGI-DELISTED	Stock	9.87	9.87	9.865	9.865	300.0
2022-08-22	ABM	Stock	48.14	48.39	46.92	46.95	248600.0
2022-08-22	ABMD-DELISTED	Stock	266.61	268.065	260.17	261.35	130389.0
2022-08-22	ABNB	Stock	110.36	114.228	109.97	111.39	6057400.0
2022-08-22	ABOS	Stock	4.82	5.39	4.8	5.01	22400.0
2022-08-22	ABR	Stock	15.25	15.29	15.01	15.05	1941000.0
2022-08-22	ABR.D	Stock	21.09	21.14	21.01	21.08	11179.0

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

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