PREVIEW / stock_daily / 2021-10-29

all stock daily files

  file:    by_date/stock_daily/2021/2021-10-29.parquet
  size:    260 KB
  rows:    7,955
  symbols: 2,677

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-10-29	AAPL	Stock	147.22	149.94	146.41	149.8	124953200.0
2021-10-29	MSFT	Stock	324.13	332.0	323.9	331.62	34766000.0
2021-10-29	NVDA	Stock	25.001	25.709	25.0	25.567	292503000.0
2021-10-29	AMZN	Stock	165.001	168.741	163.666	168.6215	129722000.0
2021-10-29	GOOGL	Stock	145.078	148.242	144.6495	148.046	43320300.0
2021-10-29	META	Stock	320.19	326.0	319.6	323.57	37059400.0
2021-10-29	TSLA	Stock	360.62	371.7367	357.7367	371.3333	89755200.0
2021-10-29	TLT	Stock	146.47	148.0	146.32	147.69	19087338.0
2021-10-29	ES	Stock	85.35	86.1	84.56	84.9	1552600.0
2021-10-29	CL	Stock	77.03	77.45	75.67	76.19	6683300.0
2021-10-29	A	Stock	155.13	157.57	154.44	157.49	1999800.0
2021-10-29	AA	Stock	46.08	47.21	45.38	45.95	6647200.0
2021-10-29	AAC-DELISTED	Stock	9.83	9.84	9.81	9.83	131590.0
2021-10-29	AACG	Stock	2.22	2.3	2.2	2.27	16200.0
2021-10-29	AACIU	Stock	9.9	9.9	9.89	9.9	25132.0
2021-10-29	AAIC-DELISTED	Stock	3.85	3.88	3.85	3.85	38492.0
2021-10-29	AAIC.C-DELISTED	Stock	25.3	25.3439	25.26	25.3439	428.0
2021-10-29	AAL	Stock	19.18	19.45	19.01	19.2	21679000.0
2021-10-29	AAM.A-DELISTED	Stock	25.97	26.05	25.97	26.05	18201.0
2021-10-29	AAM.B-DELISTED	Stock	27.05	27.205	26.99	26.99	46695.0
2021-10-29	AAMC-DELISTED	Stock	7.3324	7.5588	7.2743	7.4941	60819.0
2021-10-29	AAME	Stock	4.13	4.2	4.05	4.08	9200.0
2021-10-29	AAMI	Stock	28.84	30.25	28.65	29.98	2550400.0
2021-10-29	AAN-DELISTED	Stock	23.03	23.77	23.03	23.39	254700.0
2021-10-29	AAOI	Stock	7.61	7.71	7.61	7.65	272300.0
2021-10-29	AAON	Stock	47.5933	47.94	47.3067	47.7667	120000.0
2021-10-29	AAP	Stock	224.92	228.34	223.76	225.52	586700.0
2021-10-29	AAQC-DELISTED	Stock	9.73	9.74	9.73	9.74	2204.0
2021-10-29	AAT	Stock	38.22	38.22	37.76	37.83	299700.0
2021-10-29	AATC	Stock	6.9	6.9	6.79	6.84	10730.0
2021-10-29	AAU-DELISTED	Stock	0.38	0.38	0.3652	0.3695	1112007.0
2021-10-29	AAUAF-DELISTED	Stock	0.3771	0.3785	0.3652	0.369	1124112.0
2021-10-29	AAWW-DELISTED	Stock	80.47	82.38	80.47	81.12	226587.0
2021-10-29	AAXJ	Stock	86.44	86.5395	85.87	86.31	419535.0
2021-10-29	AB	Stock	55.99	56.46	55.91	56.39	211100.0
2021-10-29	ABB-DELISTED	Stock	33.02	33.135	32.97	33.05	792034.0
2021-10-29	ABBNY-DELISTED	Stock	33.02	33.135	32.97	33.04	894884.0
2021-10-29	ABBV	Stock	112.09	114.92	111.42	114.67	16545000.0
2021-10-29	ABC-DELISTED	Stock	120.05	122.18	119.62	122.06	452127.0
2021-10-29	ABCB	Stock	51.17	53.27	51.01	52.39	417800.0
2021-10-29	ABCL	Stock	15.75	16.219	15.62	15.71	799300.0
2021-10-29	ABCM-DELISTED	Stock	23.06	23.09	22.72	22.97	31106.0
2021-10-29	ABEO	Stock	20.25	21.0	20.0	20.25	23128.0
2021-10-29	ABEV	Stock	2.96	3.01	2.91	2.96	41934400.0
2021-10-29	ABG	Stock	194.71	199.37	194.52	195.71	149800.0
2021-10-29	ABGI-DELISTED	Stock	9.75	9.75	9.75	9.75	329500.0
2021-10-29	ABM	Stock	43.84	44.37	43.65	44.01	468500.0
2021-10-29	ABMD-DELISTED	Stock	339.49	339.49	322.38	331.93	203184.0
2021-10-29	ABNB	Stock	171.39	171.39	168.849	170.66	2294400.0
2021-10-29	ABOS	Stock	14.18	14.485	13.88	14.05	46300.0

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

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