PREVIEW / stock_daily / 2019-01-04

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-04.parquet
  size:    219 KB
  rows:    6,554
  symbols: 2,666

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-01-04	AAPL	Stock	36.1325	37.1375	35.95	37.065	234428400.0
2019-01-04	MSFT	Stock	99.72	102.51	98.93	101.93	44060600.0
2019-01-04	NVDA	Stock	3.2735	3.4432	3.2425	3.4048	585620000.0
2019-01-04	AMZN	Stock	76.5	79.7	75.9155	78.7695	183652000.0
2019-01-04	GOOGL	Stock	52.128	54.0	51.843	53.9035	46028560.0
2019-01-04	META	Stock	134.01	138.0	133.75	137.95	29002100.0
2019-01-04	TSLA	Stock	20.4	21.2	20.182	21.1793	110911500.0
2019-01-04	TLT	Stock	122.34	122.56	121.65	122.11	12970226.0
2019-01-04	ES	Stock	63.14	64.27	63.1	64.09	1365900.0
2019-01-04	CL	Stock	59.11	59.55	58.86	59.52	7087600.0
2019-01-04	A	Stock	64.09	65.95	64.09	65.46	3123700.0
2019-01-04	AA	Stock	26.84	28.61	26.65	28.34	5653300.0
2019-01-04	AABA-DELISTED	Stock	56.5	59.38	56.5	58.73	8766510.0
2019-01-04	AAC-DELISTED	Stock	1.64	2.1	1.64	1.87	556771.0
2019-01-04	AACG	Stock	0.98	1.0	0.93	0.93	6900.0
2019-01-04	AAIC-DELISTED	Stock	7.35	7.65	7.35	7.61	509310.0
2019-01-04	AAL	Stock	30.44	32.09	30.4	32.04	9369600.0
2019-01-04	AAM.A-DELISTED	Stock	22.97	23.19	22.89	23.165	31455.0
2019-01-04	AAM.B-DELISTED	Stock	22.7	23.15	22.7	23.0238	29979.0
2019-01-04	AAMC-DELISTED	Stock	9.1176	9.1765	8.7529	8.7529	7249.0
2019-01-04	AAME	Stock	2.65	3.06	2.65	2.95	1300.0
2019-01-04	AAMI	Stock	11.21	11.57	11.05	11.27	577100.0
2019-01-04	AAOI	Stock	15.33	15.77	15.16	15.54	765400.0
2019-01-04	AAON	Stock	22.88	23.8667	22.8067	23.74	368550.0
2019-01-04	AAP	Stock	164.17	164.5	158.48	158.81	1423000.0
2019-01-04	AAT	Stock	39.51	40.07	39.22	39.63	240000.0
2019-01-04	AAU-DELISTED	Stock	0.72	0.72	0.6751	0.7088	185809.0
2019-01-04	AAUAF-DELISTED	Stock	0.72	0.72	0.6751	0.7088	191891.0
2019-01-04	AAWW-DELISTED	Stock	41.14	42.77	41.105	41.94	179297.0
2019-01-04	AAXJ	Stock	62.64	63.89	62.64	63.63	1658055.0
2019-01-04	AAXN-DELISTED	Stock	43.95	46.21	43.19	46.02	698082.0
2019-01-04	AB	Stock	27.94	28.67	27.9	28.1	504100.0
2019-01-04	ABAC-DELISTED	Stock	1.27	1.27	1.12	1.1846	18975.0
2019-01-04	ABB-DELISTED	Stock	18.99	19.35	18.95	19.29	1567164.0
2019-01-04	ABBNY-DELISTED	Stock	18.99	19.35	18.95	19.29	1625704.0
2019-01-04	ABBV	Stock	87.75	89.14	86.27	89.07	8910600.0
2019-01-04	ABC-DELISTED	Stock	73.66	74.36	72.55	74.23	2005745.0
2019-01-04	ABCB	Stock	32.31	33.2	32.07	33.08	316500.0
2019-01-04	ABDC-DELISTED	Stock	6.8	6.92	6.73	6.88	31032.0
2019-01-04	ABEO	Stock	169.25	178.0	163.75	175.5	19528.0
2019-01-04	ABEOW-DELISTED	Stock	2.9254	3.25	2.9254	3.25	1600.0
2019-01-04	ABEV	Stock	4.29	4.44	4.27	4.42	25632200.0
2019-01-04	ABG	Stock	68.57	69.18	67.67	68.47	227200.0
2019-01-04	ABIL-DELISTED	Stock	1.88	1.94	1.87	1.88	290261.0
2019-01-04	ABM	Stock	31.29	32.01	31.05	32.01	1242800.0
2019-01-04	ABMD-DELISTED	Stock	305.31	321.4752	304.98	313.43	467027.0
2019-01-04	ABR	Stock	10.48	10.64	10.36	10.62	1302000.0
2019-01-04	ABR.A-DELISTED	Stock	25.35	25.4466	25.26	25.3818	7258.0
2019-01-04	ABR.B-DELISTED	Stock	25.575	25.575	25.575	25.575	400.0
2019-01-04	ABR.C-DELISTED	Stock	26.0001	26.01	25.5644	25.8	6064.0

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

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