PREVIEW / stock_daily / 2020-10-08

all stock daily files

  file:    by_date/stock_daily/2020/2020-10-08.parquet
  size:    228 KB
  rows:    6,953
  symbols: 2,480

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-10-08	AAPL	Stock	116.25	116.4	114.59	114.97	83477200.0
2020-10-08	MSFT	Stock	210.51	211.19	208.32	210.58	19925800.0
2020-10-08	NVDA	Stock	14.075	14.0845	13.758	13.8388	378900000.0
2020-10-08	AMZN	Stock	161.2495	161.6645	158.7495	159.5275	63482000.0
2020-10-08	GOOGL	Stock	73.2725	74.4014	73.2725	74.1715	26076040.0
2020-10-08	META	Stock	259.75	264.62	259.15	263.76	16312800.0
2020-10-08	TSLA	Stock	146.1467	146.3333	141.7667	141.9733	121263300.0
2020-10-08	TLT	Stock	159.97	160.25	159.655	160.12	8431544.0
2020-10-08	ES	Stock	91.54	92.95	91.24	92.43	1161300.0
2020-10-08	CL	Stock	78.23	78.84	78.08	78.74	2144500.0
2020-10-08	A	Stock	104.2	104.39	103.13	104.16	765300.0
2020-10-08	AA	Stock	12.45	12.74	12.38	12.73	4872900.0
2020-10-08	AACG	Stock	1.09	1.09	1.07	1.09	5600.0
2020-10-08	AACQ-DELISTED	Stock	9.8499	9.8499	9.77	9.785	118118.0
2020-10-08	AACQU-DELISTED	Stock	10.2	10.39	10.14	10.14	52463.0
2020-10-08	AACQW-DELISTED	Stock	1.5	1.5	1.39	1.4	123987.0
2020-10-08	AAIC-DELISTED	Stock	2.86	2.98	2.86	2.95	207583.0
2020-10-08	AAIC.C-DELISTED	Stock	18.75	18.99	18.75	18.99	6021.0
2020-10-08	AAL	Stock	13.33	13.68	12.73	13.16	88851700.0
2020-10-08	AAM.A-DELISTED	Stock	26.35	26.385	26.29	26.31	13664.0
2020-10-08	AAM.B-DELISTED	Stock	27.35	27.477	27.32	27.35	11171.0
2020-10-08	AAMC-DELISTED	Stock	6.0441	6.0441	5.7294	6.0	4417.0
2020-10-08	AAME	Stock	2.0	2.0	2.0	2.0	300.0
2020-10-08	AAMI	Stock	14.19	14.92	14.19	14.65	730300.0
2020-10-08	AAOI	Stock	11.51	11.85	11.3	11.59	361200.0
2020-10-08	AAON	Stock	42.1733	42.3267	41.4133	41.8467	189750.0
2020-10-08	AAP	Stock	157.8	158.5	155.12	157.66	404400.0
2020-10-08	AAT	Stock	24.92	25.8	24.87	25.78	190700.0
2020-10-08	AAU-DELISTED	Stock	0.77	0.795	0.75	0.777	458604.0
2020-10-08	AAUAF-DELISTED	Stock	0.77	0.795	0.75	0.777	467826.0
2020-10-08	AAWW-DELISTED	Stock	67.01	67.63	66.415	67.43	418697.0
2020-10-08	AAXJ	Stock	79.5241	79.77	79.33	79.65	1067116.0
2020-10-08	AAXN-DELISTED	Stock	96.85	97.38	95.54	97.07	288943.0
2020-10-08	AB	Stock	28.7	29.84	28.5	29.74	981300.0
2020-10-08	ABB-DELISTED	Stock	26.53	26.57	26.4	26.54	833902.0
2020-10-08	ABBNY-DELISTED	Stock	26.53	26.57	26.4	26.54	914019.0
2020-10-08	ABBV	Stock	87.27	88.58	86.92	87.34	5535100.0
2020-10-08	ABC-DELISTED	Stock	96.1	98.98	95.82	98.48	776204.0
2020-10-08	ABCB	Stock	25.97	26.63	25.43	26.43	263400.0
2020-10-08	ABEO	Stock	31.5	35.0	30.75	34.5	121496.0
2020-10-08	ABEV	Stock	2.42	2.49	2.4	2.46	19573500.0
2020-10-08	ABG	Stock	115.42	116.09	113.11	115.15	132800.0
2020-10-08	ABM	Stock	37.59	37.9	37.14	37.48	316000.0
2020-10-08	ABMD-DELISTED	Stock	271.0	272.93	267.13	270.98	134112.0
2020-10-08	ABR	Stock	11.74	11.93	11.69	11.89	1232000.0
2020-10-08	ABR.A-DELISTED	Stock	25.4	25.4399	25.35	25.37	1899.0
2020-10-08	ABR.B-DELISTED	Stock	25.1	25.19	25.1	25.19	600.0
2020-10-08	ABR.C-DELISTED	Stock	25.53	25.8509	25.53	25.8509	6250.0
2020-10-08	ABT	Stock	108.14	109.13	107.42	108.54	4168400.0
2020-10-08	ABTC	Stock	122100.0	126300.0	119700.0	119850.0	8.4

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

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