PREVIEW / stock_daily / 2023-04-13

all stock daily files

  file:    by_date/stock_daily/2023/2023-04-13.parquet
  size:    243 KB
  rows:    7,546
  symbols: 1,688

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-13	AAPL	Stock	161.63	165.8	161.42	165.56	68445600.0
2023-04-13	MSFT	Stock	283.59	289.9	283.17	289.84	24222700.0
2023-04-13	NVDA	Stock	26.734	26.887	26.329	26.463	353615000.0
2023-04-13	AMZN	Stock	98.95	102.57	98.71	102.4	67925100.0
2023-04-13	GOOGL	Stock	105.84	107.49	105.84	107.43	24843579.0
2023-04-13	META	Stock	215.73	221.15	215.69	220.35	23310400.0
2023-04-13	TSLA	Stock	182.96	186.5	180.94	185.9	112933000.0
2023-04-13	TLT	Stock	107.05	107.39	105.88	106.05	22079384.0
2023-04-13	ES	Stock	79.25	79.93	78.12	79.62	3175200.0
2023-04-13	CL	Stock	76.05	76.63	75.83	76.52	3315000.0
2023-04-13	A	Stock	139.18	141.48	138.99	141.28	1030900.0
2023-04-13	AA	Stock	40.38	41.345	40.12	40.94	4086500.0
2023-04-13	AAC-DELISTED	Stock	10.35	10.355	10.34	10.35	50868.0
2023-04-13	AACG	Stock	1.94	1.95	1.89	1.9	12700.0
2023-04-13	AACIW-DELISTED	Stock	0.0829	0.101	0.0829	0.0991	2227.0
2023-04-13	AAIC-DELISTED	Stock	2.65	2.6501	2.53	2.61	117278.0
2023-04-13	AAIC.C-DELISTED	Stock	21.49	21.59	21.49	21.5898	852.0
2023-04-13	AAL	Stock	13.15	13.18	12.77	12.95	47388900.0
2023-04-13	AAM.A-DELISTED	Stock	23.5	23.64	23.3	23.64	20711.0
2023-04-13	AAM.B-DELISTED	Stock	23.36	23.87	23.3559	23.77	14999.0
2023-04-13	AAMC-DELISTED	Stock	20.4382	20.5735	20.309	20.309	13080.0
2023-04-13	AAME	Stock	2.43	2.49	2.42	2.48	10500.0
2023-04-13	AAMI	Stock	23.32	23.58	23.12	23.25	103100.0
2023-04-13	AAN-DELISTED	Stock	10.58	10.86	10.44	10.72	254900.0
2023-04-13	AAOI	Stock	2.3	2.315	2.21	2.23	100200.0
2023-04-13	AAON	Stock	64.34	65.0133	63.6467	64.7467	503850.0
2023-04-13	AAP	Stock	119.26	124.16	119.15	123.25	1538200.0
2023-04-13	AAT	Stock	17.67	17.93	17.45	17.72	450300.0
2023-04-13	AATC	Stock	3.9	3.9	3.81	3.895	5538.0
2023-04-13	AAU-DELISTED	Stock	0.188	0.195	0.1863	0.1873	282049.0
2023-04-13	AAUAF-DELISTED	Stock	0.188	0.195	0.1863	0.1873	283762.0
2023-04-13	AAXJ	Stock	67.97	68.48	67.97	68.43	1211243.0
2023-04-13	AB	Stock	34.2	35.47	34.2	35.03	302900.0
2023-04-13	ABB-DELISTED	Stock	34.88	34.91	34.36	34.84	2641920.0
2023-04-13	ABBNY-DELISTED	Stock	34.88	34.91	34.36	34.84	2842078.0
2023-04-13	ABBV	Stock	161.0	162.86	160.55	162.69	3868500.0
2023-04-13	ABC-DELISTED	Stock	165.73	167.44	165.44	167.38	465975.0
2023-04-13	ABCB	Stock	33.6	34.46	32.92	34.24	364000.0
2023-04-13	ABCL	Stock	7.34	7.64	7.32	7.59	1285800.0
2023-04-13	ABCM-DELISTED	Stock	13.59	13.8	13.4	13.52	737272.0
2023-04-13	ABEO	Stock	2.91	2.97	2.74	2.76	79100.0
2023-04-13	ABEV	Stock	2.94	2.96	2.92	2.93	11298200.0
2023-04-13	ABG	Stock	206.05	207.36	202.71	205.27	166800.0
2023-04-13	ABM	Stock	43.74	44.21	43.44	44.19	290400.0
2023-04-13	ABNB	Stock	113.18	114.4	112.81	113.95	3878100.0
2023-04-13	ABOS	Stock	3.84	4.19	3.76	3.88	97300.0
2023-04-13	ABR	Stock	10.56	10.61	10.25	10.42	5459800.0
2023-04-13	ABR.D	Stock	18.11	18.26	17.4	17.81	28229.0
2023-04-13	ABR.E	Stock	17.5	17.51	17.25	17.51	6357.0
2023-04-13	ABR.F	Stock	18.14	18.14	17.6862	17.86	43268.0

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

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