PREVIEW / stock_daily / 2021-05-13

all stock daily files

  file:    by_date/stock_daily/2021/2021-05-13.parquet
  size:    257 KB
  rows:    7,843
  symbols: 2,959

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-05-13	AAPL	Stock	124.58	126.15	124.26	124.97	105861300.0
2021-05-13	MSFT	Stock	241.8	245.6	241.42	243.03	29624300.0
2021-05-13	NVDA	Stock	14.0338	14.0808	13.459	13.6652	285404000.0
2021-05-13	AMZN	Stock	159.2735	160.192	156.65	158.0735	67018000.0
2021-05-13	GOOGL	Stock	111.306	111.9719	110.336	111.452	33220400.0
2021-05-13	META	Stock	306.08	308.86	302.77	305.26	18079200.0
2021-05-13	TSLA	Stock	200.5133	202.1533	186.55	190.5633	132554700.0
2021-05-13	TLT	Stock	135.93	136.37	135.63	135.81	13074735.0
2021-05-13	ES	Stock	82.99	85.29	82.83	84.71	1643100.0
2021-05-13	CL	Stock	81.76	83.76	81.45	83.26	4300200.0
2021-05-13	A	Stock	129.61	130.76	129.26	130.02	805900.0
2021-05-13	AA	Stock	39.146	40.97	38.19	39.13	6493500.0
2021-05-13	AAC-DELISTED	Stock	9.82	9.89	9.79	9.79	374652.0
2021-05-13	AACG	Stock	2.72	2.75	2.56	2.61	41600.0
2021-05-13	AACQ-DELISTED	Stock	9.88	9.89	9.83	9.865	1970061.0
2021-05-13	AACQU-DELISTED	Stock	10.3	10.385	10.27	10.28	49338.0
2021-05-13	AACQW-DELISTED	Stock	1.6401	1.78	1.43	1.48	214364.0
2021-05-13	AAIC-DELISTED	Stock	3.91	4.0	3.91	3.98	193737.0
2021-05-13	AAIC.C-DELISTED	Stock	24.3	24.33	24.21	24.21	2773.0
2021-05-13	AAL	Stock	20.88	21.42	20.62	21.21	35238700.0
2021-05-13	AAM.A-DELISTED	Stock	26.13	26.25	26.1	26.25	16223.0
2021-05-13	AAM.B-DELISTED	Stock	26.99	27.01	26.8417	27.01	4818.0
2021-05-13	AAMC-DELISTED	Stock	4.8471	4.8706	4.6471	4.6643	27985.0
2021-05-13	AAME	Stock	4.24	4.34	4.01	4.15	124200.0
2021-05-13	AAMI	Stock	22.14	22.63	22.1	22.48	354800.0
2021-05-13	AAN-DELISTED	Stock	29.65	31.475	29.59	31.27	373800.0
2021-05-13	AAOI	Stock	7.08	7.47	7.041	7.17	717800.0
2021-05-13	AAON	Stock	43.1333	44.56	42.96	44.3	259350.0
2021-05-13	AAP	Stock	201.27	205.01	199.63	204.5	479300.0
2021-05-13	AAQC-DELISTED	Stock	9.71	9.71	9.69	9.69	16181.0
2021-05-13	AAT	Stock	33.72	34.74	33.64	34.54	237100.0
2021-05-13	AAU-DELISTED	Stock	0.5121	0.5209	0.5003	0.503	810981.0
2021-05-13	AAUAF-DELISTED	Stock	0.5121	0.5209	0.5003	0.508	831245.0
2021-05-13	AAWW-DELISTED	Stock	70.91	73.59	70.47	73.09	239373.0
2021-05-13	AAXJ	Stock	89.65	90.035	88.82	89.29	2134443.0
2021-05-13	AB	Stock	41.7	43.31	41.6	43.11	387700.0
2021-05-13	ABB-DELISTED	Stock	32.74	33.37	32.73	33.26	1171452.0
2021-05-13	ABBNY-DELISTED	Stock	32.74	33.37	32.73	33.26	1273038.0
2021-05-13	ABBV	Stock	115.55	117.2	115.01	116.6	6558200.0
2021-05-13	ABC-DELISTED	Stock	120.24	120.88	119.14	119.43	846500.0
2021-05-13	ABCB	Stock	53.8	56.62	53.35	56.13	393700.0
2021-05-13	ABCL	Stock	29.67	35.0	29.67	34.14	1798000.0
2021-05-13	ABCM-DELISTED	Stock	19.99	20.18	19.88	20.04	212674.0
2021-05-13	ABEO	Stock	35.5	36.0	31.75	32.25	70960.0
2021-05-13	ABEV	Stock	3.23	3.29	3.18	3.22	20007100.0
2021-05-13	ABG	Stock	197.44	201.43	194.23	199.84	139800.0
2021-05-13	ABGI-DELISTED	Stock	9.83	9.9	9.8129	9.9	800.0
2021-05-13	ABM	Stock	50.68	52.86	50.68	52.56	253200.0
2021-05-13	ABMD-DELISTED	Stock	274.75	274.75	262.59	262.6	395058.0
2021-05-13	ABNB	Stock	142.25	142.329	131.28	135.75	13005400.0

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

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