PREVIEW / stock_daily / 2019-05-20

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-20.parquet
  size:    219 KB
  rows:    6,521
  symbols: 2,546

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
2019-05-20	AAPL	Stock	45.88	46.0875	45.07	45.7725	154449200.0
2019-05-20	MSFT	Stock	126.52	127.59	125.76	126.22	23706900.0
2019-05-20	NVDA	Stock	3.8138	3.8693	3.7688	3.7938	572064000.0
2019-05-20	AMZN	Stock	92.6345	93.389	91.777	92.9485	75964000.0
2019-05-20	GOOGL	Stock	57.65	57.65	56.9068	57.233	30602520.0
2019-05-20	META	Stock	181.88	184.23	181.37	182.72	10352000.0
2019-05-20	TSLA	Stock	13.52	13.7333	13.0167	13.6907	307893000.0
2019-05-20	TLT	Stock	126.12	126.38	125.65	125.73	6043112.0
2019-05-20	ES	Stock	73.69	74.08	73.47	73.63	1074500.0
2019-05-20	CL	Stock	72.08	72.58	71.59	71.7	3149900.0
2019-05-20	A	Stock	68.66	69.97	68.64	68.93	4029700.0
2019-05-20	AA	Stock	24.33	24.88	23.85	23.99	3289200.0
2019-05-20	AABA-DELISTED	Stock	66.26	66.58	63.4555	64.4001	16501633.0
2019-05-20	AAC-DELISTED	Stock	1.36	1.43	1.3	1.38	356390.0
2019-05-20	AACG	Stock	2.38	2.38	2.1	2.14	185900.0
2019-05-20	AAIC-DELISTED	Stock	7.37	7.37	7.2	7.22	438603.0
2019-05-20	AAIC.C-DELISTED	Stock	23.6703	23.6703	23.5529	23.5834	1197.0
2019-05-20	AAL	Stock	30.65	31.22	30.22	30.96	7576200.0
2019-05-20	AAM.A-DELISTED	Stock	25.63	25.7	25.63	25.6893	12279.0
2019-05-20	AAM.B-DELISTED	Stock	25.79	25.79	25.7	25.733	23061.0
2019-05-20	AAMC-DELISTED	Stock	6.0647	6.6765	6.0647	6.3235	35397.0
2019-05-20	AAME	Stock	2.33	2.33	2.33	2.33	100.0
2019-05-20	AAMI	Stock	12.0	12.02	11.835	11.88	354500.0
2019-05-20	AAOI	Stock	9.03	9.43	8.96	9.27	680800.0
2019-05-20	AAON	Stock	30.3267	31.2733	29.72	31.16	131250.0
2019-05-20	AAP	Stock	157.35	160.19	157.2	158.64	1714600.0
2019-05-20	AAT	Stock	45.96	46.27	45.22	45.45	147500.0
2019-05-20	AAU-DELISTED	Stock	0.4798	0.4798	0.46	0.47	63717.0
2019-05-20	AAUAF-DELISTED	Stock	0.4798	0.4798	0.46	0.47	68185.0
2019-05-20	AAWW-DELISTED	Stock	39.54	39.8	38.8844	39.02	132932.0
2019-05-20	AAXJ	Stock	66.04	66.16	65.67	65.76	1727891.0
2019-05-20	AAXN-DELISTED	Stock	67.21	67.8185	65.07	65.44	875587.0
2019-05-20	AB	Stock	28.94	29.01	28.67	28.73	147300.0
2019-05-20	ABB-DELISTED	Stock	18.75	18.91	18.71	18.9	1820206.0
2019-05-20	ABBNY-DELISTED	Stock	18.75	18.91	18.71	18.9	1875054.0
2019-05-20	ABBV	Stock	79.02	80.39	78.91	79.82	4395500.0
2019-05-20	ABC-DELISTED	Stock	77.08	79.67	77.05	79.23	1265327.0
2019-05-20	ABCB	Stock	35.77	36.18	35.65	35.95	235400.0
2019-05-20	ABDC-DELISTED	Stock	8.55	8.5918	8.44	8.53	22150.0
2019-05-20	ABEO	Stock	185.25	187.0	179.75	183.5	8040.0
2019-05-20	ABEV	Stock	4.02	4.08	4.0	4.04	37947200.0
2019-05-20	ABG	Stock	78.1	78.87	77.78	77.98	82300.0
2019-05-20	ABIL-DELISTED	Stock	1.26	1.32	1.23	1.28	53523.0
2019-05-20	ABM	Stock	37.56	38.02	37.41	37.47	211500.0
2019-05-20	ABMD-DELISTED	Stock	258.18	259.13	252.005	252.45	481546.0
2019-05-20	ABR	Stock	13.24	13.29	13.11	13.16	2500100.0
2019-05-20	ABR.A-DELISTED	Stock	25.845	25.8961	25.8	25.8668	4308.0
2019-05-20	ABR.B-DELISTED	Stock	25.71	25.71	25.71	25.71	300.0
2019-05-20	ABR.C-DELISTED	Stock	26.0677	26.2015	26.0677	26.2015	1100.0
2019-05-20	ABT	Stock	75.6	75.96	75.2	75.77	4493100.0

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

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