PREVIEW / stock_daily / 2015-03-27

all stock daily files

  file:    by_date/stock_daily/2015/2015-03-27.parquet
  size:    221 KB
  rows:    6,582
  symbols: 3,473

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
2015-03-27	AAPL	Stock	31.1425	31.175	30.7275	30.8125	158184800.0
2015-03-27	MSFT	Stock	41.12	41.43	40.83	40.97	34401400.0
2015-03-27	NVDA	Stock	0.5272	0.5365	0.5188	0.5345	318288000.0
2015-03-27	AMZN	Stock	18.3555	18.6585	18.3285	18.528	52196000.0
2015-03-27	GOOGL	Stock	28.0915	28.2033	27.8465	27.8775	34552580.0
2015-03-27	META	Stock	83.38	83.95	82.88	83.3	18372600.0
2015-03-27	TSLA	Stock	12.6047	12.6193	12.0933	12.3333	129073500.0
2015-03-27	TLT	Stock	130.03	131.13	129.98	131.06	7907909.0
2015-03-27	ES	Stock	49.79	50.51	49.76	50.12	1063300.0
2015-03-27	CL	Stock	68.91	69.09	68.42	68.75	2004200.0
2015-03-27	A	Stock	40.6	41.18	40.58	41.11	1932700.0
2015-03-27	AA.B-DELISTED	Stock	43.8	43.8	43.22	43.36	37651.0
2015-03-27	AABA-DELISTED	Stock	45.2	45.67	45.0112	45.09	19257079.0
2015-03-27	AAC-DELISTED	Stock	28.38	30.86	28.36	29.26	182688.0
2015-03-27	AACG	Stock	4.0	4.02	3.96	3.97	10200.0
2015-03-27	AAIC-DELISTED	Stock	24.27	24.32	24.02	24.15	397023.0
2015-03-27	AAL	Stock	51.38	52.85	51.38	52.66	9004000.0
2015-03-27	AAMC-DELISTED	Stock	56.3912	57.3529	55.8824	56.1765	13685.0
2015-03-27	AAME	Stock	3.96	3.96	3.96	3.96	100.0
2015-03-27	AAMI	Stock	17.9	18.24	17.69	17.88	168500.0
2015-03-27	AAOI	Stock	13.27	13.38	12.85	13.19	133300.0
2015-03-27	AAON	Stock	15.6467	15.8933	15.4067	15.84	159300.0
2015-03-27	AAP	Stock	149.67	152.13	149.35	151.39	858800.0
2015-03-27	AAT	Stock	43.07	43.22	42.67	43.06	96700.0
2015-03-27	AAU-DELISTED	Stock	0.91	0.9339	0.91	0.91	58989.0
2015-03-27	AAUAF-DELISTED	Stock	0.9001	0.9237	0.9001	0.91	61016.0
2015-03-27	AAV-DELISTED	Stock	5.27	5.47	5.25	5.41	269300.0
2015-03-27	AAVL-DELISTED	Stock	38.5	40.41	38.0	38.49	427778.0
2015-03-27	AAWW-DELISTED	Stock	44.6	45.05	44.02	44.24	102358.0
2015-03-27	AAXJ	Stock	63.15	63.4	63.08	63.28	551934.0
2015-03-27	AAXN-DELISTED	Stock	24.15	24.62	23.92	24.06	807243.0
2015-03-27	AB	Stock	30.36	30.43	29.83	30.41	212100.0
2015-03-27	ABAC-DELISTED	Stock	1.4901	1.59	1.4901	1.58	8127.0
2015-03-27	ABAX-DELISTED	Stock	64.18	64.78	63.32	64.42	68490.0
2015-03-27	ABB-DELISTED	Stock	21.29	21.32	21.21	21.305	865168.0
2015-03-27	ABBNY-DELISTED	Stock	21.29	21.32	21.21	21.31	919704.0
2015-03-27	ABBV	Stock	57.63	58.05	57.31	57.65	6830100.0
2015-03-27	ABC-DELISTED	Stock	112.33	113.58	112.2128	113.2	1588084.0
2015-03-27	ABCB	Stock	26.39	26.42	26.12	26.31	78800.0
2015-03-27	ABCD-DELISTED	Stock	3.19	3.27	2.97	3.19	32549.0
2015-03-27	ABCO-DELISTED	Stock	51.3	52.5	51.3	52.41	149157.0
2015-03-27	ABCW-DELISTED	Stock	34.81	34.81	33.95	34.2	4452.0
2015-03-27	ABDC-DELISTED	Stock	13.55	13.56	13.01	13.27	73077.0
2015-03-27	ABE-DELISTED	Stock	12.5	12.57	12.5	12.52	5983.0
2015-03-27	ABEO	Stock	76.5	77.5	75.25	76.0	1152.0
2015-03-27	ABEV	Stock	5.65	5.71	5.6	5.66	8252100.0
2015-03-27	ABG	Stock	80.03	82.05	79.46	81.54	306800.0
2015-03-27	ABGB-DELISTED	Stock	17.95	18.4	17.48	18.13	93869.0
2015-03-27	ABIL-DELISTED	Stock	9.88	9.88	9.85	9.86	4700.0
2015-03-27	ABM	Stock	31.63	32.27	31.38	32.0	247000.0

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

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