PREVIEW / stock_daily / 2023-04-14

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-14.parquet
  size:    242 KB
  rows:    7,521
  symbols: 1,674

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-14	AAPL	Stock	164.59	166.32	163.82	165.21	49386500.0
2023-04-14	MSFT	Stock	287.0	288.48	283.69	286.14	20987900.0
2023-04-14	NVDA	Stock	26.504	26.883	26.22	26.758	395660000.0
2023-04-14	AMZN	Stock	102.07	103.2	101.11	102.51	51450500.0
2023-04-14	GOOGL	Stock	106.89	108.94	106.84	108.87	26578002.0
2023-04-14	META	Stock	217.88	222.11	217.55	221.49	21591200.0
2023-04-14	TSLA	Stock	183.95	186.28	182.01	185.0	96438700.0
2023-04-14	TLT	Stock	105.39	105.55	104.77	105.08	19801897.0
2023-04-14	ES	Stock	78.66	78.99	78.1	78.46	1676800.0
2023-04-14	CL	Stock	76.13	76.26	75.35	75.59	3756800.0
2023-04-14	A	Stock	140.36	141.19	138.93	139.2	954300.0
2023-04-14	AA	Stock	41.35	41.43	39.985	40.4	3376700.0
2023-04-14	AAC-DELISTED	Stock	10.35	10.35	10.34	10.34	242764.0
2023-04-14	AACG	Stock	1.93	1.98	1.83	1.85	19900.0
2023-04-14	AACIW-DELISTED	Stock	0.101	0.101	0.1009	0.1009	200.0
2023-04-14	AAIC-DELISTED	Stock	2.64	2.64	2.6	2.61	21734.0
2023-04-14	AAL	Stock	12.98	13.06	12.73	12.79	27538600.0
2023-04-14	AAM.A-DELISTED	Stock	23.68	23.83	23.48	23.83	24128.0
2023-04-14	AAM.B-DELISTED	Stock	23.94	24.0399	23.5	23.7	8192.0
2023-04-14	AAMC-DELISTED	Stock	20.3676	20.3676	20.2941	20.2941	3363.0
2023-04-14	AAME	Stock	2.49	2.49	2.4	2.49	8700.0
2023-04-14	AAMI	Stock	23.41	23.63	23.22	23.41	90500.0
2023-04-14	AAN-DELISTED	Stock	10.82	10.98	10.5	10.59	196000.0
2023-04-14	AAOI	Stock	2.23	2.26	2.05	2.12	74600.0
2023-04-14	AAON	Stock	64.46	65.5867	63.08	63.64	442650.0
2023-04-14	AAP	Stock	123.88	124.84	122.45	123.6	843800.0
2023-04-14	AAT	Stock	17.82	18.05	17.28	17.45	460200.0
2023-04-14	AATC	Stock	3.82	3.835	3.78	3.835	4718.0
2023-04-14	AAU-DELISTED	Stock	0.1876	0.192	0.1672	0.1769	453453.0
2023-04-14	AAUAF-DELISTED	Stock	0.1876	0.192	0.1672	0.1784	458832.0
2023-04-14	AAXJ	Stock	68.02	68.265	67.59	67.85	541834.0
2023-04-14	AB	Stock	35.22	36.58	35.22	36.47	309200.0
2023-04-14	ABB-DELISTED	Stock	35.14	35.39	34.97	35.135	1478388.0
2023-04-14	ABBNY-DELISTED	Stock	35.14	35.39	34.97	35.14	1744219.0
2023-04-14	ABBV	Stock	162.64	163.0	160.93	161.59	3473100.0
2023-04-14	ABC-DELISTED	Stock	167.19	167.7	166.53	167.09	512604.0
2023-04-14	ABCB	Stock	34.62	34.89	33.11	33.43	437100.0
2023-04-14	ABCL	Stock	7.63	7.63	7.28	7.38	1260700.0
2023-04-14	ABCM-DELISTED	Stock	13.6	15.74	13.56	15.59	1418652.0
2023-04-14	ABEO	Stock	2.77	2.84	2.73	2.79	36100.0
2023-04-14	ABEV	Stock	2.92	2.97	2.91	2.94	12787100.0
2023-04-14	ABG	Stock	206.81	210.07	204.86	208.27	153400.0
2023-04-14	ABM	Stock	44.1	44.22	42.92	43.19	246200.0
2023-04-14	ABNB	Stock	113.89	115.12	113.02	114.65	3415200.0
2023-04-14	ABOS	Stock	3.88	3.91	3.72	3.74	75700.0
2023-04-14	ABR	Stock	10.5	10.6	10.19	10.32	5028800.0
2023-04-14	ABR.D	Stock	17.67	17.78	17.3501	17.4765	11395.0
2023-04-14	ABR.E	Stock	17.312	17.5099	17.2911	17.2911	12434.0
2023-04-14	ABR.F	Stock	17.8	17.8	17.52	17.52	31432.0
2023-04-14	ABSI	Stock	1.85	1.88	1.77	1.785	233500.0

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

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