PREVIEW / stock_daily / 2014-09-24

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-24.parquet
  size:    221 KB
  rows:    6,615
  symbols: 3,566

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-24	AAPL	Stock	25.54	25.7125	25.3	25.4375	240687200.0
2014-09-24	MSFT	Stock	46.63	47.11	46.34	47.08	26582700.0
2014-09-24	NVDA	Stock	0.47	0.4745	0.4695	0.473	159592000.0
2014-09-24	AMZN	Stock	16.2085	16.472	15.978	16.4105	52844000.0
2014-09-24	GOOGL	Stock	29.5785	30.0055	29.515	29.921	35219060.0
2014-09-24	META	Stock	78.1	78.62	77.51	78.54	30680000.0
2014-09-24	TSLA	Stock	16.7413	16.856	16.4693	16.8093	56242500.0
2014-09-24	TLT	Stock	115.29	115.55	114.64	114.81	5223623.0
2014-09-24	ES	Stock	44.81	44.82	44.49	44.52	1058900.0
2014-09-24	CL	Stock	65.46	66.36	65.46	66.23	4024400.0
2014-09-24	A	Stock	40.6867	41.5165	40.6152	41.4592	2307399.0
2014-09-24	AA.B-DELISTED	Stock	49.11	49.7119	49.0	49.55	209264.0
2014-09-24	AABA-DELISTED	Stock	39.26	40.1	38.91	39.89	46766739.0
2014-09-24	AACG	Stock	4.5	4.5	4.48	4.5	7000.0
2014-09-24	AAIC-DELISTED	Stock	27.15	27.27	26.96	27.1	409799.0
2014-09-24	AAL	Stock	35.47	36.34	35.18	36.12	8487700.0
2014-09-24	AAMC-DELISTED	Stock	213.2	213.2	213.2	213.2	4726.0
2014-09-24	AAME	Stock	3.88	3.94	3.76	3.76	10900.0
2014-09-24	AAOI	Stock	17.16	17.9	17.0	17.77	167500.0
2014-09-24	AAON	Stock	11.9667	11.9667	11.78	11.8867	130050.0
2014-09-24	AAP	Stock	129.51	130.71	129.0	130.62	439400.0
2014-09-24	AAT	Stock	33.34	33.48	32.96	33.31	106800.0
2014-09-24	AAU-DELISTED	Stock	1.45	1.45	1.37	1.41	58449.0
2014-09-24	AAUAF-DELISTED	Stock	1.43	1.43	1.35	1.41	59923.0
2014-09-24	AAV-DELISTED	Stock	4.96	5.33	4.91	5.27	511735.0
2014-09-24	AAVL-DELISTED	Stock	33.75	34.7	32.34	34.0	82197.0
2014-09-24	AAWW-DELISTED	Stock	32.68	34.23	32.68	34.12	126487.0
2014-09-24	AAXJ	Stock	63.21	63.64	63.02	63.51	622627.0
2014-09-24	AAXN-DELISTED	Stock	16.16	16.37	15.95	16.08	1480884.0
2014-09-24	AB	Stock	27.22	27.34	26.9	27.11	154900.0
2014-09-24	ABAC-DELISTED	Stock	1.9	1.95	1.86	1.9131	13208.0
2014-09-24	ABAX-DELISTED	Stock	51.88	53.05	51.61	52.8	72194.0
2014-09-24	ABB-DELISTED	Stock	22.71	22.85	22.67	22.8	1158545.0
2014-09-24	ABBNY-DELISTED	Stock	22.71	22.85	22.67	22.8	1296982.0
2014-09-24	ABBV	Stock	57.66	59.35	57.61	59.05	15763800.0
2014-09-24	ABC-DELISTED	Stock	76.92	78.12	76.682	78.07	1564736.0
2014-09-24	ABCB	Stock	21.99	22.23	21.96	22.1	62600.0
2014-09-24	ABCD-DELISTED	Stock	1.41	1.535	1.41	1.53	29100.0
2014-09-24	ABCO-DELISTED	Stock	44.33	44.45	43.82	44.17	579140.0
2014-09-24	ABDC-DELISTED	Stock	13.67	13.75	13.5701	13.7	43730.0
2014-09-24	ABE-DELISTED	Stock	14.13	14.25	14.12	14.19	28293.0
2014-09-24	ABEO	Stock	375.0	412.5	325.0	387.5	65.0
2014-09-24	ABEV	Stock	6.74	6.92	6.68	6.88	12068000.0
2014-09-24	ABG	Stock	64.67	64.84	63.77	64.65	425300.0
2014-09-24	ABGB-DELISTED	Stock	26.86	27.1	26.75	26.94	21762.0
2014-09-24	ABM	Stock	26.79	27.06	26.56	27.02	171500.0
2014-09-24	ABMD-DELISTED	Stock	25.03	25.15	24.76	25.1	85931.0
2014-09-24	ABR	Stock	6.79	6.82	6.7	6.76	74000.0
2014-09-24	ABR.A-DELISTED	Stock	24.6	24.6	24.57	24.6	1944.0
2014-09-24	ABR.B-DELISTED	Stock	24.36	24.36	24.36	24.36	1834.0

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

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