PREVIEW / stock_daily / 2014-11-05

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-05.parquet
  size:    221 KB
  rows:    6,611
  symbols: 3,546

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-11-05	AAPL	Stock	27.275	27.325	27.0325	27.215	149743600.0
2014-11-05	MSFT	Stock	47.8	47.9	47.26	47.86	22449600.0
2014-11-05	NVDA	Stock	0.5062	0.5065	0.4995	0.5032	335652000.0
2014-11-05	AMZN	Stock	15.1505	15.2	14.708	14.826	93490000.0
2014-11-05	GOOGL	Stock	28.3395	28.345	27.7075	27.7975	32905280.0
2014-11-05	META	Stock	76.51	76.8	74.42	74.83	35913000.0
2014-11-05	TSLA	Stock	16.0667	16.0907	15.3687	15.398	135688500.0
2014-11-05	TLT	Stock	118.91	119.3699	118.82	119.16	4799628.0
2014-11-05	ES	Stock	49.7	50.86	49.62	50.83	2441900.0
2014-11-05	CL	Stock	68.81	68.81	67.88	68.15	2529900.0
2014-11-05	A	Stock	40.61	40.67	39.98	40.13	2341400.0
2014-11-05	AA.B-DELISTED	Stock	51.75	51.85	50.81	51.04	51998.0
2014-11-05	AABA-DELISTED	Stock	47.6	48.28	47.32	47.45	29666041.0
2014-11-05	AAC-DELISTED	Stock	21.82	22.0	21.0	21.011	39127.0
2014-11-05	AACG	Stock	4.0	4.14	4.0	4.14	6200.0
2014-11-05	AAIC-DELISTED	Stock	27.52	27.52	27.25	27.3	227506.0
2014-11-05	AAL	Stock	43.32	43.35	42.09	42.25	11528800.0
2014-11-05	AAMC-DELISTED	Stock	149.2647	149.2647	145.0	147.4176	33742.0
2014-11-05	AAME	Stock	3.77	3.82	3.5	3.8	20900.0
2014-11-05	AAMI	Stock	14.92	15.2	14.425	15.12	352100.0
2014-11-05	AAOI	Stock	15.82	16.09	15.3	15.85	169500.0
2014-11-05	AAON	Stock	13.6667	13.6667	13.3267	13.5133	260550.0
2014-11-05	AAP	Stock	149.27	149.84	148.56	149.37	1416400.0
2014-11-05	AAT	Stock	38.92	39.03	38.49	38.65	195700.0
2014-11-05	AAU-DELISTED	Stock	1.1336	1.134	1.03	1.04	376729.0
2014-11-05	AAUAF-DELISTED	Stock	1.09	1.09	0.99	1.04	393267.0
2014-11-05	AAV-DELISTED	Stock	4.08	4.28	4.06	4.26	177587.0
2014-11-05	AAVL-DELISTED	Stock	36.57	36.89	32.74	33.51	83817.0
2014-11-05	AAWW-DELISTED	Stock	37.65	37.75	36.29	37.17	225519.0
2014-11-05	AAXJ	Stock	62.17	62.17	61.81	62.13	349678.0
2014-11-05	AAXN-DELISTED	Stock	18.97	19.05	18.5301	18.57	1834904.0
2014-11-05	AB	Stock	26.25	26.25	26.01	26.12	172100.0
2014-11-05	ABAC-DELISTED	Stock	2.32	2.36	2.19	2.23	12641.0
2014-11-05	ABAX-DELISTED	Stock	53.72	54.48	53.256	54.47	163543.0
2014-11-05	ABB-DELISTED	Stock	22.07	22.16	21.96	22.12	1488614.0
2014-11-05	ABBNY-DELISTED	Stock	22.06	22.16	21.96	22.11	2673633.0
2014-11-05	ABBV	Stock	63.49	63.67	62.2	62.54	6465000.0
2014-11-05	ABC-DELISTED	Stock	88.83	89.23	87.61	87.78	1756731.0
2014-11-05	ABCB	Stock	24.7	25.36	24.61	24.7	127900.0
2014-11-05	ABCD-DELISTED	Stock	1.56	1.56	1.51	1.51	17900.0
2014-11-05	ABCO-DELISTED	Stock	53.93	54.4	53.9	54.31	120612.0
2014-11-05	ABCW-DELISTED	Stock	31.586	31.7175	31.0	31.005	5780.0
2014-11-05	ABDC-DELISTED	Stock	13.12	13.4899	12.872	12.96	14545.0
2014-11-05	ABE-DELISTED	Stock	14.05	14.06	13.93	14.06	14928.0
2014-11-05	ABEO	Stock	300.0	300.0	286.25	286.25	16.0
2014-11-05	ABEV	Stock	6.47	6.59	6.43	6.55	22282300.0
2014-11-05	ABG	Stock	69.66	71.08	69.66	70.89	348500.0
2014-11-05	ABGB-DELISTED	Stock	18.45	18.83	18.2199	18.82	35856.0
2014-11-05	ABM	Stock	27.27	27.54	27.04	27.2	141600.0
2014-11-05	ABMD-DELISTED	Stock	32.17	32.31	31.29	31.68	428863.0

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

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