PREVIEW / stock_daily / 2023-04-21

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-21.parquet
  size:    242 KB
  rows:    7,505
  symbols: 1,658

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-21	AAPL	Stock	165.05	166.45	164.49	165.02	58337300.0
2023-04-21	MSFT	Stock	285.01	286.27	283.06	285.76	21676400.0
2023-04-21	NVDA	Stock	26.952	27.183	26.722	27.119	345103000.0
2023-04-21	AMZN	Stock	106.1	108.15	105.08	106.96	86774200.0
2023-04-21	GOOGL	Stock	105.47	106.0	104.78	105.41	25800082.0
2023-04-21	META	Stock	210.21	213.41	209.58	212.89	17717200.0
2023-04-21	TSLA	Stock	164.8	166.0	161.32	165.08	123539000.0
2023-04-21	TLT	Stock	105.3	105.46	104.27	104.4	15244718.0
2023-04-21	ES	Stock	79.28	79.58	78.38	78.84	1116600.0
2023-04-21	CL	Stock	77.18	77.5	76.73	76.8	11708600.0
2023-04-21	A	Stock	136.21	138.56	136.21	138.5	1533600.0
2023-04-21	AA	Stock	39.83	39.83	37.41	38.16	9180100.0
2023-04-21	AAC-DELISTED	Stock	10.36	10.39	10.36	10.37	180573.0
2023-04-21	AACG	Stock	1.9	1.95	1.88	1.88	6000.0
2023-04-21	AAIC-DELISTED	Stock	2.61	2.638	2.58	2.6	30463.0
2023-04-21	AAIC.C-DELISTED	Stock	21.24	21.24	21.2398	21.2398	300.0
2023-04-21	AAL	Stock	13.31	13.42	13.16	13.4	16548000.0
2023-04-21	AAM.A-DELISTED	Stock	23.85	24.556	23.7404	24.37	24509.0
2023-04-21	AAM.B-DELISTED	Stock	23.77	24.65	23.64	24.62	15408.0
2023-04-21	AAMC-DELISTED	Stock	24.8588	24.8588	22.9677	24.1471	45142.0
2023-04-21	AAME	Stock	2.36	2.36	2.31	2.33	6600.0
2023-04-21	AAMI	Stock	23.75	23.75	23.29	23.56	85100.0
2023-04-21	AAN-DELISTED	Stock	10.28	10.36	10.02	10.15	340200.0
2023-04-21	AAOI	Stock	2.14	2.16	2.09	2.14	58600.0
2023-04-21	AAON	Stock	66.0733	66.5133	65.5467	66.3067	317850.0
2023-04-21	AAP	Stock	129.38	129.9	127.87	128.21	1142200.0
2023-04-21	AAT	Stock	18.25	18.29	17.73	17.94	261100.0
2023-04-21	AAU-DELISTED	Stock	0.1552	0.1669	0.1516	0.1537	191396.0
2023-04-21	AAUAF-DELISTED	Stock	0.1552	0.1669	0.1516	0.1537	173007.0
2023-04-21	AAXJ	Stock	66.75	66.8	66.38	66.72	502807.0
2023-04-21	AB	Stock	36.4	36.73	35.82	36.09	220100.0
2023-04-21	ABB-DELISTED	Stock	35.16	35.435	35.105	35.42	1192189.0
2023-04-21	ABBNY-DELISTED	Stock	35.16	35.435	35.105	35.42	1322909.0
2023-04-21	ABBV	Stock	162.59	163.19	162.02	162.41	4812100.0
2023-04-21	ABC-DELISTED	Stock	167.0	167.82	165.7818	166.74	526540.0
2023-04-21	ABCB	Stock	34.48	34.57	33.73	33.98	320800.0
2023-04-21	ABCL	Stock	7.13	7.365	7.079	7.21	1683000.0
2023-04-21	ABCM-DELISTED	Stock	15.64	15.91	15.41	15.85	248754.0
2023-04-21	ABEO	Stock	3.12	3.3	3.09	3.22	375200.0
2023-04-21	ABEV	Stock	2.89	2.89	2.82	2.83	7288200.0
2023-04-21	ABG	Stock	204.28	204.39	201.0	203.93	178700.0
2023-04-21	ABM	Stock	42.82	42.93	42.17	42.3	229000.0
2023-04-21	ABNB	Stock	114.955	115.75	112.02	115.5	7357800.0
2023-04-21	ABOS	Stock	4.1	4.19	3.91	4.0	96300.0
2023-04-21	ABR	Stock	10.89	10.92	10.51	10.69	4461800.0
2023-04-21	ABR.D	Stock	17.6	17.6	17.0901	17.25	17816.0
2023-04-21	ABR.E	Stock	17.1	17.55	17.1	17.4	37591.0
2023-04-21	ABR.F	Stock	17.7	17.79	17.52	17.58	24564.0
2023-04-21	ABSI	Stock	1.69	1.74	1.66	1.69	182200.0
2023-04-21	ABST-DELISTED	Stock	7.98	8.08	7.8	7.95	172410.0

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

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