PREVIEW / stock_daily / 2020-05-01

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-01.parquet
  size:    217 KB
  rows:    6,600
  symbols: 2,352

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-01	AAPL	Stock	71.5625	74.75	71.4625	72.2675	240616800.0
2020-05-01	MSFT	Stock	175.8	178.64	174.01	174.57	39370500.0
2020-05-01	NVDA	Stock	7.1088	7.2225	7.021	7.0695	342096000.0
2020-05-01	AMZN	Stock	116.84	118.122	112.9095	114.302	195452000.0
2020-05-01	GOOGL	Stock	66.2045	67.5715	65.483	65.866	48871080.0
2020-05-01	META	Stock	201.6	207.28	199.05	202.27	30415600.0
2020-05-01	TSLA	Stock	50.3333	51.518	45.536	46.7547	487977000.0
2020-05-01	TLT	Stock	167.5	168.11	166.44	167.95	10209421.0
2020-05-01	ES	Stock	80.22	80.84	79.33	79.87	1543000.0
2020-05-01	CL	Stock	70.2	71.0	68.31	68.53	4497000.0
2020-05-01	A	Stock	75.55	76.1	73.57	74.21	1618600.0
2020-05-01	AA	Stock	7.86	8.17	7.575	7.69	9065300.0
2020-05-01	AACG	Stock	0.8	0.8	0.65	0.74	33100.0
2020-05-01	AAIC-DELISTED	Stock	2.62	2.79	2.62	2.72	298124.0
2020-05-01	AAIC.C-DELISTED	Stock	17.1	17.41	16.95	17.41	4407.0
2020-05-01	AAL	Stock	11.41	11.66	10.58	10.64	99441400.0
2020-05-01	AAM.A-DELISTED	Stock	25.692	26.0	25.692	25.925	9724.0
2020-05-01	AAM.B-DELISTED	Stock	25.7	25.83	25.356	25.75	36787.0
2020-05-01	AAME	Stock	1.62	1.8	1.62	1.78	900.0
2020-05-01	AAMI	Stock	7.33	7.5	7.09	7.48	612000.0
2020-05-01	AAOI	Stock	10.38	10.66	9.92	10.11	679100.0
2020-05-01	AAON	Stock	31.0667	31.2	29.86	30.2733	342300.0
2020-05-01	AAP	Stock	118.02	119.39	115.97	116.59	501700.0
2020-05-01	AAT	Stock	27.17	27.84	26.68	27.38	337500.0
2020-05-01	AAU-DELISTED	Stock	0.435	0.4401	0.4	0.4281	331855.0
2020-05-01	AAUAF-DELISTED	Stock	0.435	0.4401	0.4	0.429	347058.0
2020-05-01	AAWW-DELISTED	Stock	31.68	31.98	31.0	31.97	446769.0
2020-05-01	AAXJ	Stock	62.62	62.66	61.66	61.8	934619.0
2020-05-01	AAXN-DELISTED	Stock	71.4	72.93	69.05	69.44	421756.0
2020-05-01	AB	Stock	22.48	22.8	21.47	21.75	523700.0
2020-05-01	ABB-DELISTED	Stock	18.32	18.54	18.185	18.38	1818494.0
2020-05-01	ABBNY-DELISTED	Stock	18.32	18.54	18.185	18.39	1913945.0
2020-05-01	ABBV	Stock	81.95	84.23	80.5	82.84	12705300.0
2020-05-01	ABC-DELISTED	Stock	88.35	88.35	85.11	86.38	857304.0
2020-05-01	ABCB	Stock	24.63	24.7	22.92	23.7	416900.0
2020-05-01	ABEO	Stock	59.0	60.25	54.5	56.75	40912.0
2020-05-01	ABEV	Stock	2.17	2.17	2.09	2.09	18804300.0
2020-05-01	ABG	Stock	65.51	66.19	62.76	65.73	297000.0
2020-05-01	ABM	Stock	33.71	34.14	32.7	33.24	418600.0
2020-05-01	ABMD-DELISTED	Stock	190.0	190.04	182.2	183.5	579180.0
2020-05-01	ABR	Stock	6.57	6.72	6.26	6.68	2273800.0
2020-05-01	ABR.A-DELISTED	Stock	21.5	23.5	21.5	21.94	3324.0
2020-05-01	ABR.B-DELISTED	Stock	20.49	21.0714	20.49	20.8823	5702.0
2020-05-01	ABR.C-DELISTED	Stock	22.3	22.5	21.92	22.15	3333.0
2020-05-01	ABT	Stock	91.0	91.36	88.75	89.85	6839800.0
2020-05-01	ABTC	Stock	242400.0	242400.0	204000.0	218700.0	8.6
2020-05-01	ABTS	Stock	10.65	10.875	10.2	10.44	860.0
2020-05-01	ABTX-DELISTED	Stock	24.14	24.6	23.75	24.395	59923.0
2020-05-01	ABUS	Stock	1.03	1.11	1.02	1.07	625100.0
2020-05-01	ACA	Stock	36.37	36.5	33.25	35.23	546353.0

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

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