PREVIEW / stock_daily / 2023-04-25

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-25.parquet
  size:    242 KB
  rows:    7,535
  symbols: 1,675

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-25	AAPL	Stock	165.19	166.31	163.73	163.77	48714100.0
2023-04-25	MSFT	Stock	279.51	281.6	275.37	275.42	45772200.0
2023-04-25	NVDA	Stock	27.078	27.247	26.225	26.241	378527000.0
2023-04-25	AMZN	Stock	104.91	105.45	102.45	102.57	65026800.0
2023-04-25	GOOGL	Stock	105.825	106.69	103.84	103.85	46664104.0
2023-04-25	META	Stock	210.82	211.26	207.13	207.55	19198200.0
2023-04-25	TSLA	Stock	159.82	163.47	158.75	160.67	121999300.0
2023-04-25	TLT	Stock	106.33	107.13	106.28	106.96	21899884.0
2023-04-25	ES	Stock	79.5	79.92	79.27	79.57	723700.0
2023-04-25	CL	Stock	78.04	78.56	77.51	77.7	6437500.0
2023-04-25	A	Stock	136.54	136.78	129.72	130.37	2154900.0
2023-04-25	AA	Stock	36.9	36.9	35.72	35.75	6363500.0
2023-04-25	AAC-DELISTED	Stock	10.35	10.37	10.35	10.37	23700.0
2023-04-25	AACG	Stock	1.87	1.91	1.84	1.84	6500.0
2023-04-25	AACIW-DELISTED	Stock	0.1009	0.1009	0.1001	0.1001	813.0
2023-04-25	AAIC-DELISTED	Stock	2.59	2.61	2.57	2.58	24086.0
2023-04-25	AAIC.C-DELISTED	Stock	21.4999	21.5	21.2003	21.2003	2452.0
2023-04-25	AAL	Stock	13.16	13.17	12.81	12.84	33615600.0
2023-04-25	AAM.A-DELISTED	Stock	24.0	24.57	23.99	24.4	13957.0
2023-04-25	AAM.B-DELISTED	Stock	24.26	24.69	24.26	24.52	19703.0
2023-04-25	AAMC-DELISTED	Stock	24.5441	24.5441	23.4029	23.6794	27346.0
2023-04-25	AAME	Stock	2.3	2.32	2.28	2.28	4800.0
2023-04-25	AAMI	Stock	23.09	23.2	22.38	22.4	67100.0
2023-04-25	AAN-DELISTED	Stock	12.25	13.28	11.75	12.62	1198600.0
2023-04-25	AAOI	Stock	2.15	2.15	2.0	2.01	85200.0
2023-04-25	AAON	Stock	65.2933	66.16	65.0867	65.0867	325650.0
2023-04-25	AAP	Stock	126.92	126.92	123.75	123.78	933900.0
2023-04-25	AAT	Stock	17.52	17.77	17.3	17.39	377500.0
2023-04-25	AATC	Stock	4.04	4.04	4.04	4.04	2600.0
2023-04-25	AAU-DELISTED	Stock	0.1364	0.1408	0.122	0.1255	398980.0
2023-04-25	AAUAF-DELISTED	Stock	0.1364	0.1408	0.122	0.1261	368703.0
2023-04-25	AAXJ	Stock	65.36	65.48	64.93	64.95	1844620.0
2023-04-25	AB	Stock	35.1	35.47	34.4	34.45	230300.0
2023-04-25	ABB-DELISTED	Stock	36.43	36.975	36.41	36.64	2724960.0
2023-04-25	ABBNY-DELISTED	Stock	36.43	36.975	36.41	36.64	3203620.0
2023-04-25	ABBV	Stock	164.81	166.2	164.49	164.9	5506200.0
2023-04-25	ABC-DELISTED	Stock	167.91	168.63	167.21	168.11	364691.0
2023-04-25	ABCB	Stock	33.19	33.39	31.94	32.08	478200.0
2023-04-25	ABCL	Stock	7.1	7.11	6.71	6.73	2316100.0
2023-04-25	ABCM-DELISTED	Stock	15.96	16.17	15.48	15.48	495115.0
2023-04-25	ABEO	Stock	3.38	3.4	3.21	3.26	76000.0
2023-04-25	ABEV	Stock	2.77	2.81	2.76	2.79	16844000.0
2023-04-25	ABG	Stock	205.88	205.88	186.34	187.64	563200.0
2023-04-25	ABLV	Stock	10.36	10.36	10.36	10.36	10000.0
2023-04-25	ABM	Stock	41.74	42.12	41.42	41.51	243100.0
2023-04-25	ABNB	Stock	115.31	115.43	112.47	112.505	3659700.0
2023-04-25	ABOS	Stock	3.73	3.73	3.6	3.66	42600.0
2023-04-25	ABR	Stock	10.43	10.51	10.29	10.42	3528700.0
2023-04-25	ABR.D	Stock	17.5948	17.6594	17.3	17.541	9483.0
2023-04-25	ABR.E	Stock	17.52	17.52	17.34	17.42	12959.0

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

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