PREVIEW / stock_daily / 2020-03-13

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-13.parquet
  size:    217 KB
  rows:    6,675
  symbols: 2,417

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-03-13	AAPL	Stock	66.2225	69.98	63.2375	69.4925	370732000.0
2020-03-13	MSFT	Stock	147.5	161.91	140.73	158.83	92727400.0
2020-03-13	NVDA	Stock	5.7625	6.0255	5.4903	6.021	634836000.0
2020-03-13	AMZN	Stock	87.75	89.3155	84.031	89.25	176194000.0
2020-03-13	GOOGL	Stock	58.7495	60.72	55.6145	60.7135	79399460.0
2020-03-13	META	Stock	163.53	170.79	157.6	170.28	35028600.0
2020-03-13	TSLA	Stock	39.6667	40.5047	33.4667	36.4413	339604500.0
2020-03-13	TLT	Stock	155.0	158.2	152.19	153.94	19812859.0
2020-03-13	ES	Stock	85.89	88.69	81.43	88.53	4368900.0
2020-03-13	CL	Stock	66.43	69.21	64.2	69.1	11952900.0
2020-03-13	A	Stock	66.53	69.51	63.75	69.2	3261200.0
2020-03-13	AA	Stock	8.08	8.35	7.16	8.0	7316200.0
2020-03-13	AACG	Stock	0.9	0.97	0.86	0.86	16400.0
2020-03-13	AAIC-DELISTED	Stock	3.55	3.67	3.16	3.34	670205.0
2020-03-13	AAIC.C-DELISTED	Stock	17.4032	17.4032	16.3502	16.89	3330.0
2020-03-13	AAL	Stock	15.3	15.6	13.12	14.31	58376100.0
2020-03-13	AAM.A-DELISTED	Stock	22.75	23.77	22.69	23.76	59285.0
2020-03-13	AAM.B-DELISTED	Stock	24.0	24.0	23.005	23.95	59010.0
2020-03-13	AAMC-DELISTED	Stock	4.9147	4.9147	4.5235	4.6853	6106.0
2020-03-13	AAME	Stock	2.6	2.6	2.4	2.5	1600.0
2020-03-13	AAMI	Stock	6.27	7.01	6.27	7.01	901300.0
2020-03-13	AAOI	Stock	6.2	6.23	5.61	6.11	990700.0
2020-03-13	AAON	Stock	29.1867	35.16	27.9933	34.7333	887850.0
2020-03-13	AAP	Stock	114.08	115.31	105.15	113.69	1251600.0
2020-03-13	AAT	Stock	32.02	34.09	29.96	33.67	672600.0
2020-03-13	AAU-DELISTED	Stock	0.289	0.289	0.26	0.2801	550148.0
2020-03-13	AAUAF-DELISTED	Stock	0.289	0.289	0.26	0.2801	595509.0
2020-03-13	AAWW-DELISTED	Stock	17.65	18.17	14.97	17.775	1283135.0
2020-03-13	AAXJ	Stock	63.31	63.67	59.92	62.52	2631298.0
2020-03-13	AAXN-DELISTED	Stock	60.33	62.79	54.696	62.37	818484.0
2020-03-13	AB	Stock	23.97	24.5	21.02	24.16	1215700.0
2020-03-13	ABB-DELISTED	Stock	17.67	17.6701	16.41	17.62	2914096.0
2020-03-13	ABBNY-DELISTED	Stock	17.67	17.6701	16.41	17.62	3183940.0
2020-03-13	ABBV	Stock	83.36	86.32	80.69	85.37	21867700.0
2020-03-13	ABC-DELISTED	Stock	83.7	90.17	80.66	90.04	2074000.0
2020-03-13	ABCB	Stock	25.85	26.54	23.01	25.69	1127800.0
2020-03-13	ABEO	Stock	46.0	46.5	40.75	43.5	61056.0
2020-03-13	ABEV	Stock	2.83	2.91	2.54	2.64	40229000.0
2020-03-13	ABG	Stock	61.84	61.84	52.95	55.11	317300.0
2020-03-13	ABM	Stock	25.7	27.29	24.66	27.28	613400.0
2020-03-13	ABMD-DELISTED	Stock	142.88	142.99	136.43	142.82	818818.0
2020-03-13	ABR	Stock	8.97	9.26	8.1	8.5	2594900.0
2020-03-13	ABR.A-DELISTED	Stock	23.14	23.8	21.6	23.75	34283.0
2020-03-13	ABR.B-DELISTED	Stock	22.51	23.25	21.61	23.17	7121.0
2020-03-13	ABR.C-DELISTED	Stock	23.3512	24.37	23.0	24.083	5073.0
2020-03-13	ABT	Stock	77.91	82.67	74.83	81.65	18316900.0
2020-03-13	ABTC	Stock	164400.0	164400.0	147000.0	152100.0	3.0533333333333332
2020-03-13	ABTS	Stock	16.5	20.25	14.4	14.55	1680.0
2020-03-13	ABTX-DELISTED	Stock	25.73	26.84	24.83	26.52	114259.0
2020-03-13	ABUS	Stock	2.29	2.58	2.1	2.12	284900.0

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

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