PREVIEW / stock_daily / 2022-07-13

all stock daily files

  file:    by_date/stock_daily/2022/2022-07-13.parquet
  size:    250 KB
  rows:    7,868
  symbols: 2,289

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-13	AAPL	Stock	142.99	146.45	142.12	145.49	71185600.0
2022-07-13	MSFT	Stock	250.19	253.55	248.11	252.72	29497400.0
2022-07-13	NVDA	Stock	14.59	15.375	14.465	15.164	521918000.0
2022-07-13	AMZN	Stock	107.03	111.78	106.01	110.4	61353800.0
2022-07-13	GOOGL	Stock	111.701	114.196	111.2015	111.3535	43722020.0
2022-07-13	META	Stock	160.16	164.98	159.61	163.49	16555100.0
2022-07-13	TSLA	Stock	225.5	242.06	225.0333	237.04	97954500.0
2022-07-13	TLT	Stock	113.77	116.65	113.45	116.44	20594832.0
2022-07-13	ES	Stock	82.68	83.76	82.58	82.8	891500.0
2022-07-13	CL	Stock	77.91	79.19	77.91	78.43	3343300.0
2022-07-13	A	Stock	117.41	119.7	116.86	118.65	1378000.0
2022-07-13	AA	Stock	41.59	43.53	41.38	43.19	3671300.0
2022-07-13	AAC-DELISTED	Stock	9.83	9.845	9.83	9.84	84566.0
2022-07-13	AACG	Stock	1.38	1.39	1.36	1.38	9000.0
2022-07-13	AACIW-DELISTED	Stock	0.17	0.19	0.1699	0.17	36420.0
2022-07-13	AAIC-DELISTED	Stock	3.12	3.17	3.1	3.1401	29905.0
2022-07-13	AAIC.C-DELISTED	Stock	20.8	21.1	20.73	21.0	3160.0
2022-07-13	AAL	Stock	14.04	14.44	13.7	14.31	45289800.0
2022-07-13	AAM.A-DELISTED	Stock	24.55	24.67	24.4812	24.6	8070.0
2022-07-13	AAM.B-DELISTED	Stock	24.65	24.93	24.55	24.56	12138.0
2022-07-13	AAMC-DELISTED	Stock	3.2353	3.2353	3.0971	3.1029	5477.0
2022-07-13	AAME	Stock	2.78	3.04	2.75	3.02	4600.0
2022-07-13	AAMI	Stock	17.0	17.1	16.62	17.06	157500.0
2022-07-13	AAN-DELISTED	Stock	14.88	14.96	14.6	14.83	214000.0
2022-07-13	AAOI	Stock	1.509	1.65	1.48	1.61	130000.0
2022-07-13	AAON	Stock	36.5933	36.5933	35.4533	35.8467	156300.0
2022-07-13	AAP	Stock	181.99	186.45	180.9	185.34	665300.0
2022-07-13	AAQC-DELISTED	Stock	9.77	9.77	9.77	9.77	2319.0
2022-07-13	AAT	Stock	29.53	29.63	29.23	29.36	98400.0
2022-07-13	AATC	Stock	5.15	5.17	5.115	5.12	3094.0
2022-07-13	AAU-DELISTED	Stock	0.218	0.238	0.2112	0.2187	1143750.0
2022-07-13	AAUAF-DELISTED	Stock	0.218	0.238	0.2112	0.2125	1198597.0
2022-07-13	AAWW-DELISTED	Stock	59.69	60.43	59.53	60.1	110314.0
2022-07-13	AAXJ	Stock	66.28	67.33	66.22	66.96	1757725.0
2022-07-13	AB	Stock	40.97	41.37	40.41	40.78	179400.0
2022-07-13	ABB-DELISTED	Stock	26.32	26.74	26.11	26.61	2383753.0
2022-07-13	ABBNY-DELISTED	Stock	26.3	26.74	26.11	26.59	2594200.0
2022-07-13	ABBV	Stock	152.0	153.83	151.3	152.15	5221200.0
2022-07-13	ABC-DELISTED	Stock	140.14	141.17	139.03	139.05	550282.0
2022-07-13	ABCB	Stock	40.83	40.83	39.83	39.88	255700.0
2022-07-13	ABCL	Stock	11.11	12.0	11.01	11.32	1637100.0
2022-07-13	ABCM-DELISTED	Stock	13.67	14.08	13.61	14.04	116293.0
2022-07-13	ABEO	Stock	5.33	5.53	5.0	5.05	134200.0
2022-07-13	ABEV	Stock	2.6	2.71	2.59	2.66	49881200.0
2022-07-13	ABG	Stock	163.94	165.45	159.57	161.5	202900.0
2022-07-13	ABM	Stock	42.29	42.61	42.11	42.54	316400.0
2022-07-13	ABMD-DELISTED	Stock	250.63	260.57	248.51	256.88	89854.0
2022-07-13	ABNB	Stock	93.75	96.589	91.61	95.64	6967800.0
2022-07-13	ABOS	Stock	5.78	5.921	5.711	5.89	33700.0
2022-07-13	ABR	Stock	13.77	14.07	13.65	13.96	1405500.0

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

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