PREVIEW / stock_daily / 2023-04-17

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-17.parquet
  size:    243 KB
  rows:    7,559
  symbols: 1,687

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
2023-04-17	AAPL	Stock	165.09	165.39	164.03	165.23	41516200.0
2023-04-17	MSFT	Stock	289.93	291.6	286.16	288.8	23836200.0
2023-04-17	NVDA	Stock	26.565	27.006	26.433	27.002	321471000.0
2023-04-17	AMZN	Stock	103.16	103.73	101.59	102.74	39919500.0
2023-04-17	GOOGL	Stock	104.658	106.16	104.52	105.97	37571218.0
2023-04-17	META	Stock	219.79	220.98	217.13	218.86	15481900.0
2023-04-17	TSLA	Stock	186.32	189.69	182.69	187.04	116662200.0
2023-04-17	TLT	Stock	104.42	104.59	103.71	103.83	19528811.0
2023-04-17	ES	Stock	78.81	79.47	78.29	79.14	1540100.0
2023-04-17	CL	Stock	75.77	76.13	75.42	75.7	4727500.0
2023-04-17	A	Stock	139.62	140.21	138.89	140.19	1115500.0
2023-04-17	AA	Stock	40.31	40.82	40.09	40.8	2841200.0
2023-04-17	AAC-DELISTED	Stock	10.36	10.36	10.35	10.36	57091.0
2023-04-17	AACG	Stock	1.98	1.98	1.83	1.85	12000.0
2023-04-17	AACIW-DELISTED	Stock	0.1005	0.1009	0.0892	0.1009	1849.0
2023-04-17	AAIC-DELISTED	Stock	2.6	2.61	2.57	2.61	34360.0
2023-04-17	AAIC.C-DELISTED	Stock	21.58	21.58	21.0	21.0	4640.0
2023-04-17	AAL	Stock	12.86	13.17	12.8	13.1	26307900.0
2023-04-17	AAM.A-DELISTED	Stock	23.74	24.01	23.645	23.65	14051.0
2023-04-17	AAM.B-DELISTED	Stock	23.84	24.22	23.35	23.35	2487.0
2023-04-17	AAMC-DELISTED	Stock	20.5882	22.4912	20.5882	22.0559	89233.0
2023-04-17	AAME	Stock	2.41	2.47	2.38	2.47	6700.0
2023-04-17	AAMI	Stock	23.64	23.73	23.34	23.68	57700.0
2023-04-17	AAN-DELISTED	Stock	10.6	10.715	10.48	10.65	194800.0
2023-04-17	AAOI	Stock	2.08	2.24	2.07	2.19	129100.0
2023-04-17	AAON	Stock	63.64	65.12	63.64	63.9867	304500.0
2023-04-17	AAP	Stock	123.98	127.0	123.77	126.87	1436000.0
2023-04-17	AAT	Stock	17.46	18.25	17.35	18.25	392800.0
2023-04-17	AATC	Stock	3.83	3.85	3.78	3.84	5973.0
2023-04-17	AAU-DELISTED	Stock	0.178	0.18	0.1672	0.175	465362.0
2023-04-17	AAUAF-DELISTED	Stock	0.178	0.18	0.1672	0.175	467782.0
2023-04-17	AAXJ	Stock	68.3	68.35	68.02	68.27	495777.0
2023-04-17	AB	Stock	36.5	37.0	36.27	36.78	242900.0
2023-04-17	ABB-DELISTED	Stock	35.17	35.2888	35.035	35.165	1414363.0
2023-04-17	ABBNY-DELISTED	Stock	35.17	35.2888	35.035	35.18	1622698.0
2023-04-17	ABBV	Stock	161.92	162.2	160.65	161.18	4354100.0
2023-04-17	ABC-DELISTED	Stock	167.06	167.4	165.99	167.38	442337.0
2023-04-17	ABCB	Stock	33.42	34.65	32.78	34.64	428600.0
2023-04-17	ABCL	Stock	7.4	7.629	7.24	7.39	1438300.0
2023-04-17	ABCM-DELISTED	Stock	15.64	16.0	15.3715	15.96	1099933.0
2023-04-17	ABEO	Stock	2.79	3.0	2.77	3.0	122900.0
2023-04-17	ABEV	Stock	2.95	2.97	2.93	2.95	8836600.0
2023-04-17	ABG	Stock	208.5	209.71	200.96	204.63	155500.0
2023-04-17	ABM	Stock	43.38	43.75	43.23	43.72	192500.0
2023-04-17	ABNB	Stock	115.42	116.18	114.59	116.17	3287100.0
2023-04-17	ABOS	Stock	3.75	3.89	3.575	3.65	156800.0
2023-04-17	ABR	Stock	10.34	10.55	10.19	10.52	3405900.0
2023-04-17	ABR.D	Stock	17.67	17.7	17.01	17.49	23823.0
2023-04-17	ABR.E	Stock	17.2999	17.3	16.4101	16.4101	11124.0
2023-04-17	ABR.F	Stock	17.59	17.59	17.48	17.5	28349.0

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

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