PREVIEW / stock_daily / 2023-03-02

all stock daily files

  file:    by_date/stock_daily/2023/2023-03-02.parquet
  size:    247 KB
  rows:    7,633
  symbols: 1,808

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-03-02	AAPL	Stock	144.38	146.71	143.9	145.91	52238100.0
2023-03-02	MSFT	Stock	246.55	251.4	245.61	251.11	24808200.0
2023-03-02	NVDA	Stock	22.488	23.38	22.432	23.314	389415000.0
2023-03-02	AMZN	Stock	91.41	92.23	90.39	92.13	55509400.0
2023-03-02	GOOGL	Stock	89.66	92.275	89.59	92.0	32226229.0
2023-03-02	META	Stock	172.38	175.01	171.43	174.53	17352000.0
2023-03-02	TSLA	Stock	186.74	193.75	186.01	190.9	181500700.0
2023-03-02	TLT	Stock	99.06	99.645	98.88	99.48	23769180.0
2023-03-02	ES	Stock	73.0	74.35	72.84	74.15	2950700.0
2023-03-02	CL	Stock	72.59	73.95	72.54	73.77	2916000.0
2023-03-02	A	Stock	136.3	141.72	136.08	141.67	1879200.0
2023-03-02	AA	Stock	50.19	53.71	50.05	53.69	6467900.0
2023-03-02	AAC-DELISTED	Stock	10.26	10.26	10.24	10.24	30427.0
2023-03-02	AACG	Stock	1.95	1.99	1.88	1.99	12900.0
2023-03-02	AAIC-DELISTED	Stock	3.0	3.09	3.0	3.01	74714.0
2023-03-02	AAIC.C-DELISTED	Stock	21.51	22.3459	21.25	22.0	10979.0
2023-03-02	AAL	Stock	15.88	16.15	15.73	16.12	11728300.0
2023-03-02	AAM.A-DELISTED	Stock	24.05	24.3999	23.44	23.5	9106.0
2023-03-02	AAM.B-DELISTED	Stock	23.73	24.07	23.1	23.53	11322.0
2023-03-02	AAMC-DELISTED	Stock	16.1765	16.3471	15.4559	15.7971	38478.0
2023-03-02	AAME	Stock	2.54	2.54	2.44	2.47	1200.0
2023-03-02	AAMI	Stock	24.91	25.03	24.52	24.97	116600.0
2023-03-02	AAN-DELISTED	Stock	12.24	13.2	11.51	12.37	1099200.0
2023-03-02	AAOI	Stock	2.74	2.83	2.67	2.69	86500.0
2023-03-02	AAON	Stock	60.1733	61.0933	59.8133	60.9067	792450.0
2023-03-02	AAP	Stock	138.18	139.64	137.12	139.21	1581600.0
2023-03-02	AAT	Stock	24.92	24.97	24.69	24.9	392800.0
2023-03-02	AATC	Stock	4.32	4.32	4.3	4.32	6729.0
2023-03-02	AAU-DELISTED	Stock	0.2194	0.2194	0.2	0.2048	406840.0
2023-03-02	AAUAF-DELISTED	Stock	0.2194	0.2194	0.2	0.2048	410111.0
2023-03-02	AAWW-DELISTED	Stock	100.65	100.83	100.03	100.35	271822.0
2023-03-02	AAXJ	Stock	66.64	67.43	66.52	67.36	706105.0
2023-03-02	AB	Stock	38.52	38.69	37.88	38.01	232500.0
2023-03-02	ABB-DELISTED	Stock	33.15	33.71	33.12	33.71	979778.0
2023-03-02	ABBNY-DELISTED	Stock	33.15	33.71	33.12	33.71	1092796.0
2023-03-02	ABBV	Stock	155.23	155.77	154.21	154.38	4567800.0
2023-03-02	ABC-DELISTED	Stock	156.49	156.78	154.72	154.91	1010329.0
2023-03-02	ABCB	Stock	47.41	47.41	46.34	46.96	294300.0
2023-03-02	ABCL	Stock	8.1	8.195	7.885	8.18	1677500.0
2023-03-02	ABCM-DELISTED	Stock	14.45	15.1	14.405	15.02	822794.0
2023-03-02	ABEO	Stock	2.25	2.45	2.25	2.42	120400.0
2023-03-02	ABEV	Stock	2.51	2.55	2.5	2.52	29163200.0
2023-03-02	ABG	Stock	230.88	233.95	229.46	232.75	120700.0
2023-03-02	ABM	Stock	48.1	48.58	47.85	48.48	167200.0
2023-03-02	ABNB	Stock	119.67	123.26	119.36	122.38	4087300.0
2023-03-02	ABOS	Stock	5.2	5.32	5.05	5.12	51300.0
2023-03-02	ABR	Stock	14.66	15.0	14.59	14.97	3548000.0
2023-03-02	ABR.D	Stock	19.0	19.0	18.0	18.67	41567.0
2023-03-02	ABR.E	Stock	18.82	18.86	18.05	18.86	12178.0
2023-03-02	ABR.F	Stock	20.72	20.73	20.37	20.5	19295.0

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

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