PREVIEW / stock_daily / 2020-08-13

all stock daily files

  file:    by_date/stock_daily/2020/2020-08-13.parquet
  size:    224 KB
  rows:    6,769
  symbols: 2,393

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-08-13	AAPL	Stock	114.43	116.0425	113.9275	115.01	210082000.0
2020-08-13	MSFT	Stock	209.44	211.35	208.15	208.7	22588900.0
2020-08-13	NVDA	Stock	11.546	11.7218	11.3558	11.443	374460000.0
2020-08-13	AMZN	Stock	159.1495	160.876	157.75	158.051	62980000.0
2020-08-13	GOOGL	Stock	75.4105	76.8487	75.4105	75.8325	22394220.0
2020-08-13	META	Stock	261.55	265.16	259.57	261.3	17374000.0
2020-08-13	TSLA	Stock	107.4	110.0787	104.484	108.0667	306379500.0
2020-08-13	TLT	Stock	165.31	165.58	163.165	163.82	12744712.0
2020-08-13	ES	Stock	87.47	88.31	87.15	87.92	777900.0
2020-08-13	CL	Stock	76.98	77.19	76.52	76.98	2964900.0
2020-08-13	A	Stock	97.55	99.12	97.18	98.77	1190800.0
2020-08-13	AA	Stock	14.75	15.12	14.42	14.48	4135700.0
2020-08-13	AACG	Stock	1.07	1.22	1.07	1.1	33300.0
2020-08-13	AACQU-DELISTED	Stock	10.17	10.18	10.11	10.15	37081.0
2020-08-13	AAIC-DELISTED	Stock	2.8	2.865	2.79	2.82	149921.0
2020-08-13	AAIC.C-DELISTED	Stock	19.4	19.5	19.2	19.2	2804.0
2020-08-13	AAL	Stock	13.19	13.9	13.11	13.3	47772800.0
2020-08-13	AAM.A-DELISTED	Stock	27.15	27.15	26.84	26.84	6759.0
2020-08-13	AAM.B-DELISTED	Stock	27.47	27.4712	27.2991	27.44	13022.0
2020-08-13	AAMC-DELISTED	Stock	4.2647	4.2647	4.1666	4.1666	4437.0
2020-08-13	AAME	Stock	2.09	2.1	2.09	2.1	1300.0
2020-08-13	AAMI	Stock	13.86	14.0	13.655	13.72	483800.0
2020-08-13	AAOI	Stock	13.29	13.78	13.23	13.46	776700.0
2020-08-13	AAON	Stock	39.6333	39.8467	39.24	39.4333	205800.0
2020-08-13	AAP	Stock	154.47	156.87	153.8	155.99	686300.0
2020-08-13	AAT	Stock	27.46	28.14	27.31	27.34	164300.0
2020-08-13	AAU-DELISTED	Stock	0.71	0.73	0.6907	0.7251	453457.0
2020-08-13	AAUAF-DELISTED	Stock	0.71	0.7338	0.6907	0.7338	473742.0
2020-08-13	AAWW-DELISTED	Stock	60.45	61.1499	59.92	60.1	385741.0
2020-08-13	AAXJ	Stock	76.93	77.08	76.55	76.84	514026.0
2020-08-13	AAXN-DELISTED	Stock	79.95	82.315	79.88	80.55	236836.0
2020-08-13	AB	Stock	29.0	29.81	28.92	29.45	408200.0
2020-08-13	ABB-DELISTED	Stock	26.55	26.6609	26.405	26.44	893552.0
2020-08-13	ABBNY-DELISTED	Stock	26.55	26.6609	26.405	26.44	956613.0
2020-08-13	ABBV	Stock	95.14	95.5	94.01	94.68	6004200.0
2020-08-13	ABC-DELISTED	Stock	103.11	103.11	101.3522	102.76	381108.0
2020-08-13	ABCB	Stock	26.24	26.38	25.62	25.8	241300.0
2020-08-13	ABEO	Stock	73.25	73.5	70.5	70.75	19024.0
2020-08-13	ABEV	Stock	2.5	2.54	2.47	2.47	16287300.0
2020-08-13	ABG	Stock	110.03	112.54	108.24	108.31	235700.0
2020-08-13	ABM	Stock	38.45	39.08	38.08	38.41	233300.0
2020-08-13	ABMD-DELISTED	Stock	304.29	310.23	304.055	308.25	99015.0
2020-08-13	ABR	Stock	11.85	11.89	11.4	11.46	2025300.0
2020-08-13	ABR.A-DELISTED	Stock	25.19	25.39	25.12	25.2001	5065.0
2020-08-13	ABR.B-DELISTED	Stock	25.16	25.44	25.16	25.16	3098.0
2020-08-13	ABR.C-DELISTED	Stock	26.01	26.24	25.79	25.7928	6085.0
2020-08-13	ABT	Stock	100.34	101.27	100.0	101.1	2951700.0
2020-08-13	ABTC	Stock	180300.0	186300.0	174900.0	174900.0	1.1066666666666667
2020-08-13	ABTS	Stock	25.35	27.9	23.775	24.6	18027.0
2020-08-13	ABTX-DELISTED	Stock	26.77	26.8	26.3	26.46	26162.0

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

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