PREVIEW / stock_daily / 2020-07-08

all stock daily files

  file:    by_date/stock_daily/2020/2020-07-08.parquet
  size:    222 KB
  rows:    6,707
  symbols: 2,382

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-07-08	AAPL	Stock	94.18	95.375	94.09	95.3425	117092000.0
2020-07-08	MSFT	Stock	210.07	213.26	208.69	212.83	33600000.0
2020-07-08	NVDA	Stock	9.9938	10.225	9.9655	10.216	365480000.0
2020-07-08	AMZN	Stock	151.1305	154.1985	150.6215	154.0555	100752000.0
2020-07-08	GOOGL	Stock	75.04	75.5585	74.615	75.18	31765840.0
2020-07-08	META	Stock	238.11	246.99	236.59	243.58	29791300.0
2020-07-08	TSLA	Stock	93.6667	94.484	87.4227	91.0587	244669500.0
2020-07-08	TLT	Stock	164.32	164.92	163.83	164.55	7253883.0
2020-07-08	ES	Stock	84.09	85.45	83.6	85.14	1270900.0
2020-07-08	CL	Stock	74.06	74.57	73.74	74.49	3166900.0
2020-07-08	A	Stock	89.52	90.33	89.13	89.54	1069600.0
2020-07-08	AA	Stock	12.07	12.12	10.89	11.09	12284000.0
2020-07-08	AACG	Stock	1.37	1.49	1.35	1.48	57200.0
2020-07-08	AAIC-DELISTED	Stock	2.81	2.8801	2.79	2.83	361925.0
2020-07-08	AAIC.C-DELISTED	Stock	19.75	19.75	19.75	19.75	312.0
2020-07-08	AAL	Stock	11.6	12.08	11.43	11.99	85034500.0
2020-07-08	AAM.A-DELISTED	Stock	25.99	26.22	25.95	26.22	12609.0
2020-07-08	AAM.B-DELISTED	Stock	26.3	26.3	26.05	26.05	26395.0
2020-07-08	AAMC-DELISTED	Stock	5.0294	5.1765	5.0294	5.1647	9836.0
2020-07-08	AAME	Stock	1.62	1.69	1.62	1.65	2200.0
2020-07-08	AAMI	Stock	12.69	12.74	12.33	12.61	754300.0
2020-07-08	AAOI	Stock	11.18	11.64	11.02	11.29	466900.0
2020-07-08	AAON	Stock	36.8067	36.9733	35.5	36.18	394350.0
2020-07-08	AAP	Stock	136.29	136.96	132.93	136.45	1361200.0
2020-07-08	AAT	Stock	26.34	26.54	25.37	26.01	207200.0
2020-07-08	AAU-DELISTED	Stock	0.5117	0.52	0.501	0.5191	373308.0
2020-07-08	AAUAF-DELISTED	Stock	0.5117	0.52	0.501	0.5191	386277.0
2020-07-08	AAWW-DELISTED	Stock	45.92	46.25	45.25	45.97	271745.0
2020-07-08	AAXJ	Stock	74.67	75.77	74.64	75.76	1539373.0
2020-07-08	AAXN-DELISTED	Stock	96.83	99.0	96.06	96.93	527407.0
2020-07-08	AB	Stock	26.75	27.33	26.59	27.3	150800.0
2020-07-08	ABB-DELISTED	Stock	24.28	24.63	24.275	24.61	1918297.0
2020-07-08	ABBNY-DELISTED	Stock	24.28	24.63	24.275	24.61	2021824.0
2020-07-08	ABBV	Stock	99.75	100.57	98.55	99.28	6154400.0
2020-07-08	ABC-DELISTED	Stock	98.35	98.76	95.9	97.21	690684.0
2020-07-08	ABCB	Stock	21.8	22.08	21.05	21.49	496200.0
2020-07-08	ABEO	Stock	88.0	94.5	82.75	85.5	91700.0
2020-07-08	ABEV	Stock	2.75	2.81	2.7	2.81	33395800.0
2020-07-08	ABG	Stock	86.54	92.06	85.81	92.01	437700.0
2020-07-08	ABM	Stock	33.81	33.89	32.54	32.99	392900.0
2020-07-08	ABMD-DELISTED	Stock	265.37	268.1953	262.8009	265.86	174376.0
2020-07-08	ABR	Stock	8.1	8.34	7.79	8.09	2766200.0
2020-07-08	ABR.A-DELISTED	Stock	24.798	24.798	24.798	24.798	100.0
2020-07-08	ABR.B-DELISTED	Stock	23.81	23.81	23.7	23.7	2350.0
2020-07-08	ABR.C-DELISTED	Stock	24.9998	25.12	24.85	24.85	3435.0
2020-07-08	ABT	Stock	92.84	93.67	91.5	92.58	3815300.0
2020-07-08	ABTC	Stock	227700.0	239100.0	219300.0	222900.0	3.6666666666666665
2020-07-08	ABTS	Stock	13.5	15.45	12.9	15.15	11987.0
2020-07-08	ABTX-DELISTED	Stock	23.08	23.2045	22.25	22.71	50378.0
2020-07-08	ABUS	Stock	1.88	1.91	1.81	1.88	578700.0

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

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