PREVIEW / stock_daily / 2019-05-28

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-28.parquet
  size:    219 KB
  rows:    6,550
  symbols: 2,558

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-28	AAPL	Stock	44.73	45.1475	44.4775	44.5575	111792800.0
2019-05-28	MSFT	Stock	126.98	128.0	126.05	126.16	23128400.0
2019-05-28	NVDA	Stock	3.6465	3.6795	3.5812	3.5833	428356000.0
2019-05-28	AMZN	Stock	91.6375	92.4635	91.3675	91.8215	64000000.0
2019-05-28	GOOGL	Stock	57.074	57.8245	56.9335	56.978	20951080.0
2019-05-28	META	Stock	181.54	184.71	181.45	184.31	14843300.0
2019-05-28	TSLA	Stock	12.7467	13.0	12.5233	12.58	154693500.0
2019-05-28	TLT	Stock	128.27	128.9	128.085	128.79	8098871.0
2019-05-28	ES	Stock	75.07	75.24	74.0	74.13	1915500.0
2019-05-28	CL	Stock	71.29	71.61	70.08	70.11	3327700.0
2019-05-28	A	Stock	68.43	68.86	66.96	67.08	2984700.0
2019-05-28	AA	Stock	23.04	23.12	22.415	22.55	3632900.0
2019-05-28	AABA-DELISTED	Stock	62.4	62.58	60.96	61.5	5479997.0
2019-05-28	AAC-DELISTED	Stock	1.09	1.27	1.05	1.24	354426.0
2019-05-28	AACG	Stock	1.98	2.07	1.93	2.01	47800.0
2019-05-28	AAIC-DELISTED	Stock	7.11	7.15	7.0	7.01	302193.0
2019-05-28	AAIC.C-DELISTED	Stock	23.37	23.4644	23.26	23.38	4551.0
2019-05-28	AAL	Stock	29.26	29.32	28.5	28.73	8362800.0
2019-05-28	AAM.A-DELISTED	Stock	25.7645	25.799	25.61	25.71	12099.0
2019-05-28	AAM.B-DELISTED	Stock	25.81	25.81	25.67	25.67	54089.0
2019-05-28	AAME	Stock	2.44	2.44	2.44	2.44	100.0
2019-05-28	AAMI	Stock	11.67	11.81	11.65	11.71	563100.0
2019-05-28	AAOI	Stock	9.05	9.093	8.72	8.84	442400.0
2019-05-28	AAON	Stock	31.24	31.98	30.8267	30.86	208350.0
2019-05-28	AAP	Stock	158.23	159.25	154.56	154.56	1207500.0
2019-05-28	AAT	Stock	46.25	46.25	45.45	45.84	562300.0
2019-05-28	AAU-DELISTED	Stock	0.45	0.4549	0.4376	0.4392	131535.0
2019-05-28	AAUAF-DELISTED	Stock	0.45	0.4549	0.4376	0.4392	143879.0
2019-05-28	AAWW-DELISTED	Stock	39.07	39.455	38.7	38.89	189884.0
2019-05-28	AAXJ	Stock	66.07	66.19	65.545	65.56	984920.0
2019-05-28	AAXN-DELISTED	Stock	67.46	69.4	67.45	68.51	613748.0
2019-05-28	AB	Stock	28.55	28.55	27.95	27.99	141000.0
2019-05-28	ABB-DELISTED	Stock	18.73	18.76	18.49	18.5	3333286.0
2019-05-28	ABBNY-DELISTED	Stock	18.73	18.76	18.49	18.49	3442775.0
2019-05-28	ABBV	Stock	80.0	80.1	77.92	78.03	6557800.0
2019-05-28	ABC-DELISTED	Stock	80.57	81.69	80.57	80.9	1592864.0
2019-05-28	ABCB	Stock	36.08	36.24	35.71	35.74	290300.0
2019-05-28	ABDC-DELISTED	Stock	8.46	8.54	8.2816	8.49	22216.0
2019-05-28	ABEO	Stock	163.0	163.0	151.0	155.0	30872.0
2019-05-28	ABEV	Stock	4.29	4.37	4.26	4.26	19551700.0
2019-05-28	ABG	Stock	78.65	79.2	77.01	77.19	131700.0
2019-05-28	ABIL-DELISTED	Stock	1.27	1.28	1.21	1.21	60349.0
2019-05-28	ABM	Stock	37.1	37.22	36.51	36.57	346100.0
2019-05-28	ABMD-DELISTED	Stock	269.81	276.07	269.36	269.44	555066.0
2019-05-28	ABR	Stock	12.95	13.02	12.86	12.9	1342200.0
2019-05-28	ABR.A-DELISTED	Stock	25.7992	25.95	25.7832	25.9499	1850.0
2019-05-28	ABR.B-DELISTED	Stock	25.86	25.8899	25.6994	25.86	4616.0
2019-05-28	ABR.C-DELISTED	Stock	26.17	26.2191	26.06	26.11	1365.0
2019-05-28	ABT	Stock	77.03	77.98	75.68	75.71	5418600.0
2019-05-28	ABTC	Stock	306900.0	306900.0	305100.0	305400.0	3.32

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

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