PREVIEW / stock_daily / 2022-07-19

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-19.parquet
  size:    255 KB
  rows:    7,916
  symbols: 2,295

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-07-19	AAPL	Stock	147.92	151.23	146.91	151.0	82982400.0
2022-07-19	MSFT	Stock	257.58	259.72	253.68	259.53	25012600.0
2022-07-19	NVDA	Stock	16.486	17.11	16.172	16.992	702366000.0
2022-07-19	AMZN	Stock	115.7	118.95	114.03	118.21	60990000.0
2022-07-19	GOOGL	Stock	110.85	114.02	109.56	113.81	36530945.0
2022-07-19	META	Stock	170.37	176.49	169.51	175.78	25933700.0
2022-07-19	TSLA	Stock	245.0	247.14	236.9767	245.53	80890200.0
2022-07-19	TLT	Stock	114.91	115.15	113.66	114.31	9276754.0
2022-07-19	ES	Stock	83.03	83.68	82.79	83.25	1297200.0
2022-07-19	CL	Stock	77.49	77.92	77.27	77.53	3712500.0
2022-07-19	A	Stock	116.99	119.34	116.37	119.06	1296900.0
2022-07-19	AA	Stock	43.29	44.92	42.85	44.9	5484100.0
2022-07-19	AAC-DELISTED	Stock	9.83	9.845	9.825	9.845	150498.0
2022-07-19	AACG	Stock	1.25	1.3	1.25	1.29	19000.0
2022-07-19	AACIU	Stock	9.97	9.97	9.97	9.97	2043.0
2022-07-19	AACIW-DELISTED	Stock	0.1601	0.1941	0.1599	0.17	58002.0
2022-07-19	AAIC-DELISTED	Stock	3.11	3.15	3.1	3.12	34525.0
2022-07-19	AAIC.C-DELISTED	Stock	20.06	20.66	20.0	20.3	15987.0
2022-07-19	AAL	Stock	14.9	15.27	14.87	15.16	30099600.0
2022-07-19	AAM.A-DELISTED	Stock	24.32	24.6	24.32	24.58	20573.0
2022-07-19	AAM.B-DELISTED	Stock	24.66	24.88	24.6	24.8	7676.0
2022-07-19	AAMC-DELISTED	Stock	3.2118	3.2353	3.15	3.2353	7806.0
2022-07-19	AAME	Stock	2.9	2.91	2.72	2.73	2200.0
2022-07-19	AAMI	Stock	17.59	18.2	17.55	18.12	159000.0
2022-07-19	AAN-DELISTED	Stock	15.69	16.0	15.351	15.88	318200.0
2022-07-19	AAOI	Stock	1.69	1.78	1.69	1.76	131000.0
2022-07-19	AAON	Stock	35.18	36.4733	34.2267	36.2067	174300.0
2022-07-19	AAP	Stock	188.3	190.92	186.38	190.65	646100.0
2022-07-19	AAQC-DELISTED	Stock	9.78	9.7941	9.78	9.78	2767.0
2022-07-19	AAT	Stock	29.9	30.13	29.89	30.11	368200.0
2022-07-19	AATC	Stock	4.91	5.0399	4.9	4.9999	17003.0
2022-07-19	AAU-DELISTED	Stock	0.222	0.2289	0.22	0.228	227901.0
2022-07-19	AAUAF-DELISTED	Stock	0.222	0.2289	0.22	0.228	236360.0
2022-07-19	AAWW-DELISTED	Stock	63.3	67.53	63.3	67.36	517969.0
2022-07-19	AAXJ	Stock	67.8	68.23	67.65	68.2	720234.0
2022-07-19	AB	Stock	40.12	41.17	40.12	41.11	297700.0
2022-07-19	ABB-DELISTED	Stock	27.75	28.17	27.74	28.11	1829122.0
2022-07-19	ABBNY-DELISTED	Stock	27.75	28.17	27.74	28.11	1995721.0
2022-07-19	ABBV	Stock	150.0	150.23	148.8	149.74	5647100.0
2022-07-19	ABC-DELISTED	Stock	141.81	143.4	141.09	142.99	435700.0
2022-07-19	ABCB	Stock	41.42	42.47	40.89	42.13	304800.0
2022-07-19	ABCL	Stock	10.58	10.83	10.47	10.65	1241400.0
2022-07-19	ABCM-DELISTED	Stock	13.39	13.73	13.26	13.72	75001.0
2022-07-19	ABEO	Stock	4.72	4.91	4.7	4.86	78100.0
2022-07-19	ABEV	Stock	2.67	2.72	2.64	2.65	36816600.0
2022-07-19	ABG	Stock	168.97	176.09	166.42	174.96	157300.0
2022-07-19	ABGI-DELISTED	Stock	9.815	9.82	9.8	9.82	227893.0
2022-07-19	ABM	Stock	42.76	43.93	42.76	43.72	281100.0
2022-07-19	ABMD-DELISTED	Stock	267.07	269.72	263.57	269.21	232906.0
2022-07-19	ABNB	Stock	99.7	102.71	98.76	102.2	5603800.0

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

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