PREVIEW / stock_daily / 2020-05-08

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-08.parquet
  size:    217 KB
  rows:    6,606
  symbols: 2,347

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-05-08	AAPL	Stock	76.41	77.5875	76.0725	77.5325	133838400.0
2020-05-08	MSFT	Stock	184.98	185.0	183.36	184.68	30877800.0
2020-05-08	NVDA	Stock	7.6938	7.8188	7.6598	7.8125	339216000.0
2020-05-08	AMZN	Stock	118.607	119.362	117.85	118.9805	64132000.0
2020-05-08	GOOGL	Stock	69.091	69.832	68.6005	69.217	33329740.0
2020-05-08	META	Stock	212.24	213.21	210.85	212.35	12506000.0
2020-05-08	TSLA	Stock	52.918	54.9333	52.4673	54.628	241297500.0
2020-05-08	TLT	Stock	164.49	165.4	163.68	163.98	8130474.0
2020-05-08	ES	Stock	77.64	79.0	77.12	77.79	1430000.0
2020-05-08	CL	Stock	69.75	69.82	68.78	69.37	3938600.0
2020-05-08	A	Stock	79.67	80.33	79.19	79.71	2255000.0
2020-05-08	AA	Stock	7.64	8.08	7.48	8.07	11306400.0
2020-05-08	AACG	Stock	0.8	0.8	0.74	0.75	12700.0
2020-05-08	AAIC-DELISTED	Stock	2.65	2.72	2.61	2.65	206421.0
2020-05-08	AAIC.C-DELISTED	Stock	17.1	17.2995	17.1	17.29	1900.0
2020-05-08	AAL	Stock	9.78	10.15	9.68	10.14	59186200.0
2020-05-08	AAM.A-DELISTED	Stock	26.0926	26.0926	25.78	25.9293	10075.0
2020-05-08	AAM.B-DELISTED	Stock	25.97	25.97	25.768	25.93	16923.0
2020-05-08	AAMC-DELISTED	Stock	4.3471	4.5368	4.1912	4.5368	8347.0
2020-05-08	AAME	Stock	1.72	1.79	1.72	1.79	1500.0
2020-05-08	AAMI	Stock	8.53	8.57	7.945	8.41	929500.0
2020-05-08	AAOI	Stock	10.79	11.04	10.11	10.19	2428700.0
2020-05-08	AAON	Stock	32.7133	33.5733	32.06	32.6267	506100.0
2020-05-08	AAP	Stock	121.9	125.71	121.13	124.85	911500.0
2020-05-08	AAT	Stock	27.38	27.84	27.15	27.82	254900.0
2020-05-08	AAU-DELISTED	Stock	0.435	0.444	0.41	0.412	301790.0
2020-05-08	AAUAF-DELISTED	Stock	0.435	0.444	0.41	0.4397	314023.0
2020-05-08	AAWW-DELISTED	Stock	38.34	38.99	37.3	38.68	663335.0
2020-05-08	AAXJ	Stock	64.11	64.69	63.99	64.55	1133933.0
2020-05-08	AAXN-DELISTED	Stock	77.29	86.48	76.5314	86.13	2969860.0
2020-05-08	AB	Stock	22.55	22.8	22.29	22.8	203100.0
2020-05-08	ABB-DELISTED	Stock	18.17	18.365	18.105	18.34	1312100.0
2020-05-08	ABBNY-DELISTED	Stock	18.17	18.365	18.105	18.33	1519909.0
2020-05-08	ABBV	Stock	84.42	84.66	82.45	83.96	20188100.0
2020-05-08	ABC-DELISTED	Stock	90.54	92.4	87.09	88.12	897217.0
2020-05-08	ABCB	Stock	22.54	23.46	21.9	23.45	531800.0
2020-05-08	ABEO	Stock	58.75	69.25	57.5	67.25	99412.0
2020-05-08	ABEV	Stock	2.09	2.15	2.08	2.15	18685300.0
2020-05-08	ABG	Stock	68.52	69.61	67.6	69.52	226700.0
2020-05-08	ABM	Stock	32.3	33.57	32.03	33.5	381000.0
2020-05-08	ABMD-DELISTED	Stock	188.14	190.28	185.7553	187.11	261485.0
2020-05-08	ABR	Stock	7.45	7.73	6.97	7.51	4355800.0
2020-05-08	ABR.A-DELISTED	Stock	23.5	24.0	23.03	23.38	8054.0
2020-05-08	ABR.B-DELISTED	Stock	21.825	23.3538	21.825	23.0	7484.0
2020-05-08	ABR.C-DELISTED	Stock	24.0	24.94	23.855	24.59	14241.0
2020-05-08	ABT	Stock	94.84	94.94	92.9	93.7	6167600.0
2020-05-08	ABTC	Stock	239400.0	249900.0	234000.0	236100.0	3.893333333333333
2020-05-08	ABTS	Stock	13.395	13.395	12.0	12.6	627.0
2020-05-08	ABTX-DELISTED	Stock	23.5	24.22	23.5	24.13	70073.0
2020-05-08	ABUS	Stock	1.44	1.45	1.31	1.35	665600.0

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

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