PREVIEW / stock_daily / 2020-05-19

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-19.parquet
  size:    217 KB
  rows:    6,611
  symbols: 2,355

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-19	AAPL	Stock	78.7575	79.63	78.2525	78.285	101729600.0
2020-05-19	MSFT	Stock	185.03	186.6	183.49	183.63	26799100.0
2020-05-19	NVDA	Stock	8.7902	9.0875	8.7628	8.8055	717320000.0
2020-05-19	AMZN	Stock	121.4915	124.25	121.4485	122.4665	86410000.0
2020-05-19	GOOGL	Stock	69.274	69.6245	68.688	68.72	31585000.0
2020-05-19	META	Stock	213.27	220.49	212.83	216.88	31843200.0
2020-05-19	TSLA	Stock	54.3447	54.8047	53.7387	53.8673	144547500.0
2020-05-19	TLT	Stock	162.52	163.7	162.48	163.66	8639263.0
2020-05-19	ES	Stock	78.82	79.33	77.98	78.23	1466700.0
2020-05-19	CL	Stock	69.82	70.38	69.14	69.25	5304100.0
2020-05-19	A	Stock	83.23	83.54	81.89	81.97	2099200.0
2020-05-19	AA	Stock	7.8	8.195	7.66	7.74	10589600.0
2020-05-19	AACG	Stock	0.8	0.8	0.71	0.76	19500.0
2020-05-19	AAIC-DELISTED	Stock	2.45	2.52	2.305	2.39	471588.0
2020-05-19	AAIC.C-DELISTED	Stock	16.53	16.545	16.362	16.5	6726.0
2020-05-19	AAL	Stock	10.14	10.19	9.59	9.64	62242500.0
2020-05-19	AAM.A-DELISTED	Stock	25.8709	26.03	25.75	25.89	19873.0
2020-05-19	AAM.B-DELISTED	Stock	25.77	25.96	25.71	25.87	20138.0
2020-05-19	AAMC-DELISTED	Stock	4.7794	5.2254	4.7794	5.0779	16650.0
2020-05-19	AAME	Stock	1.95	1.95	1.8	1.8	500.0
2020-05-19	AAMI	Stock	8.43	8.55	8.23	8.24	746200.0
2020-05-19	AAOI	Stock	8.37	8.66	8.25	8.44	675300.0
2020-05-19	AAON	Stock	34.0467	34.38	33.26	33.28	210450.0
2020-05-19	AAP	Stock	140.34	141.8	135.25	135.82	3755600.0
2020-05-19	AAT	Stock	25.79	25.79	25.05	25.1	264900.0
2020-05-19	AAU-DELISTED	Stock	0.43	0.47	0.429	0.4651	790472.0
2020-05-19	AAUAF-DELISTED	Stock	0.43	0.47	0.429	0.465	801825.0
2020-05-19	AAWW-DELISTED	Stock	38.5	40.37	37.13	38.75	513195.0
2020-05-19	AAXJ	Stock	65.23	65.59	64.915	64.92	717427.0
2020-05-19	AAXN-DELISTED	Stock	74.39	76.2197	73.695	74.74	542656.0
2020-05-19	AB	Stock	22.55	23.93	22.35	22.88	447000.0
2020-05-19	ABB-DELISTED	Stock	18.74	18.89	18.63	18.63	1353931.0
2020-05-19	ABBNY-DELISTED	Stock	18.74	18.89	18.62	18.62	1460148.0
2020-05-19	ABBV	Stock	91.26	91.65	89.56	91.2	9892500.0
2020-05-19	ABC-DELISTED	Stock	88.81	90.39	88.5	89.71	686435.0
2020-05-19	ABCB	Stock	21.53	21.94	20.55	20.56	358800.0
2020-05-19	ABEO	Stock	74.75	82.0	74.75	76.5	29376.0
2020-05-19	ABEV	Stock	2.15	2.16	2.09	2.09	32944600.0
2020-05-19	ABG	Stock	69.95	71.95	68.16	68.8	215700.0
2020-05-19	ABM	Stock	32.33	32.79	31.79	31.87	264000.0
2020-05-19	ABMD-DELISTED	Stock	190.95	194.33	188.37	190.79	207951.0
2020-05-19	ABR	Stock	7.14	7.61	6.88	7.32	2649500.0
2020-05-19	ABR.A-DELISTED	Stock	23.77	23.82	23.6188	23.8	4961.0
2020-05-19	ABR.B-DELISTED	Stock	23.12	23.27	23.0	23.0	13877.0
2020-05-19	ABR.C-DELISTED	Stock	24.88	25.15	24.75	25.1	3177.0
2020-05-19	ABT	Stock	90.33	90.5	88.11	88.22	7693100.0
2020-05-19	ABTC	Stock	225600.0	239100.0	225600.0	238200.0	2.1599999999999997
2020-05-19	ABTS	Stock	10.02	10.02	9.0	9.315	833.0
2020-05-19	ABTX-DELISTED	Stock	24.13	24.815	23.12	23.12	51356.0
2020-05-19	ABUS	Stock	2.69	2.69	2.28	2.31	12182400.0

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

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