PREVIEW / stock_daily / 2014-05-27

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-27.parquet
  size:    220 KB
  rows:    6,577
  symbols: 3,572

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-27	AAPL	Stock	21.9957	22.3521	21.9868	22.3439	348866000.0
2014-05-27	MSFT	Stock	40.26	40.26	39.81	40.19	26160600.0
2014-05-27	NVDA	Stock	0.465	0.4705	0.4635	0.4705	209680000.0
2014-05-27	AMZN	Stock	15.7205	15.7315	15.369	15.541	97242000.0
2014-05-27	GOOGL	Stock	28.389	28.7435	28.2075	28.7435	43836560.0
2014-05-27	META	Stock	61.62	63.51	61.57	63.48	55682000.0
2014-05-27	TSLA	Stock	13.9013	14.258	13.8467	14.104	80116500.0
2014-05-27	TLT	Stock	112.85	113.4	112.4	113.36	6659270.0
2014-05-27	ES	Stock	45.56	45.67	45.18	45.22	1481700.0
2014-05-27	CL	Stock	66.89	66.94	66.52	66.71	3614400.0
2014-05-27	A	Stock	40.279	40.4149	40.0787	40.2575	1664459.0
2014-05-27	AABA-DELISTED	Stock	35.0	35.13	34.73	35.115	12422693.0
2014-05-27	AACG	Stock	4.8	4.99	4.61	4.99	65100.0
2014-05-27	AAIC-DELISTED	Stock	27.4	27.7	27.33	27.45	256750.0
2014-05-27	AAL	Stock	39.38	39.93	39.23	39.35	9586900.0
2014-05-27	AAMC-DELISTED	Stock	284.3059	290.8353	284.3059	286.6824	33521.0
2014-05-27	AAME	Stock	3.57	3.6	3.47	3.6	3300.0
2014-05-27	AAOI	Stock	18.78	19.38	18.56	19.1	81700.0
2014-05-27	AAON	Stock	13.9778	14.1022	13.8	14.0933	255375.0
2014-05-27	AAP	Stock	124.03	124.03	121.24	121.44	599200.0
2014-05-27	AAT	Stock	34.47	34.66	34.15	34.65	462000.0
2014-05-27	AAU-DELISTED	Stock	1.34	1.34	1.29	1.3	57377.0
2014-05-27	AAUAF-DELISTED	Stock	1.34	1.34	1.29	1.31	57897.0
2014-05-27	AAV-DELISTED	Stock	5.8	5.82	5.63	5.66	205643.0
2014-05-27	AAWW-DELISTED	Stock	36.88	37.26	36.37	37.07	140643.0
2014-05-27	AAXJ	Stock	61.98	61.99	61.59	61.75	381421.0
2014-05-27	AAXN-DELISTED	Stock	13.43	13.605	13.33	13.48	543692.0
2014-05-27	AB	Stock	23.62	24.04	23.55	23.87	373500.0
2014-05-27	ABAC-DELISTED	Stock	2.25	2.25	2.15	2.24	55226.0
2014-05-27	ABAX-DELISTED	Stock	41.85	42.52	41.85	42.15	140404.0
2014-05-27	ABB-DELISTED	Stock	23.93	23.96	23.75	23.87	1395714.0
2014-05-27	ABBNY-DELISTED	Stock	23.93	23.96	23.75	23.87	1841215.0
2014-05-27	ABBV	Stock	54.2	54.2	53.78	53.99	3816300.0
2014-05-27	ABC-DELISTED	Stock	71.76	72.41	71.71	72.405	1372154.0
2014-05-27	ABCB	Stock	21.0	21.5	21.0	21.31	46300.0
2014-05-27	ABCD-DELISTED	Stock	2.3287	2.34	2.21	2.25	31462.0
2014-05-27	ABCO-DELISTED	Stock	48.7	50.08	48.13	49.97	376380.0
2014-05-27	ABDC-DELISTED	Stock	15.0	15.0	14.8	14.86	10101.0
2014-05-27	ABE-DELISTED	Stock	14.11	14.11	14.0101	14.0897	4672.0
2014-05-27	ABEO	Stock	525.0	575.0	525.0	575.0	3.0
2014-05-27	ABEV	Stock	7.39	7.42	7.11	7.11	22785100.0
2014-05-27	ABG	Stock	64.6	65.6	64.18	64.88	312900.0
2014-05-27	ABGB-DELISTED	Stock	21.19	21.2999	21.06	21.21	5640.0
2014-05-27	ABIL-DELISTED	Stock	9.78	9.78	9.78	9.78	245.0
2014-05-27	ABM	Stock	27.44	27.79	27.38	27.48	85700.0
2014-05-27	ABMD-DELISTED	Stock	21.34	21.72	20.99	21.53	414710.0
2014-05-27	ABR	Stock	7.14	7.15	7.09	7.12	99000.0
2014-05-27	ABR.A-DELISTED	Stock	24.2499	24.2799	24.18	24.25	49025.0
2014-05-27	ABR.B-DELISTED	Stock	23.76	23.8	23.76	23.7601	2950.0
2014-05-27	ABR.C-DELISTED	Stock	24.87	24.89	24.83	24.8899	4380.0

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

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