PREVIEW / stock_daily / 2019-01-09

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-09.parquet
  size:    219 KB
  rows:    6,552
  symbols: 2,663

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-09	AAPL	Stock	37.8225	38.6325	37.4075	38.3275	180396400.0
2019-01-09	MSFT	Stock	103.86	104.88	103.24	104.27	32280800.0
2019-01-09	NVDA	Stock	3.5475	3.6123	3.4965	3.5645	617260000.0
2019-01-09	AMZN	Stock	82.649	83.39	82.07	82.971	126976000.0
2019-01-09	GOOGL	Stock	54.3995	54.582	53.7185	54.0825	26998240.0
2019-01-09	META	Stock	142.95	144.7	141.27	144.23	22205900.0
2019-01-09	TSLA	Stock	22.3667	22.9	22.098	22.5687	81493500.0
2019-01-09	TLT	Stock	121.26	121.43	120.795	121.24	9349195.0
2019-01-09	ES	Stock	64.82	65.43	64.57	64.75	1483900.0
2019-01-09	CL	Stock	61.97	62.23	60.96	61.3	6284000.0
2019-01-09	A	Stock	68.2	69.66	68.0	69.25	2442300.0
2019-01-09	AA	Stock	28.6	29.28	28.24	29.1	2372400.0
2019-01-09	AABA-DELISTED	Stock	61.9	63.47	61.72	62.91	10196074.0
2019-01-09	AAC-DELISTED	Stock	2.24	2.59	2.24	2.42	318633.0
2019-01-09	AACG	Stock	0.99	1.14	0.94	1.07	349900.0
2019-01-09	AAIC-DELISTED	Stock	8.0	8.07	7.9101	8.07	434658.0
2019-01-09	AAL	Stock	32.42	33.55	32.3	33.42	6179400.0
2019-01-09	AAM.A-DELISTED	Stock	23.72	23.75	23.6	23.66	32332.0
2019-01-09	AAM.B-DELISTED	Stock	23.68	23.69	23.5392	23.63	23251.0
2019-01-09	AAMC-DELISTED	Stock	8.2412	8.6438	8.2412	8.6438	891.0
2019-01-09	AAME	Stock	2.79	2.79	2.79	2.79	800.0
2019-01-09	AAMI	Stock	11.09	11.32	10.645	11.1	665900.0
2019-01-09	AAOI	Stock	16.22	16.57	15.91	16.12	597400.0
2019-01-09	AAON	Stock	24.3667	24.38	24.0333	24.18	118350.0
2019-01-09	AAP	Stock	162.68	165.79	161.23	164.43	1429900.0
2019-01-09	AAT	Stock	41.17	41.35	40.53	40.76	173500.0
2019-01-09	AAU-DELISTED	Stock	0.78	0.8386	0.752	0.8215	936472.0
2019-01-09	AAUAF-DELISTED	Stock	0.78	0.8386	0.752	0.8215	976798.0
2019-01-09	AAWW-DELISTED	Stock	43.97	47.12	43.97	46.9	389530.0
2019-01-09	AAXJ	Stock	64.82	65.58	64.82	65.28	1094311.0
2019-01-09	AAXN-DELISTED	Stock	49.84	50.61	49.13	50.26	608552.0
2019-01-09	AB	Stock	28.19	29.2	28.04	28.06	485900.0
2019-01-09	ABAC-DELISTED	Stock	1.23	1.23	1.1801	1.2	18536.0
2019-01-09	ABB-DELISTED	Stock	19.78	19.89	19.68	19.75	1257200.0
2019-01-09	ABBNY-DELISTED	Stock	19.78	19.89	19.68	19.74	1306011.0
2019-01-09	ABBV	Stock	90.88	91.39	87.46	87.81	9971900.0
2019-01-09	ABC-DELISTED	Stock	75.92	76.9	75.59	76.31	987658.0
2019-01-09	ABCB	Stock	34.54	34.8	34.2	34.5	316200.0
2019-01-09	ABDC-DELISTED	Stock	6.98	7.1	6.8	6.885	36134.0
2019-01-09	ABEO	Stock	182.75	186.75	180.5	182.75	8872.0
2019-01-09	ABEV	Stock	4.36	4.45	4.34	4.39	26220500.0
2019-01-09	ABG	Stock	70.06	71.2	70.0	70.59	124900.0
2019-01-09	ABIL-DELISTED	Stock	1.95	1.98	1.91	1.93	213364.0
2019-01-09	ABM	Stock	35.19	35.25	34.29	34.92	1051100.0
2019-01-09	ABMD-DELISTED	Stock	324.74	342.97	322.1	336.39	444350.0
2019-01-09	ABR	Stock	11.11	11.24	10.96	11.22	1207600.0
2019-01-09	ABR.A-DELISTED	Stock	25.4951	25.4951	25.4	25.4312	800.0
2019-01-09	ABR.B-DELISTED	Stock	25.2672	25.292	25.125	25.2799	3125.0
2019-01-09	ABT	Stock	68.93	69.85	68.8	69.44	6091000.0
2019-01-09	ABTC	Stock	300300.0	303900.0	300300.0	303900.0	0.10666666666666667

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

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