PREVIEW / stock_daily / 2022-11-16

all stock daily files

  file:    by_date/stock_daily/2022/2022-11-16.parquet
  size:    250 KB
  rows:    7,770
  symbols: 2,059

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-11-16	AAPL	Stock	149.13	149.87	147.29	148.79	64218300.0
2022-11-16	MSFT	Stock	242.79	243.8	240.42	241.73	24093300.0
2022-11-16	NVDA	Stock	16.162	16.362	15.873	15.91	649547000.0
2022-11-16	AMZN	Stock	96.85	98.49	95.54	97.12	87958800.0
2022-11-16	GOOGL	Stock	97.9	99.6375	97.64	98.85	29105154.0
2022-11-16	META	Stock	114.5	116.08	112.66	113.23	33287800.0
2022-11-16	TSLA	Stock	191.51	192.57	185.66	186.92	66567600.0
2022-11-16	TLT	Stock	100.02	101.45	99.74	101.4	28507673.0
2022-11-16	ES	Stock	78.83	79.84	78.83	79.5	1742100.0
2022-11-16	CL	Stock	75.69	76.57	75.65	76.01	2799000.0
2022-11-16	A	Stock	148.19	148.75	146.35	147.12	1476700.0
2022-11-16	AA	Stock	47.65	48.83	46.24	48.67	7751300.0
2022-11-16	AAC-DELISTED	Stock	10.0	10.0	9.99	9.99	2797.0
2022-11-16	AACG	Stock	1.65	1.76	1.65	1.68	2600.0
2022-11-16	AACIW-DELISTED	Stock	0.0999	0.0999	0.024	0.0299	32402.0
2022-11-16	AAIC-DELISTED	Stock	3.12	3.165	3.1	3.1	71294.0
2022-11-16	AAL	Stock	14.45	14.47	14.01	14.09	28858000.0
2022-11-16	AAM.A-DELISTED	Stock	24.3	24.67	24.3	24.58	28615.0
2022-11-16	AAM.B-DELISTED	Stock	24.45	24.86	24.45	24.527	4736.0
2022-11-16	AAMC-DELISTED	Stock	6.0	6.0	5.5853	5.5912	3499.0
2022-11-16	AAME	Stock	3.08	3.1	3.08	3.08	600.0
2022-11-16	AAMI	Stock	19.93	20.04	19.54	19.68	117000.0
2022-11-16	AAN-DELISTED	Stock	10.57	10.57	10.13	10.16	315600.0
2022-11-16	AAOI	Stock	2.3	2.3	2.12	2.15	249700.0
2022-11-16	AAON	Stock	53.2733	53.74	52.64	53.5133	379050.0
2022-11-16	AAP	Stock	155.0	161.73	150.35	156.24	5374000.0
2022-11-16	AAQC-DELISTED	Stock	10.01	10.02	10.01	10.01	182477.0
2022-11-16	AAT	Stock	28.23	28.23	27.77	27.81	197400.0
2022-11-16	AATC	Stock	4.01	4.2	4.01	4.18	4871.0
2022-11-16	AAU-DELISTED	Stock	0.2566	0.26	0.251	0.2511	158882.0
2022-11-16	AAUAF-DELISTED	Stock	0.2566	0.26	0.251	0.2518	161392.0
2022-11-16	AAWW-DELISTED	Stock	100.41	100.66	100.41	100.48	133186.0
2022-11-16	AAXJ	Stock	64.44	64.55	63.92	64.02	1024627.0
2022-11-16	AB	Stock	40.0	40.39	39.42	40.2	186500.0
2022-11-16	ABB-DELISTED	Stock	30.92	31.065	30.77	30.81	1072197.0
2022-11-16	ABBNY-DELISTED	Stock	30.92	31.065	30.77	30.82	1272700.0
2022-11-16	ABBV	Stock	153.44	156.69	151.23	151.87	7358700.0
2022-11-16	ABC-DELISTED	Stock	153.72	156.675	153.72	155.86	755895.0
2022-11-16	ABCB	Stock	52.42	52.54	51.55	51.72	211800.0
2022-11-16	ABCL	Stock	14.73	14.8	14.071	14.52	1678000.0
2022-11-16	ABCM-DELISTED	Stock	16.51	16.72	16.28	16.61	576392.0
2022-11-16	ABEO	Stock	3.99	4.2	3.79	3.93	328500.0
2022-11-16	ABEV	Stock	2.91	2.94	2.82	2.83	39748500.0
2022-11-16	ABG	Stock	177.88	178.67	174.5	176.19	134100.0
2022-11-16	ABGI-DELISTED	Stock	10.0	10.0	9.99	10.0	25380.0
2022-11-16	ABM	Stock	45.08	45.2	44.5	44.78	270500.0
2022-11-16	ABMD-DELISTED	Stock	374.5	375.75	374.25	374.4	1172157.0
2022-11-16	ABNB	Stock	107.7	107.7	104.38	104.43	3681800.0
2022-11-16	ABOS	Stock	6.37	6.51	5.87	6.15	142400.0
2022-11-16	ABR	Stock	14.73	14.79	14.47	14.53	2080500.0

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

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