PREVIEW / stock_daily / 2022-10-14

all stock daily files

  file:    by_date/stock_daily/2022/2022-10-14.parquet
  size:    249 KB
  rows:    7,802
  symbols: 2,124

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-14	AAPL	Stock	144.31	144.52	138.19	138.38	88598000.0
2022-10-14	MSFT	Stock	235.54	237.24	228.34	228.56	30198600.0
2022-10-14	NVDA	Stock	12.057	12.111	11.204	11.227	713432000.0
2022-10-14	AMZN	Stock	114.1	114.96	106.6	106.9	67737300.0
2022-10-14	GOOGL	Stock	99.99	100.69	96.37	96.56	25410674.0
2022-10-14	META	Stock	131.0	131.79	126.52	126.76	23559400.0
2022-10-14	TSLA	Stock	224.01	226.26	204.16	204.99	94124500.0
2022-10-14	TLT	Stock	100.19	100.19	98.25	98.57	18732892.0
2022-10-14	ES	Stock	74.55	74.63	72.02	72.56	2204600.0
2022-10-14	CL	Stock	71.32	72.14	70.89	71.33	4964800.0
2022-10-14	A	Stock	129.0	130.22	125.47	125.7	1217200.0
2022-10-14	AA	Stock	40.94	40.94	37.89	38.35	5605600.0
2022-10-14	AAC-DELISTED	Stock	9.94	9.945	9.94	9.94	49206.0
2022-10-14	AACG	Stock	1.85	1.92	1.85	1.87	9900.0
2022-10-14	AAIC-DELISTED	Stock	2.87	2.87	2.78	2.8	26657.0
2022-10-14	AAL	Stock	13.35	13.58	12.96	13.11	34831700.0
2022-10-14	AAM.A-DELISTED	Stock	23.11	23.11	22.81	22.9381	6796.0
2022-10-14	AAM.B-DELISTED	Stock	22.64	23.14	22.4956	22.562	12734.0
2022-10-14	AAMC-DELISTED	Stock	3.8118	4.0765	3.7324	3.9441	11676.0
2022-10-14	AAME	Stock	2.92	2.92	2.76	2.77	800.0
2022-10-14	AAMI	Stock	18.6	18.725	17.16	17.64	515900.0
2022-10-14	AAN-DELISTED	Stock	9.24	9.35	8.84	8.86	271100.0
2022-10-14	AAOI	Stock	2.77	2.85	2.7	2.74	160600.0
2022-10-14	AAON	Stock	36.9667	36.9667	36.06	36.1467	130200.0
2022-10-14	AAP	Stock	172.48	173.32	168.2	168.57	552200.0
2022-10-14	AAQC-DELISTED	Stock	9.86	9.87	9.86	9.87	58386.0
2022-10-14	AAT	Stock	25.74	25.89	24.85	24.96	301100.0
2022-10-14	AATC	Stock	4.4042	4.42	4.4042	4.42	1324.0
2022-10-14	AAU-DELISTED	Stock	0.23	0.24	0.2211	0.222	159190.0
2022-10-14	AAUAF-DELISTED	Stock	0.23	0.24	0.2211	0.222	160499.0
2022-10-14	AAWW-DELISTED	Stock	99.5	99.79	99.2	99.65	169713.0
2022-10-14	AAXJ	Stock	57.86	58.14	56.84	56.9	1151216.0
2022-10-14	AB	Stock	33.31	33.58	32.36	32.45	339900.0
2022-10-14	ABB-DELISTED	Stock	25.82	25.91	25.09	25.15	1821458.0
2022-10-14	ABBNY-DELISTED	Stock	25.82	25.91	25.09	25.15	1957037.0
2022-10-14	ABBV	Stock	142.6	144.48	142.21	142.94	5290500.0
2022-10-14	ABC-DELISTED	Stock	143.31	143.7	139.755	140.73	492060.0
2022-10-14	ABCB	Stock	50.31	50.89	49.21	49.48	269300.0
2022-10-14	ABCL	Stock	10.84	10.95	10.29	10.34	855400.0
2022-10-14	ABCM-DELISTED	Stock	15.45	15.52	14.99	15.06	147575.0
2022-10-14	ABEO	Stock	5.2	5.42	4.29	4.3	624600.0
2022-10-14	ABEV	Stock	2.82	2.83	2.74	2.74	23399000.0
2022-10-14	ABG	Stock	160.78	160.78	153.57	154.43	93800.0
2022-10-14	ABGI-DELISTED	Stock	9.93	9.93	9.93	9.93	100.0
2022-10-14	ABM	Stock	41.23	41.55	39.51	39.57	207600.0
2022-10-14	ABMD-DELISTED	Stock	261.85	262.64	248.77	249.24	227221.0
2022-10-14	ABNB	Stock	115.0	116.448	109.01	109.16	5001700.0
2022-10-14	ABOS	Stock	8.0	8.32	7.82	7.91	203800.0
2022-10-14	ABR	Stock	12.57	12.78	12.05	12.09	2310900.0
2022-10-14	ABR.D	Stock	18.05	18.05	17.82	17.9	6600.0

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

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