PREVIEW / stock_daily / 2014-09-26

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-26.parquet
  size:    220 KB
  rows:    6,600
  symbols: 3,558

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-09-26	AAPL	Stock	24.6325	25.1875	24.6	25.1875	249482000.0
2014-09-26	MSFT	Stock	45.93	46.62	45.76	46.41	27078800.0
2014-09-26	NVDA	Stock	0.4643	0.4673	0.4622	0.4638	241188000.0
2014-09-26	AMZN	Stock	16.03	16.175	15.882	16.1605	72760000.0
2014-09-26	GOOGL	Stock	29.2965	29.4787	29.25	29.395	25781800.0
2014-09-26	META	Stock	77.59	78.84	77.33	78.79	28872000.0
2014-09-26	TSLA	Stock	16.55	16.6487	16.4047	16.44	56931000.0
2014-09-26	TLT	Stock	116.02	116.285	115.62	116.0	7800462.0
2014-09-26	ES	Stock	44.22	44.55	43.88	44.4	987000.0
2014-09-26	CL	Stock	65.43	65.85	65.06	65.7	1988000.0
2014-09-26	A	Stock	40.6223	40.7296	40.1073	40.4149	3101323.0
2014-09-26	AA.B-DELISTED	Stock	49.3	50.3699	49.25	50.195	262587.0
2014-09-26	AABA-DELISTED	Stock	39.01	40.8	39.0	40.66	59843089.0
2014-09-26	AACG	Stock	4.5	4.5	4.5	4.5	2900.0
2014-09-26	AAIC-DELISTED	Stock	26.25	26.4	26.05	26.2	340976.0
2014-09-26	AAL	Stock	35.25	36.12	35.02	35.93	8514800.0
2014-09-26	AAMC-DELISTED	Stock	205.3	207.2221	205.3	205.8824	17422.0
2014-09-26	AAME	Stock	3.74	3.92	3.74	3.9	6900.0
2014-09-26	AAOI	Stock	17.05	17.1	16.57	16.81	230300.0
2014-09-26	AAON	Stock	11.6533	11.7867	11.5333	11.62	145950.0
2014-09-26	AAP	Stock	128.68	130.37	128.68	130.1	460400.0
2014-09-26	AAT	Stock	33.24	33.61	33.01	33.52	407200.0
2014-09-26	AAU-DELISTED	Stock	1.38	1.43	1.33	1.34	119757.0
2014-09-26	AAUAF-DELISTED	Stock	1.37	1.42	1.33	1.35	125834.0
2014-09-26	AAV-DELISTED	Stock	5.06	5.14	5.01	5.07	192066.0
2014-09-26	AAVL-DELISTED	Stock	35.48	36.23	34.02	36.05	63331.0
2014-09-26	AAWW-DELISTED	Stock	33.91	34.2825	33.76	33.95	136385.0
2014-09-26	AAXJ	Stock	62.5	62.7064	62.39	62.57	271493.0
2014-09-26	AAXN-DELISTED	Stock	16.01	16.08	15.4	15.66	1720863.0
2014-09-26	AB	Stock	26.12	27.02	26.12	26.71	152700.0
2014-09-26	ABAC-DELISTED	Stock	1.92	1.95	1.8799	1.95	25566.0
2014-09-26	ABAX-DELISTED	Stock	50.48	50.95	49.47	50.82	380770.0
2014-09-26	ABB-DELISTED	Stock	22.76	22.79	22.6	22.68	1043540.0
2014-09-26	ABBNY-DELISTED	Stock	22.76	22.79	22.6	22.69	1277639.0
2014-09-26	ABBV	Stock	58.54	59.24	58.1	59.19	15866000.0
2014-09-26	ABC-DELISTED	Stock	77.41	77.67	76.86	77.42	785172.0
2014-09-26	ABCB	Stock	21.88	22.28	21.82	22.21	93400.0
2014-09-26	ABCD-DELISTED	Stock	1.49	1.63	1.43	1.52	14730.0
2014-09-26	ABCO-DELISTED	Stock	44.29	45.32	44.06	45.27	517795.0
2014-09-26	ABDC-DELISTED	Stock	13.3	13.3	12.68	13.26	86759.0
2014-09-26	ABE-DELISTED	Stock	13.95	14.03	13.92	14.0	7536.0
2014-09-26	ABEV	Stock	6.73	6.84	6.67	6.79	9864600.0
2014-09-26	ABG	Stock	65.25	65.61	64.51	65.35	231600.0
2014-09-26	ABGB-DELISTED	Stock	26.13	26.2199	25.83	26.21	6717.0
2014-09-26	ABM	Stock	26.38	26.53	26.21	26.23	221000.0
2014-09-26	ABMD-DELISTED	Stock	24.94	25.17	24.7855	24.91	113825.0
2014-09-26	ABR	Stock	6.65	6.75	6.61	6.71	118800.0
2014-09-26	ABR.A-DELISTED	Stock	24.57	24.6	24.52	24.5615	3649.0
2014-09-26	ABR.B-DELISTED	Stock	24.2501	24.26	24.1	24.15	5513.0
2014-09-26	ABR.C-DELISTED	Stock	24.97	24.99	24.93	24.99	4050.0

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

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