PREVIEW / stock_daily / 2014-02-28

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-28.parquet
  size:    218 KB
  rows:    6,481
  symbols: 3,540

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-02-28	AAPL	Stock	18.8957	19.0268	18.6471	18.7943	371968800.0
2014-02-28	MSFT	Stock	37.98	38.46	37.82	38.31	41215000.0
2014-02-28	NVDA	Stock	0.46	0.4645	0.4528	0.4595	321692000.0
2014-02-28	AMZN	Stock	18.03	18.2935	17.854	18.105	77640000.0
2014-02-28	META	Stock	69.47	69.88	67.38	68.46	66783700.0
2014-02-28	TSLA	Stock	16.6433	16.8453	16.17	16.3207	218847000.0
2014-02-28	TLT	Stock	108.28	108.74	107.78	108.57	8463065.0
2014-02-28	ES	Stock	44.09	44.57	43.97	44.45	1917800.0
2014-02-28	CL	Stock	62.39	63.15	62.09	62.83	3366200.0
2014-02-28	A	Stock	40.3791	40.8512	40.3433	40.7225	3998000.0
2014-02-28	AABA-DELISTED	Stock	38.55	39.38	38.22	38.67	16191028.0
2014-02-28	AACG	Stock	4.05	4.3	4.05	4.3	10800.0
2014-02-28	AAIC-DELISTED	Stock	26.52	26.67	26.3101	26.52	164297.0
2014-02-28	AAL	Stock	36.11	36.98	36.07	36.93	7989800.0
2014-02-28	AAMC-DELISTED	Stock	227.3529	235.2618	200.8118	227.9412	180717.0
2014-02-28	AAME	Stock	3.92	3.98	3.87	3.94	10300.0
2014-02-28	AAOI	Stock	23.55	24.96	21.66	23.66	488100.0
2014-02-28	AAON	Stock	13.1467	13.3111	13.0444	13.28	272925.0
2014-02-28	AAP	Stock	125.05	128.44	125.05	127.36	1037400.0
2014-02-28	AAT	Stock	32.86	33.28	32.79	33.07	359100.0
2014-02-28	AAU-DELISTED	Stock	1.58	1.63	1.58	1.6	146362.0
2014-02-28	AAUAF-DELISTED	Stock	1.58	1.63	1.58	1.6	148278.0
2014-02-28	AAV-DELISTED	Stock	3.97	4.13	3.97	4.09	135180.0
2014-02-28	AAWW-DELISTED	Stock	31.4	31.61	30.0	30.13	630914.0
2014-02-28	AAXJ	Stock	58.58	58.58	57.85	58.15	534381.0
2014-02-28	AAXN-DELISTED	Stock	20.0	20.11	19.01	19.2399	2759931.0
2014-02-28	AB	Stock	24.0	24.46	23.9	24.22	315000.0
2014-02-28	ABAC-DELISTED	Stock	1.7601	1.87	1.7601	1.83	3100.0
2014-02-28	ABAX-DELISTED	Stock	37.99	38.41	37.325	37.95	268446.0
2014-02-28	ABB-DELISTED	Stock	25.43	25.63	25.365	25.47	1245109.0
2014-02-28	ABBNY-DELISTED	Stock	25.43	25.63	25.365	25.48	1311777.0
2014-02-28	ABBV	Stock	50.84	51.96	50.51	50.91	7095600.0
2014-02-28	ABC-DELISTED	Stock	68.17	68.38	67.475	67.86	1509980.0
2014-02-28	ABCB	Stock	20.94	21.33	20.87	21.04	83500.0
2014-02-28	ABCD-DELISTED	Stock	1.972	2.05	1.96	2.0	18704.0
2014-02-28	ABCO-DELISTED	Stock	64.17	64.35	63.8	64.05	154650.0
2014-02-28	ABE-DELISTED	Stock	12.4603	12.4796	12.45	12.47	18334.0
2014-02-28	ABEO	Stock	462.5	487.5	462.5	487.5	16.0
2014-02-28	ABEV	Stock	7.21	7.26	7.11	7.2	11137200.0
2014-02-28	ABFS-DELISTED	Stock	33.72	34.39	32.95	33.26	244362.0
2014-02-28	ABG	Stock	51.45	51.91	50.39	50.84	193300.0
2014-02-28	ABGB-DELISTED	Stock	23.57	23.8	23.36	23.55	17109.0
2014-02-28	ABIL-DELISTED	Stock	9.61	9.69	9.61	9.67	1381.0
2014-02-28	ABM	Stock	28.19	28.32	27.97	28.23	281700.0
2014-02-28	ABMD-DELISTED	Stock	29.19	29.2	28.13	28.18	362149.0
2014-02-28	ABR	Stock	6.87	6.87	6.79	6.86	138800.0
2014-02-28	ABR.A-DELISTED	Stock	24.0	24.14	23.88	24.13	1538.0
2014-02-28	ABR.B-DELISTED	Stock	22.95	22.95	22.7801	22.92	7314.0
2014-02-28	ABR.C-DELISTED	Stock	24.35	24.4	24.04	24.21	16591.0
2014-02-28	ABT	Stock	39.62	39.98	39.42	39.78	8695700.0

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

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