PREVIEW / stock_daily / 2022-07-11

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-11.parquet
  size:    252 KB
  rows:    7,888
  symbols: 2,290

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-11	AAPL	Stock	145.67	146.64	143.78	144.87	63141600.0
2022-07-11	MSFT	Stock	265.65	266.53	262.18	264.51	19455200.0
2022-07-11	NVDA	Stock	15.526	15.527	15.038	15.152	437321000.0
2022-07-11	AMZN	Stock	114.08	114.3	110.87	111.75	53487600.0
2022-07-11	GOOGL	Stock	117.998	117.998	115.3305	115.6765	31243700.0
2022-07-11	META	Stock	167.07	167.49	161.91	162.88	21885600.0
2022-07-11	TSLA	Stock	252.1033	253.0633	233.6267	234.3433	99241200.0
2022-07-11	TLT	Stock	113.79	114.79	113.7	114.44	13639942.0
2022-07-11	ES	Stock	83.15	84.23	82.56	83.72	1688600.0
2022-07-11	CL	Stock	78.5	78.99	78.09	78.7	5459600.0
2022-07-11	A	Stock	121.61	123.46	121.01	123.12	1304400.0
2022-07-11	AA	Stock	43.82	44.38	42.59	42.73	4848000.0
2022-07-11	AAC-DELISTED	Stock	9.83	9.85	9.83	9.85	234906.0
2022-07-11	AACG	Stock	1.36	1.36	1.32	1.34	20600.0
2022-07-11	AACIW-DELISTED	Stock	0.1647	0.1899	0.1647	0.1899	300.0
2022-07-11	AAIC-DELISTED	Stock	3.14	3.2255	3.14	3.15	57778.0
2022-07-11	AAIC.C-DELISTED	Stock	20.89	20.9	20.89	20.9	2375.0
2022-07-11	AAL	Stock	13.82	13.97	13.31	13.43	25163100.0
2022-07-11	AAM.A-DELISTED	Stock	24.35	24.692	24.35	24.6215	15826.0
2022-07-11	AAM.B-DELISTED	Stock	24.57	24.69	24.4362	24.63	3174.0
2022-07-11	AAMC-DELISTED	Stock	3.1471	3.1941	3.1029	3.1029	2795.0
2022-07-11	AAME	Stock	3.11	3.2	2.99	3.13	15100.0
2022-07-11	AAMI	Stock	17.47	17.57	17.21	17.29	227500.0
2022-07-11	AAN-DELISTED	Stock	15.2	15.43	15.131	15.18	167700.0
2022-07-11	AAOI	Stock	1.61	1.66	1.5	1.5	131500.0
2022-07-11	AAON	Stock	36.3333	36.8533	35.7733	36.28	262050.0
2022-07-11	AAP	Stock	182.9	183.62	180.62	181.75	605600.0
2022-07-11	AAQC-DELISTED	Stock	9.77	9.7793	9.77	9.7793	2124.0
2022-07-11	AAT	Stock	29.35	29.47	29.03	29.16	127100.0
2022-07-11	AATC	Stock	5.32	5.3229	5.26	5.26	10187.0
2022-07-11	AAU-DELISTED	Stock	0.2311	0.2447	0.23	0.2329	141746.0
2022-07-11	AAUAF-DELISTED	Stock	0.2311	0.2447	0.23	0.2329	149850.0
2022-07-11	AAWW-DELISTED	Stock	61.24	62.11	60.13	60.49	124255.0
2022-07-11	AAXJ	Stock	67.71	67.74	67.01	67.24	799141.0
2022-07-11	AB	Stock	41.05	41.34	40.61	41.02	191400.0
2022-07-11	ABB-DELISTED	Stock	26.57	26.61	26.335	26.43	1597838.0
2022-07-11	ABBNY-DELISTED	Stock	26.56	26.61	26.335	26.44	1769291.0
2022-07-11	ABBV	Stock	152.28	154.5	152.28	153.23	4491000.0
2022-07-11	ABC-DELISTED	Stock	140.81	142.47	139.55	141.28	775247.0
2022-07-11	ABCB	Stock	40.76	41.07	40.35	40.7	538700.0
2022-07-11	ABCL	Stock	11.44	11.65	11.085	11.11	1199300.0
2022-07-11	ABCM-DELISTED	Stock	14.62	14.81	14.49	14.52	101829.0
2022-07-11	ABEO	Stock	5.63	6.13	5.51	5.56	363400.0
2022-07-11	ABEV	Stock	2.64	2.64	2.56	2.57	28983400.0
2022-07-11	ABG	Stock	169.95	169.95	163.43	163.69	118900.0
2022-07-11	ABM	Stock	43.06	43.36	42.56	43.21	162500.0
2022-07-11	ABMD-DELISTED	Stock	263.88	265.32	259.745	262.08	69408.0
2022-07-11	ABNB	Stock	96.0	97.09	93.27	95.1	6041400.0
2022-07-11	ABOS	Stock	5.85	6.28	5.705	5.98	83200.0
2022-07-11	ABR	Stock	13.82	13.94	13.71	13.75	1563300.0

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

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