PREVIEW / stock_daily / 2020-05-29

all stock daily files

  file:    by_date/stock_daily/2020/2020-05-29.parquet
  size:    219 KB
  rows:    6,621
  symbols: 2,350

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-29	AAPL	Stock	79.8125	80.2875	79.1175	79.485	153532400.0
2020-05-29	MSFT	Stock	182.73	184.27	180.41	183.25	42130400.0
2020-05-29	NVDA	Stock	8.5545	8.8755	8.485	8.8755	745256000.0
2020-05-29	AMZN	Stock	120.797	122.1185	119.91	122.1185	70198000.0
2020-05-29	GOOGL	Stock	71.0215	71.8365	70.799	71.676	37050440.0
2020-05-29	META	Stock	225.2	227.49	222.88	225.09	23241500.0
2020-05-29	TSLA	Stock	53.9167	55.6667	53.614	55.6667	176467500.0
2020-05-29	TLT	Stock	162.71	164.09	162.355	163.59	14662054.0
2020-05-29	ES	Stock	80.57	84.19	80.57	83.7	3700600.0
2020-05-29	CL	Stock	72.14	72.58	71.56	72.33	4317000.0
2020-05-29	A	Stock	87.17	88.49	86.47	88.14	2394500.0
2020-05-29	AA	Stock	9.28	9.47	8.97	9.21	7932500.0
2020-05-29	AACG	Stock	0.95	0.95	0.9	0.9	6200.0
2020-05-29	AAIC-DELISTED	Stock	2.47	2.4727	2.37	2.4	497648.0
2020-05-29	AAIC.C-DELISTED	Stock	17.44	17.67	17.1494	17.5	1465.0
2020-05-29	AAL	Stock	10.48	10.87	10.32	10.5	58920300.0
2020-05-29	AAM.A-DELISTED	Stock	26.23	26.5	25.83	26.5	23623.0
2020-05-29	AAM.B-DELISTED	Stock	26.43	26.45	26.21	26.45	31812.0
2020-05-29	AAME	Stock	1.86	1.88	1.76	1.77	5800.0
2020-05-29	AAMI	Stock	8.34	8.48	8.23	8.35	381300.0
2020-05-29	AAOI	Stock	8.82	8.89	8.62	8.83	568100.0
2020-05-29	AAON	Stock	35.8333	36.48	35.2667	36.1133	432600.0
2020-05-29	AAP	Stock	137.7	140.81	136.5	139.32	1324300.0
2020-05-29	AAT	Stock	26.68	26.84	25.99	26.17	489200.0
2020-05-29	AAU-DELISTED	Stock	0.485	0.4901	0.4602	0.4744	494000.0
2020-05-29	AAUAF-DELISTED	Stock	0.485	0.4901	0.4602	0.4744	516959.0
2020-05-29	AAWW-DELISTED	Stock	38.53	39.61	37.57	39.11	313089.0
2020-05-29	AAXJ	Stock	63.9	64.76	63.53	64.67	982550.0
2020-05-29	AAXN-DELISTED	Stock	72.78	76.14	72.14	75.95	622205.0
2020-05-29	AB	Stock	25.0	25.64	24.35	24.97	511600.0
2020-05-29	ABB-DELISTED	Stock	19.84	19.855	19.425	19.66	2338997.0
2020-05-29	ABBNY-DELISTED	Stock	19.84	19.855	19.425	19.66	2612320.0
2020-05-29	ABBV	Stock	91.0	92.89	89.6	92.67	13758800.0
2020-05-29	ABC-DELISTED	Stock	94.7	95.6	93.61	95.31	1018002.0
2020-05-29	ABCB	Stock	24.1	24.85	23.46	24.23	731000.0
2020-05-29	ABEO	Stock	81.75	83.25	79.25	82.75	19872.0
2020-05-29	ABEV	Stock	2.37	2.39	2.26	2.31	59416500.0
2020-05-29	ABG	Stock	74.64	75.21	72.07	72.28	211000.0
2020-05-29	ABM	Stock	33.13	33.42	30.47	30.73	608600.0
2020-05-29	ABMD-DELISTED	Stock	218.53	224.18	214.39	223.56	692890.0
2020-05-29	ABR	Stock	8.37	8.7	8.25	8.42	2634900.0
2020-05-29	ABR.A-DELISTED	Stock	24.3986	24.3986	24.3986	24.3986	142.0
2020-05-29	ABR.B-DELISTED	Stock	23.31	23.9768	23.29	23.779	1259.0
2020-05-29	ABR.C-DELISTED	Stock	25.0	25.0	24.58	24.58	300.0
2020-05-29	ABT	Stock	92.9	95.59	90.75	94.92	10138500.0
2020-05-29	ABTC	Stock	297600.0	299700.0	270000.0	278400.0	5.64
2020-05-29	ABTS	Stock	9.645	9.765	8.73	9.165	1487.0
2020-05-29	ABTX-DELISTED	Stock	25.8	26.05	25.01	25.58	100023.0
2020-05-29	ABUS	Stock	2.12	2.21	2.08	2.17	450700.0
2020-05-29	ACA	Stock	37.63	38.25	36.94	38.17	507429.0

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

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