PREVIEW / stock_daily / 2023-04-19

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-19.parquet
  size:    244 KB
  rows:    7,560
  symbols: 1,691

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-19	AAPL	Stock	165.8	168.16	165.54	167.63	47720200.0
2023-04-19	MSFT	Stock	285.99	289.05	284.54	288.45	17150300.0
2023-04-19	NVDA	Stock	27.361	28.0	27.232	27.931	358660000.0
2023-04-19	AMZN	Stock	101.58	105.12	101.39	104.3	58398900.0
2023-04-19	GOOGL	Stock	103.58	104.98	103.07	104.18	20905684.0
2023-04-19	META	Stock	213.47	217.33	212.93	215.7	15898100.0
2023-04-19	TSLA	Stock	179.1	183.5	177.65	180.59	125732700.0
2023-04-19	TLT	Stock	103.91	104.237	103.475	104.1	16093905.0
2023-04-19	ES	Stock	78.61	79.21	78.41	78.99	1112800.0
2023-04-19	CL	Stock	75.7	75.9	75.13	75.59	3629700.0
2023-04-19	A	Stock	138.37	139.62	137.68	138.93	1178400.0
2023-04-19	AA	Stock	40.96	41.958	40.5	41.22	5952000.0
2023-04-19	AAC-DELISTED	Stock	10.35	10.37	10.35	10.365	1166192.0
2023-04-19	AACG	Stock	1.93	1.95	1.9	1.94	3600.0
2023-04-19	AACIU	Stock	10.68	10.68	10.11	10.11	605.0
2023-04-19	AACIW-DELISTED	Stock	0.0884	0.1009	0.0874	0.1	2504.0
2023-04-19	AAIC-DELISTED	Stock	2.61	2.6473	2.55	2.6472	112534.0
2023-04-19	AAL	Stock	13.13	13.68	13.13	13.63	31596500.0
2023-04-19	AAM.A-DELISTED	Stock	24.0	24.31	23.55	24.09	23110.0
2023-04-19	AAM.B-DELISTED	Stock	24.71	24.75	24.305	24.53	11236.0
2023-04-19	AAMC-DELISTED	Stock	22.9441	25.7059	22.9441	25.5676	115835.0
2023-04-19	AAME	Stock	2.32	2.43	2.24	2.31	10500.0
2023-04-19	AAMI	Stock	24.0	24.0	23.6	23.7	74500.0
2023-04-19	AAN-DELISTED	Stock	10.38	10.42	10.23	10.35	238900.0
2023-04-19	AAOI	Stock	2.23	2.309	2.16	2.19	142500.0
2023-04-19	AAON	Stock	64.58	65.5933	64.52	65.4333	388350.0
2023-04-19	AAP	Stock	126.47	128.68	126.22	128.11	1931700.0
2023-04-19	AAT	Stock	17.63	18.39	17.51	18.37	367100.0
2023-04-19	AATC	Stock	4.09	4.11	4.07	4.07	5228.0
2023-04-19	AAU-DELISTED	Stock	0.162	0.174	0.1542	0.1567	367485.0
2023-04-19	AAUAF-DELISTED	Stock	0.162	0.174	0.1542	0.1567	373835.0
2023-04-19	AAXJ	Stock	67.36	67.65	67.31	67.54	433092.0
2023-04-19	AB	Stock	35.89	36.24	35.51	35.67	248200.0
2023-04-19	ABB-DELISTED	Stock	35.11	35.235	35.03	35.11	1245224.0
2023-04-19	ABBNY-DELISTED	Stock	35.11	35.235	35.03	35.11	1419093.0
2023-04-19	ABBV	Stock	158.67	161.44	158.52	161.21	4826900.0
2023-04-19	ABC-DELISTED	Stock	167.47	167.55	163.98	164.48	828451.0
2023-04-19	ABCB	Stock	33.83	35.4	33.57	34.99	481600.0
2023-04-19	ABCL	Stock	7.11	7.27	7.1	7.21	1185600.0
2023-04-19	ABCM-DELISTED	Stock	15.7	15.97	15.595	15.82	337484.0
2023-04-19	ABEO	Stock	2.97	3.3	2.93	3.15	266200.0
2023-04-19	ABEV	Stock	2.86	2.88	2.84	2.85	8994200.0
2023-04-19	ABG	Stock	204.82	208.01	200.88	206.3	164600.0
2023-04-19	ABLV	Stock	10.35	10.35	10.35	10.35	5000.0
2023-04-19	ABM	Stock	43.1	43.25	42.7	42.82	213800.0
2023-04-19	ABNB	Stock	118.145	120.37	117.64	120.1	3309700.0
2023-04-19	ABOS	Stock	3.53	4.03	3.53	4.0	112100.0
2023-04-19	ABR	Stock	10.37	11.19	10.37	11.05	6441300.0
2023-04-19	ABR.D	Stock	17.8	17.8	17.155	17.35	15008.0
2023-04-19	ABR.E	Stock	16.79	17.0	16.79	17.0	6346.0

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

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