PREVIEW / stock_daily / 2023-05-19

all stock daily files

  file:    by_date/stock_daily/2023/2023-05-19.parquet
  size:    242 KB
  rows:    7,526
  symbols: 1,629

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-05-19	AAPL	Stock	176.39	176.39	174.94	175.16	55772400.0
2023-05-19	MSFT	Stock	316.74	318.75	316.37	318.34	27529500.0
2023-05-19	NVDA	Stock	31.536	31.58	30.916	31.264	473908000.0
2023-05-19	AMZN	Stock	118.16	118.31	115.7	116.25	54990200.0
2023-05-19	GOOGL	Stock	123.55	125.97	122.15	122.76	41353445.0
2023-05-19	META	Stock	247.47	248.69	243.41	245.64	21599800.0
2023-05-19	TSLA	Stock	177.17	181.95	176.31	180.14	136024200.0
2023-05-19	TLT	Stock	101.26	101.86	100.93	101.1	29038022.0
2023-05-19	ES	Stock	74.03	74.38	73.17	73.17	1670200.0
2023-05-19	CL	Stock	79.87	80.04	79.37	79.93	3763300.0
2023-05-19	A	Stock	129.59	130.47	128.62	128.87	1480400.0
2023-05-19	AA	Stock	37.15	37.15	35.93	36.1	3544300.0
2023-05-19	AAC-DELISTED	Stock	10.46	10.477	10.43	10.44	506901.0
2023-05-19	AACG	Stock	1.49	1.5	1.48	1.48	26100.0
2023-05-19	AACIW-DELISTED	Stock	0.1085	0.1085	0.1085	0.1085	790.0
2023-05-19	AAIC-DELISTED	Stock	2.58	2.6	2.56	2.595	106332.0
2023-05-19	AAIC.C-DELISTED	Stock	21.1	21.1001	20.9	21.1	4930.0
2023-05-19	AAL	Stock	15.07	15.09	14.63	14.82	17870900.0
2023-05-19	AAM.A-DELISTED	Stock	24.17	24.17	23.745	23.78	7208.0
2023-05-19	AAM.B-DELISTED	Stock	24.28	24.28	23.3775	24.06	8730.0
2023-05-19	AAMC-DELISTED	Stock	29.4088	29.4088	27.9559	28.5176	16436.0
2023-05-19	AAME	Stock	2.2	2.23	2.2	2.23	500.0
2023-05-19	AAMI	Stock	22.83	22.83	22.33	22.68	76700.0
2023-05-19	AAN-DELISTED	Stock	13.03	13.03	12.56	12.58	234200.0
2023-05-19	AAOI	Stock	1.73	1.754	1.71	1.71	42100.0
2023-05-19	AAON	Stock	61.82	61.9133	60.6933	60.9467	404850.0
2023-05-19	AAP	Stock	120.61	121.23	117.09	117.41	962800.0
2023-05-19	AAT	Stock	19.04	19.45	18.9	18.97	724500.0
2023-05-19	AATC	Stock	4.12	4.125	4.02	4.1	7324.0
2023-05-19	AAU-DELISTED	Stock	0.1154	0.1247	0.115	0.1201	345813.0
2023-05-19	AAUAF-DELISTED	Stock	0.1154	0.1247	0.115	0.1201	332466.0
2023-05-19	AAXJ	Stock	65.97	66.34	65.92	66.11	633060.0
2023-05-19	AB	Stock	35.09	35.27	34.3	34.42	132800.0
2023-05-19	ABB-DELISTED	Stock	37.57	37.76	37.465	37.56	2290433.0
2023-05-19	ABBNY-DELISTED	Stock	37.57	37.76	37.465	37.56	2505337.0
2023-05-19	ABBV	Stock	143.86	145.8	143.8	145.11	5609900.0
2023-05-19	ABC-DELISTED	Stock	175.13	176.62	173.1	173.37	1173541.0
2023-05-19	ABCB	Stock	32.34	32.34	30.66	31.04	561400.0
2023-05-19	ABCL	Stock	5.92	5.945	5.8	5.84	1535200.0
2023-05-19	ABCM-DELISTED	Stock	16.93	17.07	16.7	16.81	584089.0
2023-05-19	ABEO	Stock	3.02	3.1	2.95	3.1	69800.0
2023-05-19	ABEV	Stock	2.91	2.92	2.86	2.88	12237600.0
2023-05-19	ABG	Stock	209.86	209.86	203.82	204.23	184400.0
2023-05-19	ABLV	Stock	10.49	10.49	10.49	10.49	267.0
2023-05-19	ABM	Stock	44.52	44.52	43.54	43.6	319400.0
2023-05-19	ABNB	Stock	110.82	110.82	106.645	107.38	9124200.0
2023-05-19	ABOS	Stock	5.61	5.97	5.52	5.96	112000.0
2023-05-19	ABR	Stock	12.85	12.87	12.18	12.3	3984800.0
2023-05-19	ABR.D	Stock	17.2799	17.2799	17.0167	17.1	7667.0
2023-05-19	ABR.E	Stock	16.8	16.8	16.48	16.76	5844.0

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

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