PREVIEW / stock_daily / 2014-09-29

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-29.parquet
  size:    222 KB
  rows:    6,651
  symbols: 3,588

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-09-29	AAPL	Stock	24.6625	25.11	24.6575	25.0275	199065200.0
2014-09-29	MSFT	Stock	45.98	46.56	45.76	46.44	26091000.0
2014-09-29	NVDA	Stock	0.46	0.4662	0.4555	0.463	208540000.0
2014-09-29	AMZN	Stock	16.025	16.1875	15.95	16.091	38492000.0
2014-09-29	GOOGL	Stock	29.0915	29.4655	29.0785	29.3905	22899640.0
2014-09-29	META	Stock	78.12	79.2	77.91	79.0	34031000.0
2014-09-29	TSLA	Stock	16.2667	16.576	16.092	16.3507	72790500.0
2014-09-29	TLT	Stock	117.0	117.165	116.66	116.93	6791793.0
2014-09-29	ES	Stock	44.21	44.44	44.0	44.31	1104400.0
2014-09-29	CL	Stock	65.41	65.69	65.19	65.63	3073900.0
2014-09-29	A	Stock	40.0858	40.9013	40.0	40.8798	2273987.0
2014-09-29	AA.B-DELISTED	Stock	49.62	49.98	49.43	49.59	115735.0
2014-09-29	AABA-DELISTED	Stock	40.41	41.09	40.16	40.53	33973411.0
2014-09-29	AACG	Stock	4.44	4.48	4.44	4.48	4200.0
2014-09-29	AAIC-DELISTED	Stock	26.2	26.27	25.92	26.1	288788.0
2014-09-29	AAL	Stock	35.35	35.75	34.94	35.03	7485000.0
2014-09-29	AAMC-DELISTED	Stock	205.8824	215.0029	205.8824	207.9059	30440.0
2014-09-29	AAME	Stock	3.94	3.98	3.82	3.98	9500.0
2014-09-29	AAOI	Stock	16.58	16.81	16.33	16.63	162900.0
2014-09-29	AAON	Stock	11.46	11.6867	11.34	11.66	136500.0
2014-09-29	AAP	Stock	128.3	130.94	128.3	130.64	574900.0
2014-09-29	AAT	Stock	33.3	33.59	33.13	33.58	113200.0
2014-09-29	AAU-DELISTED	Stock	1.39	1.39	1.35	1.35	101352.0
2014-09-29	AAUAF-DELISTED	Stock	1.39	1.39	1.34	1.34	102214.0
2014-09-29	AAV-DELISTED	Stock	5.05	5.26	5.03	5.23	291948.0
2014-09-29	AAVL-DELISTED	Stock	35.67	36.7	34.574	36.51	162014.0
2014-09-29	AAWW-DELISTED	Stock	33.51	34.19	33.27	33.9	173732.0
2014-09-29	AAXJ	Stock	61.47	61.57	61.26	61.41	572498.0
2014-09-29	AAXN-DELISTED	Stock	15.31	15.524	15.17	15.4	1769700.0
2014-09-29	AB	Stock	26.3	26.63	26.16	26.55	118200.0
2014-09-29	ABAC-DELISTED	Stock	1.92	2.05	1.85	2.03	71919.0
2014-09-29	ABAX-DELISTED	Stock	50.47	50.884	50.01	50.61	187800.0
2014-09-29	ABB-DELISTED	Stock	22.53	22.6076	22.45	22.52	1045645.0
2014-09-29	ABBNY-DELISTED	Stock	22.53	22.6076	22.45	22.52	1090178.0
2014-09-29	ABBV	Stock	58.14	58.83	57.94	58.52	7640400.0
2014-09-29	ABC-DELISTED	Stock	77.05	77.84	76.95	77.645	840908.0
2014-09-29	ABCB	Stock	21.98	22.14	21.9	22.06	90800.0
2014-09-29	ABCD-DELISTED	Stock	1.4901	1.54	1.4901	1.54	2300.0
2014-09-29	ABCO-DELISTED	Stock	44.64	46.25	44.41	46.25	358866.0
2014-09-29	ABDC-DELISTED	Stock	13.2	13.24	12.84	12.84	57494.0
2014-09-29	ABE-DELISTED	Stock	13.84	14.2499	13.84	13.9045	9332.0
2014-09-29	ABEO	Stock	387.5	412.5	337.5	375.0	15.0
2014-09-29	ABEV	Stock	6.47	6.6	6.43	6.57	27249000.0
2014-09-29	ABG	Stock	64.69	66.11	64.63	65.7	459800.0
2014-09-29	ABGB-DELISTED	Stock	26.25	26.3877	26.25	26.37	5067.0
2014-09-29	ABIL-DELISTED	Stock	9.7	9.79	9.7	9.7899	1600.0
2014-09-29	ABM	Stock	26.0	26.21	25.85	26.11	213400.0
2014-09-29	ABMD-DELISTED	Stock	24.76	25.32	24.76	25.05	148159.0
2014-09-29	ABR	Stock	6.67	6.72	6.64	6.7	141000.0
2014-09-29	ABR.A-DELISTED	Stock	24.55	24.5999	24.31	24.4499	16294.0

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

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