PREVIEW / stock_daily / 2020-03-09

all stock daily files

  file:    by_date/stock_daily/2020/2020-03-09.parquet
  size:    217 KB
  rows:    6,653
  symbols: 2,395

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-09	AAPL	Stock	65.9375	69.5225	65.75	66.5425	286744800.0
2020-03-09	MSFT	Stock	151.0	157.75	150.0	150.62	70419300.0
2020-03-09	NVDA	Stock	5.9975	6.485	5.9545	6.136	614160000.0
2020-03-09	AMZN	Stock	88.693	93.1385	88.0645	90.0305	156264000.0
2020-03-09	GOOGL	Stock	60.248	62.6365	59.902	60.7895	69251560.0
2020-03-09	META	Stock	169.6	175.0	165.19	169.5	29949000.0
2020-03-09	TSLA	Stock	40.3593	44.2	40.3333	40.5333	256105500.0
2020-03-09	TLT	Stock	179.1	179.7	170.34	171.29	41552819.0
2020-03-09	ES	Stock	91.4	94.59	90.0	92.56	3900000.0
2020-03-09	CL	Stock	69.3	71.61	69.0	69.99	7399300.0
2020-03-09	A	Stock	72.59	74.19	70.17	70.75	4598200.0
2020-03-09	AA	Stock	9.62	10.11	8.61	8.69	10034000.0
2020-03-09	AACG	Stock	1.0	1.03	0.97	0.97	23700.0
2020-03-09	AAIC-DELISTED	Stock	5.31	5.31	4.96	4.97	527304.0
2020-03-09	AAIC.C-DELISTED	Stock	21.05	21.127	20.21	20.6	3518.0
2020-03-09	AAL	Stock	14.87	15.79	14.46	14.75	42558000.0
2020-03-09	AAM.A-DELISTED	Stock	25.63	25.705	25.05	25.31	94530.0
2020-03-09	AAM.B-DELISTED	Stock	26.64	26.64	25.4	25.46	93461.0
2020-03-09	AAMC-DELISTED	Stock	6.2618	6.9118	6.0311	6.0311	4145.0
2020-03-09	AAME	Stock	2.32	2.61	2.32	2.55	2700.0
2020-03-09	AAMI	Stock	6.85	6.91	5.93	6.35	706900.0
2020-03-09	AAOI	Stock	8.07	8.27	7.588	7.72	1214700.0
2020-03-09	AAON	Stock	37.02	37.1733	33.7067	34.4533	630750.0
2020-03-09	AAP	Stock	119.93	132.19	119.44	130.36	1736700.0
2020-03-09	AAT	Stock	39.33	39.58	37.11	37.31	461300.0
2020-03-09	AAU-DELISTED	Stock	0.36	0.3678	0.3334	0.3334	268373.0
2020-03-09	AAUAF-DELISTED	Stock	0.36	0.3678	0.3334	0.3346	281238.0
2020-03-09	AAWW-DELISTED	Stock	21.77	22.56	20.26	20.83	954500.0
2020-03-09	AAXJ	Stock	63.95	65.75	63.94	64.79	2761277.0
2020-03-09	AAXN-DELISTED	Stock	69.17	70.52	62.66	66.09	762609.0
2020-03-09	AB	Stock	28.37	28.45	26.75	27.51	1304300.0
2020-03-09	ABB-DELISTED	Stock	19.34	19.9	18.99	19.02	3219225.0
2020-03-09	ABBNY-DELISTED	Stock	19.34	19.9	18.99	19.02	3424498.0
2020-03-09	ABBV	Stock	84.0	87.34	82.43	85.27	15806200.0
2020-03-09	ABC-DELISTED	Stock	79.69	85.83	77.56	83.37	2946856.0
2020-03-09	ABCB	Stock	29.63	30.0	27.07	27.08	409400.0
2020-03-09	ABEO	Stock	62.5	64.0	55.75	59.0	60284.0
2020-03-09	ABEV	Stock	3.05	3.25	3.05	3.08	79975700.0
2020-03-09	ABG	Stock	82.22	84.08	78.95	80.21	332500.0
2020-03-09	ABM	Stock	31.4	32.68	28.0	31.54	363800.0
2020-03-09	ABMD-DELISTED	Stock	148.5	159.05	147.07	156.42	730679.0
2020-03-09	ABR	Stock	11.33	11.42	10.6	10.64	2214300.0
2020-03-09	ABR.A-DELISTED	Stock	25.25	25.25	24.01	25.1471	24047.0
2020-03-09	ABR.B-DELISTED	Stock	25.0	25.0	24.3663	24.6805	13256.0
2020-03-09	ABR.C-DELISTED	Stock	25.0	25.4752	24.9	25.25	17860.0
2020-03-09	ABT	Stock	76.61	79.34	75.1	77.02	10285000.0
2020-03-09	ABTC	Stock	206100.0	206100.0	132600.0	134100.0	7.2
2020-03-09	ABTS	Stock	16.05	16.05	7.5	7.5	473.0
2020-03-09	ABTX-DELISTED	Stock	27.77	30.344	26.58	26.73	114069.0
2020-03-09	ABUS	Stock	2.84	2.9	2.66	2.76	255200.0

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

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