PREVIEW / stock_daily / 2014-04-29

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-29.parquet
  size:    218 KB
  rows:    6,526
  symbols: 3,555

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-29	AAPL	Stock	21.205	21.285	21.0539	21.1546	337377600.0
2014-04-29	MSFT	Stock	41.1	41.19	40.39	40.51	29636200.0
2014-04-29	NVDA	Stock	0.468	0.469	0.462	0.4673	171300000.0
2014-04-29	AMZN	Stock	14.822	15.092	14.5225	15.019	130186000.0
2014-04-29	GOOGL	Stock	26.1945	26.888	26.15	26.8165	50719340.0
2014-04-29	META	Stock	56.09	58.28	55.84	58.15	75557000.0
2014-04-29	TSLA	Stock	13.214	13.81	13.0353	13.7947	86686500.0
2014-04-29	TLT	Stock	110.17	110.73	110.04	110.64	5235169.0
2014-04-29	ES	Stock	47.33	47.6	46.97	47.11	2136500.0
2014-04-29	CL	Stock	67.75	67.82	67.03	67.04	4473600.0
2014-04-29	A	Stock	38.1187	38.3047	37.1745	38.1259	4688612.0
2014-04-29	AABA-DELISTED	Stock	34.37	35.89	34.12	35.82	26951118.0
2014-04-29	AACG	Stock	4.14	4.18	4.05	4.11	19200.0
2014-04-29	AAIC-DELISTED	Stock	25.77	26.32	25.77	26.11	404514.0
2014-04-29	AAL	Stock	35.2	35.65	34.97	35.51	8994200.0
2014-04-29	AAMC-DELISTED	Stock	275.5735	279.5706	269.7059	279.1176	93949.0
2014-04-29	AAME	Stock	3.49	3.57	3.46	3.55	18000.0
2014-04-29	AAOI	Stock	22.6	23.09	22.13	22.84	92800.0
2014-04-29	AAON	Stock	12.6533	12.7067	12.4044	12.4267	188550.0
2014-04-29	AAP	Stock	121.37	121.37	118.86	119.83	762900.0
2014-04-29	AAT	Stock	33.89	34.21	33.82	34.06	169000.0
2014-04-29	AAU-DELISTED	Stock	1.41	1.47	1.41	1.43	26006.0
2014-04-29	AAUAF-DELISTED	Stock	1.41	1.47	1.41	1.43	26441.0
2014-04-29	AAV-DELISTED	Stock	6.15	6.37	6.11	6.36	1791150.0
2014-04-29	AAWW-DELISTED	Stock	34.47	34.47	34.13	34.32	113519.0
2014-04-29	AAXJ	Stock	59.98	60.12	59.67	59.96	269453.0
2014-04-29	AAXN-DELISTED	Stock	16.84	17.2	16.62	17.07	899502.0
2014-04-29	AB	Stock	25.16	25.74	25.01	25.62	291900.0
2014-04-29	ABAC-DELISTED	Stock	2.0	2.0599	1.93	1.9801	21992.0
2014-04-29	ABAX-DELISTED	Stock	41.12	41.625	40.55	40.66	159256.0
2014-04-29	ABB-DELISTED	Stock	24.36	24.48	24.09	24.13	6206958.0
2014-04-29	ABBNY-DELISTED	Stock	24.36	24.48	24.09	24.12	6843678.0
2014-04-29	ABBV	Stock	50.94	51.53	50.76	51.37	5601300.0
2014-04-29	ABC-DELISTED	Stock	63.7	64.3	63.558	63.98	1582596.0
2014-04-29	ABCB	Stock	22.05	22.44	21.72	21.78	81900.0
2014-04-29	ABCD-DELISTED	Stock	2.33	2.33	2.2301	2.24	12818.0
2014-04-29	ABCO-DELISTED	Stock	57.34	58.1	54.74	57.47	121088.0
2014-04-29	ABE-DELISTED	Stock	13.44	13.495	13.41	13.49	9901.0
2014-04-29	ABEO	Stock	637.5	637.5	575.0	612.5	12.0
2014-04-29	ABEV	Stock	7.78	7.8	7.62	7.64	10633600.0
2014-04-29	ABFS-DELISTED	Stock	38.01	39.6796	36.8001	38.0	256279.0
2014-04-29	ABG	Stock	60.17	61.08	59.56	60.71	287900.0
2014-04-29	ABGB-DELISTED	Stock	22.25	22.5	21.87	22.21	14236.0
2014-04-29	ABIL-DELISTED	Stock	9.7	9.86	9.65	9.7	40588.0
2014-04-29	ABM	Stock	27.27	27.47	27.02	27.09	157500.0
2014-04-29	ABMD-DELISTED	Stock	24.03	24.39	23.451	23.95	203884.0
2014-04-29	ABR	Stock	7.02	7.03	6.94	6.98	115000.0
2014-04-29	ABR.A-DELISTED	Stock	25.0	25.15	24.99	25.15	2564.0
2014-04-29	ABR.B-DELISTED	Stock	23.95	24.18	23.9101	23.9874	4820.0
2014-04-29	ABR.C-DELISTED	Stock	25.24	25.52	25.226	25.3	59627.0

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

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