PREVIEW / stock_daily / 2014-04-16

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-16.parquet
  size:    218 KB
  rows:    6,522
  symbols: 3,545

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-04-16	AAPL	Stock	18.5018	18.6104	18.3621	18.5361	214765600.0
2014-04-16	MSFT	Stock	40.06	40.42	39.91	40.4	30615800.0
2014-04-16	NVDA	Stock	0.4635	0.464	0.4565	0.4622	235136000.0
2014-04-16	AMZN	Stock	16.0585	16.2	15.7355	16.184	85698000.0
2014-04-16	GOOGL	Stock	27.885	28.2	27.655	28.195	91770820.0
2014-04-16	META	Stock	59.79	60.19	57.74	59.72	78774000.0
2014-04-16	TSLA	Stock	13.1333	13.3327	12.7213	13.274	108033000.0
2014-04-16	TLT	Stock	110.43	111.27	110.384	111.27	5523220.0
2014-04-16	ES	Stock	46.46	46.63	46.28	46.54	1373800.0
2014-04-16	CL	Stock	66.57	67.4	66.41	67.18	3575800.0
2014-04-16	A	Stock	38.3047	38.4621	38.0901	38.3977	1738413.0
2014-04-16	AABA-DELISTED	Stock	36.99	37.3	35.81	36.33	59330053.0
2014-04-16	AACG	Stock	4.12	4.17	4.12	4.12	26300.0
2014-04-16	AAIC-DELISTED	Stock	25.53	25.99	25.4404	25.91	222505.0
2014-04-16	AAL	Stock	34.17	35.59	33.94	35.51	15634200.0
2014-04-16	AAMC-DELISTED	Stock	279.4118	280.1941	267.6794	276.4706	84963.0
2014-04-16	AAME	Stock	3.55	3.55	3.49	3.53	6200.0
2014-04-16	AAOI	Stock	21.5	22.97	21.25	22.7	121200.0
2014-04-16	AAON	Stock	11.6222	11.7956	11.4622	11.6622	166275.0
2014-04-16	AAP	Stock	118.45	119.58	117.76	119.51	542200.0
2014-04-16	AAT	Stock	33.28	33.49	32.93	33.31	80400.0
2014-04-16	AAU-DELISTED	Stock	1.32	1.3297	1.27	1.29	95431.0
2014-04-16	AAUAF-DELISTED	Stock	1.32	1.3297	1.27	1.29	96002.0
2014-04-16	AAV-DELISTED	Stock	5.48	5.6701	5.45	5.615	362048.0
2014-04-16	AAWW-DELISTED	Stock	34.88	35.1982	34.57	34.93	253711.0
2014-04-16	AAXJ	Stock	60.56	60.79	60.35	60.74	348337.0
2014-04-16	AAXN-DELISTED	Stock	17.48	17.83	17.27	17.775	1064594.0
2014-04-16	AB	Stock	25.32	25.6	25.16	25.57	229100.0
2014-04-16	ABAC-DELISTED	Stock	2.03	2.03	1.9	1.95	42042.0
2014-04-16	ABAX-DELISTED	Stock	38.58	39.102	38.14	38.61	69591.0
2014-04-16	ABB-DELISTED	Stock	25.51	25.65	25.37	25.64	1490726.0
2014-04-16	ABBNY-DELISTED	Stock	25.51	25.65	25.37	25.63	1567506.0
2014-04-16	ABBV	Stock	48.58	48.84	47.62	48.12	7151000.0
2014-04-16	ABC-DELISTED	Stock	64.87	65.14	64.3	64.96	1227860.0
2014-04-16	ABCB	Stock	22.59	22.74	22.09	22.35	46600.0
2014-04-16	ABCD-DELISTED	Stock	2.1	2.18	2.1	2.165	28170.0
2014-04-16	ABCO-DELISTED	Stock	60.29	60.75	59.21	60.7	174712.0
2014-04-16	ABE-DELISTED	Stock	13.24	13.4	13.24	13.33	11961.0
2014-04-16	ABEO	Stock	537.5	575.0	537.5	575.0	10.0
2014-04-16	ABEV	Stock	7.75	7.76	7.65	7.73	9579300.0
2014-04-16	ABFS-DELISTED	Stock	36.37	37.27	36.17	37.25	129048.0
2014-04-16	ABG	Stock	54.26	55.15	54.17	54.88	164600.0
2014-04-16	ABGB-DELISTED	Stock	21.86	22.1399	21.7501	21.94	8641.0
2014-04-16	ABIL-DELISTED	Stock	9.7	9.85	9.63	9.63	51857.0
2014-04-16	ABM	Stock	27.14	27.33	27.03	27.28	139700.0
2014-04-16	ABMD-DELISTED	Stock	24.54	24.9	24.15	24.47	224939.0
2014-04-16	ABR	Stock	6.86	6.97	6.83	6.97	52500.0
2014-04-16	ABR.A-DELISTED	Stock	24.99	25.0099	24.96	24.99	8755.0
2014-04-16	ABR.B-DELISTED	Stock	23.23	23.35	23.16	23.34	28734.0
2014-04-16	ABR.C-DELISTED	Stock	24.85	24.9	24.81	24.85	13860.0

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

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