PREVIEW / stock_daily / 2014-08-28

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-28.parquet
  size:    221 KB
  rows:    6,626
  symbols: 3,580

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-08-28	AAPL	Stock	25.3975	25.695	25.39	25.5625	273840000.0
2014-08-28	MSFT	Stock	44.75	44.98	44.61	44.88	17657600.0
2014-08-28	NVDA	Stock	0.4798	0.4858	0.4782	0.4848	179704000.0
2014-08-28	AMZN	Stock	17.0	17.0895	16.94	17.001	45054000.0
2014-08-28	GOOGL	Stock	29.001	29.2355	28.894	29.016	28119000.0
2014-08-28	META	Stock	74.0	74.43	73.73	73.86	21947000.0
2014-08-28	TSLA	Stock	17.4593	17.632	17.4427	17.5907	42673500.0
2014-08-28	TLT	Stock	119.13	119.37	118.67	118.97	9463642.0
2014-08-28	ES	Stock	45.2	45.67	45.06	45.58	2300400.0
2014-08-28	CL	Stock	64.63	64.74	64.45	64.51	2204600.0
2014-08-28	A	Stock	40.8727	41.1516	40.7582	40.8798	1950769.0
2014-08-28	AABA-DELISTED	Stock	38.08	38.57	37.9	38.31	15129962.0
2014-08-28	AAIC-DELISTED	Stock	28.16	28.24	28.02	28.12	100243.0
2014-08-28	AAL	Stock	38.71	39.4	38.7	39.17	3888100.0
2014-08-28	AAMC-DELISTED	Stock	208.6441	213.8706	207.6471	211.8088	19710.0
2014-08-28	AAME	Stock	4.13	4.14	4.13	4.14	1400.0
2014-08-28	AAOI	Stock	21.17	22.26	21.06	21.67	374100.0
2014-08-28	AAON	Stock	12.46	12.84	12.24	12.2933	118650.0
2014-08-28	AAP	Stock	137.59	138.06	136.28	137.41	629000.0
2014-08-28	AAT	Stock	34.7	34.94	34.66	34.83	59900.0
2014-08-28	AAU-DELISTED	Stock	1.42	1.45	1.4	1.43	72351.0
2014-08-28	AAUAF-DELISTED	Stock	1.42	1.45	1.4	1.43	72784.0
2014-08-28	AAV-DELISTED	Stock	6.1	6.19	6.07	6.13	185598.0
2014-08-28	AAVL-DELISTED	Stock	29.0	29.5	28.24	29.1	40345.0
2014-08-28	AAWW-DELISTED	Stock	33.5	33.54	32.8	32.96	118176.0
2014-08-28	AAXJ	Stock	65.5	65.72	65.46	65.7	254403.0
2014-08-28	AAXN-DELISTED	Stock	15.74	15.9	15.45	15.67	1668211.0
2014-08-28	AB	Stock	27.35	27.48	27.05	27.23	158100.0
2014-08-28	ABAC-DELISTED	Stock	1.9199	1.98	1.85	1.92	28827.0
2014-08-28	ABAX-DELISTED	Stock	47.0	47.45	47.0	47.19	75209.0
2014-08-28	ABB-DELISTED	Stock	22.72	22.86	22.71	22.83	519574.0
2014-08-28	ABBNY-DELISTED	Stock	22.72	22.86	22.71	22.81	562326.0
2014-08-28	ABBV	Stock	55.52	55.68	55.25	55.6	7277900.0
2014-08-28	ABC-DELISTED	Stock	76.31	76.92	76.09	76.72	494286.0
2014-08-28	ABCB	Stock	23.33	23.48	22.82	22.84	45800.0
2014-08-28	ABCD-DELISTED	Stock	1.5601	1.68	1.5601	1.68	3177.0
2014-08-28	ABCO-DELISTED	Stock	49.86	50.19	48.74	48.77	124933.0
2014-08-28	ABDC-DELISTED	Stock	13.58	13.62	13.26	13.49	88153.0
2014-08-28	ABE-DELISTED	Stock	14.66	14.7559	14.66	14.71	25523.0
2014-08-28	ABEO	Stock	412.5	412.5	400.0	400.0	1.0
2014-08-28	ABEV	Stock	7.28	7.34	7.18	7.26	8307500.0
2014-08-28	ABG	Stock	69.48	69.73	68.38	69.48	97100.0
2014-08-28	ABGB-DELISTED	Stock	28.04	28.05	27.8197	27.8197	4490.0
2014-08-28	ABIL-DELISTED	Stock	9.81	9.81	9.79	9.79	1739.0
2014-08-28	ABM	Stock	26.36	26.44	26.15	26.4	127700.0
2014-08-28	ABMD-DELISTED	Stock	25.94	26.13	25.79	26.08	145240.0
2014-08-28	ABR	Stock	6.93	7.0	6.93	6.97	82800.0
2014-08-28	ABR.A-DELISTED	Stock	24.76	24.86	24.76	24.81	8702.0
2014-08-28	ABR.B-DELISTED	Stock	24.15	24.18	24.09	24.14	11032.0
2014-08-28	ABR.C-DELISTED	Stock	25.139	25.14	25.1001	25.1399	5400.0

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

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