PREVIEW / stock_daily / 2020-04-30

all stock daily files

  file:    by_date/stock_daily/2020/2020-04-30.parquet
  size:    217 KB
  rows:    6,579
  symbols: 2,342

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-30	AAPL	Stock	72.49	73.6325	72.0875	73.45	183064000.0
2020-04-30	MSFT	Stock	180.0	180.4	176.23	179.21	53875900.0
2020-04-30	NVDA	Stock	7.4073	7.4615	7.293	7.307	375916000.0
2020-04-30	AMZN	Stock	120.992	123.75	119.8005	123.7	190692000.0
2020-04-30	GOOGL	Stock	66.568	67.5	66.075	67.335	55842480.0
2020-04-30	META	Stock	206.92	209.69	201.57	204.71	46230100.0
2020-04-30	TSLA	Stock	57.0127	57.988	50.9	52.1253	427078500.0
2020-04-30	TLT	Stock	168.74	169.23	166.71	166.74	11606074.0
2020-04-30	ES	Stock	82.83	83.09	80.22	80.7	3111700.0
2020-04-30	CL	Stock	69.75	70.79	69.17	70.27	7128300.0
2020-04-30	A	Stock	77.96	78.44	75.99	76.66	1795200.0
2020-04-30	AA	Stock	8.61	8.63	8.06	8.15	10728600.0
2020-04-30	AACG	Stock	0.76	0.76	0.72	0.72	10700.0
2020-04-30	AAIC-DELISTED	Stock	2.85	2.89	2.7601	2.83	454157.0
2020-04-30	AAIC.C-DELISTED	Stock	17.44	17.45	17.4	17.4	2131.0
2020-04-30	AAL	Stock	11.92	12.59	11.26	12.01	94921400.0
2020-04-30	AAM.A-DELISTED	Stock	25.785	26.13	25.76	26.13	28515.0
2020-04-30	AAM.B-DELISTED	Stock	25.6	25.99	25.56	25.65	56269.0
2020-04-30	AAMC-DELISTED	Stock	5.8676	6.0824	5.3971	5.5147	26058.0
2020-04-30	AAME	Stock	1.78	1.8	1.76	1.78	2600.0
2020-04-30	AAMI	Stock	7.67	7.76	7.4	7.41	808600.0
2020-04-30	AAOI	Stock	11.005	11.45	10.47	10.72	782200.0
2020-04-30	AAON	Stock	31.92	32.0	30.72	31.76	406200.0
2020-04-30	AAP	Stock	123.33	123.42	118.78	120.91	750000.0
2020-04-30	AAT	Stock	28.7	29.61	28.08	28.32	529700.0
2020-04-30	AAU-DELISTED	Stock	0.47	0.47	0.4151	0.43	390796.0
2020-04-30	AAUAF-DELISTED	Stock	0.47	0.47	0.4151	0.4351	414059.0
2020-04-30	AAWW-DELISTED	Stock	34.18	34.38	32.55	32.85	934254.0
2020-04-30	AAXJ	Stock	65.07	65.35	63.71	63.99	974966.0
2020-04-30	AAXN-DELISTED	Stock	75.0	75.23	71.9039	72.62	376521.0
2020-04-30	AB	Stock	23.0	23.51	22.41	23.42	686100.0
2020-04-30	ABB-DELISTED	Stock	19.06	19.06	18.695	18.77	2778848.0
2020-04-30	ABBNY-DELISTED	Stock	19.02	19.05	18.695	18.76	3471653.0
2020-04-30	ABBV	Stock	82.97	83.26	81.23	82.2	15535800.0
2020-04-30	ABC-DELISTED	Stock	88.71	91.03	88.61	89.68	1323664.0
2020-04-30	ABCB	Stock	25.93	26.43	25.17	25.43	471900.0
2020-04-30	ABEO	Stock	63.25	64.0	59.25	59.5	39084.0
2020-04-30	ABEV	Stock	2.14	2.16	2.09	2.15	24730400.0
2020-04-30	ABG	Stock	67.87	68.27	65.17	67.5	284700.0
2020-04-30	ABM	Stock	35.0	35.74	34.26	34.49	1435500.0
2020-04-30	ABMD-DELISTED	Stock	174.98	198.43	169.28	191.25	1935965.0
2020-04-30	ABR	Stock	7.1	7.17	6.72	6.89	2701700.0
2020-04-30	ABR.A-DELISTED	Stock	21.59	22.15	21.5	21.5	4035.0
2020-04-30	ABR.B-DELISTED	Stock	21.25	21.95	20.56	20.57	3301.0
2020-04-30	ABR.C-DELISTED	Stock	22.318	22.38	22.25	22.35	924.0
2020-04-30	ABT	Stock	91.85	93.77	91.85	92.09	7978300.0
2020-04-30	ABTC	Stock	262500.0	262500.0	246300.0	250500.0	2.0933333333333333
2020-04-30	ABTS	Stock	10.965	11.13	9.855	10.2	1040.0
2020-04-30	ABTX-DELISTED	Stock	22.94	26.4844	22.94	25.05	80827.0
2020-04-30	ABUS	Stock	1.18	1.2	1.12	1.16	393300.0

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

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