PREVIEW / stock_daily / 2022-07-14

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-14.parquet
  size:    250 KB
  rows:    7,866
  symbols: 2,288

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-14	AAPL	Stock	144.08	148.95	143.25	148.47	78140700.0
2022-07-14	MSFT	Stock	250.57	255.14	245.94	254.08	25102800.0
2022-07-14	NVDA	Stock	15.108	15.473	14.728	15.372	456235000.0
2022-07-14	AMZN	Stock	110.24	111.18	107.58	110.63	51163100.0
2022-07-14	GOOGL	Stock	110.2105	111.093	108.373	110.3675	37003040.0
2022-07-14	META	Stock	161.22	162.59	157.28	158.05	23765200.0
2022-07-14	TSLA	Stock	234.8967	238.6533	229.3333	238.3133	78557400.0
2022-07-14	TLT	Stock	115.08	116.16	114.47	115.49	15664987.0
2022-07-14	ES	Stock	81.57	83.71	80.67	83.48	1172500.0
2022-07-14	CL	Stock	77.36	78.47	77.09	78.34	5753200.0
2022-07-14	A	Stock	117.1	117.73	113.02	115.88	1347300.0
2022-07-14	AA	Stock	40.84	41.15	39.565	40.81	5408200.0
2022-07-14	AAC-DELISTED	Stock	9.85	9.85	9.83	9.84	40571.0
2022-07-14	AACG	Stock	1.38	1.38	1.34	1.34	7100.0
2022-07-14	AACIW-DELISTED	Stock	0.166	0.1722	0.16	0.17	34140.0
2022-07-14	AAIC-DELISTED	Stock	3.1	3.12	3.05	3.07	32992.0
2022-07-14	AAIC.C-DELISTED	Stock	20.9	20.9	20.8484	20.86	1370.0
2022-07-14	AAL	Stock	14.18	14.87	14.05	14.25	39441400.0
2022-07-14	AAM.A-DELISTED	Stock	24.5	24.63	24.32	24.565	6483.0
2022-07-14	AAM.B-DELISTED	Stock	24.54	24.95	24.28	24.85	15895.0
2022-07-14	AAMC-DELISTED	Stock	3.2059	3.2059	3.0941	3.1294	2448.0
2022-07-14	AAME	Stock	3.05	3.05	2.88	2.88	2100.0
2022-07-14	AAMI	Stock	16.86	17.25	16.68	17.18	190400.0
2022-07-14	AAN-DELISTED	Stock	14.35	14.5	13.86	14.1	549900.0
2022-07-14	AAOI	Stock	1.61	1.61	1.56	1.56	26700.0
2022-07-14	AAON	Stock	35.5267	35.7467	35.0333	35.3667	183150.0
2022-07-14	AAP	Stock	182.41	186.37	182.0	186.01	657300.0
2022-07-14	AAQC-DELISTED	Stock	9.77	9.78	9.77	9.78	17389.0
2022-07-14	AAT	Stock	28.52	28.99	28.38	28.87	169400.0
2022-07-14	AATC	Stock	5.3399	5.3399	5.05	5.075	9099.0
2022-07-14	AAU-DELISTED	Stock	0.2111	0.2235	0.2111	0.2147	409012.0
2022-07-14	AAUAF-DELISTED	Stock	0.2111	0.2235	0.2111	0.2147	415851.0
2022-07-14	AAWW-DELISTED	Stock	59.1	60.12	58.7	60.12	128994.0
2022-07-14	AAXJ	Stock	66.46	66.605	65.93	66.53	1279984.0
2022-07-14	AB	Stock	40.01	40.59	39.89	40.43	156200.0
2022-07-14	ABB-DELISTED	Stock	26.18	26.35	25.951	26.34	1464475.0
2022-07-14	ABBNY-DELISTED	Stock	26.18	26.35	25.951	26.33	1621228.0
2022-07-14	ABBV	Stock	148.89	151.01	148.49	150.44	7576900.0
2022-07-14	ABC-DELISTED	Stock	137.06	139.96	136.34	139.42	723889.0
2022-07-14	ABCB	Stock	39.0	39.24	38.22	38.86	305600.0
2022-07-14	ABCL	Stock	11.3	11.41	10.91	11.1	1839000.0
2022-07-14	ABCM-DELISTED	Stock	13.75	13.82	13.52	13.78	213088.0
2022-07-14	ABEO	Stock	5.0	5.0	4.75	4.76	105400.0
2022-07-14	ABEV	Stock	2.65	2.72	2.61	2.69	52029100.0
2022-07-14	ABG	Stock	156.81	159.05	147.96	150.98	419600.0
2022-07-14	ABGI-DELISTED	Stock	9.8	9.8	9.8	9.8	1041.0
2022-07-14	ABM	Stock	41.6	42.33	41.45	42.16	192300.0
2022-07-14	ABMD-DELISTED	Stock	253.7	259.4	248.24	258.88	105266.0
2022-07-14	ABNB	Stock	94.28	94.58	90.17	91.05	8334600.0
2022-07-14	ABOS	Stock	5.85	6.37	5.85	6.26	60700.0

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

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