PREVIEW / stock_daily / 2022-10-21

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-21.parquet
  size:    251 KB
  rows:    7,853
  symbols: 2,146

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-21	AAPL	Stock	142.87	147.85	142.65	147.27	86548600.0
2022-10-21	MSFT	Stock	234.74	243.0	234.5	242.12	26299700.0
2022-10-21	NVDA	Stock	12.098	12.498	11.887	12.466	609494000.0
2022-10-21	AMZN	Stock	114.79	119.59	114.5	119.32	55660500.0
2022-10-21	GOOGL	Stock	97.845	101.31	97.72	101.13	32458722.0
2022-10-21	META	Stock	126.31	130.12	125.44	130.01	46348600.0
2022-10-21	TSLA	Stock	206.42	214.66	203.8	214.44	75713800.0
2022-10-21	TLT	Stock	93.02	93.93	92.26	93.17	46280271.0
2022-10-21	ES	Stock	71.88	73.04	71.33	72.59	1531100.0
2022-10-21	CL	Stock	70.48	71.77	70.25	71.47	5947100.0
2022-10-21	A	Stock	126.37	130.13	124.82	129.88	1067000.0
2022-10-21	AA	Stock	38.85	41.92	38.56	41.06	13762600.0
2022-10-21	AAC-DELISTED	Stock	9.94	9.96	9.94	9.95	102581.0
2022-10-21	AACG	Stock	1.85	1.85	1.82	1.82	6500.0
2022-10-21	AACIW-DELISTED	Stock	0.08	0.08	0.08	0.08	501.0
2022-10-21	AAIC-DELISTED	Stock	2.82	2.8499	2.82	2.83	7741.0
2022-10-21	AAIC.C-DELISTED	Stock	19.63	19.9102	19.63	19.9102	2834.0
2022-10-21	AAL	Stock	13.36	13.87	13.21	13.71	36760000.0
2022-10-21	AAM.A-DELISTED	Stock	21.87	21.87	20.98	21.04	116871.0
2022-10-21	AAM.B-DELISTED	Stock	22.15	22.3114	21.1859	21.22	31191.0
2022-10-21	AAMC-DELISTED	Stock	4.3412	4.3824	4.0735	4.1176	16157.0
2022-10-21	AAME	Stock	2.76	2.76	2.76	2.76	300.0
2022-10-21	AAMI	Stock	17.34	17.57	17.02	17.39	481900.0
2022-10-21	AAN-DELISTED	Stock	8.62	8.75	8.35	8.71	260400.0
2022-10-21	AAOI	Stock	2.84	2.85	2.7	2.74	277300.0
2022-10-21	AAON	Stock	36.5267	37.74	35.9	37.5	270900.0
2022-10-21	AAP	Stock	170.59	172.78	169.5	171.34	826300.0
2022-10-21	AAQC-DELISTED	Stock	9.88	9.88	9.87	9.88	12559.0
2022-10-21	AAT	Stock	25.98	26.28	25.66	26.25	306500.0
2022-10-21	AATC	Stock	4.4	4.4	4.36	4.36	6840.0
2022-10-21	AAU-DELISTED	Stock	0.2379	0.2401	0.232	0.235	188362.0
2022-10-21	AAUAF-DELISTED	Stock	0.2379	0.2401	0.232	0.235	190344.0
2022-10-21	AAWW-DELISTED	Stock	101.1	101.1	100.41	100.5	236965.0
2022-10-21	AAXJ	Stock	56.81	57.72	56.66	57.7	643983.0
2022-10-21	AB	Stock	33.64	35.03	33.55	35.01	270300.0
2022-10-21	ABB-DELISTED	Stock	26.43	27.435	26.36	27.42	1298326.0
2022-10-21	ABBNY-DELISTED	Stock	26.43	27.435	26.36	27.41	1414157.0
2022-10-21	ABBV	Stock	143.34	147.76	142.43	147.06	5419400.0
2022-10-21	ABC-DELISTED	Stock	142.47	148.39	142.47	147.76	1168615.0
2022-10-21	ABCB	Stock	48.67	49.2	48.13	48.71	465300.0
2022-10-21	ABCL	Stock	10.18	10.35	9.83	10.31	1441800.0
2022-10-21	ABCM-DELISTED	Stock	13.8	14.33	13.72	14.31	162580.0
2022-10-21	ABEO	Stock	3.97	3.97	3.58	3.61	242400.0
2022-10-21	ABEV	Stock	2.83	2.94	2.82	2.94	35941100.0
2022-10-21	ABG	Stock	140.74	144.39	138.88	143.15	207800.0
2022-10-21	ABGI-DELISTED	Stock	9.94	9.94	9.94	9.94	100.0
2022-10-21	ABM	Stock	41.21	41.97	40.69	41.82	203200.0
2022-10-21	ABMD-DELISTED	Stock	251.4	256.96	247.18	256.22	129903.0
2022-10-21	ABNB	Stock	116.76	120.34	114.64	119.95	4146100.0
2022-10-21	ABOS	Stock	7.32	7.79	7.15	7.64	69700.0

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

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