PREVIEW / stock_daily / 2016-04-26

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-26.parquet
  size:    220 KB
  rows:    6,566
  symbols: 3,306

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-26	AAPL	Stock	25.9775	26.325	25.9775	26.0875	224064800.0
2016-04-26	MSFT	Stock	52.26	52.35	51.09	51.44	33532600.0
2016-04-26	NVDA	Stock	0.9168	0.9273	0.908	0.912	214536000.0
2016-04-26	AMZN	Stock	31.3085	31.3375	30.744	30.844	50428000.0
2016-04-26	GOOGL	Stock	37.221	37.2795	36.016	36.2685	55864200.0
2016-04-26	META	Stock	110.49	110.5	108.15	108.76	22521500.0
2016-04-26	TSLA	Stock	16.8033	17.0487	16.626	16.916	48357000.0
2016-04-26	TLT	Stock	127.76	127.76	127.12	127.25	7839962.0
2016-04-26	ES	Stock	55.57	55.81	55.15	55.36	1337000.0
2016-04-26	CL	Stock	69.74	69.75	68.78	68.96	2913400.0
2016-04-26	A	Stock	41.82	41.88	41.26	41.32	1869000.0
2016-04-26	AA.B-DELISTED	Stock	35.9891	37.07	35.7022	37.07	24663.0
2016-04-26	AAAP-DELISTED	Stock	32.64	35.03	32.64	34.98	5949.0
2016-04-26	AABA-DELISTED	Stock	37.32	37.54	36.91	37.1	9697650.0
2016-04-26	AAC-DELISTED	Stock	19.93	20.31	19.89	20.18	104559.0
2016-04-26	AACG	Stock	5.68	5.71	5.67	5.67	23700.0
2016-04-26	AAIC-DELISTED	Stock	13.0	13.2	12.9	13.07	242265.0
2016-04-26	AAL	Stock	37.27	37.49	36.26	36.92	14692700.0
2016-04-26	AAMC-DELISTED	Stock	4.7	4.7	4.3412	4.4824	91361.0
2016-04-26	AAME	Stock	4.55	4.55	4.24	4.24	5000.0
2016-04-26	AAMI	Stock	13.78	13.84	13.64	13.74	126500.0
2016-04-26	AAOI	Stock	11.15	11.15	10.65	10.9	706100.0
2016-04-26	AAON	Stock	17.8	18.0467	17.7533	18.0333	411900.0
2016-04-26	AAP	Stock	157.89	158.76	156.19	158.28	656500.0
2016-04-26	AAT	Stock	38.28	38.89	38.28	38.6	167900.0
2016-04-26	AAU-DELISTED	Stock	1.09	1.16	1.09	1.16	225228.0
2016-04-26	AAUAF-DELISTED	Stock	1.09	1.16	1.09	1.15	226006.0
2016-04-26	AAV-DELISTED	Stock	5.44	5.56	5.42	5.48	89864.0
2016-04-26	AAVL-DELISTED	Stock	6.1	6.22	6.025	6.15	147940.0
2016-04-26	AAWW-DELISTED	Stock	39.6	41.09	39.35	40.92	164750.0
2016-04-26	AAXJ	Stock	54.96	55.08	54.835	55.04	268862.0
2016-04-26	AAXN-DELISTED	Stock	18.14	18.4799	18.07	18.43	488295.0
2016-04-26	AB	Stock	24.5	24.65	24.21	24.28	145500.0
2016-04-26	ABAC-DELISTED	Stock	0.7001	0.749	0.7	0.739	21000.0
2016-04-26	ABAX-DELISTED	Stock	45.44	46.76	44.35	45.945	190919.0
2016-04-26	ABB-DELISTED	Stock	20.88	20.95	20.83	20.92	1614154.0
2016-04-26	ABBNY-DELISTED	Stock	20.88	20.95	20.83	20.91	1818602.0
2016-04-26	ABBV	Stock	60.96	61.29	60.53	60.93	4281700.0
2016-04-26	ABC-DELISTED	Stock	91.73	92.0	91.13	91.26	1004260.0
2016-04-26	ABCB	Stock	31.37	32.0	31.26	31.8	542100.0
2016-04-26	ABCD-DELISTED	Stock	4.64	4.83	4.41	4.76	19421.0
2016-04-26	ABCO-DELISTED	Stock	31.49	31.76	31.11	31.5	220855.0
2016-04-26	ABCW-DELISTED	Stock	46.79	47.15	46.4796	47.03	42791.0
2016-04-26	ABDC-DELISTED	Stock	11.6799	11.6799	11.38	11.43	20917.0
2016-04-26	ABE-DELISTED	Stock	12.14	12.23	12.13	12.145	9345.0
2016-04-26	ABEO	Stock	69.0	69.0	65.0	68.25	2316.0
2016-04-26	ABEV	Stock	5.39	5.43	5.35	5.42	22083700.0
2016-04-26	ABG	Stock	58.57	63.89	57.1	62.25	985600.0
2016-04-26	ABGB-DELISTED	Stock	1.3	1.48	1.3	1.38	69185.0
2016-04-26	ABIL-DELISTED	Stock	7.14	7.16	7.01	7.05	4496.0

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

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