PREVIEW / stock_daily / 2020-09-15

all stock daily files

  file:    by_date/stock_daily/2020/2020-09-15.parquet
  size:    227 KB
  rows:    6,870
  symbols: 2,456

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
2020-09-15	AAPL	Stock	118.33	118.83	113.61	115.54	184642000.0
2020-09-15	MSFT	Stock	208.42	209.78	206.93	208.78	21823900.0
2020-09-15	NVDA	Stock	13.28	13.2988	12.8278	12.991	727556000.0
2020-09-15	AMZN	Stock	156.808	158.751	155.446	157.8065	80430000.0
2020-09-15	GOOGL	Stock	76.3945	77.5495	76.105	76.756	23041100.0
2020-09-15	META	Stock	270.67	274.52	269.3	272.42	18478500.0
2020-09-15	TSLA	Stock	145.52	153.98	143.5667	149.92	291894600.0
2020-09-15	TLT	Stock	164.17	164.47	163.79	164.07	6928498.0
2020-09-15	ES	Stock	83.23	85.16	83.23	83.97	1433500.0
2020-09-15	CL	Stock	77.22	77.72	76.92	76.94	2093300.0
2020-09-15	A	Stock	99.72	101.0	99.72	100.37	1053800.0
2020-09-15	AA	Stock	14.2	14.39	13.78	13.78	5345900.0
2020-09-15	AACG	Stock	1.11	1.11	1.07	1.1	13700.0
2020-09-15	AACQ-DELISTED	Stock	9.985	10.0	9.905	10.0	68934.0
2020-09-15	AACQU-DELISTED	Stock	10.4467	10.49	10.41	10.43	47227.0
2020-09-15	AACQW-DELISTED	Stock	1.67	1.8	1.65	1.6614	775353.0
2020-09-15	AAIC-DELISTED	Stock	2.71	2.7301	2.7	2.7	171615.0
2020-09-15	AAIC.C-DELISTED	Stock	19.0	19.0	18.75	18.75	4673.0
2020-09-15	AAL	Stock	13.27	13.66	13.08	13.14	38958800.0
2020-09-15	AAM.A-DELISTED	Stock	26.62	26.62	26.3239	26.4902	11193.0
2020-09-15	AAM.B-DELISTED	Stock	27.25	27.3	27.03	27.3	14566.0
2020-09-15	AAMC-DELISTED	Stock	6.3294	6.8206	6.3221	6.6559	34289.0
2020-09-15	AAME	Stock	2.04	2.07	1.9	2.01	4100.0
2020-09-15	AAMI	Stock	13.48	13.48	13.14	13.2	546800.0
2020-09-15	AAOI	Stock	10.37	10.71	10.313	10.41	462100.0
2020-09-15	AAON	Stock	37.98	38.5667	37.9467	38.2667	235350.0
2020-09-15	AAP	Stock	157.91	158.41	156.51	156.88	496800.0
2020-09-15	AAT	Stock	25.55	26.14	25.55	25.65	330100.0
2020-09-15	AAU-DELISTED	Stock	0.89	0.94	0.87	0.8876	1500646.0
2020-09-15	AAUAF-DELISTED	Stock	0.89	0.94	0.87	0.8891	1552669.0
2020-09-15	AAWW-DELISTED	Stock	58.12	61.5	58.12	59.5	511007.0
2020-09-15	AAXJ	Stock	78.6	78.75	78.45	78.56	800075.0
2020-09-15	AAXN-DELISTED	Stock	84.58	84.58	83.05	84.51	287733.0
2020-09-15	AB	Stock	27.36	27.64	27.17	27.55	262400.0
2020-09-15	ABB-DELISTED	Stock	26.39	26.43	26.115	26.17	1539240.0
2020-09-15	ABBNY-DELISTED	Stock	26.39	26.43	26.115	26.17	1614860.0
2020-09-15	ABBV	Stock	91.4	91.98	90.64	90.91	3851300.0
2020-09-15	ABC-DELISTED	Stock	94.32	96.08	94.31	94.91	708915.0
2020-09-15	ABCB	Stock	24.03	24.24	23.36	23.39	229200.0
2020-09-15	ABEO	Stock	49.5	53.0	49.25	50.25	28464.0
2020-09-15	ABEV	Stock	2.39	2.47	2.38	2.44	21320400.0
2020-09-15	ABG	Stock	109.01	109.01	105.56	106.71	104000.0
2020-09-15	ABM	Stock	36.7	37.1	36.46	37.06	277900.0
2020-09-15	ABMD-DELISTED	Stock	277.92	283.5	276.33	278.73	116866.0
2020-09-15	ABR	Stock	11.89	12.08	11.78	11.8	1135300.0
2020-09-15	ABR.A-DELISTED	Stock	25.26	25.47	25.26	25.3499	2383.0
2020-09-15	ABR.B-DELISTED	Stock	25.225	25.2452	25.09	25.2452	928.0
2020-09-15	ABR.C-DELISTED	Stock	25.454	25.5	25.454	25.5	667.0
2020-09-15	ABT	Stock	107.0	107.53	106.17	106.58	3654900.0
2020-09-15	ABTC	Stock	136500.0	138900.0	131100.0	132300.0	2.0

> showing 50 of 6,870 rows — these rows as CSV

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