PREVIEW / stock_daily / 2022-09-30

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-30.parquet
  size:    252 KB
  rows:    7,899
  symbols: 2,205

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-30	AAPL	Stock	141.28	143.1	138.0	138.2	124925300.0
2022-09-30	MSFT	Stock	238.29	240.54	232.73	232.9	35694800.0
2022-09-30	NVDA	Stock	12.087	12.633	12.075	12.139	565638000.0
2022-09-30	AMZN	Stock	114.08	116.92	112.84	113.0	59479600.0
2022-09-30	GOOGL	Stock	97.05	98.9	95.56	95.65	32941493.0
2022-09-30	META	Stock	136.05	140.99	135.5	135.68	33166400.0
2022-09-30	TSLA	Stock	266.15	275.57	262.47	265.25	67726600.0
2022-09-30	TLT	Stock	104.27	104.86	102.225	102.45	26485690.0
2022-09-30	ES	Stock	80.22	80.25	77.61	77.96	3345500.0
2022-09-30	CL	Stock	72.0	72.29	70.16	70.25	7510600.0
2022-09-30	A	Stock	123.02	125.13	121.38	121.55	1624200.0
2022-09-30	AA	Stock	34.81	35.74	33.55	33.66	9024600.0
2022-09-30	AAC-DELISTED	Stock	9.91	9.93	9.91	9.93	23306.0
2022-09-30	AACG	Stock	1.75	1.78	1.71	1.71	4300.0
2022-09-30	AAIC-DELISTED	Stock	2.74	2.82	2.72	2.72	68118.0
2022-09-30	AAIC.C-DELISTED	Stock	17.9	18.0001	17.9	18.0001	1570.0
2022-09-30	AAL	Stock	12.13	12.4	12.01	12.04	30111400.0
2022-09-30	AAM.A-DELISTED	Stock	23.79	24.22	23.64	24.22	63641.0
2022-09-30	AAM.B-DELISTED	Stock	23.59	23.96	23.4824	23.7	44010.0
2022-09-30	AAMC-DELISTED	Stock	4.6608	4.6608	4.6353	4.6353	3108.0
2022-09-30	AAME	Stock	2.98	2.98	2.86	2.86	1900.0
2022-09-30	AAMI	Stock	15.23	15.44	14.9	14.91	323000.0
2022-09-30	AAN-DELISTED	Stock	10.13	10.34	9.71	9.72	853800.0
2022-09-30	AAOI	Stock	2.68	2.835	2.67	2.72	394300.0
2022-09-30	AAON	Stock	36.1733	36.88	35.8267	35.92	217500.0
2022-09-30	AAP	Stock	159.0	159.2	154.46	156.34	574500.0
2022-09-30	AAQC-DELISTED	Stock	9.84	9.84	9.84	9.84	117700.0
2022-09-30	AAT	Stock	25.3	26.0	25.26	25.72	453200.0
2022-09-30	AATC	Stock	4.6	4.6153	4.52	4.55	13200.0
2022-09-30	AAU-DELISTED	Stock	0.22	0.225	0.2101	0.222	142682.0
2022-09-30	AAUAF-DELISTED	Stock	0.22	0.225	0.2101	0.22	155612.0
2022-09-30	AAWW-DELISTED	Stock	95.65	96.38	95.45	95.56	392737.0
2022-09-30	AAXJ	Stock	58.76	59.25	58.53	58.53	1708455.0
2022-09-30	AB	Stock	35.53	35.83	34.9	35.06	284100.0
2022-09-30	ABB-DELISTED	Stock	25.89	26.365	25.61	25.66	2712594.0
2022-09-30	ABBNY-DELISTED	Stock	25.89	26.365	25.61	25.66	2902642.0
2022-09-30	ABBV	Stock	142.2	142.32	134.09	134.21	15359000.0
2022-09-30	ABC-DELISTED	Stock	136.6	137.485	135.14	135.4	817986.0
2022-09-30	ABCB	Stock	44.9	45.6	44.63	44.71	394500.0
2022-09-30	ABCL	Stock	9.77	10.105	9.73	9.89	1778200.0
2022-09-30	ABCM-DELISTED	Stock	14.78	15.14	14.78	15.04	136346.0
2022-09-30	ABEO	Stock	2.95	3.09	2.95	3.04	48300.0
2022-09-30	ABEV	Stock	2.85	2.88	2.82	2.83	28473100.0
2022-09-30	ABG	Stock	146.77	153.72	144.13	151.1	315500.0
2022-09-30	ABGI-DELISTED	Stock	9.93	9.93	9.93	9.93	31456.0
2022-09-30	ABM	Stock	38.53	39.26	38.17	38.23	373100.0
2022-09-30	ABMD-DELISTED	Stock	249.53	257.08	245.36	245.66	258164.0
2022-09-30	ABNB	Stock	104.76	109.08	104.73	105.04	4750600.0
2022-09-30	ABOS	Stock	10.64	10.97	9.78	10.03	2858600.0
2022-09-30	ABR	Stock	11.65	11.93	11.49	11.5	2724500.0

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

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