PREVIEW / stock_daily / 2022-10-18

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-18.parquet
  size:    251 KB
  rows:    7,864
  symbols: 2,160

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-18	AAPL	Stock	145.49	146.7	140.61	143.75	99136600.0
2022-10-18	MSFT	Stock	243.24	243.93	235.37	238.5	26329600.0
2022-10-18	NVDA	Stock	12.344	12.492	11.618	11.967	659362000.0
2022-10-18	AMZN	Stock	119.06	119.52	114.79	116.36	65607400.0
2022-10-18	GOOGL	Stock	103.13	103.47	99.97	100.77	24060671.0
2022-10-18	META	Stock	137.09	137.84	131.4	132.8	25445000.0
2022-10-18	TSLA	Stock	229.5	229.82	217.25	220.19	75891900.0
2022-10-18	TLT	Stock	97.95	98.46	96.87	98.32	16931451.0
2022-10-18	ES	Stock	75.29	76.02	74.91	75.86	1955800.0
2022-10-18	CL	Stock	72.94	74.9	72.43	72.92	10417100.0
2022-10-18	A	Stock	133.92	134.68	131.2	132.3	1038100.0
2022-10-18	AA	Stock	40.37	40.58	38.578	39.71	5082700.0
2022-10-18	AAC-DELISTED	Stock	9.98	9.98	9.95	9.95	128495.0
2022-10-18	AACG	Stock	1.93	1.93	1.84	1.89	14000.0
2022-10-18	AACIU	Stock	9.95	9.95	9.95	9.95	500.0
2022-10-18	AACIW-DELISTED	Stock	0.0748	0.0748	0.0748	0.0748	200.0
2022-10-18	AAIC-DELISTED	Stock	2.8	2.92	2.8	2.86	62028.0
2022-10-18	AAIC.C-DELISTED	Stock	20.24	20.24	20.24	20.24	179.0
2022-10-18	AAL	Stock	13.57	13.88	13.46	13.7	38762400.0
2022-10-18	AAM.A-DELISTED	Stock	22.91	22.95	22.57	22.57	9749.0
2022-10-18	AAM.B-DELISTED	Stock	22.82	23.0315	22.5354	22.98	12399.0
2022-10-18	AAMC-DELISTED	Stock	4.2647	4.4588	4.2353	4.4	9496.0
2022-10-18	AAME	Stock	2.77	2.86	2.75	2.75	1500.0
2022-10-18	AAMI	Stock	18.08	18.11	17.55	17.64	239700.0
2022-10-18	AAN-DELISTED	Stock	9.26	9.47	8.84	8.88	300900.0
2022-10-18	AAOI	Stock	2.87	2.97	2.835	2.92	224700.0
2022-10-18	AAON	Stock	37.6667	38.2267	37.3667	37.5533	246450.0
2022-10-18	AAP	Stock	173.23	175.56	172.4	174.73	691100.0
2022-10-18	AAQC-DELISTED	Stock	9.87	9.88	9.863	9.88	333399.0
2022-10-18	AAT	Stock	26.35	26.64	26.05	26.33	340800.0
2022-10-18	AATC	Stock	4.43	4.52	4.39	4.43	5802.0
2022-10-18	AAU-DELISTED	Stock	0.2375	0.2402	0.2251	0.23	192605.0
2022-10-18	AAUAF-DELISTED	Stock	0.2375	0.2402	0.2251	0.23	194893.0
2022-10-18	AAWW-DELISTED	Stock	99.99	100.28	99.55	99.92	192186.0
2022-10-18	AAXJ	Stock	58.87	58.88	57.795	58.08	602377.0
2022-10-18	AB	Stock	34.95	35.43	34.34	34.5	455000.0
2022-10-18	ABB-DELISTED	Stock	27.16	27.205	26.5512	26.885	1989240.0
2022-10-18	ABBNY-DELISTED	Stock	27.16	27.205	26.5512	26.87	2129778.0
2022-10-18	ABBV	Stock	145.23	145.87	143.53	144.6	3540400.0
2022-10-18	ABC-DELISTED	Stock	144.22	145.25	143.15	144.11	511923.0
2022-10-18	ABCB	Stock	51.21	51.71	50.05	50.35	429700.0
2022-10-18	ABCL	Stock	10.93	11.06	10.51	10.64	1093900.0
2022-10-18	ABCM-DELISTED	Stock	15.28	15.62	15.27	15.54	188301.0
2022-10-18	ABEO	Stock	4.1	4.16	3.64	3.71	638400.0
2022-10-18	ABEV	Stock	2.81	2.84	2.77	2.8	18917400.0
2022-10-18	ABG	Stock	160.81	163.74	158.94	159.0	193800.0
2022-10-18	ABGI-DELISTED	Stock	9.93	9.94	9.93	9.94	118819.0
2022-10-18	ABM	Stock	41.92	42.38	41.44	41.72	195500.0
2022-10-18	ABMD-DELISTED	Stock	264.87	267.94	258.17	259.17	134104.0
2022-10-18	ABNB	Stock	120.03	120.71	115.7	117.94	5580000.0

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

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