PREVIEW / stock_daily / 2021-08-13

all stock daily files

  file:    by_date/stock_daily/2021/2021-08-13.parquet
  size:    256 KB
  rows:    7,885
  symbols: 2,778

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-13	AAPL	Stock	148.97	149.44	148.27	149.1	59375000.0
2021-08-13	MSFT	Stock	289.48	292.9	289.3	292.85	18249000.0
2021-08-13	NVDA	Stock	19.905	20.214	19.851	20.188	183063000.0
2021-08-13	AMZN	Stock	165.2835	165.3035	164.15	164.6985	41134000.0
2021-08-13	GOOGL	Stock	137.25	137.8565	137.033	137.7275	15947440.0
2021-08-13	META	Stock	362.97	364.66	361.48	363.18	7195700.0
2021-08-13	TSLA	Stock	241.2367	243.3	238.1133	239.0567	50194500.0
2021-08-13	TLT	Stock	146.83	148.56	146.81	148.55	18653828.0
2021-08-13	ES	Stock	89.79	90.46	89.58	90.44	1401400.0
2021-08-13	CL	Stock	78.74	79.58	78.68	79.44	3521600.0
2021-08-13	A	Stock	158.4	159.27	157.39	159.23	1733200.0
2021-08-13	AA	Stock	45.39	45.791	44.89	45.25	5839400.0
2021-08-13	AAC-DELISTED	Stock	9.74	9.74	9.68	9.71	26819.0
2021-08-13	AACG	Stock	2.76	2.98	2.51	2.71	254800.0
2021-08-13	AACIU	Stock	9.8	9.9	9.78	9.8	4794118.0
2021-08-13	AAIC-DELISTED	Stock	3.86	3.87	3.84	3.84	164430.0
2021-08-13	AAIC.C-DELISTED	Stock	25.05	25.05	24.97	25.02	5772.0
2021-08-13	AAL	Stock	20.37	20.55	19.75	19.84	30877500.0
2021-08-13	AAM.A-DELISTED	Stock	26.35	26.42	26.3027	26.38	11516.0
2021-08-13	AAM.B-DELISTED	Stock	27.01	27.06	26.99	27.03	25117.0
2021-08-13	AAMC-DELISTED	Stock	4.175	4.1981	4.175	4.1981	3189.0
2021-08-13	AAME	Stock	4.06	4.09	3.85	3.85	62300.0
2021-08-13	AAMI	Stock	26.81	26.88	26.65	26.73	178000.0
2021-08-13	AAN-DELISTED	Stock	29.34	30.25	29.19	29.24	321400.0
2021-08-13	AAOI	Stock	6.96	7.2	6.74	7.04	791400.0
2021-08-13	AAON	Stock	46.0733	46.0733	45.16	45.98	153750.0
2021-08-13	AAP	Stock	209.65	209.79	206.36	206.43	455500.0
2021-08-13	AAQC-DELISTED	Stock	9.64	9.65	9.6	9.65	393107.0
2021-08-13	AAT	Stock	38.19	38.43	38.05	38.24	124900.0
2021-08-13	AATC	Stock	6.76	7.1999	6.76	7.13	197264.0
2021-08-13	AAU-DELISTED	Stock	0.4159	0.4258	0.41	0.419	376278.0
2021-08-13	AAUAF-DELISTED	Stock	0.4159	0.4258	0.41	0.419	383002.0
2021-08-13	AAWW-DELISTED	Stock	74.7	77.0	74.325	76.57	457615.0
2021-08-13	AAXJ	Stock	87.61	87.8	87.16	87.56	373593.0
2021-08-13	AB	Stock	50.0	50.74	49.99	50.66	241900.0
2021-08-13	ABB-DELISTED	Stock	37.54	37.875	37.515	37.82	1057161.0
2021-08-13	ABBNY-DELISTED	Stock	37.54	37.875	37.515	37.82	1148506.0
2021-08-13	ABBV	Stock	115.82	116.76	115.7	116.48	4416400.0
2021-08-13	ABC-DELISTED	Stock	119.75	120.22	118.28	119.56	649366.0
2021-08-13	ABCB	Stock	51.17	51.25	50.18	50.43	220300.0
2021-08-13	ABCL	Stock	15.0	18.95	15.0	17.89	9978200.0
2021-08-13	ABCM-DELISTED	Stock	20.38	20.72	20.37	20.53	13812.0
2021-08-13	ABEO	Stock	31.25	31.25	30.5	30.75	16072.0
2021-08-13	ABEV	Stock	3.1	3.14	3.06	3.12	14535600.0
2021-08-13	ABG	Stock	197.85	198.65	193.4	195.11	101800.0
2021-08-13	ABGI-DELISTED	Stock	9.66	9.7	9.63	9.7	1864.0
2021-08-13	ABM	Stock	47.26	47.8	46.9	47.53	313200.0
2021-08-13	ABMD-DELISTED	Stock	320.9	324.92	319.42	321.99	45556.0
2021-08-13	ABNB	Stock	146.66	152.76	144.51	152.76	16789100.0
2021-08-13	ABOS	Stock	15.1	15.45	14.9	15.17	87000.0

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

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