PREVIEW / stock_daily / 2022-12-12

all stock daily files

  file:    by_date/stock_daily/2022/2022-12-12.parquet
  size:    249 KB
  rows:    7,735
  symbols: 1,998

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-12-12	AAPL	Stock	142.7	144.5	141.06	144.49	70462700.0
2022-12-12	MSFT	Stock	247.45	252.54	247.17	252.51	30665100.0
2022-12-12	NVDA	Stock	17.037	17.538	16.797	17.535	457328000.0
2022-12-12	AMZN	Stock	89.21	90.58	87.87	90.55	61999800.0
2022-12-12	GOOGL	Stock	92.71	93.56	91.61	93.31	29009013.0
2022-12-12	META	Stock	115.18	115.72	113.14	114.71	24747100.0
2022-12-12	TSLA	Stock	176.1	177.37	167.52	167.82	109794500.0
2022-12-12	TLT	Stock	107.86	108.11	106.26	106.67	16897091.0
2022-12-12	ES	Stock	84.8	85.79	83.93	85.7	1480600.0
2022-12-12	CL	Stock	77.99	78.71	77.62	78.61	4774600.0
2022-12-12	A	Stock	154.01	155.98	153.43	155.33	1071400.0
2022-12-12	AA	Stock	44.38	45.88	43.79	45.81	4502800.0
2022-12-12	AAC-DELISTED	Stock	10.06	10.07	10.06	10.06	396014.0
2022-12-12	AACG	Stock	1.41	1.45	1.18	1.33	16600.0
2022-12-12	AACIW-DELISTED	Stock	0.02	0.02	0.0125	0.0152	15500.0
2022-12-12	AAIC-DELISTED	Stock	2.95	3.01	2.95	2.99	18789.0
2022-12-12	AAIC.C-DELISTED	Stock	21.5	21.5	21.5	21.5	145.0
2022-12-12	AAL	Stock	13.49	14.21	13.45	14.2	23344600.0
2022-12-12	AAM.A-DELISTED	Stock	22.86	23.0	22.52	22.89	32017.0
2022-12-12	AAM.B-DELISTED	Stock	23.04	23.156	22.3347	22.7442	20999.0
2022-12-12	AAMC-DELISTED	Stock	6.5878	6.7765	6.5878	6.6206	5297.0
2022-12-12	AAME	Stock	2.5	2.66	2.5	2.66	7200.0
2022-12-12	AAMI	Stock	19.35	19.47	19.08	19.2	181600.0
2022-12-12	AAN-DELISTED	Stock	11.82	12.29	11.61	12.21	310300.0
2022-12-12	AAOI	Stock	2.11	2.2	2.1	2.15	93800.0
2022-12-12	AAON	Stock	53.5867	53.5867	52.78	53.04	186300.0
2022-12-12	AAP	Stock	145.87	146.56	143.82	145.93	868300.0
2022-12-12	AAQC-DELISTED	Stock	10.08	10.08	10.08	10.08	300.0
2022-12-12	AAT	Stock	27.2	27.2	26.77	27.0	264600.0
2022-12-12	AATC	Stock	5.19	5.192	5.18	5.19	3440.0
2022-12-12	AAU-DELISTED	Stock	0.2479	0.2479	0.2401	0.2428	64980.0
2022-12-12	AAUAF-DELISTED	Stock	0.2479	0.2479	0.2401	0.2402	73241.0
2022-12-12	AAWW-DELISTED	Stock	100.45	100.81	100.45	100.8	138873.0
2022-12-12	AAXJ	Stock	66.41	66.545	66.0	66.53	1276927.0
2022-12-12	AB	Stock	38.15	38.9	37.84	38.84	459600.0
2022-12-12	ABB-DELISTED	Stock	31.02	31.3	30.935	31.295	992464.0
2022-12-12	ABBNY-DELISTED	Stock	31.02	31.3	30.935	31.3	1108826.0
2022-12-12	ABBV	Stock	163.21	165.49	162.75	165.32	4109400.0
2022-12-12	ABC-DELISTED	Stock	165.99	167.19	165.04	167.19	907696.0
2022-12-12	ABCB	Stock	50.43	50.69	49.9	50.3	326300.0
2022-12-12	ABCL	Stock	10.57	10.63	10.32	10.49	1549800.0
2022-12-12	ABCM-DELISTED	Stock	13.57	15.41	13.5	15.26	3069739.0
2022-12-12	ABEO	Stock	3.23	3.23	3.08	3.1	136600.0
2022-12-12	ABEV	Stock	2.85	2.87	2.8	2.87	24610300.0
2022-12-12	ABG	Stock	182.04	182.65	179.03	179.78	207600.0
2022-12-12	ABGI-DELISTED	Stock	10.05	10.05	10.05	10.05	21221.0
2022-12-12	ABM	Stock	45.72	46.06	45.25	45.67	520400.0
2022-12-12	ABMD-DELISTED	Stock	380.99	380.99	380.0	380.09	1095587.0
2022-12-12	ABNB	Stock	93.76	95.96	93.49	95.58	4664100.0
2022-12-12	ABOS	Stock	6.18	6.18	5.5	5.53	82900.0

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

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