PREVIEW / stock_daily / 2014-01-30

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-30.parquet
  size:    217 KB
  rows:    6,449
  symbols: 3,527

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-30	AAPL	Stock	17.9479	18.0893	17.7393	17.8493	678501600.0
2014-01-30	MSFT	Stock	36.79	36.88	36.23	36.86	35036300.0
2014-01-30	NVDA	Stock	0.3888	0.3938	0.3875	0.393	202896000.0
2014-01-30	AMZN	Stock	19.6885	20.3125	19.385	20.1505	209478000.0
2014-01-30	META	Stock	62.12	62.5	60.46	61.08	150178900.0
2014-01-30	TSLA	Stock	11.8667	12.3187	11.8007	12.1893	128475000.0
2014-01-30	TLT	Stock	107.47	107.665	107.11	107.56	5956881.0
2014-01-30	ES	Stock	42.96	43.57	42.88	43.49	1428100.0
2014-01-30	CL	Stock	63.44	63.81	61.13	61.49	5456400.0
2014-01-30	A	Stock	41.7883	42.9971	41.7883	42.568	5232994.0
2014-01-30	AABA-DELISTED	Stock	34.89	35.81	34.45	35.305	30096963.0
2014-01-30	AACG	Stock	3.99	4.03	3.99	4.0	1400.0
2014-01-30	AAIC-DELISTED	Stock	26.29	26.55	26.0745	26.39	123743.0
2014-01-30	AAL	Stock	33.36	34.2	33.2	33.8	13660500.0
2014-01-30	AAMC-DELISTED	Stock	295.8676	297.0588	290.8265	295.5147	9132.0
2014-01-30	AAME	Stock	3.99	4.0	3.93	4.0	2000.0
2014-01-30	AAOI	Stock	13.67	14.41	13.67	14.0	72700.0
2014-01-30	AAON	Stock	13.8844	14.24	13.6133	13.7378	431325.0
2014-01-30	AAP	Stock	115.0	115.89	114.45	115.2	585800.0
2014-01-30	AAT	Stock	31.69	33.02	31.47	32.79	219500.0
2014-01-30	AAU-DELISTED	Stock	1.315	1.35	1.26	1.335	241669.0
2014-01-30	AAUAF-DELISTED	Stock	1.31	1.34	1.26	1.34	244514.0
2014-01-30	AAV-DELISTED	Stock	4.13	4.16	4.07	4.1	132840.0
2014-01-30	AAWW-DELISTED	Stock	35.7	35.85	35.43	35.63	200906.0
2014-01-30	AAXJ	Stock	56.18	56.338	55.91	56.02	1592073.0
2014-01-30	AAXN-DELISTED	Stock	16.12	16.52	16.0	16.3	969512.0
2014-01-30	AB	Stock	21.94	22.58	21.87	22.52	205100.0
2014-01-30	ABAC-DELISTED	Stock	1.9501	2.0	1.94	1.98	14190.0
2014-01-30	ABAX-DELISTED	Stock	39.1	39.76	37.57	38.0	829316.0
2014-01-30	ABB-DELISTED	Stock	25.22	25.25	25.02	25.14	1612685.0
2014-01-30	ABBNY-DELISTED	Stock	25.22	25.25	25.02	25.14	1787840.0
2014-01-30	ABBV	Stock	47.97	48.88	47.9	48.31	7669500.0
2014-01-30	ABC-DELISTED	Stock	67.65	68.145	67.65	67.75	1308785.0
2014-01-30	ABCB	Stock	20.04	20.78	20.03	20.5	147900.0
2014-01-30	ABCD-DELISTED	Stock	2.0054	2.0054	1.81	1.8499	9451.0
2014-01-30	ABCO-DELISTED	Stock	63.82	65.54	63.55	64.79	112527.0
2014-01-30	ABE-DELISTED	Stock	12.29	12.29	12.2	12.2349	11961.0
2014-01-30	ABEO	Stock	475.0	475.0	412.5	450.0	10.0
2014-01-30	ABEV	Stock	6.63	6.65	6.47	6.56	7069300.0
2014-01-30	ABFS-DELISTED	Stock	32.1	34.18	32.0	33.33	333095.0
2014-01-30	ABG	Stock	46.37	48.02	46.3	47.7	533400.0
2014-01-30	ABGB-DELISTED	Stock	17.11	17.11	16.681	16.81	800.0
2014-01-30	ABM	Stock	26.92	27.17	26.7	27.04	200600.0
2014-01-30	ABMD-DELISTED	Stock	29.49	29.49	26.57	26.9	538227.0
2014-01-30	ABR	Stock	6.87	6.94	6.82	6.85	95700.0
2014-01-30	ABR.A-DELISTED	Stock	24.9104	24.9104	24.9104	24.9104	250.0
2014-01-30	ABR.B-DELISTED	Stock	22.9499	22.95	22.9499	22.95	469.0
2014-01-30	ABT	Stock	36.24	36.62	36.14	36.53	9579800.0
2014-01-30	ABTL-DELISTED	Stock	15.1	16.4	15.098	15.51	275353.0
2014-01-30	ABUS	Stock	12.22	13.04	12.07	13.0	460400.0

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

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