PREVIEW / stock_daily / 2020-06-09

all stock daily files

  file:    by_date/stock_daily/2020/2020-06-09.parquet
  size:    221 KB
  rows:    6,677
  symbols: 2,379

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-06-09	AAPL	Stock	83.035	86.4025	83.0025	85.9975	147712400.0
2020-06-09	MSFT	Stock	188.0	190.7	187.26	189.8	29783900.0
2020-06-09	NVDA	Stock	8.8	9.1098	8.7512	9.046	468488000.0
2020-06-09	AMZN	Stock	126.472	131.3215	126.25	130.043	103520000.0
2020-06-09	GOOGL	Stock	72.262	73.39	72.118	72.604	33623100.0
2020-06-09	META	Stock	231.52	239.77	230.41	238.67	27462900.0
2020-06-09	TSLA	Stock	62.6673	63.6293	61.5953	62.7113	170823000.0
2020-06-09	TLT	Stock	159.05	159.64	158.3	158.49	9095265.0
2020-06-09	ES	Stock	87.18	87.18	84.57	85.27	1407300.0
2020-06-09	CL	Stock	73.29	73.56	72.14	73.28	4608100.0
2020-06-09	A	Stock	90.09	90.51	89.32	89.77	1817300.0
2020-06-09	AA	Stock	12.38	12.69	12.07	12.59	7781500.0
2020-06-09	AACG	Stock	0.93	0.93	0.83	0.92	17100.0
2020-06-09	AAIC-DELISTED	Stock	3.46	3.59	3.3101	3.44	844331.0
2020-06-09	AAIC.C-DELISTED	Stock	20.18	20.813	19.82	20.67	8946.0
2020-06-09	AAL	Stock	18.45	18.97	17.61	18.55	111234400.0
2020-06-09	AAM.A-DELISTED	Stock	25.95	26.01	25.93	26.01	9226.0
2020-06-09	AAM.B-DELISTED	Stock	26.28	26.28	26.124	26.23	5895.0
2020-06-09	AAMC-DELISTED	Stock	5.2441	5.7357	5.2441	5.5853	27815.0
2020-06-09	AAME	Stock	1.86	1.91	1.81	1.9	3500.0
2020-06-09	AAMI	Stock	9.6	9.76	9.48	9.7	365400.0
2020-06-09	AAOI	Stock	10.07	10.148	9.52	9.695	689200.0
2020-06-09	AAON	Stock	38.12	38.7667	37.6133	38.1933	316800.0
2020-06-09	AAP	Stock	145.22	145.71	142.33	144.21	717100.0
2020-06-09	AAT	Stock	33.78	34.26	33.13	33.29	479500.0
2020-06-09	AAU-DELISTED	Stock	0.49	0.519	0.49	0.519	883020.0
2020-06-09	AAUAF-DELISTED	Stock	0.49	0.519	0.49	0.519	931462.0
2020-06-09	AAWW-DELISTED	Stock	40.07	41.67	39.4	41.31	817365.0
2020-06-09	AAXJ	Stock	69.06	69.74	68.99	69.61	1081955.0
2020-06-09	AAXN-DELISTED	Stock	96.75	104.76	96.1	100.29	1767504.0
2020-06-09	AB	Stock	26.5	27.09	25.84	26.57	461500.0
2020-06-09	ABB-DELISTED	Stock	21.6	21.85	21.55	21.72	1520427.0
2020-06-09	ABBNY-DELISTED	Stock	21.61	21.85	21.55	21.73	1617049.0
2020-06-09	ABBV	Stock	94.95	96.66	94.76	96.17	9555900.0
2020-06-09	ABC-DELISTED	Stock	101.0	101.6	99.55	99.9	657632.0
2020-06-09	ABCB	Stock	28.51	28.74	27.33	28.34	445600.0
2020-06-09	ABEO	Stock	74.0	75.5	72.25	72.5	31732.0
2020-06-09	ABEV	Stock	2.92	2.95	2.87	2.92	33461400.0
2020-06-09	ABG	Stock	81.07	82.86	79.72	81.52	200000.0
2020-06-09	ABM	Stock	36.2	36.28	34.91	35.56	346700.0
2020-06-09	ABMD-DELISTED	Stock	253.18	253.18	243.18	245.62	297238.0
2020-06-09	ABR	Stock	10.55	10.86	10.31	10.45	2500300.0
2020-06-09	ABR.A-DELISTED	Stock	25.3	25.45	24.5735	24.5735	1988.0
2020-06-09	ABR.B-DELISTED	Stock	24.1169	24.5	24.1169	24.48	2500.0
2020-06-09	ABR.C-DELISTED	Stock	25.64	25.746	25.6	25.6	2274.0
2020-06-09	ABT	Stock	92.32	92.82	90.24	90.27	4857400.0
2020-06-09	ABTC	Stock	323100.0	323700.0	303300.0	308400.0	6.133333333333333
2020-06-09	ABTS	Stock	12.735	20.25	10.83	18.0	64120.0
2020-06-09	ABTX-DELISTED	Stock	28.63	29.8	28.24	29.2	38250.0
2020-06-09	ABUS	Stock	2.05	2.1	1.9	1.91	1323900.0

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

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