PREVIEW / stock_daily / 2022-11-29

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-29.parquet
  size:    248 KB
  rows:    7,780
  symbols: 2,054

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-11-29	AAPL	Stock	144.29	144.81	140.35	141.17	83763800.0
2022-11-29	MSFT	Stock	241.4	242.79	238.21	240.33	17956300.0
2022-11-29	NVDA	Stock	15.827	15.932	15.52	15.639	298384000.0
2022-11-29	AMZN	Stock	94.04	94.41	91.44	92.42	65567300.0
2022-11-29	GOOGL	Stock	95.73	96.12	94.11	95.19	20061720.0
2022-11-29	META	Stock	109.54	110.94	108.54	109.46	23899200.0
2022-11-29	TSLA	Stock	184.99	186.38	178.75	180.83	83357100.0
2022-11-29	TLT	Stock	102.15	102.96	101.91	101.98	16576438.0
2022-11-29	ES	Stock	80.91	81.7	80.12	80.65	1704500.0
2022-11-29	CL	Stock	75.96	76.38	75.64	75.97	2499800.0
2022-11-29	A	Stock	151.88	152.9	150.49	150.94	954600.0
2022-11-29	AA	Stock	47.78	48.313	47.451	47.7	3632200.0
2022-11-29	AAC-DELISTED	Stock	10.0	10.02	10.0	10.01	994362.0
2022-11-29	AACG	Stock	1.82	1.82	1.7	1.77	2200.0
2022-11-29	AAIC-DELISTED	Stock	3.06	3.08	3.06	3.06	46580.0
2022-11-29	AAIC.C-DELISTED	Stock	21.5104	21.54	21.5104	21.54	600.0
2022-11-29	AAL	Stock	13.89	14.16	13.83	14.14	17335300.0
2022-11-29	AAM.A-DELISTED	Stock	24.18	24.18	23.82	23.82	6970.0
2022-11-29	AAM.B-DELISTED	Stock	24.0	24.05	23.5	23.62	13947.0
2022-11-29	AAMC-DELISTED	Stock	6.1765	6.4441	5.8824	5.9333	7089.0
2022-11-29	AAME	Stock	2.88	2.88	2.83	2.83	1200.0
2022-11-29	AAMI	Stock	19.46	19.83	19.43	19.74	105300.0
2022-11-29	AAN-DELISTED	Stock	11.55	12.14	11.4	11.85	284400.0
2022-11-29	AAOI	Stock	2.11	2.15	2.09	2.11	121600.0
2022-11-29	AAON	Stock	50.3933	51.36	49.76	51.2467	464250.0
2022-11-29	AAP	Stock	150.34	150.67	146.5	147.93	1138400.0
2022-11-29	AAQC-DELISTED	Stock	10.03	10.065	10.03	10.06	1020291.0
2022-11-29	AAT	Stock	27.93	28.48	27.88	28.46	352600.0
2022-11-29	AATC	Stock	4.85	4.9175	4.85	4.88	8057.0
2022-11-29	AAU-DELISTED	Stock	0.25	0.2512	0.2301	0.2365	113922.0
2022-11-29	AAUAF-DELISTED	Stock	0.25	0.2512	0.2301	0.2346	122608.0
2022-11-29	AAWW-DELISTED	Stock	100.66	100.8	100.47	100.67	205375.0
2022-11-29	AAXJ	Stock	64.45	64.72	64.31	64.55	538616.0
2022-11-29	AB	Stock	40.01	40.66	39.88	40.36	196200.0
2022-11-29	ABB-DELISTED	Stock	31.11	31.18	30.67	30.87	909051.0
2022-11-29	ABBNY-DELISTED	Stock	31.11	31.18	30.67	30.87	1026613.0
2022-11-29	ABBV	Stock	158.31	159.43	157.21	158.2	3689000.0
2022-11-29	ABC-DELISTED	Stock	167.03	168.6	166.47	167.85	1345704.0
2022-11-29	ABCB	Stock	51.96	52.42	51.52	52.11	303600.0
2022-11-29	ABCL	Stock	13.56	13.699	13.25	13.36	1169000.0
2022-11-29	ABCM-DELISTED	Stock	15.52	15.52	14.96	15.325	567382.0
2022-11-29	ABEO	Stock	3.85	3.95	3.8	3.81	141000.0
2022-11-29	ABEV	Stock	2.97	2.98	2.92	2.92	24456700.0
2022-11-29	ABG	Stock	180.18	184.66	180.18	182.09	140900.0
2022-11-29	ABGI-DELISTED	Stock	10.02	10.03	10.02	10.03	115600.0
2022-11-29	ABLV	Stock	10.11	10.11	10.11	10.11	701.0
2022-11-29	ABM	Stock	45.24	45.67	44.96	45.65	179600.0
2022-11-29	ABMD-DELISTED	Stock	377.58	377.83	377.3	377.33	362299.0
2022-11-29	ABNB	Stock	96.1	97.26	95.3	95.38	3694000.0
2022-11-29	ABOS	Stock	6.31	6.31	5.75	5.84	121300.0

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

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