PREVIEW / stock_daily / 2016-04-25

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-25.parquet
  size:    219 KB
  rows:    6,573
  symbols: 3,307

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
2016-04-25	AAPL	Stock	26.25	26.4125	26.1275	26.27	112126400.0
2016-04-25	MSFT	Stock	51.78	52.13	51.63	52.11	33226900.0
2016-04-25	NVDA	Stock	0.907	0.9162	0.9045	0.9113	191972000.0
2016-04-25	AMZN	Stock	30.8305	31.349	30.8125	31.31	53658000.0
2016-04-25	GOOGL	Stock	36.7675	37.244	36.755	37.1105	49441220.0
2016-04-25	META	Stock	109.87	110.67	109.07	110.1	21017900.0
2016-04-25	TSLA	Stock	16.8673	17.1587	16.7173	16.788	55054500.0
2016-04-25	TLT	Stock	128.06	128.52	127.83	127.83	5539464.0
2016-04-25	ES	Stock	55.18	55.58	55.06	55.5	1223600.0
2016-04-25	CL	Stock	68.87	69.52	68.58	69.42	3038600.0
2016-04-25	A	Stock	41.71	41.86	41.53	41.63	1500400.0
2016-04-25	AA.B-DELISTED	Stock	36.75	36.75	35.33	35.6	22828.0
2016-04-25	AAAP-DELISTED	Stock	34.48	34.48	32.55	32.8	31056.0
2016-04-25	AABA-DELISTED	Stock	37.47	37.54	37.18	37.23	9325299.0
2016-04-25	AAC-DELISTED	Stock	20.9	20.9	19.82	19.91	66052.0
2016-04-25	AACG	Stock	5.86	5.88	5.68	5.68	29200.0
2016-04-25	AAIC-DELISTED	Stock	12.97	13.0	12.71	12.84	220178.0
2016-04-25	AAL	Stock	38.16	38.4	36.92	37.0	12670100.0
2016-04-25	AAMC-DELISTED	Stock	4.85	4.8639	4.4294	4.5676	80002.0
2016-04-25	AAME	Stock	4.63	4.63	4.63	4.63	300.0
2016-04-25	AAMI	Stock	13.85	13.87	13.64	13.72	106700.0
2016-04-25	AAOI	Stock	11.51	11.53	11.05	11.08	392000.0
2016-04-25	AAON	Stock	18.26	18.26	17.6	17.7133	219450.0
2016-04-25	AAP	Stock	157.59	158.31	155.63	157.39	618000.0
2016-04-25	AAT	Stock	37.71	38.23	37.66	38.16	472800.0
2016-04-25	AAU-DELISTED	Stock	1.12	1.1699	1.1	1.1	387607.0
2016-04-25	AAUAF-DELISTED	Stock	1.12	1.1699	1.1	1.1	388956.0
2016-04-25	AAV-DELISTED	Stock	5.47	5.51	5.4	5.4	53353.0
2016-04-25	AAVL-DELISTED	Stock	6.25	6.31	5.99	6.1	173446.0
2016-04-25	AAWW-DELISTED	Stock	40.73	40.94	39.12	39.55	154321.0
2016-04-25	AAXJ	Stock	54.87	54.89	54.625	54.72	909490.0
2016-04-25	AAXN-DELISTED	Stock	18.52	18.72	18.0329	18.14	683788.0
2016-04-25	AB	Stock	24.18	24.43	24.15	24.4	164700.0
2016-04-25	ABAC-DELISTED	Stock	0.6914	0.7	0.6901	0.6901	6870.0
2016-04-25	ABAX-DELISTED	Stock	46.51	46.72	45.29	45.54	157433.0
2016-04-25	ABB-DELISTED	Stock	20.62	20.68	20.54	20.6	1540724.0
2016-04-25	ABBNY-DELISTED	Stock	20.62	20.68	20.54	20.59	1589592.0
2016-04-25	ABBV	Stock	61.13	61.3	60.75	60.97	4320500.0
2016-04-25	ABC-DELISTED	Stock	91.75	91.99	90.98	91.51	2051768.0
2016-04-25	ABCB	Stock	32.26	32.4	31.73	32.01	156900.0
2016-04-25	ABCD-DELISTED	Stock	4.41	4.63	4.41	4.62	13220.0
2016-04-25	ABCO-DELISTED	Stock	31.93	32.07	31.37	31.47	247063.0
2016-04-25	ABCW-DELISTED	Stock	46.978	47.21	46.64	47.195	93581.0
2016-04-25	ABDC-DELISTED	Stock	11.75	11.75	11.5	11.5841	26423.0
2016-04-25	ABE-DELISTED	Stock	11.95	12.12	11.88	12.12	20563.0
2016-04-25	ABEO	Stock	69.5	69.75	68.0	68.5	1376.0
2016-04-25	ABEV	Stock	5.36	5.37	5.31	5.36	4586100.0
2016-04-25	ABG	Stock	58.62	58.92	57.01	57.42	321500.0
2016-04-25	ABGB-DELISTED	Stock	1.3	1.43	1.2716	1.35	54083.0
2016-04-25	ABIL-DELISTED	Stock	7.0046	7.52	7.0046	7.37	3625.0

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

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