PREVIEW / stock_daily / 2014-04-15

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-15.parquet
  size:    219 KB
  rows:    6,527
  symbols: 3,545

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-04-15	AAPL	Stock	18.5811	18.63	18.2618	18.4986	266490000.0
2014-04-15	MSFT	Stock	39.34	39.96	39.05	39.75	33968700.0
2014-04-15	NVDA	Stock	0.4585	0.4638	0.454	0.4612	304636000.0
2014-04-15	AMZN	Stock	15.835	15.914	15.275	15.804	107972000.0
2014-04-15	GOOGL	Stock	27.55	27.6445	26.532	27.435	79996860.0
2014-04-15	META	Stock	59.29	59.68	55.88	59.09	108623000.0
2014-04-15	TSLA	Stock	13.2727	13.286	12.288	12.9273	204889500.0
2014-04-15	TLT	Stock	110.61	111.51	110.35	111.13	7752014.0
2014-04-15	ES	Stock	45.69	46.33	45.67	46.32	1657600.0
2014-04-15	CL	Stock	66.09	66.47	65.83	66.37	4172700.0
2014-04-15	A	Stock	37.7969	38.1688	37.1674	37.99	3037155.0
2014-04-15	AABA-DELISTED	Stock	33.93	34.28	32.64	34.21	48917204.0
2014-04-15	AACG	Stock	4.05	4.24	4.05	4.11	2100.0
2014-04-15	AAIC-DELISTED	Stock	25.37	25.5499	25.12	25.44	262418.0
2014-04-15	AAL	Stock	33.52	34.33	31.86	33.72	15979100.0
2014-04-15	AAMC-DELISTED	Stock	280.2941	281.2329	270.5882	278.2353	53819.0
2014-04-15	AAME	Stock	3.5	3.54	3.5	3.54	4900.0
2014-04-15	AAOI	Stock	21.51	21.7	20.84	21.51	206800.0
2014-04-15	AAON	Stock	11.76	11.7778	11.3111	11.5067	206775.0
2014-04-15	AAP	Stock	117.41	118.49	115.86	117.54	539400.0
2014-04-15	AAT	Stock	32.82	33.15	32.42	33.11	197200.0
2014-04-15	AAU-DELISTED	Stock	1.31	1.355	1.29	1.35	254353.0
2014-04-15	AAUAF-DELISTED	Stock	1.31	1.355	1.29	1.35	259005.0
2014-04-15	AAV-DELISTED	Stock	5.48	5.61	5.4	5.46	429826.0
2014-04-15	AAWW-DELISTED	Stock	34.62	34.83	34.13	34.73	293618.0
2014-04-15	AAXJ	Stock	60.48	60.51	59.58	60.25	376013.0
2014-04-15	AAXN-DELISTED	Stock	16.86	17.57	16.78	17.31	1145410.0
2014-04-15	AB	Stock	25.25	25.4	24.76	25.21	231500.0
2014-04-15	ABAC-DELISTED	Stock	1.95	2.15	1.95	2.029	70015.0
2014-04-15	ABAX-DELISTED	Stock	39.17	39.45	37.37	38.41	80566.0
2014-04-15	ABB-DELISTED	Stock	25.41	25.535	25.18	25.49	1729341.0
2014-04-15	ABBNY-DELISTED	Stock	25.41	25.535	25.18	25.49	1803207.0
2014-04-15	ABBV	Stock	47.42	48.09	46.76	47.86	9531100.0
2014-04-15	ABC-DELISTED	Stock	64.56	64.91	63.23	64.22	1855255.0
2014-04-15	ABCB	Stock	22.46	22.74	21.95	22.35	40800.0
2014-04-15	ABCD-DELISTED	Stock	2.15	2.15	2.08	2.13	9975.0
2014-04-15	ABCO-DELISTED	Stock	59.56	60.05	57.62	59.76	167752.0
2014-04-15	ABE-DELISTED	Stock	13.4	13.43	13.1901	13.29	10887.0
2014-04-15	ABEO	Stock	575.0	575.0	575.0	575.0	10.0
2014-04-15	ABEV	Stock	7.74	7.76	7.53	7.7	10131800.0
2014-04-15	ABFS-DELISTED	Stock	36.08	36.74	35.0933	36.08	197782.0
2014-04-15	ABG	Stock	53.65	54.45	52.88	53.79	292700.0
2014-04-15	ABGB-DELISTED	Stock	23.5	23.5	20.8852	21.25	11813.0
2014-04-15	ABIL-DELISTED	Stock	9.63	9.67	9.6	9.63	1800.0
2014-04-15	ABM	Stock	27.16	27.34	26.66	26.97	177600.0
2014-04-15	ABMD-DELISTED	Stock	24.17	24.53	23.7	24.28	381422.0
2014-04-15	ABR	Stock	6.85	6.94	6.77	6.85	79500.0
2014-04-15	ABR.A-DELISTED	Stock	24.812	24.9796	24.812	24.9796	598.0
2014-04-15	ABR.B-DELISTED	Stock	23.0999	23.19	23.0999	23.13	6550.0
2014-04-15	ABR.C-DELISTED	Stock	24.849	24.9	24.8399	24.8499	4561.0

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

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