PREVIEW / stock_daily / 2014-04-11

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-11.parquet
  size:    218 KB
  rows:    6,519
  symbols: 3,547

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-11	AAPL	Stock	18.5357	18.6725	18.4693	18.5575	271717600.0
2014-04-11	MSFT	Stock	39.0	39.79	39.0	39.21	34330200.0
2014-04-11	NVDA	Stock	0.456	0.463	0.447	0.453	353112000.0
2014-04-11	AMZN	Stock	15.7	15.825	15.475	15.5865	145750000.0
2014-04-11	GOOGL	Stock	26.897	27.3795	26.67	26.888	63509200.0
2014-04-11	META	Stock	57.6	60.31	57.31	58.53	91452000.0
2014-04-11	TSLA	Stock	13.374	13.8	13.24	13.5853	136008000.0
2014-04-11	TLT	Stock	110.54	110.79	110.13	110.73	10267141.0
2014-04-11	ES	Stock	45.44	45.81	45.31	45.44	1493700.0
2014-04-11	CL	Stock	65.76	66.27	65.25	65.31	4838300.0
2014-04-11	A	Stock	38.4049	38.6624	37.6609	37.7468	3623616.0
2014-04-11	AABA-DELISTED	Stock	32.64	33.4755	32.15	32.87	26917961.0
2014-04-11	AACG	Stock	4.04	4.1	4.03	4.09	27000.0
2014-04-11	AAIC-DELISTED	Stock	25.5	25.81	25.43	25.65	280660.0
2014-04-11	AAL	Stock	34.1	35.46	33.59	33.68	15532400.0
2014-04-11	AAMC-DELISTED	Stock	295.3382	305.8	280.1412	285.2882	78146.0
2014-04-11	AAME	Stock	3.53	3.53	3.47	3.52	16100.0
2014-04-11	AAOI	Stock	21.57	22.1	20.42	20.73	227600.0
2014-04-11	AAON	Stock	11.4267	11.7289	11.4	11.4089	246375.0
2014-04-11	AAP	Stock	117.29	118.69	116.15	116.25	823100.0
2014-04-11	AAT	Stock	32.72	33.13	32.16	32.67	130000.0
2014-04-11	AAU-DELISTED	Stock	1.43	1.44	1.36	1.3701	89646.0
2014-04-11	AAUAF-DELISTED	Stock	1.43	1.44	1.36	1.3701	90417.0
2014-04-11	AAV-DELISTED	Stock	5.39	5.46	5.36	5.39	442085.0
2014-04-11	AAWW-DELISTED	Stock	34.69	35.15	33.98	34.22	427830.0
2014-04-11	AAXJ	Stock	60.35	60.74	60.35	60.67	394672.0
2014-04-11	AAXN-DELISTED	Stock	16.16	17.17	16.16	16.74	1149928.0
2014-04-11	AB	Stock	24.92	25.2	24.58	25.03	295000.0
2014-04-11	ABAC-DELISTED	Stock	1.89	1.94	1.8201	1.91	64679.0
2014-04-11	ABAX-DELISTED	Stock	39.1	40.43	38.33	40.3975	177254.0
2014-04-11	ABB-DELISTED	Stock	25.49	25.7	25.452	25.52	1589895.0
2014-04-11	ABBNY-DELISTED	Stock	25.49	25.7	25.452	25.51	1684563.0
2014-04-11	ABBV	Stock	46.58	47.21	45.5	46.46	11465800.0
2014-04-11	ABC-DELISTED	Stock	64.53	65.25	63.86	64.18	2388712.0
2014-04-11	ABCB	Stock	22.31	22.69	22.28	22.43	66600.0
2014-04-11	ABCD-DELISTED	Stock	2.156	2.21	2.13	2.13	6306.0
2014-04-11	ABCO-DELISTED	Stock	60.17	61.82	57.72	57.75	298351.0
2014-04-11	ABE-DELISTED	Stock	13.39	13.4645	13.37	13.4	16223.0
2014-04-11	ABEO	Stock	575.0	600.0	562.5	600.0	40.0
2014-04-11	ABEV	Stock	7.58	7.82	7.54	7.8	13422900.0
2014-04-11	ABFS-DELISTED	Stock	36.26	37.09	36.08	36.14	249547.0
2014-04-11	ABG	Stock	54.16	54.48	52.98	53.15	356100.0
2014-04-11	ABGB-DELISTED	Stock	23.49	23.68	23.32	23.4	9055.0
2014-04-11	ABIL-DELISTED	Stock	9.65	9.65	9.64	9.64	804.0
2014-04-11	ABM	Stock	27.92	28.18	27.22	27.25	300500.0
2014-04-11	ABMD-DELISTED	Stock	23.63	24.18	23.2401	23.67	322383.0
2014-04-11	ABR	Stock	6.99	7.03	6.91	6.96	102800.0
2014-04-11	ABR.A-DELISTED	Stock	24.99	24.99	24.78	24.9899	2793.0
2014-04-11	ABR.B-DELISTED	Stock	22.9901	23.0	22.9901	23.0	1665.0
2014-04-11	ABR.C-DELISTED	Stock	24.85	24.85	24.85	24.85	802.0

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

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