PREVIEW / stock_daily / 2021-11-01

all stock daily files

  file:    by_date/stock_daily/2021/2021-11-01.parquet
  size:    260 KB
  rows:    7,967
  symbols: 2,676

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-11-01	AAPL	Stock	148.99	149.7	147.8	148.96	74588300.0
2021-11-01	MSFT	Stock	331.36	331.49	326.37	329.37	27073200.0
2021-11-01	NVDA	Stock	25.649	25.894	25.227	25.827	265740000.0
2021-11-01	AMZN	Stock	168.09	168.793	164.601	165.9055	72178000.0
2021-11-01	GOOGL	Stock	148.046	148.046	143.2255	143.497	46923240.0
2021-11-01	META	Stock	326.04	333.45	326.0	329.98	31518900.0
2021-11-01	TSLA	Stock	381.6667	403.25	372.8867	402.8633	168146100.0
2021-11-01	TLT	Stock	145.8	146.76	145.7	146.44	18035452.0
2021-11-01	ES	Stock	84.9	85.06	84.35	84.75	1014200.0
2021-11-01	CL	Stock	75.99	76.6	75.67	75.95	4008000.0
2021-11-01	A	Stock	157.38	158.0	155.8	157.06	1329100.0
2021-11-01	AA	Stock	46.22	47.53	45.21	46.73	9336800.0
2021-11-01	AAC-DELISTED	Stock	9.84	9.84	9.8	9.83	601344.0
2021-11-01	AACG	Stock	2.27	2.37	2.25	2.29	23800.0
2021-11-01	AAIC-DELISTED	Stock	3.84	3.92	3.84	3.88	76150.0
2021-11-01	AAIC.C-DELISTED	Stock	25.4799	25.5	25.4747	25.5	2481.0
2021-11-01	AAL	Stock	19.09	19.78	18.87	19.77	32308500.0
2021-11-01	AAM.A-DELISTED	Stock	25.9835	26.08	25.98	26.08	15351.0
2021-11-01	AAM.B-DELISTED	Stock	27.0	27.185	26.88	27.15	27884.0
2021-11-01	AAMC-DELISTED	Stock	7.27	7.4853	7.2559	7.4853	9275.0
2021-11-01	AAME	Stock	4.08	4.35	4.07	4.26	46400.0
2021-11-01	AAMI	Stock	30.24	30.72	29.54	29.82	904100.0
2021-11-01	AAN-DELISTED	Stock	23.42	25.43	23.4	25.31	302600.0
2021-11-01	AAOI	Stock	7.64	7.72	7.58	7.66	302000.0
2021-11-01	AAON	Stock	47.8533	48.6467	47.5467	48.3267	137850.0
2021-11-01	AAP	Stock	226.29	228.01	223.46	225.11	733800.0
2021-11-01	AAQC-DELISTED	Stock	9.74	9.74	9.74	9.74	274.0
2021-11-01	AAT	Stock	37.99	38.7	37.79	38.55	306800.0
2021-11-01	AATC	Stock	6.84	6.9	6.7601	6.9	25178.0
2021-11-01	AAU-DELISTED	Stock	0.37	0.385	0.369	0.38	477120.0
2021-11-01	AAUAF-DELISTED	Stock	0.37	0.385	0.369	0.38	519711.0
2021-11-01	AAWW-DELISTED	Stock	81.42	83.58	81.42	83.53	264315.0
2021-11-01	AAXJ	Stock	86.13	87.04	86.13	86.99	863714.0
2021-11-01	AB	Stock	56.89	57.54	55.95	56.55	348800.0
2021-11-01	ABB-DELISTED	Stock	33.35	33.435	33.2	33.35	1427511.0
2021-11-01	ABBNY-DELISTED	Stock	33.35	33.435	33.2	33.35	3653675.0
2021-11-01	ABBV	Stock	115.25	115.72	113.57	114.81	7096800.0
2021-11-01	ABC-DELISTED	Stock	122.42	123.745	122.2	122.83	444262.0
2021-11-01	ABCB	Stock	53.07	53.89	52.59	53.87	553400.0
2021-11-01	ABCL	Stock	15.77	17.25	15.76	17.03	1649900.0
2021-11-01	ABCM-DELISTED	Stock	22.92	23.08	22.74	23.03	30887.0
2021-11-01	ABEO	Stock	20.75	23.25	20.5	22.5	45380.0
2021-11-01	ABEV	Stock	2.95	3.06	2.95	3.05	21590400.0
2021-11-01	ABG	Stock	195.86	202.33	195.86	202.02	267100.0
2021-11-01	ABGI-DELISTED	Stock	9.75	9.78	9.75	9.78	9272.0
2021-11-01	ABM	Stock	44.15	45.99	44.15	45.5	318000.0
2021-11-01	ABMD-DELISTED	Stock	333.06	350.55	332.57	349.98	240235.0
2021-11-01	ABNB	Stock	170.5	175.44	170.5	174.6	4401100.0
2021-11-01	ABOS	Stock	14.05	14.72	13.61	13.87	27700.0
2021-11-01	ABR	Stock	20.2	20.74	20.19	20.73	1972200.0

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

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