PREVIEW / stock_daily / 2023-04-27

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-27.parquet
  size:    241 KB
  rows:    7,503
  symbols: 1,645

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-27	AAPL	Stock	165.19	168.56	165.19	168.41	64902300.0
2023-04-27	MSFT	Stock	295.97	305.2	295.25	304.83	46462600.0
2023-04-27	NVDA	Stock	27.363	27.495	26.625	27.226	377161000.0
2023-04-27	AMZN	Stock	108.16	110.86	106.8	109.82	149961200.0
2023-04-27	GOOGL	Stock	104.45	108.37	103.54	107.59	50089187.0
2023-04-27	META	Stock	239.89	241.69	236.77	238.56	71196500.0
2023-04-27	TSLA	Stock	152.64	160.48	152.37	160.19	127015200.0
2023-04-27	TLT	Stock	105.2	105.27	104.61	104.77	20247619.0
2023-04-27	ES	Stock	77.6	78.52	76.83	77.98	1701700.0
2023-04-27	CL	Stock	76.99	77.97	76.78	77.93	5652600.0
2023-04-27	A	Stock	132.96	133.86	131.33	133.25	1125300.0
2023-04-27	AA	Stock	35.555	36.48	35.402	36.27	3850900.0
2023-04-27	AAC-DELISTED	Stock	10.38	10.38	10.37	10.38	184780.0
2023-04-27	AACG	Stock	1.81	1.82	1.79	1.8	3900.0
2023-04-27	AACIW-DELISTED	Stock	0.11	0.11	0.1099	0.1099	200.0
2023-04-27	AAIC-DELISTED	Stock	2.63	2.63	2.59	2.6	36742.0
2023-04-27	AAIC.C-DELISTED	Stock	20.89	21.11	20.8	21.0	3981.0
2023-04-27	AAL	Stock	12.97	13.4	12.75	12.88	48368000.0
2023-04-27	AAM.A-DELISTED	Stock	24.64	24.86	24.4203	24.75	18739.0
2023-04-27	AAM.B-DELISTED	Stock	24.53	24.8	24.39	24.8	13336.0
2023-04-27	AAMC-DELISTED	Stock	24.7941	26.2643	24.7941	25.2353	67425.0
2023-04-27	AAME	Stock	2.22	2.23	2.17	2.2	4500.0
2023-04-27	AAMI	Stock	22.14	22.61	22.14	22.34	59400.0
2023-04-27	AAN-DELISTED	Stock	13.2	13.48	13.04	13.23	531000.0
2023-04-27	AAOI	Stock	2.08	2.08	1.92	1.95	223000.0
2023-04-27	AAON	Stock	63.2667	66.7667	63.26	66.1467	987000.0
2023-04-27	AAP	Stock	121.8	125.07	121.8	124.9	833900.0
2023-04-27	AAT	Stock	17.73	18.35	17.73	18.29	412600.0
2023-04-27	AATC	Stock	4.02	4.02	4.0	4.01	6157.0
2023-04-27	AAU-DELISTED	Stock	0.1211	0.134	0.1211	0.1269	290271.0
2023-04-27	AAUAF-DELISTED	Stock	0.1211	0.134	0.1211	0.1269	286970.0
2023-04-27	AAXJ	Stock	65.82	66.49	65.79	66.37	209601.0
2023-04-27	AB	Stock	34.1	35.75	33.2	34.91	355400.0
2023-04-27	ABB-DELISTED	Stock	35.96	36.48	35.81	36.44	1852246.0
2023-04-27	ABBNY-DELISTED	Stock	35.96	36.48	35.81	36.44	2112463.0
2023-04-27	ABBV	Stock	153.87	153.87	147.16	148.87	17063000.0
2023-04-27	ABC-DELISTED	Stock	164.99	167.6	164.99	167.49	391442.0
2023-04-27	ABCB	Stock	32.99	33.99	32.91	33.76	685000.0
2023-04-27	ABCL	Stock	6.77	6.83	6.6	6.64	1256100.0
2023-04-27	ABCM-DELISTED	Stock	15.8	15.96	15.54	15.92	257184.0
2023-04-27	ABEO	Stock	3.21	3.21	3.03	3.13	157000.0
2023-04-27	ABEV	Stock	2.8	2.81	2.77	2.8	12815300.0
2023-04-27	ABG	Stock	185.2	194.22	184.03	193.19	250200.0
2023-04-27	ABLV	Stock	10.39	10.39	10.38	10.38	1100.0
2023-04-27	ABM	Stock	41.07	42.02	41.07	41.71	253300.0
2023-04-27	ABNB	Stock	114.44	115.85	112.287	115.25	3870500.0
2023-04-27	ABOS	Stock	3.72	3.85	3.552	3.82	18100.0
2023-04-27	ABR	Stock	10.58	11.06	10.57	11.02	4222400.0
2023-04-27	ABR.D	Stock	17.75	17.75	17.54	17.54	7688.0
2023-04-27	ABR.E	Stock	17.415	17.74	17.2911	17.44	7239.0

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

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