PREVIEW / stock_daily / 2019-04-17

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-17.parquet
  size:    221 KB
  rows:    6,554
  symbols: 2,599

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-04-17	AAPL	Stock	49.885	50.845	49.6525	50.7825	115627200.0
2019-04-17	MSFT	Stock	121.24	121.85	120.54	121.77	19300900.0
2019-04-17	NVDA	Stock	4.7405	4.7615	4.6598	4.6822	351004000.0
2019-04-17	AMZN	Stock	93.6495	93.8235	93.022	93.241	57870000.0
2019-04-17	GOOGL	Stock	61.85	62.2548	61.645	62.007	30365720.0
2019-04-17	META	Stock	179.6	180.74	178.36	178.78	9973700.0
2019-04-17	TSLA	Stock	18.3167	18.3193	17.9027	18.082	76897500.0
2019-04-17	TLT	Stock	122.13	122.5701	122.11	122.26	6118702.0
2019-04-17	ES	Stock	70.13	70.5	69.89	70.21	1350200.0
2019-04-17	CL	Stock	68.89	68.96	68.55	68.68	2633600.0
2019-04-17	A	Stock	78.15	78.32	74.46	75.43	4472000.0
2019-04-17	AA	Stock	27.98	28.59	27.67	27.72	5016000.0
2019-04-17	AABA-DELISTED	Stock	75.7	76.2	75.26	76.11	2219139.0
2019-04-17	AAC-DELISTED	Stock	1.82	1.8609	1.74	1.7475	132882.0
2019-04-17	AACG	Stock	2.71	2.84	2.64	2.77	529300.0
2019-04-17	AAIC-DELISTED	Stock	7.6	7.6	7.525	7.59	262706.0
2019-04-17	AAIC.C-DELISTED	Stock	23.3943	23.5	23.13	23.31	17162.0
2019-04-17	AAL	Stock	34.45	34.72	34.1	34.38	3772100.0
2019-04-17	AAM.A-DELISTED	Stock	24.97	24.995	24.95	24.97	43070.0
2019-04-17	AAM.B-DELISTED	Stock	24.9893	25.0101	24.96	25.0	78576.0
2019-04-17	AAMC-DELISTED	Stock	8.8235	8.8235	8.6435	8.7294	15977.0
2019-04-17	AAME	Stock	2.45	2.47	2.39	2.39	2600.0
2019-04-17	AAMI	Stock	14.51	14.62	14.47	14.55	372100.0
2019-04-17	AAOI	Stock	12.83	12.95	12.35	12.57	609500.0
2019-04-17	AAON	Stock	32.4067	32.4733	31.4467	31.64	193950.0
2019-04-17	AAP	Stock	179.95	180.05	176.67	176.81	741500.0
2019-04-17	AAT	Stock	44.38	44.38	43.72	44.08	360200.0
2019-04-17	AAU-DELISTED	Stock	0.5739	0.5799	0.555	0.5576	47730.0
2019-04-17	AAUAF-DELISTED	Stock	0.5739	0.5799	0.555	0.5576	48266.0
2019-04-17	AAWW-DELISTED	Stock	50.51	50.6453	49.56	49.96	125412.0
2019-04-17	AAXJ	Stock	73.57	73.645	73.27	73.4	685371.0
2019-04-17	AAXN-DELISTED	Stock	61.86	62.24	60.26	61.5	336700.0
2019-04-17	AB	Stock	29.97	30.05	29.61	29.94	193000.0
2019-04-17	ABB-DELISTED	Stock	21.14	21.185	20.855	20.89	4990543.0
2019-04-17	ABBNY-DELISTED	Stock	21.14	21.185	20.855	20.89	6168500.0
2019-04-17	ABBV	Stock	80.1	80.2	77.55	77.98	6817100.0
2019-04-17	ABC-DELISTED	Stock	75.59	75.79	71.6301	72.28	1363051.0
2019-04-17	ABCB	Stock	36.1	36.1	35.36	35.79	171500.0
2019-04-17	ABDC-DELISTED	Stock	7.85	7.95	7.8	7.86	22420.0
2019-04-17	ABEO	Stock	204.75	206.75	197.25	204.5	16880.0
2019-04-17	ABEOW-DELISTED	Stock	3.77	3.77	3.77	3.77	500.0
2019-04-17	ABEV	Stock	4.47	4.47	4.29	4.34	17174200.0
2019-04-17	ABG	Stock	76.76	77.41	75.62	75.87	152400.0
2019-04-17	ABIL-DELISTED	Stock	1.6974	1.71	1.66	1.6675	27239.0
2019-04-17	ABM	Stock	37.4	37.8	36.82	36.91	352400.0
2019-04-17	ABMD-DELISTED	Stock	267.58	267.862	250.2953	251.5	779263.0
2019-04-17	ABR	Stock	13.75	13.78	13.37	13.5	1182400.0
2019-04-17	ABR.A-DELISTED	Stock	25.7989	25.88	25.7989	25.88	945.0
2019-04-17	ABR.B-DELISTED	Stock	25.64	25.65	25.64	25.64	1575.0
2019-04-17	ABR.C-DELISTED	Stock	26.195	26.4	26.195	26.28	1150.0

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

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