PREVIEW / stock_daily / 2014-01-27

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-27.parquet
  size:    217 KB
  rows:    6,465
  symbols: 3,542

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
2014-01-27	AAPL	Stock	19.6454	19.8143	19.4911	19.6607	554878800.0
2014-01-27	MSFT	Stock	36.87	36.89	35.98	36.03	44420800.0
2014-01-27	NVDA	Stock	0.389	0.3945	0.3842	0.3865	233812000.0
2014-01-27	AMZN	Stock	19.525	19.705	19.0245	19.314	78736000.0
2014-01-27	META	Stock	54.73	54.94	51.85	53.55	73924100.0
2014-01-27	TSLA	Stock	11.6773	11.8613	10.9807	11.308	130746000.0
2014-01-27	TLT	Stock	107.22	107.6	106.7	106.73	9222620.0
2014-01-27	ES	Stock	42.43	42.98	42.35	42.81	1726300.0
2014-01-27	CL	Stock	62.47	62.65	61.95	62.11	4636800.0
2014-01-27	A	Stock	41.4163	41.7525	40.7582	41.7024	6527262.0
2014-01-27	AABA-DELISTED	Stock	37.6	37.94	36.62	36.65	24544994.0
2014-01-27	AACG	Stock	3.91	3.95	3.9	3.9	7200.0
2014-01-27	AAIC-DELISTED	Stock	26.12	26.18	25.3	25.44	250326.0
2014-01-27	AAL	Stock	30.4	30.87	28.67	30.18	16276300.0
2014-01-27	AAMC-DELISTED	Stock	273.5809	323.4941	273.5809	300.2353	27968.0
2014-01-27	AAME	Stock	3.99	4.03	3.99	3.99	7900.0
2014-01-27	AAOI	Stock	13.5	13.81	13.4	13.72	33900.0
2014-01-27	AAON	Stock	14.4	14.5822	13.8978	14.0756	193275.0
2014-01-27	AAP	Stock	116.49	117.2	113.8	115.4	974300.0
2014-01-27	AAT	Stock	31.77	31.79	31.38	31.43	107000.0
2014-01-27	AAU-DELISTED	Stock	1.5	1.55	1.3666	1.38	196728.0
2014-01-27	AAUAF-DELISTED	Stock	1.5	1.55	1.3666	1.39	197770.0
2014-01-27	AAV-DELISTED	Stock	4.28	4.291	4.06	4.14	126820.0
2014-01-27	AAWW-DELISTED	Stock	37.9	37.9	36.26	37.1	451728.0
2014-01-27	AAXJ	Stock	55.93	56.1	55.36	55.76	1095213.0
2014-01-27	AAXN-DELISTED	Stock	16.78	16.88	16.085	16.51	926729.0
2014-01-27	AB	Stock	22.32	22.32	21.5	21.55	417500.0
2014-01-27	ABAC-DELISTED	Stock	1.98	2.0	1.98	1.9994	17587.0
2014-01-27	ABAX-DELISTED	Stock	42.47	42.74	40.96	41.0	206572.0
2014-01-27	ABB-DELISTED	Stock	25.17	25.23	24.91	25.01	1866927.0
2014-01-27	ABBNY-DELISTED	Stock	25.18	25.23	24.91	25.01	2086788.0
2014-01-27	ABBV	Stock	47.79	47.83	46.42	46.83	10749800.0
2014-01-27	ABC-DELISTED	Stock	67.04	67.51	66.641	66.81	2551160.0
2014-01-27	ABCB	Stock	21.47	21.47	19.94	20.21	123000.0
2014-01-27	ABCD-DELISTED	Stock	2.04	2.09	1.88	1.95	19436.0
2014-01-27	ABCO-DELISTED	Stock	63.83	63.94	63.04	63.15	220201.0
2014-01-27	ABE-DELISTED	Stock	12.63	12.63	12.3301	12.44	13170.0
2014-01-27	ABEO	Stock	487.5	487.5	412.5	475.0	9.0
2014-01-27	ABEV	Stock	6.72	6.74	6.58	6.65	9404300.0
2014-01-27	ABFS-DELISTED	Stock	32.14	33.09	31.53	32.26	362259.0
2014-01-27	ABG	Stock	48.04	48.44	46.19	46.81	400200.0
2014-01-27	ABGB-DELISTED	Stock	17.0	17.0	16.34	16.5	1750.0
2014-01-27	ABM	Stock	27.27	27.49	26.91	26.98	108100.0
2014-01-27	ABMD-DELISTED	Stock	26.54	27.01	26.34	26.57	280635.0
2014-01-27	ABR	Stock	6.85	6.93	6.78	6.82	155200.0
2014-01-27	ABR.A-DELISTED	Stock	25.0461	25.0461	24.85	25.0	565.0
2014-01-27	ABR.B-DELISTED	Stock	22.9	22.98	22.9	22.94	2805.0
2014-01-27	ABT	Stock	36.68	36.83	36.13	36.3	9128900.0
2014-01-27	ABTL-DELISTED	Stock	16.38	16.6499	14.7009	15.98	463556.0
2014-01-27	ABUS	Stock	12.11	12.11	11.02	11.75	173800.0

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

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