PREVIEW / stock_daily / 2014-03-17

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-17.parquet
  size:    217 KB
  rows:    6,497
  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-03-17	AAPL	Stock	18.8464	18.9275	18.7804	18.8121	199544800.0
2014-03-17	MSFT	Stock	37.9	38.41	37.79	38.05	20479600.0
2014-03-17	NVDA	Stock	0.4468	0.45	0.445	0.4455	299656000.0
2014-03-17	AMZN	Stock	18.786	18.9425	18.744	18.752	46060000.0
2014-03-17	META	Stock	68.18	68.95	66.62	68.74	52197000.0
2014-03-17	TSLA	Stock	15.6633	15.862	15.3667	15.5987	88689000.0
2014-03-17	TLT	Stock	108.18	108.3	107.67	107.71	7382327.0
2014-03-17	ES	Stock	44.99	45.16	44.74	45.08	1082900.0
2014-03-17	CL	Stock	64.05	64.69	63.91	64.4	2838300.0
2014-03-17	A	Stock	39.8283	40.3505	39.6853	39.9142	2009625.0
2014-03-17	AABA-DELISTED	Stock	38.99	39.36	38.61	39.1	28415585.0
2014-03-17	AACG	Stock	4.19	4.49	4.11	4.43	43800.0
2014-03-17	AAIC-DELISTED	Stock	27.65	28.07	27.65	27.76	154829.0
2014-03-17	AAL	Stock	36.62	37.77	36.53	37.7	9235100.0
2014-03-17	AAMC-DELISTED	Stock	280.8029	329.4118	280.8029	307.3588	162622.0
2014-03-17	AAME	Stock	3.54	3.75	3.52	3.56	10100.0
2014-03-17	AAOI	Stock	25.55	26.5	25.12	25.75	119500.0
2014-03-17	AAON	Stock	12.4133	12.5778	12.0267	12.1289	325575.0
2014-03-17	AAP	Stock	125.61	126.5	124.86	126.3	607700.0
2014-03-17	AAT	Stock	33.11	33.42	32.99	33.26	108700.0
2014-03-17	AAU-DELISTED	Stock	1.56	1.5705	1.53	1.53	109398.0
2014-03-17	AAUAF-DELISTED	Stock	1.54	1.55	1.51	1.53	111869.0
2014-03-17	AAV-DELISTED	Stock	4.05	4.2	4.0	4.15	261153.0
2014-03-17	AAWW-DELISTED	Stock	32.08	32.32	31.84	32.01	157815.0
2014-03-17	AAXJ	Stock	57.2	57.51	57.2	57.32	299469.0
2014-03-17	AAXN-DELISTED	Stock	18.35	18.6	18.11	18.3	706309.0
2014-03-17	AB	Stock	24.15	25.41	24.1	24.82	872700.0
2014-03-17	ABAC-DELISTED	Stock	1.8	1.866	1.8	1.82	61788.0
2014-03-17	ABAX-DELISTED	Stock	38.43	38.97	38.25	38.75	43076.0
2014-03-17	ABB-DELISTED	Stock	24.91	25.12	24.91	24.97	1392214.0
2014-03-17	ABBNY-DELISTED	Stock	24.91	25.12	24.91	24.97	1488535.0
2014-03-17	ABBV	Stock	51.47	52.19	51.26	51.98	3875500.0
2014-03-17	ABC-DELISTED	Stock	67.73	68.18	67.64	68.07	1340406.0
2014-03-17	ABCB	Stock	23.76	24.07	23.56	23.93	89900.0
2014-03-17	ABCD-DELISTED	Stock	2.17	2.2	2.12	2.15	9895.0
2014-03-17	ABCO-DELISTED	Stock	67.4	67.78	66.83	67.28	121296.0
2014-03-17	ABE-DELISTED	Stock	12.45	12.71	12.45	12.58	12095.0
2014-03-17	ABEO	Stock	550.0	600.0	512.5	587.5	16.0
2014-03-17	ABEV	Stock	6.94	7.09	6.93	7.06	8147700.0
2014-03-17	ABFS-DELISTED	Stock	35.72	36.16	35.37	35.58	168990.0
2014-03-17	ABG	Stock	51.96	52.79	51.96	52.78	167900.0
2014-03-17	ABGB-DELISTED	Stock	22.31	22.642	22.31	22.642	3525.0
2014-03-17	ABIL-DELISTED	Stock	9.71	9.71	9.64	9.64	1000.0
2014-03-17	ABM	Stock	28.45	28.65	28.33	28.5	198100.0
2014-03-17	ABMD-DELISTED	Stock	26.09	26.34	25.42	25.6	508644.0
2014-03-17	ABR	Stock	6.74	6.78	6.7	6.76	149600.0
2014-03-17	ABR.A-DELISTED	Stock	24.35	24.35	24.346	24.35	1899.0
2014-03-17	ABR.B-DELISTED	Stock	22.96	22.97	22.96	22.97	403.0
2014-03-17	ABR.C-DELISTED	Stock	24.73	24.75	24.7	24.72	4313.0
2014-03-17	ABT	Stock	39.05	39.58	39.04	39.51	5768900.0

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

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