PREVIEW / stock_daily / 2014-04-23

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-23.parquet
  size:    218 KB
  rows:    6,520
  symbols: 3,551

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-23	AAPL	Stock	18.895	18.9689	18.7304	18.7411	394940000.0
2014-04-23	MSFT	Stock	39.99	39.99	39.47	39.69	24602800.0
2014-04-23	NVDA	Stock	0.4725	0.4785	0.4718	0.4772	261580000.0
2014-04-23	AMZN	Stock	16.653	16.6565	16.1695	16.229	72092000.0
2014-04-23	GOOGL	Stock	27.1835	27.24	26.4064	26.8755	39186600.0
2014-04-23	META	Stock	63.45	63.48	61.26	61.36	95908700.0
2014-04-23	TSLA	Stock	14.422	14.4493	13.8	13.866	109434000.0
2014-04-23	TLT	Stock	110.6	111.05	110.53	110.96	5748971.0
2014-04-23	ES	Stock	45.89	46.57	45.87	46.1	1287300.0
2014-04-23	CL	Stock	66.38	66.57	65.8	65.87	3688200.0
2014-04-23	A	Stock	39.2346	39.485	39.0343	39.3491	1250092.0
2014-04-23	AABA-DELISTED	Stock	36.08	36.19	35.4	35.45	18072740.0
2014-04-23	AACG	Stock	3.93	4.09	3.91	3.93	67200.0
2014-04-23	AAIC-DELISTED	Stock	25.9	26.0694	25.86	25.97	113107.0
2014-04-23	AAL	Stock	37.14	37.6	36.4	37.09	14649500.0
2014-04-23	AAMC-DELISTED	Stock	289.4118	292.9411	286.1765	291.4735	48620.0
2014-04-23	AAME	Stock	3.46	3.61	3.46	3.54	17600.0
2014-04-23	AAOI	Stock	23.81	24.24	23.43	23.63	227600.0
2014-04-23	AAON	Stock	12.1867	12.4222	12.0356	12.32	383850.0
2014-04-23	AAP	Stock	121.4	123.09	120.56	122.15	592000.0
2014-04-23	AAT	Stock	33.7	34.02	33.29	33.92	169600.0
2014-04-23	AAU-DELISTED	Stock	1.33	1.41	1.33	1.39	80595.0
2014-04-23	AAUAF-DELISTED	Stock	1.33	1.41	1.33	1.39	81147.0
2014-04-23	AAV-DELISTED	Stock	5.9	5.96	5.796	5.92	470143.0
2014-04-23	AAWW-DELISTED	Stock	35.79	36.159	35.735	36.01	175032.0
2014-04-23	AAXJ	Stock	60.1	60.24	59.785	60.02	650071.0
2014-04-23	AAXN-DELISTED	Stock	18.24	18.595	18.17	18.26	814011.0
2014-04-23	AB	Stock	26.33	26.58	26.16	26.41	277400.0
2014-04-23	ABAC-DELISTED	Stock	2.25	2.25	2.16	2.179	71611.0
2014-04-23	ABAX-DELISTED	Stock	39.0	39.58	38.76	39.31	164714.0
2014-04-23	ABB-DELISTED	Stock	26.07	26.07	25.9	25.95	1244242.0
2014-04-23	ABBNY-DELISTED	Stock	26.07	26.07	25.9	25.96	1299172.0
2014-04-23	ABBV	Stock	50.14	50.26	49.39	50.14	6578300.0
2014-04-23	ABC-DELISTED	Stock	64.8	65.19	64.5	64.85	1220537.0
2014-04-23	ABCB	Stock	22.26	22.95	22.16	22.6	99400.0
2014-04-23	ABCD-DELISTED	Stock	2.19	2.2	2.13	2.17	19126.0
2014-04-23	ABCO-DELISTED	Stock	60.94	61.44	59.76	59.99	119501.0
2014-04-23	ABE-DELISTED	Stock	13.33	13.3301	13.28	13.32	8364.0
2014-04-23	ABEO	Stock	562.5	562.5	550.0	550.0	4.0
2014-04-23	ABEV	Stock	7.86	7.88	7.77	7.86	9331100.0
2014-04-23	ABFS-DELISTED	Stock	38.98	39.58	38.5	38.85	223034.0
2014-04-23	ABG	Stock	58.48	59.4	56.64	57.48	720700.0
2014-04-23	ABGB-DELISTED	Stock	23.13	23.54	23.13	23.51	43307.0
2014-04-23	ABM	Stock	27.83	28.05	27.55	27.55	181100.0
2014-04-23	ABMD-DELISTED	Stock	25.35	25.53	25.2	25.3	177428.0
2014-04-23	ABR	Stock	7.03	7.03	7.0	7.03	71700.0
2014-04-23	ABR.A-DELISTED	Stock	24.91	25.0999	24.9	24.98	8420.0
2014-04-23	ABR.B-DELISTED	Stock	23.34	23.52	23.34	23.5	20195.0
2014-04-23	ABR.C-DELISTED	Stock	25.1	25.239	25.0	25.239	29201.0
2014-04-23	ABT	Stock	38.73	38.82	38.52	38.6	3557500.0

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

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