PREVIEW / stock_daily / 2014-09-23

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-23.parquet
  size:    222 KB
  rows:    6,642
  symbols: 3,581

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-23	AAPL	Stock	25.15	25.735	25.135	25.66	253608800.0
2014-09-23	MSFT	Stock	46.85	46.98	46.47	46.56	33430300.0
2014-09-23	NVDA	Stock	0.4698	0.4755	0.468	0.4702	196144000.0
2014-09-23	AMZN	Stock	16.123	16.38	16.0625	16.1815	47052000.0
2014-09-23	GOOGL	Stock	29.75	29.8325	29.512	29.559	28101560.0
2014-09-23	META	Stock	76.33	78.63	76.04	78.29	36814000.0
2014-09-23	TSLA	Stock	16.348	16.92	16.3333	16.694	84880500.0
2014-09-23	TLT	Stock	114.91	115.47	114.77	115.45	6365250.0
2014-09-23	ES	Stock	44.9	44.95	44.65	44.69	1127300.0
2014-09-23	CL	Stock	65.46	65.84	65.35	65.4	3138500.0
2014-09-23	A	Stock	40.9514	41.1159	40.7082	40.7582	2281955.0
2014-09-23	AABA-DELISTED	Stock	38.15	39.27	37.9	39.04	63464740.0
2014-09-23	AACG	Stock	4.48	4.5	4.31	4.49	3900.0
2014-09-23	AAIC-DELISTED	Stock	27.34	27.38	27.0506	27.13	307326.0
2014-09-23	AAL	Stock	35.04	35.77	34.64	35.33	12146800.0
2014-09-23	AAMC-DELISTED	Stock	211.4853	220.0353	208.8235	208.8235	23681.0
2014-09-23	AAME	Stock	3.82	3.96	3.76	3.79	4700.0
2014-09-23	AAOI	Stock	17.02	17.35	16.9	17.1	169200.0
2014-09-23	AAON	Stock	11.96	12.0133	11.8467	11.8933	226050.0
2014-09-23	AAP	Stock	130.7	131.28	129.09	129.12	595600.0
2014-09-23	AAT	Stock	33.4	33.49	33.19	33.21	220500.0
2014-09-23	AAU-DELISTED	Stock	1.44	1.4503	1.4	1.43	75139.0
2014-09-23	AAUAF-DELISTED	Stock	1.42	1.43	1.38	1.43	76939.0
2014-09-23	AAV-DELISTED	Stock	5.03	5.23	4.95	4.97	663860.0
2014-09-23	AAVL-DELISTED	Stock	33.77	33.835	32.1	33.38	133486.0
2014-09-23	AAWW-DELISTED	Stock	34.7	34.97	34.2	34.23	126420.0
2014-09-23	AAXJ	Stock	62.86	63.07	62.68	62.7	794716.0
2014-09-23	AAXN-DELISTED	Stock	15.68	16.07	15.68	15.81	1187862.0
2014-09-23	AB	Stock	27.05	27.36	26.81	27.22	187100.0
2014-09-23	ABAC-DELISTED	Stock	1.91	1.95	1.85	1.95	54028.0
2014-09-23	ABAX-DELISTED	Stock	52.48	52.59	52.08	52.13	196910.0
2014-09-23	ABB-DELISTED	Stock	23.0	23.08	22.91	22.96	1624457.0
2014-09-23	ABBNY-DELISTED	Stock	23.0	23.08	22.9	22.97	4285018.0
2014-09-23	ABBV	Stock	56.8	58.27	56.6	57.56	24204400.0
2014-09-23	ABC-DELISTED	Stock	76.72	77.15	76.43	76.8	1049833.0
2014-09-23	ABCB	Stock	21.88	22.15	21.82	21.99	83200.0
2014-09-23	ABCD-DELISTED	Stock	1.46	1.5	1.45	1.477	10100.0
2014-09-23	ABCO-DELISTED	Stock	45.79	45.86	44.31	44.33	449347.0
2014-09-23	ABDC-DELISTED	Stock	13.55	13.75	13.4256	13.6	27161.0
2014-09-23	ABE-DELISTED	Stock	14.1	14.209	14.05	14.05	13095.0
2014-09-23	ABEO	Stock	300.0	375.0	300.0	375.0	9.0
2014-09-23	ABEV	Stock	6.8	6.86	6.7	6.78	12854500.0
2014-09-23	ABG	Stock	66.25	67.36	64.42	64.46	866800.0
2014-09-23	ABGB-DELISTED	Stock	27.21	27.409	27.189	27.28	11133.0
2014-09-23	ABIL-DELISTED	Stock	9.74	9.74	9.74	9.74	176000.0
2014-09-23	ABM	Stock	27.0	27.16	26.67	26.69	188500.0
2014-09-23	ABMD-DELISTED	Stock	24.85	25.24	24.85	24.93	117332.0
2014-09-23	ABR	Stock	6.66	6.81	6.66	6.76	180100.0
2014-09-23	ABR.A-DELISTED	Stock	24.673	24.689	24.6	24.6099	4840.0
2014-09-23	ABR.B-DELISTED	Stock	24.16	24.39	24.16	24.28	6528.0

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

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