PREVIEW / stock_daily / 2021-08-26

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-26.parquet
  size:    257 KB
  rows:    7,872
  symbols: 2,736

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
2021-08-26	AAPL	Stock	148.35	149.12	147.51	147.54	48597200.0
2021-08-26	MSFT	Stock	300.99	302.43	298.95	299.09	17666100.0
2021-08-26	NVDA	Stock	22.2	22.34	21.79	22.068	237940000.0
2021-08-26	AMZN	Stock	164.95	166.6	164.8	165.8	41976000.0
2021-08-26	GOOGL	Stock	141.75	142.4175	141.357	141.4405	20609320.0
2021-08-26	META	Stock	368.38	369.44	364.13	364.38	7888700.0
2021-08-26	TSLA	Stock	236.1033	238.4667	232.54	233.72	39642900.0
2021-08-26	TLT	Stock	147.965	148.57	147.51	148.45	16657435.0
2021-08-26	ES	Stock	90.21	90.64	89.98	90.29	1646200.0
2021-08-26	CL	Stock	77.67	77.79	77.05	77.31	2317300.0
2021-08-26	A	Stock	173.39	174.47	172.1	173.59	1273400.0
2021-08-26	AA	Stock	41.72	42.58	41.35	41.42	3972000.0
2021-08-26	AAC-DELISTED	Stock	9.7	9.7	9.67	9.67	53069.0
2021-08-26	AACG	Stock	2.67	2.67	2.56	2.63	25400.0
2021-08-26	AACIU	Stock	9.85	9.97	9.85	9.92	473833.0
2021-08-26	AAIC-DELISTED	Stock	3.75	3.8	3.75	3.77	89925.0
2021-08-26	AAIC.C-DELISTED	Stock	25.1999	25.2	25.18	25.2	1300.0
2021-08-26	AAL	Stock	20.0	20.44	19.58	19.9	22809500.0
2021-08-26	AAM.A-DELISTED	Stock	26.11	26.2	26.1	26.155	6792.0
2021-08-26	AAM.B-DELISTED	Stock	27.1	27.2	27.1	27.2	4346.0
2021-08-26	AAMC-DELISTED	Stock	4.0794	4.0794	4.0229	4.0353	6467.0
2021-08-26	AAME	Stock	3.7	3.79	3.65	3.69	20600.0
2021-08-26	AAMI	Stock	27.33	27.4	27.16	27.26	365200.0
2021-08-26	AAN-DELISTED	Stock	27.48	27.89	26.87	26.96	218900.0
2021-08-26	AAOI	Stock	6.88	7.15	6.88	7.09	332900.0
2021-08-26	AAON	Stock	45.54	45.54	44.8267	44.9267	175350.0
2021-08-26	AAP	Stock	211.64	212.0	208.0	208.82	679000.0
2021-08-26	AAQC-DELISTED	Stock	9.606	9.65	9.606	9.64	7814.0
2021-08-26	AAT	Stock	38.33	38.47	38.03	38.09	213700.0
2021-08-26	AATC	Stock	7.5	7.7499	7.34	7.6	57306.0
2021-08-26	AAU-DELISTED	Stock	0.3989	0.4099	0.39	0.3925	364263.0
2021-08-26	AAUAF-DELISTED	Stock	0.3989	0.4099	0.39	0.3949	371632.0
2021-08-26	AAWW-DELISTED	Stock	73.82	74.38	72.7	73.32	157910.0
2021-08-26	AAXJ	Stock	86.81	86.81	86.29	86.3	1025659.0
2021-08-26	AB	Stock	50.63	51.1	50.58	50.77	228600.0
2021-08-26	ABB-DELISTED	Stock	37.39	37.55	37.3	37.37	781024.0
2021-08-26	ABBNY-DELISTED	Stock	37.39	37.55	37.3	37.37	878653.0
2021-08-26	ABBV	Stock	120.86	121.25	120.15	120.4	5035400.0
2021-08-26	ABC-DELISTED	Stock	118.06	118.07	115.81	116.82	618596.0
2021-08-26	ABCB	Stock	49.5	50.04	48.37	48.43	214900.0
2021-08-26	ABCL	Stock	17.82	17.855	16.86	17.37	933600.0
2021-08-26	ABCM-DELISTED	Stock	20.68	20.99	20.66	20.85	85347.0
2021-08-26	ABEO	Stock	31.5	32.75	31.5	32.25	13544.0
2021-08-26	ABEV	Stock	3.28	3.28	3.21	3.21	22672400.0
2021-08-26	ABG	Stock	190.0	190.0	185.15	185.38	99200.0
2021-08-26	ABM	Stock	48.97	50.71	48.97	49.07	426800.0
2021-08-26	ABMD-DELISTED	Stock	357.35	360.27	353.0	358.57	83525.0
2021-08-26	ABNB	Stock	159.34	159.5	151.45	152.73	7243000.0
2021-08-26	ABOS	Stock	17.07	18.19	16.44	17.45	267800.0
2021-08-26	ABR	Stock	18.2	18.25	17.92	17.96	998500.0

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

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