PREVIEW / stock_daily / 2023-06-22

all stock daily files

  file:    by_date/stock_daily/2023/2023-06-22.parquet
  size:    242 KB
  rows:    7,514
  symbols: 1,585

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-22	AAPL	Stock	183.74	187.05	183.67	187.0	51245300.0
2023-06-22	MSFT	Stock	334.12	340.12	333.34	339.71	23556800.0
2023-06-22	NVDA	Stock	42.253	43.426	42.234	43.025	417737000.0
2023-06-22	AMZN	Stock	125.31	130.33	125.14	130.15	90354600.0
2023-06-22	GOOGL	Stock	120.0	123.24	118.83	123.15	26952246.0
2023-06-22	META	Stock	279.08	285.26	277.79	284.88	17563100.0
2023-06-22	TSLA	Stock	250.77	265.0	248.25	264.61	166875900.0
2023-06-22	TLT	Stock	102.8	103.25	102.2	102.31	23633350.0
2023-06-22	ES	Stock	71.84	71.98	70.34	70.75	1584800.0
2023-06-22	CL	Stock	78.03	78.18	77.45	78.0	3939100.0
2023-06-22	A	Stock	118.84	118.95	117.17	118.68	1736000.0
2023-06-22	AA	Stock	33.8	33.95	32.81	33.41	7327400.0
2023-06-22	AAC-DELISTED	Stock	10.51	10.52	10.51	10.515	7730.0
2023-06-22	AACG	Stock	1.36	1.41	1.36	1.4	2200.0
2023-06-22	AACIW-DELISTED	Stock	0.145	0.145	0.145	0.145	1643.0
2023-06-22	AACT	Stock	10.13	10.13	10.12	10.12	652166.0
2023-06-22	AAIC-DELISTED	Stock	4.37	4.43	4.365	4.37	162703.0
2023-06-22	AAIC.C-DELISTED	Stock	22.68	22.68	22.68	22.68	398.0
2023-06-22	AAL	Stock	16.23	16.39	16.07	16.36	12694200.0
2023-06-22	AAM.A-DELISTED	Stock	23.2	23.3	22.68	22.97	14598.0
2023-06-22	AAM.B-DELISTED	Stock	22.96	23.28	22.46	22.77	15596.0
2023-06-22	AAMC-DELISTED	Stock	17.0	17.3235	16.4118	16.6647	89631.0
2023-06-22	AAME	Stock	2.11	2.11	2.04	2.04	3300.0
2023-06-22	AAMI	Stock	21.22	21.22	20.86	20.91	143800.0
2023-06-22	AAN-DELISTED	Stock	13.3	13.34	12.93	13.02	144800.0
2023-06-22	AAOI	Stock	4.695	4.7	3.591	3.77	6424000.0
2023-06-22	AAON	Stock	66.7467	66.8467	64.74	64.8133	455250.0
2023-06-22	AAP	Stock	69.19	69.36	67.52	67.97	2525600.0
2023-06-22	AAT	Stock	19.22	19.22	18.34	18.45	457400.0
2023-06-22	AATC	Stock	4.385	4.45	4.3788	4.4	5564.0
2023-06-22	AAU-DELISTED	Stock	0.128	0.1293	0.127	0.128	252058.0
2023-06-22	AAUAF-DELISTED	Stock	0.128	0.1293	0.127	0.1284	227092.0
2023-06-22	AAXJ	Stock	66.6	66.97	66.54	66.88	264048.0
2023-06-22	AB	Stock	32.28	32.61	31.86	32.04	415100.0
2023-06-22	ABBNY-DELISTED	Stock	38.21	38.46	38.21	38.38	447358.0
2023-06-22	ABBV	Stock	137.15	137.9	135.89	137.41	4826900.0
2023-06-22	ABC-DELISTED	Stock	186.2	187.88	185.105	187.88	999446.0
2023-06-22	ABCB	Stock	34.0	34.17	32.84	33.3	413300.0
2023-06-22	ABCL	Stock	7.2	7.25	7.0	7.2	3028400.0
2023-06-22	ABCM-DELISTED	Stock	19.98	20.32	19.75	20.28	4425621.0
2023-06-22	ABEO	Stock	4.8	5.4	4.72	5.27	321200.0
2023-06-22	ABEV	Stock	3.18	3.23	3.16	3.22	17415700.0
2023-06-22	ABG	Stock	225.99	229.99	222.53	229.89	106600.0
2023-06-22	ABM	Stock	41.68	41.78	40.92	41.03	659300.0
2023-06-22	ABNB	Stock	126.58	128.62	125.35	127.96	3935600.0
2023-06-22	ABOS	Stock	5.614	5.82	5.563	5.65	60900.0
2023-06-22	ABR	Stock	14.34	14.61	13.95	14.08	47485800.0
2023-06-22	ABR.D	Stock	18.2422	18.25	18.2	18.2	9565.0
2023-06-22	ABR.E	Stock	17.85	18.2	17.85	18.1975	5313.0
2023-06-22	ABR.F	Stock	19.23	19.25	19.1	19.24	12590.0

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

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