PREVIEW / stock_daily / 2020-05-20

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-20.parquet
  size:    217 KB
  rows:    6,608
  symbols: 2,339

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-20	AAPL	Stock	79.17	79.88	79.13	79.8075	111504800.0
2020-05-20	MSFT	Stock	184.81	185.85	183.94	185.66	31261300.0
2020-05-20	NVDA	Stock	8.991	9.043	8.8888	8.97	587536000.0
2020-05-20	AMZN	Stock	123.8935	125.0005	123.3635	124.897	79962000.0
2020-05-20	GOOGL	Stock	69.458	70.6013	69.371	70.458	38262660.0
2020-05-20	META	Stock	223.5	231.34	223.19	229.97	50162900.0
2020-05-20	TSLA	Stock	54.7	55.0667	54.12	54.3707	109639500.0
2020-05-20	TLT	Stock	163.17	164.7	162.88	164.15	10927274.0
2020-05-20	ES	Stock	78.91	80.17	78.31	79.4	1360700.0
2020-05-20	CL	Stock	69.67	70.59	69.46	70.47	3406100.0
2020-05-20	A	Stock	82.98	82.98	81.47	81.71	2748100.0
2020-05-20	AA	Stock	8.06	8.44	8.055	8.35	10545700.0
2020-05-20	AACG	Stock	0.72	0.84	0.72	0.79	26000.0
2020-05-20	AAIC-DELISTED	Stock	2.47	2.5	2.405	2.44	280561.0
2020-05-20	AAIC.C-DELISTED	Stock	15.9249	16.62	15.61	16.55	14285.0
2020-05-20	AAL	Stock	9.91	10.14	9.77	9.87	44006700.0
2020-05-20	AAM.A-DELISTED	Stock	25.9005	26.0966	25.86	26.04	6109.0
2020-05-20	AAM.B-DELISTED	Stock	25.7	26.09	25.7	26.09	35226.0
2020-05-20	AAMC-DELISTED	Stock	5.0118	5.1471	4.5647	5.1441	11815.0
2020-05-20	AAME	Stock	1.81	1.9	1.75	1.9	3000.0
2020-05-20	AAMI	Stock	8.46	8.55	8.31	8.4	261900.0
2020-05-20	AAOI	Stock	8.59	8.86	8.5	8.61	485100.0
2020-05-20	AAON	Stock	33.78	34.4533	33.28	33.5533	274650.0
2020-05-20	AAP	Stock	138.23	140.16	135.04	135.72	1216300.0
2020-05-20	AAT	Stock	25.78	26.0	25.08	25.81	389100.0
2020-05-20	AAU-DELISTED	Stock	0.47	0.4775	0.426	0.4611	431716.0
2020-05-20	AAUAF-DELISTED	Stock	0.47	0.4775	0.426	0.4611	458900.0
2020-05-20	AAWW-DELISTED	Stock	39.65	40.35	39.37	39.87	306000.0
2020-05-20	AAXJ	Stock	65.84	66.07	65.25	65.61	1158972.0
2020-05-20	AAXN-DELISTED	Stock	76.86	77.3738	75.66	76.14	311603.0
2020-05-20	AB	Stock	23.27	24.15	23.27	23.69	313100.0
2020-05-20	ABB-DELISTED	Stock	19.06	19.15	18.875	18.94	1461931.0
2020-05-20	ABBNY-DELISTED	Stock	19.06	19.15	18.875	18.94	1581203.0
2020-05-20	ABBV	Stock	92.13	92.54	89.9	91.19	10661500.0
2020-05-20	ABC-DELISTED	Stock	90.0	95.13	89.02	92.68	1829580.0
2020-05-20	ABCB	Stock	20.91	21.7	20.66	21.63	371800.0
2020-05-20	ABEO	Stock	78.25	82.5	77.25	80.0	29140.0
2020-05-20	ABEV	Stock	2.12	2.18	2.09	2.17	30071600.0
2020-05-20	ABG	Stock	70.65	72.1	70.13	70.71	234800.0
2020-05-20	ABM	Stock	32.52	33.03	32.15	32.68	258900.0
2020-05-20	ABMD-DELISTED	Stock	192.62	196.74	192.24	196.35	192085.0
2020-05-20	ABR	Stock	7.43	7.68	7.41	7.61	2058500.0
2020-05-20	ABR.A-DELISTED	Stock	23.99	24.335	23.8181	23.8181	1000.0
2020-05-20	ABR.B-DELISTED	Stock	23.2704	23.2704	22.7385	23.0	1593.0
2020-05-20	ABR.C-DELISTED	Stock	25.5	25.5	24.775	24.775	4038.0
2020-05-20	ABT	Stock	89.58	90.42	88.03	90.09	7488800.0
2020-05-20	ABTC	Stock	240000.0	246000.0	235830.0	242100.0	1.04
2020-05-20	ABTS	Stock	9.15	10.95	9.15	9.84	3273.0
2020-05-20	ABTX-DELISTED	Stock	23.76	25.01	23.76	24.9	57283.0
2020-05-20	ABUS	Stock	2.34	2.36	2.19	2.36	2782100.0

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

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