PREVIEW / stock_daily / 2022-09-12

all stock daily files

  file:    by_date/stock_daily/2022/2022-09-12.parquet
  size:    252 KB
  rows:    7,876
  symbols: 2,210

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-12	AAPL	Stock	159.59	164.26	159.3	163.43	104956000.0
2022-09-12	MSFT	Stock	265.78	267.45	265.16	266.65	18747700.0
2022-09-12	NVDA	Stock	14.369	14.547	14.198	14.505	484159000.0
2022-09-12	AMZN	Stock	134.1	136.49	134.0	136.45	53826900.0
2022-09-12	GOOGL	Stock	110.99	111.62	109.93	110.86	22966752.0
2022-09-12	META	Stock	167.39	171.39	167.28	168.96	23220400.0
2022-09-12	TSLA	Stock	300.72	305.49	300.4	304.42	48674600.0
2022-09-12	TLT	Stock	108.63	108.89	106.92	107.42	14806921.0
2022-09-12	ES	Stock	91.83	92.8	91.59	92.54	964800.0
2022-09-12	CL	Stock	78.14	78.62	77.63	77.9	6390600.0
2022-09-12	A	Stock	137.53	140.0	137.23	139.87	1851100.0
2022-09-12	AA	Stock	53.4	53.79	51.56	52.34	5283200.0
2022-09-12	AAC-DELISTED	Stock	9.91	9.92	9.905	9.915	1256476.0
2022-09-12	AACG	Stock	1.96	2.05	1.96	2.01	5100.0
2022-09-12	AACIW-DELISTED	Stock	0.1799	0.18	0.137	0.18	1601.0
2022-09-12	AAIC-DELISTED	Stock	3.2	3.2166	3.19	3.2	25296.0
2022-09-12	AAIC.C-DELISTED	Stock	21.6	21.6	21.6	21.6	300.0
2022-09-12	AAL	Stock	14.35	14.67	14.32	14.47	27655300.0
2022-09-12	AAM.A-DELISTED	Stock	24.15	24.35	23.962	24.29	4469.0
2022-09-12	AAM.B-DELISTED	Stock	23.97	24.27	23.93	24.1572	3469.0
2022-09-12	AAMC-DELISTED	Stock	5.7353	5.7853	5.3765	5.7853	4862.0
2022-09-12	AAME	Stock	3.01	3.06	2.95	2.95	11100.0
2022-09-12	AAMI	Stock	18.49	18.55	18.22	18.38	281700.0
2022-09-12	AAN-DELISTED	Stock	12.43	12.84	12.26	12.56	207500.0
2022-09-12	AAOI	Stock	2.56	2.69	2.46	2.5	255000.0
2022-09-12	AAON	Stock	38.4133	39.6133	38.3733	39.5133	296400.0
2022-09-12	AAP	Stock	182.0	183.63	180.54	181.49	662700.0
2022-09-12	AAQC-DELISTED	Stock	9.82	9.82	9.82	9.82	100.0
2022-09-12	AAT	Stock	28.41	28.69	28.08	28.45	230700.0
2022-09-12	AATC	Stock	5.2	5.22	5.125	5.17	8176.0
2022-09-12	AAU-DELISTED	Stock	0.231	0.2327	0.2209	0.23	308611.0
2022-09-12	AAUAF-DELISTED	Stock	0.231	0.2327	0.2209	0.23	313458.0
2022-09-12	AAWW-DELISTED	Stock	99.99	100.26	99.78	99.93	514447.0
2022-09-12	AAXJ	Stock	66.42	66.95	66.35	66.87	677781.0
2022-09-12	AB	Stock	43.79	44.48	43.41	43.72	208100.0
2022-09-12	ABB-DELISTED	Stock	29.17	29.37	29.06	29.09	1842053.0
2022-09-12	ABBNY-DELISTED	Stock	29.17	29.37	29.06	29.09	1979835.0
2022-09-12	ABBV	Stock	141.01	142.87	140.32	142.24	4938400.0
2022-09-12	ABC-DELISTED	Stock	148.06	149.505	147.15	147.71	511678.0
2022-09-12	ABCB	Stock	47.58	48.26	47.08	48.18	355200.0
2022-09-12	ABCL	Stock	11.22	11.275	10.98	11.08	1166900.0
2022-09-12	ABCM-DELISTED	Stock	15.21	15.81	15.0149	15.7	236047.0
2022-09-12	ABEO	Stock	3.95	3.97	3.72	3.94	62900.0
2022-09-12	ABEV	Stock	3.01	3.05	3.0	3.03	12191000.0
2022-09-12	ABG	Stock	171.06	175.73	171.06	174.19	110700.0
2022-09-12	ABGI-DELISTED	Stock	9.885	9.885	9.885	9.885	100.0
2022-09-12	ABLV	Stock	9.94	9.95	9.94	9.94	359990.0
2022-09-12	ABM	Stock	45.54	45.84	42.53	43.87	838400.0
2022-09-12	ABMD-DELISTED	Stock	282.74	282.75	277.96	279.32	190933.0
2022-09-12	ABNB	Stock	124.25	127.24	123.785	124.79	6993300.0

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

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