PREVIEW / stock_daily / 2020-04-15

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-15.parquet
  size:    214 KB
  rows:    6,564
  symbols: 2,331

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-04-15	AAPL	Stock	70.6	71.5825	70.1575	71.1075	131154400.0
2020-04-15	MSFT	Stock	171.2	173.57	169.24	171.88	40940800.0
2020-04-15	NVDA	Stock	6.93	7.1042	6.8845	7.021	366148000.0
2020-04-15	AMZN	Stock	112.884	116.6685	112.25	115.384	137332000.0
2020-04-15	GOOGL	Stock	62.3255	63.7555	61.7	62.865	42236840.0
2020-04-15	META	Stock	175.19	178.19	172.82	176.97	17423000.0
2020-04-15	TSLA	Stock	49.4667	50.2087	47.3333	48.6553	353655000.0
2020-04-15	TLT	Stock	166.8	168.6	166.74	168.18	10027752.0
2020-04-15	ES	Stock	89.81	90.84	87.42	88.92	1767100.0
2020-04-15	CL	Stock	72.2	72.94	71.69	72.65	3390500.0
2020-04-15	A	Stock	77.44	78.39	77.0	77.05	2721100.0
2020-04-15	AA	Stock	7.23	7.42	7.01	7.26	8642600.0
2020-04-15	AACG	Stock	0.82	0.86	0.82	0.86	2700.0
2020-04-15	AAIC-DELISTED	Stock	2.83	2.8551	2.67	2.77	334285.0
2020-04-15	AAIC.C-DELISTED	Stock	16.69	17.0	15.98	17.0	3599.0
2020-04-15	AAL	Stock	12.52	12.69	11.39	12.29	124719900.0
2020-04-15	AAM.A-DELISTED	Stock	24.5	24.8351	24.12	24.78	45501.0
2020-04-15	AAM.B-DELISTED	Stock	24.503	25.0	24.5	24.93	29245.0
2020-04-15	AAMC-DELISTED	Stock	4.1029	4.1029	3.8158	3.8158	5120.0
2020-04-15	AAME	Stock	2.0	2.0	1.86	1.94	2600.0
2020-04-15	AAMI	Stock	5.84	5.87	5.46	5.48	388400.0
2020-04-15	AAOI	Stock	8.0	8.86	7.82	8.72	726900.0
2020-04-15	AAON	Stock	31.0	31.76	30.4733	31.08	304650.0
2020-04-15	AAP	Stock	110.95	112.95	108.89	111.99	835100.0
2020-04-15	AAT	Stock	28.19	29.26	26.75	26.85	403000.0
2020-04-15	AAU-DELISTED	Stock	0.3651	0.375	0.339	0.35	415196.0
2020-04-15	AAUAF-DELISTED	Stock	0.3651	0.375	0.339	0.35	437227.0
2020-04-15	AAWW-DELISTED	Stock	24.47	24.8091	23.11	23.86	428004.0
2020-04-15	AAXJ	Stock	61.88	62.06	61.48	61.75	1245959.0
2020-04-15	AAXN-DELISTED	Stock	73.89	75.49	72.34	74.151	339833.0
2020-04-15	AB	Stock	20.11	20.45	19.73	19.97	430600.0
2020-04-15	ABB-DELISTED	Stock	17.49	17.51	17.21	17.3	1914924.0
2020-04-15	ABBNY-DELISTED	Stock	17.49	17.51	17.21	17.3	2072209.0
2020-04-15	ABBV	Stock	80.51	83.04	79.62	81.82	8977300.0
2020-04-15	ABC-DELISTED	Stock	87.94	89.71	85.59	88.38	764218.0
2020-04-15	ABCB	Stock	23.0	23.19	21.72	21.87	414400.0
2020-04-15	ABEO	Stock	61.75	64.5	58.75	62.5	28352.0
2020-04-15	ABEV	Stock	2.31	2.33	2.24	2.29	24166000.0
2020-04-15	ABG	Stock	57.56	60.13	52.98	53.2	242500.0
2020-04-15	ABM	Stock	29.8	31.31	29.58	30.55	933800.0
2020-04-15	ABMD-DELISTED	Stock	159.07	162.82	156.67	159.73	198633.0
2020-04-15	ABR	Stock	6.5	6.74	6.15	6.29	2204200.0
2020-04-15	ABR.A-DELISTED	Stock	21.0085	21.0085	19.604	20.15	4480.0
2020-04-15	ABR.B-DELISTED	Stock	21.2	21.2	19.2	19.25	5344.0
2020-04-15	ABR.C-DELISTED	Stock	20.25	20.25	19.26	20.25	8539.0
2020-04-15	ABT	Stock	90.01	91.9	88.51	90.94	14128000.0
2020-04-15	ABTC	Stock	240000.0	245700.0	227100.0	232800.0	3.2800000000000002
2020-04-15	ABTS	Stock	14.55	14.775	13.5	13.5	940.0
2020-04-15	ABTX-DELISTED	Stock	23.58	25.0	22.59	22.7	54856.0
2020-04-15	ABUS	Stock	1.06	1.25	1.01	1.19	1508200.0

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

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