PREVIEW / stock_daily / 2014-06-27

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-27.parquet
  size:    222 KB
  rows:    6,587
  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-06-27	AAPL	Stock	22.705	23.0	22.6925	22.995	256116000.0
2014-06-27	MSFT	Stock	41.61	42.29	41.51	42.25	74640000.0
2014-06-27	NVDA	Stock	0.4585	0.4622	0.4558	0.4595	302820000.0
2014-06-27	AMZN	Stock	16.294	16.326	16.1635	16.2285	48324000.0
2014-06-27	GOOGL	Stock	29.2725	29.394	29.131	29.2845	40442360.0
2014-06-27	META	Stock	67.31	67.7	66.84	67.6	46461000.0
2014-06-27	TSLA	Stock	15.646	16.0	15.6333	15.9373	84525000.0
2014-06-27	TLT	Stock	113.68	113.82	113.17	113.24	7216735.0
2014-06-27	ES	Stock	46.74	47.04	46.52	46.86	1637500.0
2014-06-27	CL	Stock	67.78	68.49	67.57	68.43	4109300.0
2014-06-27	A	Stock	41.1445	41.588	40.9013	41.1302	2123562.0
2014-06-27	AABA-DELISTED	Stock	33.85	34.55	33.7	34.25	24436013.0
2014-06-27	AACG	Stock	4.5	4.64	4.5	4.64	1900.0
2014-06-27	AAIC-DELISTED	Stock	27.15	27.38	27.03	27.34	243435.0
2014-06-27	AAL	Stock	44.3	44.75	43.91	44.0	41468300.0
2014-06-27	AAMC-DELISTED	Stock	248.5294	256.1559	231.9118	231.9118	578224.0
2014-06-27	AAME	Stock	3.94	3.94	3.93	3.94	2400.0
2014-06-27	AAOI	Stock	22.75	23.215	21.88	22.92	1636000.0
2014-06-27	AAON	Stock	14.4489	14.8622	14.4178	14.7822	353250.0
2014-06-27	AAP	Stock	130.5	133.51	130.5	133.48	1338000.0
2014-06-27	AAT	Stock	34.23	34.75	34.23	34.36	383800.0
2014-06-27	AAU-DELISTED	Stock	1.4	1.41	1.34	1.35	154888.0
2014-06-27	AAUAF-DELISTED	Stock	1.4	1.41	1.34	1.36	156605.0
2014-06-27	AAV-DELISTED	Stock	6.75	6.84	6.65	6.69	178145.0
2014-06-27	AAWW-DELISTED	Stock	36.04	36.85	36.04	36.65	346890.0
2014-06-27	AAXJ	Stock	62.35	62.68	62.32	62.64	1554319.0
2014-06-27	AAXN-DELISTED	Stock	13.22	13.42	13.13	13.37	581956.0
2014-06-27	AB	Stock	25.48	25.64	25.44	25.51	273000.0
2014-06-27	ABAC-DELISTED	Stock	2.08	2.1	2.02	2.08	42430.0
2014-06-27	ABAX-DELISTED	Stock	43.83	44.95	43.64	44.19	166080.0
2014-06-27	ABB-DELISTED	Stock	22.78	23.0	22.77	22.95	1251166.0
2014-06-27	ABBNY-DELISTED	Stock	22.78	23.0	22.77	22.95	1297288.0
2014-06-27	ABBV	Stock	56.58	56.9	56.28	56.79	7490800.0
2014-06-27	ABC-DELISTED	Stock	72.59	73.25	72.43	72.88	990602.0
2014-06-27	ABCB	Stock	21.3	21.68	21.27	21.58	172000.0
2014-06-27	ABCD-DELISTED	Stock	2.15	2.23	2.08	2.2	13668.0
2014-06-27	ABCO-DELISTED	Stock	50.53	50.92	49.98	50.55	253718.0
2014-06-27	ABDC-DELISTED	Stock	14.31	14.95	14.31	14.89	88227.0
2014-06-27	ABE-DELISTED	Stock	14.29	14.29	14.29	14.29	474.0
2014-06-27	ABEO	Stock	350.0	375.0	350.0	375.0	150.0
2014-06-27	ABEV	Stock	7.07	7.1	6.99	7.02	7448800.0
2014-06-27	ABG	Stock	66.28	68.29	66.28	68.01	352800.0
2014-06-27	ABGB-DELISTED	Stock	26.62	26.96	26.57	26.9	9804.0
2014-06-27	ABIL-DELISTED	Stock	9.79	9.86	9.77	9.79	20801.0
2014-06-27	ABM	Stock	26.27	26.74	26.24	26.71	267900.0
2014-06-27	ABMD-DELISTED	Stock	24.31	24.6	24.25	24.57	193801.0
2014-06-27	ABR	Stock	7.01	7.06	6.77	6.77	569100.0
2014-06-27	ABR.A-DELISTED	Stock	24.6799	24.6799	24.56	24.66	6840.0
2014-06-27	ABR.B-DELISTED	Stock	24.48	24.48	24.48	24.48	598.0
2014-06-27	ABR.C-DELISTED	Stock	25.102	25.102	25.07	25.09	1200.0

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

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