PREVIEW / stock_daily / 2022-10-04

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-04.parquet
  size:    254 KB
  rows:    7,979
  symbols: 2,262

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-10-04	AAPL	Stock	145.03	146.22	144.26	146.1	87830100.0
2022-10-04	MSFT	Stock	245.09	250.36	244.98	248.88	34888400.0
2022-10-04	NVDA	Stock	12.879	13.22	12.879	13.167	584182000.0
2022-10-04	AMZN	Stock	119.89	123.0	119.79	121.09	62812600.0
2022-10-04	GOOGL	Stock	100.44	101.84	100.38	101.64	28850773.0
2022-10-04	META	Stock	140.49	142.39	139.34	140.28	34670700.0
2022-10-04	TSLA	Stock	250.52	257.5	242.01	249.44	109578500.0
2022-10-04	TLT	Stock	104.15	104.6499	103.3	103.54	13788739.0
2022-10-04	ES	Stock	80.23	81.81	80.04	81.02	1818000.0
2022-10-04	CL	Stock	71.28	72.42	71.22	71.84	4066900.0
2022-10-04	A	Stock	128.79	131.56	128.57	131.41	1647800.0
2022-10-04	AA	Stock	39.16	40.39	38.38	40.23	9700700.0
2022-10-04	AAC-DELISTED	Stock	9.94	9.95	9.925	9.95	1808781.0
2022-10-04	AACG	Stock	1.71	1.85	1.71	1.82	5200.0
2022-10-04	AACIW-DELISTED	Stock	0.0948	0.0948	0.07	0.07	1540.0
2022-10-04	AAIC-DELISTED	Stock	2.89	3.01	2.89	2.96	48227.0
2022-10-04	AAIC.C-DELISTED	Stock	18.32	18.98	18.3005	18.8999	2230.0
2022-10-04	AAL	Stock	12.31	13.05	12.3	12.95	47616000.0
2022-10-04	AAM.A-DELISTED	Stock	24.47	24.61	23.7	23.7	15315.0
2022-10-04	AAM.B-DELISTED	Stock	24.08	24.1899	23.58	23.75	30472.0
2022-10-04	AAMC-DELISTED	Stock	4.8118	4.9412	4.7	4.7	18571.0
2022-10-04	AAME	Stock	2.89	2.89	2.8	2.8	1100.0
2022-10-04	AAMI	Stock	15.41	16.02	15.41	15.95	371100.0
2022-10-04	AAN-DELISTED	Stock	10.14	10.58	10.14	10.34	567800.0
2022-10-04	AAOI	Stock	2.82	2.99	2.79	2.94	424400.0
2022-10-04	AAON	Stock	37.42	38.2067	37.16	37.5333	266400.0
2022-10-04	AAP	Stock	165.55	168.13	165.32	167.83	721500.0
2022-10-04	AAQC-DELISTED	Stock	9.83	9.8301	9.83	9.83	6908.0
2022-10-04	AAT	Stock	25.88	26.6	25.88	26.2	320500.0
2022-10-04	AATC	Stock	4.6	4.6435	4.53	4.55	7477.0
2022-10-04	AAU-DELISTED	Stock	0.23	0.2426	0.225	0.24	482395.0
2022-10-04	AAUAF-DELISTED	Stock	0.23	0.2426	0.225	0.2405	494059.0
2022-10-04	AAWW-DELISTED	Stock	97.72	98.41	97.54	97.75	431400.0
2022-10-04	AAXJ	Stock	60.24	61.26	60.18	61.08	1026997.0
2022-10-04	AB	Stock	36.62	37.3	36.61	36.84	278200.0
2022-10-04	ABB-DELISTED	Stock	25.81	26.435	25.78	26.375	3062504.0
2022-10-04	ABBNY-DELISTED	Stock	25.81	26.435	25.78	26.38	3568675.0
2022-10-04	ABBV	Stock	139.21	142.72	137.76	141.99	6612300.0
2022-10-04	ABC-DELISTED	Stock	140.02	142.8516	139.57	142.73	757189.0
2022-10-04	ABCB	Stock	46.31	48.35	46.31	48.34	312700.0
2022-10-04	ABCL	Stock	10.51	11.24	10.34	11.24	2597000.0
2022-10-04	ABCM-DELISTED	Stock	15.77	16.28	15.77	16.27	203534.0
2022-10-04	ABEO	Stock	3.5	3.96	3.38	3.41	604400.0
2022-10-04	ABEV	Stock	3.15	3.16	3.06	3.1	33031900.0
2022-10-04	ABG	Stock	159.56	161.96	157.06	160.76	226700.0
2022-10-04	ABLV	Stock	9.96	10.03	9.96	10.03	2919.0
2022-10-04	ABM	Stock	39.93	42.09	39.93	41.99	542800.0
2022-10-04	ABMD-DELISTED	Stock	261.82	264.63	260.62	264.13	140589.0
2022-10-04	ABNB	Stock	109.14	111.61	108.68	110.81	4835000.0
2022-10-04	ABOS	Stock	9.29	10.02	9.29	9.55	524900.0

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

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