PREVIEW / stock_daily / 2014-05-12

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-12.parquet
  size:    219 KB
  rows:    6,551
  symbols: 3,552

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-05-12	AAPL	Stock	20.9818	21.2021	20.9786	21.1725	213208800.0
2014-05-12	MSFT	Stock	39.74	40.02	39.65	39.97	22782600.0
2014-05-12	NVDA	Stock	0.4522	0.4655	0.452	0.4645	299856000.0
2014-05-12	AMZN	Stock	14.715	15.167	14.708	15.143	74592000.0
2014-05-12	GOOGL	Stock	26.592	26.9375	26.3755	26.9215	38985820.0
2014-05-12	META	Stock	57.98	59.9	57.98	59.83	48575000.0
2014-05-12	TSLA	Stock	12.258	12.4793	11.992	12.3113	105034500.0
2014-05-12	TLT	Stock	111.01	111.13	110.54	110.79	4564276.0
2014-05-12	ES	Stock	45.87	45.96	45.1	45.15	1617100.0
2014-05-12	CL	Stock	67.75	67.75	67.07	67.19	1690900.0
2014-05-12	A	Stock	39.7568	40.5007	39.6781	40.3505	2854856.0
2014-05-12	AABA-DELISTED	Stock	33.99	34.53	33.87	34.45	21898613.0
2014-05-12	AACG	Stock	4.38	4.5	4.33	4.4	31500.0
2014-05-12	AAIC-DELISTED	Stock	26.4	27.03	26.38	26.85	433162.0
2014-05-12	AAL	Stock	38.35	39.49	38.35	39.39	12438300.0
2014-05-12	AAMC-DELISTED	Stock	217.2	250.5882	208.8324	243.25	116515.0
2014-05-12	AAME	Stock	3.5	3.58	3.25	3.5	10600.0
2014-05-12	AAOI	Stock	17.57	17.64	17.08	17.44	276500.0
2014-05-12	AAON	Stock	13.7289	14.2711	13.6978	14.1956	227025.0
2014-05-12	AAP	Stock	124.79	125.66	124.26	125.25	755200.0
2014-05-12	AAT	Stock	34.59	34.64	34.29	34.3	248600.0
2014-05-12	AAU-DELISTED	Stock	1.3	1.34	1.3	1.32	79150.0
2014-05-12	AAUAF-DELISTED	Stock	1.3	1.34	1.3	1.32	79713.0
2014-05-12	AAV-DELISTED	Stock	5.92	6.12	5.79	5.85	683148.0
2014-05-12	AAWW-DELISTED	Stock	35.97	36.69	35.82	36.35	359979.0
2014-05-12	AAXJ	Stock	60.21	60.56	60.21	60.54	271161.0
2014-05-12	AAXN-DELISTED	Stock	13.6	14.31	13.5	14.07	1723200.0
2014-05-12	AB	Stock	23.43	23.75	23.05	23.69	261600.0
2014-05-12	ABAC-DELISTED	Stock	2.15	2.18	2.02	2.12	37139.0
2014-05-12	ABAX-DELISTED	Stock	40.97	41.92	40.37	41.5	91965.0
2014-05-12	ABB-DELISTED	Stock	23.77	23.85	23.71	23.82	1752910.0
2014-05-12	ABBNY-DELISTED	Stock	23.77	23.85	23.71	23.81	2859513.0
2014-05-12	ABBV	Stock	52.36	52.56	52.22	52.37	3626400.0
2014-05-12	ABC-DELISTED	Stock	65.98	66.72	65.87	66.66	1554588.0
2014-05-12	ABCB	Stock	20.71	21.22	20.51	20.98	62600.0
2014-05-12	ABCD-DELISTED	Stock	2.2	2.35	2.19	2.19	39926.0
2014-05-12	ABCO-DELISTED	Stock	50.46	53.34	50.3	52.56	274480.0
2014-05-12	ABDC-DELISTED	Stock	15.14	15.14	14.8154	15.0	32758.0
2014-05-12	ABE-DELISTED	Stock	13.76	13.867	13.76	13.8501	15882.0
2014-05-12	ABEO	Stock	525.0	600.0	525.0	600.0	25.0
2014-05-12	ABEV	Stock	7.45	7.5	7.44	7.49	8090300.0
2014-05-12	ABG	Stock	63.13	65.01	63.13	64.66	565900.0
2014-05-12	ABGB-DELISTED	Stock	22.29	22.94	22.29	22.86	3240.0
2014-05-12	ABIL-DELISTED	Stock	9.73	9.8	9.73	9.77	17648.0
2014-05-12	ABM	Stock	26.93	27.59	26.9	27.5	164100.0
2014-05-12	ABMD-DELISTED	Stock	21.74	22.07	21.54	21.91	225193.0
2014-05-12	ABR	Stock	7.06	7.18	7.06	7.16	159600.0
2014-05-12	ABR.A-DELISTED	Stock	25.294	25.294	25.28	25.28	1674.0
2014-05-12	ABR.B-DELISTED	Stock	24.106	24.18	23.98	24.18	37848.0
2014-05-12	ABR.C-DELISTED	Stock	25.33	25.33	25.23	25.25	17233.0

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

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