PREVIEW / stock_daily / 2022-10-05

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-05.parquet
  size:    250 KB
  rows:    7,813
  symbols: 2,149

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-05	AAPL	Stock	144.07	147.38	143.01	146.4	79471000.0
2022-10-05	MSFT	Stock	245.99	250.58	244.1	249.2	20347100.0
2022-10-05	NVDA	Stock	12.911	13.321	12.621	13.209	507131000.0
2022-10-05	AMZN	Stock	118.58	121.75	117.69	120.95	48217500.0
2022-10-05	GOOGL	Stock	99.825	101.93	98.8	101.43	22176903.0
2022-10-05	META	Stock	138.24	140.21	134.78	138.98	27979300.0
2022-10-05	TSLA	Stock	245.01	246.67	233.27	240.81	86982700.0
2022-10-05	TLT	Stock	102.73	102.84	101.5802	102.55	20522057.0
2022-10-05	ES	Stock	79.95	80.0	78.01	78.9	1395600.0
2022-10-05	CL	Stock	72.1	72.1	70.61	71.11	3467800.0
2022-10-05	A	Stock	129.99	133.53	129.5	132.64	1567700.0
2022-10-05	AA	Stock	38.93	40.42	38.31	40.08	7798400.0
2022-10-05	AAC-DELISTED	Stock	9.95	9.95	9.94	9.95	415782.0
2022-10-05	AACG	Stock	1.72	1.85	1.72	1.83	6500.0
2022-10-05	AACIW-DELISTED	Stock	0.09	0.09	0.0709	0.0709	2100.0
2022-10-05	AAIC-DELISTED	Stock	2.9	2.9179	2.8	2.85	34144.0
2022-10-05	AAIC.C-DELISTED	Stock	18.8999	18.99	18.87	18.99	3524.0
2022-10-05	AAL	Stock	12.63	12.96	12.43	12.87	28172500.0
2022-10-05	AAM.A-DELISTED	Stock	23.7449	23.986	23.7449	23.986	500.0
2022-10-05	AAM.B-DELISTED	Stock	23.65	23.89	23.5488	23.6981	5484.0
2022-10-05	AAME	Stock	2.83	2.83	2.8	2.8	1000.0
2022-10-05	AAMI	Stock	15.65	15.895	15.44	15.86	180300.0
2022-10-05	AAN-DELISTED	Stock	10.14	10.235	9.95	10.21	335200.0
2022-10-05	AAOI	Stock	2.91	3.09	2.87	3.01	582300.0
2022-10-05	AAON	Stock	36.9933	37.7133	36.9467	37.5667	208650.0
2022-10-05	AAP	Stock	166.27	169.6	164.96	167.64	690300.0
2022-10-05	AAQC-DELISTED	Stock	9.83	9.8303	9.82	9.83	4496.0
2022-10-05	AAT	Stock	25.81	25.85	24.78	25.32	280400.0
2022-10-05	AATC	Stock	4.5	4.5376	4.45	4.48	4819.0
2022-10-05	AAU-DELISTED	Stock	0.2376	0.2416	0.2302	0.2358	180636.0
2022-10-05	AAUAF-DELISTED	Stock	0.2376	0.2416	0.2302	0.2392	185099.0
2022-10-05	AAWW-DELISTED	Stock	97.61	98.29	97.17	97.94	240564.0
2022-10-05	AAXJ	Stock	60.99	61.42	60.63	61.2	635997.0
2022-10-05	AB	Stock	36.31	36.73	35.87	36.09	234900.0
2022-10-05	ABB-DELISTED	Stock	25.91	26.27	25.575	26.06	1815554.0
2022-10-05	ABBNY-DELISTED	Stock	25.91	26.27	25.575	26.06	1976084.0
2022-10-05	ABBV	Stock	141.47	144.47	141.11	143.33	4777900.0
2022-10-05	ABC-DELISTED	Stock	141.84	143.5196	141.1	142.47	470523.0
2022-10-05	ABCB	Stock	47.53	48.51	47.52	48.49	253900.0
2022-10-05	ABCL	Stock	11.0	11.4	10.761	11.23	2369000.0
2022-10-05	ABCM-DELISTED	Stock	15.8	16.25	15.8	16.19	218656.0
2022-10-05	ABEO	Stock	3.49	3.63	3.18	3.21	1131000.0
2022-10-05	ABEV	Stock	3.06	3.1	2.99	3.07	66769900.0
2022-10-05	ABG	Stock	157.69	159.67	154.14	158.04	167100.0
2022-10-05	ABGI-DELISTED	Stock	9.9	9.9	9.9	9.9	255701.0
2022-10-05	ABLV	Stock	10.0	10.005	9.97	9.97	5534.0
2022-10-05	ABM	Stock	41.06	42.01	40.86	41.65	324900.0
2022-10-05	ABMD-DELISTED	Stock	260.79	265.4	258.8	264.24	143270.0
2022-10-05	ABNB	Stock	110.52	112.34	107.84	111.76	4008700.0
2022-10-05	ABOS	Stock	10.32	10.39	9.82	10.17	1019900.0

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

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