PREVIEW / stock_daily / 2019-05-23

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-23.parquet
  size:    219 KB
  rows:    6,526
  symbols: 2,563

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-23	AAPL	Stock	44.95	45.135	44.4525	44.915	146118800.0
2019-05-23	MSFT	Stock	126.2	126.29	124.74	126.18	23603800.0
2019-05-23	NVDA	Stock	3.7422	3.7422	3.6228	3.683	591844000.0
2019-05-23	AMZN	Stock	91.8295	92.2	90.21	90.774	88486000.0
2019-05-23	GOOGL	Stock	57.3035	57.5025	56.658	57.267	25213140.0
2019-05-23	META	Stock	182.42	183.9	179.67	180.87	12768800.0
2019-05-23	TSLA	Stock	12.956	13.298	12.4147	13.0327	398206500.0
2019-05-23	TLT	Stock	126.89	128.09	126.88	127.67	9743687.0
2019-05-23	ES	Stock	73.9	74.87	73.51	74.84	1855500.0
2019-05-23	CL	Stock	71.37	71.78	71.11	71.75	2855100.0
2019-05-23	A	Stock	67.18	67.85	66.03	67.7	5358500.0
2019-05-23	AA	Stock	23.9	23.9	23.066	23.24	3338100.0
2019-05-23	AABA-DELISTED	Stock	62.07	63.2	61.64	62.23	6491502.0
2019-05-23	AAC-DELISTED	Stock	1.17	1.53	1.06	1.3	1157351.0
2019-05-23	AACG	Stock	2.03	2.15	2.0	2.02	67900.0
2019-05-23	AAIC-DELISTED	Stock	7.08	7.11	7.005	7.05	287318.0
2019-05-23	AAIC.C-DELISTED	Stock	23.3	23.4799	23.11	23.2305	14115.0
2019-05-23	AAL	Stock	29.73	29.98	29.31	29.5	11324600.0
2019-05-23	AAM.A-DELISTED	Stock	25.69	25.76	25.69	25.71	10987.0
2019-05-23	AAM.B-DELISTED	Stock	25.72	25.79	25.65	25.751	29000.0
2019-05-23	AAMC-DELISTED	Stock	6.0324	6.4294	6.0294	6.4294	5131.0
2019-05-23	AAME	Stock	2.46	2.46	2.46	2.46	100.0
2019-05-23	AAMI	Stock	11.6	11.66	11.4	11.52	404800.0
2019-05-23	AAOI	Stock	8.94	9.03	8.72	8.86	805500.0
2019-05-23	AAON	Stock	30.5467	30.88	30.0867	30.6933	205950.0
2019-05-23	AAP	Stock	165.58	167.0	158.55	159.8	2600200.0
2019-05-23	AAT	Stock	45.68	45.72	45.39	45.7	156900.0
2019-05-23	AAU-DELISTED	Stock	0.4516	0.4659	0.4504	0.4531	46233.0
2019-05-23	AAUAF-DELISTED	Stock	0.4516	0.4659	0.4504	0.4531	51057.0
2019-05-23	AAWW-DELISTED	Stock	38.45	38.4596	37.79	38.11	164091.0
2019-05-23	AAXJ	Stock	65.26	65.57	65.09	65.35	1935842.0
2019-05-23	AAXN-DELISTED	Stock	67.18	67.81	66.2701	67.03	486772.0
2019-05-23	AB	Stock	28.53	28.63	28.02	28.24	137800.0
2019-05-23	ABB-DELISTED	Stock	18.59	18.71	18.52	18.7	1896511.0
2019-05-23	ABBNY-DELISTED	Stock	18.59	18.71	18.52	18.69	1986463.0
2019-05-23	ABBV	Stock	80.39	81.63	80.32	81.15	3299100.0
2019-05-23	ABC-DELISTED	Stock	81.16	81.67	79.95	80.42	855430.0
2019-05-23	ABCB	Stock	35.58	35.72	34.96	35.32	381700.0
2019-05-23	ABDC-DELISTED	Stock	8.56	8.688	8.44	8.55	24795.0
2019-05-23	ABEO	Stock	172.5	173.0	162.25	162.25	18908.0
2019-05-23	ABEOW-DELISTED	Stock	2.2	2.2	2.2	2.2	100.0
2019-05-23	ABEV	Stock	4.22	4.32	4.21	4.26	22987600.0
2019-05-23	ABG	Stock	77.44	78.16	76.72	77.8	79100.0
2019-05-23	ABIL-DELISTED	Stock	1.25	1.28	1.22	1.24	43495.0
2019-05-23	ABM	Stock	37.63	37.7	36.62	36.92	246200.0
2019-05-23	ABMD-DELISTED	Stock	263.5	266.6	259.21	262.78	614244.0
2019-05-23	ABR	Stock	12.83	12.95	12.83	12.92	852600.0
2019-05-23	ABR.A-DELISTED	Stock	25.63	25.7472	25.62	25.74	3260.0
2019-05-23	ABR.B-DELISTED	Stock	25.58	25.58	25.57	25.58	492.0
2019-05-23	ABR.C-DELISTED	Stock	26.1518	26.1518	26.02	26.02	4300.0

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

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