PREVIEW / stock_daily / 2014-01-28

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-28.parquet
  size:    217 KB
  rows:    6,471
  symbols: 3,550

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-28	AAPL	Stock	18.17	18.3929	17.9311	18.0893	1065523200.0
2014-01-28	MSFT	Stock	36.12	36.39	35.75	36.27	36205500.0
2014-01-28	NVDA	Stock	0.3858	0.3905	0.3842	0.3902	167996000.0
2014-01-28	AMZN	Stock	19.37	19.737	19.356	19.7215	57890000.0
2014-01-28	META	Stock	54.02	55.28	54.0	55.14	48191200.0
2014-01-28	TSLA	Stock	11.4333	11.932	11.4	11.892	91401000.0
2014-01-28	TLT	Stock	106.91	106.99	106.55	106.99	5666819.0
2014-01-28	ES	Stock	42.84	43.04	42.66	42.96	1557700.0
2014-01-28	CL	Stock	62.2	62.93	62.2	62.87	3377600.0
2014-01-28	A	Stock	41.8455	42.1173	41.4235	41.5594	3545328.0
2014-01-28	AABA-DELISTED	Stock	36.83	38.32	36.52	38.22	39392502.0
2014-01-28	AACG	Stock	3.95	3.96	3.95	3.96	4700.0
2014-01-28	AAIC-DELISTED	Stock	25.54	26.28	25.45	26.26	155818.0
2014-01-28	AAL	Stock	30.32	32.2	30.02	31.96	23937900.0
2014-01-28	AAMC-DELISTED	Stock	297.5147	307.4868	297.0676	305.8824	43741.0
2014-01-28	AAME	Stock	3.97	4.01	3.97	4.0	3000.0
2014-01-28	AAOI	Stock	13.85	14.19	13.76	13.84	44000.0
2014-01-28	AAON	Stock	14.1244	14.5378	14.0	14.4444	423000.0
2014-01-28	AAP	Stock	115.39	117.66	115.22	116.25	918500.0
2014-01-28	AAT	Stock	31.54	32.16	31.54	31.94	171700.0
2014-01-28	AAU-DELISTED	Stock	1.42	1.4648	1.36	1.38	140728.0
2014-01-28	AAUAF-DELISTED	Stock	1.41	1.4596	1.36	1.39	142065.0
2014-01-28	AAV-DELISTED	Stock	4.17	4.2	4.08	4.19	110083.0
2014-01-28	AAWW-DELISTED	Stock	37.06	37.34	36.22	36.22	462686.0
2014-01-28	AAXJ	Stock	56.1	56.336	55.99	56.13	2484826.0
2014-01-28	AAXN-DELISTED	Stock	16.53	16.97	16.3	16.65	1068287.0
2014-01-28	AB	Stock	21.53	22.2	21.52	22.12	192700.0
2014-01-28	ABAC-DELISTED	Stock	1.971	2.07	1.97	2.03	12566.0
2014-01-28	ABAX-DELISTED	Stock	41.17	41.58	40.56	41.07	163789.0
2014-01-28	ABB-DELISTED	Stock	25.33	25.49	25.32	25.44	1415130.0
2014-01-28	ABBNY-DELISTED	Stock	25.33	25.49	25.32	25.43	1494448.0
2014-01-28	ABBV	Stock	47.08	48.47	47.08	47.69	12298600.0
2014-01-28	ABC-DELISTED	Stock	66.74	67.89	66.61	67.71	1661879.0
2014-01-28	ABCB	Stock	20.18	20.44	20.01	20.38	88600.0
2014-01-28	ABCD-DELISTED	Stock	2.02	2.05	1.84	1.96	54415.0
2014-01-28	ABCO-DELISTED	Stock	63.14	64.19	62.97	63.86	271485.0
2014-01-28	ABE-DELISTED	Stock	12.41	12.41	12.33	12.34	11204.0
2014-01-28	ABEO	Stock	437.5	475.0	412.5	475.0	12.0
2014-01-28	ABEV	Stock	6.72	6.79	6.62	6.68	11416700.0
2014-01-28	ABFS-DELISTED	Stock	32.42	33.61	32.0225	33.1	318340.0
2014-01-28	ABG	Stock	46.83	47.44	46.08	46.86	377800.0
2014-01-28	ABGB-DELISTED	Stock	17.09	17.18	16.99	17.0701	15669.0
2014-01-28	ABM	Stock	27.05	27.16	26.9	27.1	179300.0
2014-01-28	ABMD-DELISTED	Stock	26.49	27.08	26.26	26.56	299857.0
2014-01-28	ABR	Stock	6.84	6.9	6.78	6.87	69300.0
2014-01-28	ABR.A-DELISTED	Stock	25.0	25.0471	25.0	25.0471	4100.0
2014-01-28	ABR.B-DELISTED	Stock	22.86	22.86	22.86	22.86	300.0
2014-01-28	ABT	Stock	36.54	36.87	36.28	36.37	7608200.0
2014-01-28	ABTL-DELISTED	Stock	15.69	16.9399	15.07	16.27	219446.0
2014-01-28	ABUS	Stock	11.65	12.08	11.57	12.06	78000.0

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

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