PREVIEW / stock_daily / 2023-06-20

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-20.parquet
  size:    242 KB
  rows:    7,545
  symbols: 1,616

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-06-20	AAPL	Stock	184.41	186.1	184.41	185.01	49799100.0
2023-06-20	MSFT	Stock	339.31	342.08	335.86	338.05	26375400.0
2023-06-20	NVDA	Stock	42.998	43.99	42.674	43.808	451153000.0
2023-06-20	AMZN	Stock	124.97	127.25	124.5	125.78	56930100.0
2023-06-20	GOOGL	Stock	122.93	124.57	122.14	123.1	26097492.0
2023-06-20	META	Stock	278.73	284.8	276.22	284.33	20701600.0
2023-06-20	TSLA	Stock	261.5	274.75	261.12	274.45	165611200.0
2023-06-20	TLT	Stock	103.11	103.6581	103.11	103.31	17163972.0
2023-06-20	ES	Stock	71.72	72.01	70.6	70.64	2207700.0
2023-06-20	CL	Stock	77.94	78.53	77.61	77.62	5232000.0
2023-06-20	A	Stock	118.64	118.79	116.88	118.16	2108200.0
2023-06-20	AA	Stock	34.584	34.88	33.88	34.22	5372900.0
2023-06-20	AAC-DELISTED	Stock	10.53	10.53	10.48	10.51	188809.0
2023-06-20	AACG	Stock	1.44	1.45	1.4	1.45	9600.0
2023-06-20	AACIW-DELISTED	Stock	0.06	0.0796	0.0353	0.079	7772.0
2023-06-20	AACT	Stock	10.13	10.13	10.11	10.12	102816.0
2023-06-20	AAIC-DELISTED	Stock	4.28	4.36	4.28	4.34	382315.0
2023-06-20	AAIC.C-DELISTED	Stock	22.6797	22.9	22.23	22.65	7824.0
2023-06-20	AAL	Stock	16.38	16.43	16.16	16.32	17926100.0
2023-06-20	AAM.A-DELISTED	Stock	21.95	22.5632	21.95	22.45	27680.0
2023-06-20	AAM.B-DELISTED	Stock	22.09	22.48	22.06	22.33	19180.0
2023-06-20	AAMC-DELISTED	Stock	17.7941	17.7941	16.7147	16.9529	45754.0
2023-06-20	AAME	Stock	2.08	2.2	2.08	2.1	13600.0
2023-06-20	AAMI	Stock	22.17	22.17	21.69	21.75	136100.0
2023-06-20	AAN-DELISTED	Stock	13.21	13.5	13.05	13.37	300100.0
2023-06-20	AAOI	Stock	5.05	5.67	5.047	5.2	8224500.0
2023-06-20	AAON	Stock	63.8667	65.1733	63.6333	64.6933	409350.0
2023-06-20	AAP	Stock	69.22	69.59	67.37	67.98	3743700.0
2023-06-20	AAT	Stock	19.65	19.65	19.18	19.3	294700.0
2023-06-20	AATC	Stock	4.29	4.4	4.25	4.33	3241.0
2023-06-20	AAU-DELISTED	Stock	0.1287	0.13	0.127	0.1281	121899.0
2023-06-20	AAUAF-DELISTED	Stock	0.1287	0.13	0.127	0.128	124049.0
2023-06-20	AAXJ	Stock	67.88	67.92	67.215	67.34	1229018.0
2023-06-20	AB	Stock	33.25	33.27	32.61	32.75	495500.0
2023-06-20	ABBNY-DELISTED	Stock	38.88	39.03	38.6	38.6	228216.0
2023-06-20	ABBV	Stock	137.1	138.95	136.66	137.82	4868800.0
2023-06-20	ABC-DELISTED	Stock	183.18	185.035	183.01	184.5	872778.0
2023-06-20	ABCB	Stock	35.23	35.23	34.5	34.68	285200.0
2023-06-20	ABCL	Stock	7.55	7.67	7.36	7.51	5122100.0
2023-06-20	ABCM-DELISTED	Stock	21.65	21.92	20.59	20.64	3907551.0
2023-06-20	ABEO	Stock	4.55	4.59	4.07	4.55	323100.0
2023-06-20	ABEV	Stock	3.12	3.13	3.1	3.11	14211100.0
2023-06-20	ABG	Stock	221.97	226.16	220.7	224.47	209700.0
2023-06-20	ABM	Stock	42.32	42.47	41.41	41.41	413700.0
2023-06-20	ABNB	Stock	126.37	127.63	124.395	126.45	5383600.0
2023-06-20	ABOS	Stock	5.86	6.06	5.555	5.95	181100.0
2023-06-20	ABR	Stock	13.7	13.8	13.31	13.44	4158200.0
2023-06-20	ABR.D	Stock	18.1472	18.2	17.78	17.93	16958.0
2023-06-20	ABR.E	Stock	18.05	18.05	17.9003	17.99	9025.0
2023-06-20	ABR.F	Stock	19.12	19.15	19.0	19.06	12353.0

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

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