PREVIEW / stock_daily / 2014-11-10

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-10.parquet
  size:    222 KB
  rows:    6,633
  symbols: 3,563

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-10	AAPL	Stock	27.255	27.3325	27.1675	27.2075	108782000.0
2014-11-10	MSFT	Stock	48.65	49.15	48.55	48.89	36370100.0
2014-11-10	NVDA	Stock	0.4942	0.5038	0.493	0.5005	293388000.0
2014-11-10	AMZN	Stock	15.0	15.29	15.0	15.2555	56182000.0
2014-11-10	GOOGL	Stock	27.62	28.0315	27.581	27.9115	26089620.0
2014-11-10	META	Stock	75.36	75.48	74.61	75.0	21575100.0
2014-11-10	TSLA	Stock	15.9407	16.192	15.7867	16.1287	68658000.0
2014-11-10	TLT	Stock	119.58	119.58	118.56	118.65	4787298.0
2014-11-10	ES	Stock	50.55	50.92	50.11	50.73	1719100.0
2014-11-10	CL	Stock	67.92	68.56	67.82	68.55	2475000.0
2014-11-10	A	Stock	40.98	41.55	40.88	41.53	2583900.0
2014-11-10	AA.B-DELISTED	Stock	51.434	51.434	50.79	51.07	15187.0
2014-11-10	AABA-DELISTED	Stock	48.8	49.63	48.79	49.409	23595465.0
2014-11-10	AAC-DELISTED	Stock	25.71	27.31	24.67	26.48	74553.0
2014-11-10	AACG	Stock	4.03	4.03	3.96	3.96	11300.0
2014-11-10	AAIC-DELISTED	Stock	27.61	27.68	27.2501	27.51	222367.0
2014-11-10	AAL	Stock	42.5	43.94	41.68	43.83	13171000.0
2014-11-10	AAMC-DELISTED	Stock	153.95	158.8235	153.2353	157.9382	11723.0
2014-11-10	AAME	Stock	3.7	3.88	3.7	3.77	6800.0
2014-11-10	AAMI	Stock	15.65	15.8	15.39	15.45	221900.0
2014-11-10	AAOI	Stock	15.8	16.07	15.63	15.68	489300.0
2014-11-10	AAON	Stock	13.92	13.9933	13.8	13.8933	311250.0
2014-11-10	AAP	Stock	142.23	145.18	141.8	145.17	1164700.0
2014-11-10	AAT	Stock	38.46	38.71	38.43	38.67	151400.0
2014-11-10	AAU-DELISTED	Stock	1.05	1.07	1.02	1.07	107413.0
2014-11-10	AAUAF-DELISTED	Stock	1.05	1.07	1.02	1.069	109341.0
2014-11-10	AAV-DELISTED	Stock	4.87	5.01	4.58	4.6	281419.0
2014-11-10	AAVL-DELISTED	Stock	35.0	35.71	33.8	34.33	30953.0
2014-11-10	AAWW-DELISTED	Stock	41.54	42.07	40.83	41.74	278505.0
2014-11-10	AAXJ	Stock	62.73	62.73	62.31	62.34	538625.0
2014-11-10	AAXN-DELISTED	Stock	18.66	19.13	18.24	18.925	2922070.0
2014-11-10	AB	Stock	26.25	26.55	26.13	26.35	342700.0
2014-11-10	ABAC-DELISTED	Stock	2.2499	2.25	2.15	2.2399	46587.0
2014-11-10	ABAX-DELISTED	Stock	51.72	52.96	51.39	52.94	86806.0
2014-11-10	ABB-DELISTED	Stock	22.4	22.44	22.34	22.4	1088846.0
2014-11-10	ABBNY-DELISTED	Stock	22.4	22.44	22.34	22.39	1206575.0
2014-11-10	ABBV	Stock	61.99	64.06	61.87	63.79	9513000.0
2014-11-10	ABC-DELISTED	Stock	87.02	87.863	86.52	87.7	1098365.0
2014-11-10	ABCB	Stock	26.51	26.74	25.53	25.55	215200.0
2014-11-10	ABCD-DELISTED	Stock	1.66	2.1	1.66	1.8	45163.0
2014-11-10	ABCO-DELISTED	Stock	48.37	48.37	47.23	47.43	393040.0
2014-11-10	ABCW-DELISTED	Stock	31.253	31.338	29.41	29.81	4462.0
2014-11-10	ABDC-DELISTED	Stock	12.8	12.82	12.66	12.79	47321.0
2014-11-10	ABE-DELISTED	Stock	13.97	13.97	13.79	13.85	1758.0
2014-11-10	ABEO	Stock	220.0	220.0	205.0	212.5	100.0
2014-11-10	ABEV	Stock	6.49	6.51	6.37	6.39	6019000.0
2014-11-10	ABG	Stock	73.7	74.08	72.43	73.54	312400.0
2014-11-10	ABGB-DELISTED	Stock	18.72	18.73	18.3952	18.72	13574.0
2014-11-10	ABM	Stock	27.25	27.33	27.1	27.26	187900.0
2014-11-10	ABMD-DELISTED	Stock	32.05	33.0	32.0201	33.0	263805.0

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

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