PREVIEW / stock_daily / 2022-09-08

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-08.parquet
  size:    251 KB
  rows:    7,836
  symbols: 2,195

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-09-08	AAPL	Stock	154.64	156.36	152.68	154.46	84923800.0
2022-09-08	MSFT	Stock	257.51	260.43	254.79	258.52	20319900.0
2022-09-08	NVDA	Stock	13.459	14.008	13.369	13.99	624873000.0
2022-09-08	AMZN	Stock	127.72	130.28	127.1	129.82	43988500.0
2022-09-08	GOOGL	Stock	108.04	109.6	107.16	108.38	24238293.0
2022-09-08	META	Stock	158.71	162.23	157.74	162.06	22530800.0
2022-09-08	TSLA	Stock	281.3	289.5	279.76	289.26	53713100.0
2022-09-08	TLT	Stock	108.84	109.52	108.05	108.07	14671366.0
2022-09-08	ES	Stock	91.5	92.44	91.14	91.42	1239000.0
2022-09-08	CL	Stock	77.96	78.3	76.85	77.84	5775200.0
2022-09-08	A	Stock	130.93	135.27	130.71	135.19	1355100.0
2022-09-08	AA	Stock	47.98	48.94	47.15	48.86	5264300.0
2022-09-08	AAC-DELISTED	Stock	9.91	9.92	9.905	9.91	404790.0
2022-09-08	AACG	Stock	2.19	2.19	2.13	2.15	34500.0
2022-09-08	AACIW-DELISTED	Stock	0.1647	0.1647	0.1475	0.1475	1250.0
2022-09-08	AAIC-DELISTED	Stock	3.19	3.21	3.18	3.2	18281.0
2022-09-08	AAIC.C-DELISTED	Stock	21.45	21.45	21.37	21.37	600.0
2022-09-08	AAL	Stock	13.67	14.12	13.56	13.96	26437600.0
2022-09-08	AAM.A-DELISTED	Stock	23.82	24.1	23.54	23.54	14147.0
2022-09-08	AAM.B-DELISTED	Stock	23.9	24.0649	23.52	23.52	14112.0
2022-09-08	AAMC-DELISTED	Stock	5.8824	5.8985	5.603	5.7118	8337.0
2022-09-08	AAME	Stock	2.81	3.03	2.81	2.93	2200.0
2022-09-08	AAMI	Stock	17.56	18.12	17.34	18.04	240100.0
2022-09-08	AAN-DELISTED	Stock	11.67	11.87	11.47	11.83	190200.0
2022-09-08	AAOI	Stock	2.27	2.37	2.27	2.35	122000.0
2022-09-08	AAON	Stock	38.0	38.08	37.48	38.08	157200.0
2022-09-08	AAP	Stock	177.67	180.59	177.0	180.29	697400.0
2022-09-08	AAQC-DELISTED	Stock	9.81	9.825	9.81	9.81	105074.0
2022-09-08	AAT	Stock	27.41	28.02	27.22	27.97	192000.0
2022-09-08	AATC	Stock	5.1699	5.1699	5.02	5.05	1337.0
2022-09-08	AAU-DELISTED	Stock	0.2276	0.2298	0.2226	0.2251	372391.0
2022-09-08	AAUAF-DELISTED	Stock	0.2276	0.2301	0.2226	0.2301	374790.0
2022-09-08	AAWW-DELISTED	Stock	99.93	99.98	99.84	99.9	674363.0
2022-09-08	AAXJ	Stock	64.74	65.11	64.51	65.08	452282.0
2022-09-08	AB	Stock	42.16	43.49	42.07	43.49	150500.0
2022-09-08	ABB-DELISTED	Stock	27.43	27.935	27.335	27.92	1315786.0
2022-09-08	ABBNY-DELISTED	Stock	27.41	27.935	27.335	27.93	1459906.0
2022-09-08	ABBV	Stock	139.64	140.57	138.65	140.52	3988300.0
2022-09-08	ABC-DELISTED	Stock	147.53	148.78	146.895	147.55	454909.0
2022-09-08	ABCB	Stock	45.4	47.32	45.2	46.9	316900.0
2022-09-08	ABCL	Stock	10.73	11.32	10.71	11.3	1047900.0
2022-09-08	ABCM-DELISTED	Stock	13.81	14.64	13.76	14.611	201568.0
2022-09-08	ABEO	Stock	3.7	3.85	3.7	3.85	37400.0
2022-09-08	ABEV	Stock	2.97	2.98	2.89	2.92	22334800.0
2022-09-08	ABG	Stock	167.51	169.48	163.44	168.19	124100.0
2022-09-08	ABM	Stock	45.22	46.21	44.75	46.06	228400.0
2022-09-08	ABMD-DELISTED	Stock	264.66	277.75	262.01	275.43	117177.0
2022-09-08	ABNB	Stock	114.0	119.347	114.0	118.58	4064000.0
2022-09-08	ABOS	Stock	6.55	6.73	6.31	6.55	82500.0
2022-09-08	ABR	Stock	14.65	14.87	14.58	14.85	1690600.0

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

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