PREVIEW / stock_daily / 2014-04-10

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-10.parquet
  size:    219 KB
  rows:    6,531
  symbols: 3,553

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-10	AAPL	Stock	18.9529	19.0086	18.6846	18.6957	239652000.0
2014-04-10	MSFT	Stock	40.44	40.69	39.09	39.36	45960800.0
2014-04-10	NVDA	Stock	0.469	0.4755	0.458	0.4595	372748000.0
2014-04-10	AMZN	Stock	16.53	16.55	15.825	15.8555	122534000.0
2014-04-10	GOOGL	Stock	28.4	28.4105	27.275	27.3345	65939920.0
2014-04-10	META	Stock	63.08	63.18	58.68	59.16	114988000.0
2014-04-10	TSLA	Stock	14.4547	14.5	13.586	13.6127	108172500.0
2014-04-10	TLT	Stock	108.92	110.22	108.9	109.84	12706388.0
2014-04-10	ES	Stock	45.76	45.91	45.23	45.39	1232400.0
2014-04-10	CL	Stock	65.59	66.31	65.39	65.94	6901000.0
2014-04-10	A	Stock	39.7496	39.7997	38.5551	38.6624	2749027.0
2014-04-10	AABA-DELISTED	Stock	34.88	34.98	33.09	33.41	32490098.0
2014-04-10	AACG	Stock	4.09	4.29	4.04	4.08	36700.0
2014-04-10	AAIC-DELISTED	Stock	25.79	26.04	25.53	25.53	154579.0
2014-04-10	AAL	Stock	36.7	37.38	34.6	35.29	16311400.0
2014-04-10	AAMC-DELISTED	Stock	304.4121	311.1765	296.1618	301.8529	57678.0
2014-04-10	AAME	Stock	3.58	3.58	3.58	3.58	1300.0
2014-04-10	AAOI	Stock	23.0	23.13	21.26	21.79	394100.0
2014-04-10	AAON	Stock	11.8	11.9822	11.4533	11.5422	228375.0
2014-04-10	AAP	Stock	122.63	124.62	118.61	118.61	702900.0
2014-04-10	AAT	Stock	33.56	33.7	32.87	32.98	137800.0
2014-04-10	AAU-DELISTED	Stock	1.43	1.46	1.42	1.44	70090.0
2014-04-10	AAUAF-DELISTED	Stock	1.43	1.46	1.42	1.44	70760.0
2014-04-10	AAV-DELISTED	Stock	5.22	5.49	5.21	5.44	436469.0
2014-04-10	AAWW-DELISTED	Stock	34.88	35.4	34.67	34.7	289173.0
2014-04-10	AAXJ	Stock	61.28	61.42	60.67	60.8	1664407.0
2014-04-10	AAXN-DELISTED	Stock	17.41	17.41	16.2	16.44	899890.0
2014-04-10	AB	Stock	25.56	25.6	24.98	25.14	718600.0
2014-04-10	ABAC-DELISTED	Stock	1.88	2.0	1.8201	1.8201	44602.0
2014-04-10	ABAX-DELISTED	Stock	41.37	41.88	39.11	39.24	114289.0
2014-04-10	ABB-DELISTED	Stock	26.04	26.05	25.55	25.6	1757857.0
2014-04-10	ABBNY-DELISTED	Stock	26.04	26.05	25.55	25.58	1876837.0
2014-04-10	ABBV	Stock	50.08	50.27	47.29	47.35	13177200.0
2014-04-10	ABC-DELISTED	Stock	65.91	66.18	64.74	65.0	1898560.0
2014-04-10	ABCB	Stock	23.11	23.25	22.39	22.56	88800.0
2014-04-10	ABCD-DELISTED	Stock	2.17	2.23	2.11	2.13	18400.0
2014-04-10	ABCO-DELISTED	Stock	62.69	63.6	60.14	60.7	124386.0
2014-04-10	ABE-DELISTED	Stock	13.5	13.53	13.41	13.43	6192.0
2014-04-10	ABEO	Stock	587.5	637.5	575.0	637.5	28.0
2014-04-10	ABEV	Stock	7.6	7.72	7.55	7.64	11181800.0
2014-04-10	ABFS-DELISTED	Stock	37.06	37.16	36.13	36.45	269745.0
2014-04-10	ABG	Stock	56.35	56.35	54.39	54.9	210000.0
2014-04-10	ABGB-DELISTED	Stock	24.94	24.94	24.197	24.25	3746.0
2014-04-10	ABIL-DELISTED	Stock	9.65	9.65	9.65	9.65	458.0
2014-04-10	ABM	Stock	28.51	28.95	27.95	28.24	369300.0
2014-04-10	ABMD-DELISTED	Stock	24.66	24.885	23.51	23.96	448677.0
2014-04-10	ABR	Stock	7.14	7.2	6.94	6.95	103300.0
2014-04-10	ABR.A-DELISTED	Stock	25.0	25.0	25.0	25.0	400.0
2014-04-10	ABR.B-DELISTED	Stock	23.0	23.0	22.9901	22.9901	5558.0
2014-04-10	ABR.C-DELISTED	Stock	24.8001	24.85	24.8	24.85	6285.0

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

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