PREVIEW / stock_daily / 2022-07-08

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-08.parquet
  size:    251 KB
  rows:    7,859
  symbols: 2,294

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-08	AAPL	Stock	145.26	147.55	145.0	147.04	64547800.0
2022-07-08	MSFT	Stock	264.79	268.1	263.29	267.66	19658800.0
2022-07-08	NVDA	Stock	15.43	16.037	15.389	15.838	467972000.0
2022-07-08	AMZN	Stock	114.6	116.58	113.69	115.54	45719700.0
2022-07-08	GOOGL	Stock	117.25	119.685	116.9012	119.3535	38238160.0
2022-07-08	META	Stock	169.98	172.4	168.15	170.88	19249200.0
2022-07-08	TSLA	Stock	242.3333	254.98	241.16	250.7633	101854200.0
2022-07-08	TLT	Stock	113.5	113.5	112.05	112.5	15320004.0
2022-07-08	ES	Stock	83.77	84.37	83.19	83.32	1796300.0
2022-07-08	CL	Stock	79.29	79.58	78.23	78.35	3668500.0
2022-07-08	A	Stock	120.96	123.21	120.96	122.51	1267300.0
2022-07-08	AA	Stock	45.63	45.79	44.4	44.83	5312500.0
2022-07-08	AAC-DELISTED	Stock	9.83	9.84	9.83	9.83	53553.0
2022-07-08	AACG	Stock	1.2	1.29	1.16	1.27	33900.0
2022-07-08	AACIW-DELISTED	Stock	0.19	0.19	0.1899	0.1899	504.0
2022-07-08	AAIC-DELISTED	Stock	3.16	3.23	3.13	3.19	40638.0
2022-07-08	AAIC.C-DELISTED	Stock	20.72	20.72	20.72	20.72	100.0
2022-07-08	AAL	Stock	13.96	14.27	13.72	13.97	28114100.0
2022-07-08	AAM.A-DELISTED	Stock	23.86	24.3503	23.86	24.3503	11277.0
2022-07-08	AAM.B-DELISTED	Stock	24.46	24.56	24.29	24.4772	7698.0
2022-07-08	AAMC-DELISTED	Stock	3.1	3.1471	2.9765	3.0882	13192.0
2022-07-08	AAME	Stock	2.96	3.16	2.89	3.06	3900.0
2022-07-08	AAMI	Stock	17.98	17.99	17.58	17.68	236900.0
2022-07-08	AAN-DELISTED	Stock	15.09	15.35	15.0	15.33	179000.0
2022-07-08	AAOI	Stock	1.64	1.688	1.6	1.63	99000.0
2022-07-08	AAON	Stock	37.1133	37.3333	36.0067	36.48	184650.0
2022-07-08	AAP	Stock	184.24	185.59	182.31	182.9	395200.0
2022-07-08	AAQC-DELISTED	Stock	9.77	9.77	9.77	9.77	1600.0
2022-07-08	AAT	Stock	29.9	29.99	29.46	29.53	123300.0
2022-07-08	AATC	Stock	5.29	5.49	5.29	5.3213	10129.0
2022-07-08	AAU-DELISTED	Stock	0.2297	0.2461	0.2251	0.24	249581.0
2022-07-08	AAUAF-DELISTED	Stock	0.2297	0.2461	0.2251	0.24	255190.0
2022-07-08	AAWW-DELISTED	Stock	61.03	61.84	60.0	61.73	202810.0
2022-07-08	AAXJ	Stock	68.96	69.49	68.72	69.21	774454.0
2022-07-08	AB	Stock	42.0	42.0	41.13	41.46	113200.0
2022-07-08	ABB-DELISTED	Stock	26.96	27.16	26.765	26.9	1569454.0
2022-07-08	ABBNY-DELISTED	Stock	26.95	27.16	26.765	26.9	1892079.0
2022-07-08	ABBV	Stock	152.0	155.25	151.79	152.85	4078400.0
2022-07-08	ABC-DELISTED	Stock	141.0	144.05	140.71	142.58	663199.0
2022-07-08	ABCB	Stock	41.53	41.53	40.64	41.22	522100.0
2022-07-08	ABCL	Stock	11.34	11.88	11.07	11.58	1605000.0
2022-07-08	ABCM-DELISTED	Stock	14.68	14.9	14.63	14.78	55379.0
2022-07-08	ABEO	Stock	4.44	5.63	4.4	5.49	560300.0
2022-07-08	ABEV	Stock	2.63	2.68	2.62	2.68	29100300.0
2022-07-08	ABG	Stock	174.8	176.61	171.08	171.24	88500.0
2022-07-08	ABM	Stock	43.14	43.44	42.75	43.13	191100.0
2022-07-08	ABMD-DELISTED	Stock	264.49	271.25	262.48	267.01	104696.0
2022-07-08	ABNB	Stock	96.23	98.12	93.242	97.35	5669500.0
2022-07-08	ABOS	Stock	5.91	6.03	5.72	5.99	43100.0
2022-07-08	ABR	Stock	13.79	13.95	13.62	13.83	2194600.0

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

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