PREVIEW / stock_daily / 2014-09-12

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-12.parquet
  size:    221 KB
  rows:    6,626
  symbols: 3,579

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-09-12	AAPL	Stock	25.3025	25.5475	25.27	25.415	250504400.0
2014-09-12	MSFT	Stock	46.91	47.02	46.6	46.7	38244700.0
2014-09-12	NVDA	Stock	0.4883	0.4883	0.4775	0.478	262536000.0
2014-09-12	AMZN	Stock	16.478	16.6445	16.4395	16.5595	68586000.0
2014-09-12	GOOGL	Stock	29.5195	29.574	29.164	29.245	37045420.0
2014-09-12	META	Stock	78.02	78.3	77.1	77.48	26676800.0
2014-09-12	TSLA	Stock	18.7	18.826	18.4667	18.6133	49869000.0
2014-09-12	TLT	Stock	113.69	113.92	113.22	113.38	11115097.0
2014-09-12	ES	Stock	45.22	45.22	44.47	44.57	1315800.0
2014-09-12	CL	Stock	64.18	64.56	64.08	64.48	3230400.0
2014-09-12	A	Stock	41.2089	41.9385	41.2089	41.917	3621379.0
2014-09-12	AABA-DELISTED	Stock	41.73	43.2	41.5	42.89	67370869.0
2014-09-12	AACG	Stock	4.51	4.6	4.5	4.5	8000.0
2014-09-12	AAIC-DELISTED	Stock	27.56	27.65	26.97	27.08	437966.0
2014-09-12	AAL	Stock	38.09	38.51	37.63	37.65	8229200.0
2014-09-12	AAMC-DELISTED	Stock	206.5353	206.7824	204.4118	204.4324	42786.0
2014-09-12	AAME	Stock	3.99	3.99	3.93	3.93	2300.0
2014-09-12	AAOI	Stock	18.93	19.17	18.25	18.9	321900.0
2014-09-12	AAON	Stock	12.58	12.6067	12.2467	12.3333	170400.0
2014-09-12	AAP	Stock	134.76	135.24	133.25	133.86	533400.0
2014-09-12	AAT	Stock	34.7	34.73	33.6	33.76	156500.0
2014-09-12	AAU-DELISTED	Stock	1.51	1.64	1.5	1.58	535780.0
2014-09-12	AAUAF-DELISTED	Stock	1.51	1.64	1.5	1.58	538607.0
2014-09-12	AAV-DELISTED	Stock	5.66	5.69	5.54	5.56	233490.0
2014-09-12	AAVL-DELISTED	Stock	32.51	36.783	31.29	35.65	245965.0
2014-09-12	AAWW-DELISTED	Stock	36.45	36.63	35.83	36.51	340843.0
2014-09-12	AAXJ	Stock	64.91	64.91	64.4008	64.57	272272.0
2014-09-12	AAXN-DELISTED	Stock	18.29	18.7	17.87	18.42	4837744.0
2014-09-12	AB	Stock	27.0	27.6	27.0	27.5	398900.0
2014-09-12	ABAC-DELISTED	Stock	1.44	1.69	1.44	1.65	72675.0
2014-09-12	ABAX-DELISTED	Stock	50.67	50.7215	49.44	50.32	176613.0
2014-09-12	ABB-DELISTED	Stock	22.88	22.96	22.845	22.9	864785.0
2014-09-12	ABBNY-DELISTED	Stock	22.88	22.96	22.845	22.89	962158.0
2014-09-12	ABBV	Stock	57.85	58.77	57.74	57.88	15556200.0
2014-09-12	ABC-DELISTED	Stock	77.35	77.6	76.61	77.09	1097810.0
2014-09-12	ABCB	Stock	23.12	23.31	22.73	23.0	49800.0
2014-09-12	ABCD-DELISTED	Stock	1.55	1.58	1.55	1.56	6996.0
2014-09-12	ABCO-DELISTED	Stock	49.7	51.11	49.43	50.04	623888.0
2014-09-12	ABDC-DELISTED	Stock	13.8	13.91	13.7001	13.81	77764.0
2014-09-12	ABE-DELISTED	Stock	14.5041	14.54	14.3488	14.54	19300.0
2014-09-12	ABEO	Stock	387.5	387.5	387.5	387.5	4.0
2014-09-12	ABEV	Stock	6.72	6.82	6.6	6.64	26422800.0
2014-09-12	ABG	Stock	68.8	68.8	66.73	67.11	406900.0
2014-09-12	ABGB-DELISTED	Stock	27.98	27.98	27.54	27.73	17395.0
2014-09-12	ABIL-DELISTED	Stock	9.8	9.8	9.78	9.79	500.0
2014-09-12	ABM	Stock	28.01	28.03	27.54	27.76	171200.0
2014-09-12	ABMD-DELISTED	Stock	25.22	25.42	24.99	25.13	178943.0
2014-09-12	ABR	Stock	6.8	6.88	6.8	6.83	397100.0
2014-09-12	ABR.A-DELISTED	Stock	24.74	24.74	24.49	24.509	13779.0
2014-09-12	ABR.B-DELISTED	Stock	23.7	23.85	23.7	23.83	7477.0

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

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