PREVIEW / stock_daily / 2014-06-20

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-20.parquet
  size:    222 KB
  rows:    6,602
  symbols: 3,582

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-06-20	AAPL	Stock	22.9625	23.1375	22.725	22.7275	403592000.0
2014-06-20	MSFT	Stock	41.45	41.83	41.38	41.68	47764900.0
2014-06-20	NVDA	Stock	0.4798	0.4815	0.4695	0.4732	353148000.0
2014-06-20	AMZN	Stock	16.388	16.411	16.021	16.21	121080000.0
2014-06-20	GOOGL	Stock	28.3225	28.3385	27.9685	28.326	63242940.0
2014-06-20	META	Stock	64.46	64.81	63.35	64.5	46466000.0
2014-06-20	TSLA	Stock	15.2347	15.4193	15.08	15.306	73558500.0
2014-06-20	TLT	Stock	110.97	111.8	110.9	111.8	7319071.0
2014-06-20	ES	Stock	46.8	46.96	46.4	46.45	1984000.0
2014-06-20	CL	Stock	69.3	69.47	68.33	68.38	4035200.0
2014-06-20	A	Stock	41.3734	42.2461	41.3734	42.0386	2837101.0
2014-06-20	AABA-DELISTED	Stock	34.81	34.81	33.97	34.0201	20856478.0
2014-06-20	AACG	Stock	4.6	4.6	4.6	4.6	300.0
2014-06-20	AAIC-DELISTED	Stock	28.01	28.0499	27.85	27.92	351691.0
2014-06-20	AAL	Stock	43.04	44.55	43.03	44.55	40641900.0
2014-06-20	AAMC-DELISTED	Stock	322.7941	323.8235	320.7206	323.2412	76779.0
2014-06-20	AAME	Stock	3.94	3.94	3.88	3.9	8300.0
2014-06-20	AAOI	Stock	23.15	23.73	22.97	23.58	474500.0
2014-06-20	AAON	Stock	14.6667	14.8578	14.44	14.6889	746550.0
2014-06-20	AAP	Stock	129.4	129.91	127.89	129.8	828800.0
2014-06-20	AAT	Stock	34.69	34.77	34.2	34.34	523900.0
2014-06-20	AAU-DELISTED	Stock	1.5	1.52	1.45	1.47	479557.0
2014-06-20	AAUAF-DELISTED	Stock	1.5	1.52	1.45	1.47	481695.0
2014-06-20	AAV-DELISTED	Stock	7.0	7.01	6.83	6.92	348838.0
2014-06-20	AAWW-DELISTED	Stock	36.24	36.62	35.18	35.7	508751.0
2014-06-20	AAXJ	Stock	62.6	62.6	62.41	62.51	221878.0
2014-06-20	AAXN-DELISTED	Stock	13.74	14.25	13.57	13.86	1676101.0
2014-06-20	AB	Stock	25.92	26.0	25.09	25.5	768400.0
2014-06-20	ABAC-DELISTED	Stock	2.17	2.28	2.16	2.19	60867.0
2014-06-20	ABAX-DELISTED	Stock	43.68	44.32	43.275	44.16	165203.0
2014-06-20	ABB-DELISTED	Stock	23.17	23.24	23.12	23.23	1338224.0
2014-06-20	ABBNY-DELISTED	Stock	23.17	23.24	23.12	23.22	1505593.0
2014-06-20	ABBV	Stock	55.62	55.62	53.16	53.3	13457700.0
2014-06-20	ABC-DELISTED	Stock	72.17	72.46	71.91	72.25	2362870.0
2014-06-20	ABCB	Stock	21.87	21.88	21.53	21.63	103000.0
2014-06-20	ABCD-DELISTED	Stock	2.07	2.07	1.97	2.05	27238.0
2014-06-20	ABCO-DELISTED	Stock	52.46	52.61	50.6	51.34	404216.0
2014-06-20	ABDC-DELISTED	Stock	14.47	14.49	14.05	14.31	51411.0
2014-06-20	ABE-DELISTED	Stock	14.39	14.39	14.251	14.3	8260.0
2014-06-20	ABEO	Stock	400.0	400.0	400.0	400.0	98.0
2014-06-20	ABEV	Stock	7.08	7.14	7.05	7.13	7746600.0
2014-06-20	ABG	Stock	65.31	66.13	64.99	65.75	497300.0
2014-06-20	ABGB-DELISTED	Stock	29.29	29.3799	29.1	29.22	25130.0
2014-06-20	ABM	Stock	26.71	26.74	26.55	26.72	431900.0
2014-06-20	ABMD-DELISTED	Stock	23.52	23.78	23.16	23.39	303414.0
2014-06-20	ABR	Stock	7.08	7.15	7.02	7.02	235200.0
2014-06-20	ABR.A-DELISTED	Stock	24.459	24.459	24.25	24.3	14787.0
2014-06-20	ABR.B-DELISTED	Stock	23.97	23.98	23.9699	23.98	912.0
2014-06-20	ABR.C-DELISTED	Stock	25.04	25.11	25.04	25.05	900.0
2014-06-20	ABRN-DELISTED	Stock	24.89	24.97	24.85	24.95	5188.0

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

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