PREVIEW / stock_daily / 2014-04-30

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-30.parquet
  size:    219 KB
  rows:    6,550
  symbols: 3,555

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-30	AAPL	Stock	21.1657	21.4082	21.0643	21.0746	456640800.0
2014-04-30	MSFT	Stock	40.4	40.5	40.17	40.4	35458700.0
2014-04-30	NVDA	Stock	0.4665	0.467	0.4608	0.4618	305740000.0
2014-04-30	AMZN	Stock	14.905	15.228	14.905	15.2065	81772000.0
2014-04-30	GOOGL	Stock	26.756	26.817	26.4545	26.744	40773160.0
2014-04-30	META	Stock	57.58	59.85	57.16	59.78	76093000.0
2014-04-30	TSLA	Stock	13.5733	13.8773	13.4187	13.8593	66609000.0
2014-04-30	TLT	Stock	110.72	111.26	110.38	111.1	7721499.0
2014-04-30	ES	Stock	47.19	47.43	47.06	47.26	1677300.0
2014-04-30	CL	Stock	67.31	67.68	67.08	67.3	3839500.0
2014-04-30	A	Stock	38.2189	38.6767	37.9256	38.6552	2346683.0
2014-04-30	AABA-DELISTED	Stock	35.89	36.1	35.25	35.95	22361645.0
2014-04-30	AACG	Stock	4.07	4.13	4.07	4.13	11600.0
2014-04-30	AAIC-DELISTED	Stock	26.02	26.6	26.02	26.45	594139.0
2014-04-30	AAL	Stock	35.68	35.88	34.89	35.07	6944600.0
2014-04-30	AAMC-DELISTED	Stock	279.4118	289.9651	273.5294	287.7206	26619.0
2014-04-30	AAME	Stock	3.51	3.57	3.5	3.5	4600.0
2014-04-30	AAOI	Stock	22.76	22.76	22.07	22.5	189400.0
2014-04-30	AAON	Stock	12.3556	12.6933	12.3244	12.6	268875.0
2014-04-30	AAP	Stock	120.03	121.47	119.41	121.29	671000.0
2014-04-30	AAT	Stock	33.8	34.13	33.65	33.95	83000.0
2014-04-30	AAU-DELISTED	Stock	1.43	1.43	1.35	1.39	43000.0
2014-04-30	AAUAF-DELISTED	Stock	1.43	1.43	1.35	1.39	43300.0
2014-04-30	AAV-DELISTED	Stock	6.33	6.36	6.21	6.34	481890.0
2014-04-30	AAWW-DELISTED	Stock	34.36	35.03	34.06	34.97	148520.0
2014-04-30	AAXJ	Stock	59.35	59.65	59.34	59.62	255840.0
2014-04-30	AAXN-DELISTED	Stock	17.02	17.1896	15.33	16.15	1663380.0
2014-04-30	AB	Stock	24.73	25.5	24.05	25.43	629200.0
2014-04-30	ABAC-DELISTED	Stock	2.0	2.0899	2.0	2.07	7850.0
2014-04-30	ABAX-DELISTED	Stock	40.51	40.69	39.91	40.6	119837.0
2014-04-30	ABB-DELISTED	Stock	24.26	24.27	23.805	23.915	2903050.0
2014-04-30	ABBNY-DELISTED	Stock	24.26	24.27	23.805	23.92	3024742.0
2014-04-30	ABBV	Stock	51.38	52.17	51.0	52.08	7430600.0
2014-04-30	ABC-DELISTED	Stock	63.75	65.29	63.59	65.18	2841182.0
2014-04-30	ABCB	Stock	21.78	21.89	21.14	21.27	171800.0
2014-04-30	ABCD-DELISTED	Stock	2.24	2.25	2.22	2.24	4179.0
2014-04-30	ABCO-DELISTED	Stock	57.29	58.15	56.96	57.27	161994.0
2014-04-30	ABE-DELISTED	Stock	13.46	13.46	13.4	13.432	1674.0
2014-04-30	ABEO	Stock	587.5	625.0	525.0	587.5	69.0
2014-04-30	ABEV	Stock	7.34	7.36	7.17	7.25	39653300.0
2014-04-30	ABFS-DELISTED	Stock	37.92	39.61	37.35	39.43	384316.0
2014-04-30	ABG	Stock	60.5	61.91	59.36	61.74	343300.0
2014-04-30	ABGB-DELISTED	Stock	22.13	22.38	22.0259	22.37	2810.0
2014-04-30	ABIL-DELISTED	Stock	9.65	9.79	9.65	9.7	42600.0
2014-04-30	ABM	Stock	26.93	27.21	26.7	27.09	193400.0
2014-04-30	ABMD-DELISTED	Stock	23.91	23.91	23.25	23.68	588983.0
2014-04-30	ABR	Stock	7.0	7.03	6.95	7.01	51000.0
2014-04-30	ABR.A-DELISTED	Stock	25.136	25.15	25.03	25.15	14338.0
2014-04-30	ABR.B-DELISTED	Stock	23.99	24.0	23.9	23.9	4670.0
2014-04-30	ABR.C-DELISTED	Stock	25.2501	25.36	25.17	25.31	45485.0

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

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