PREVIEW / stock_daily / 2014-08-27

all stock daily files

  file:    by_date/stock_daily/2014/2014-08-27.parquet
  size:    221 KB
  rows:    6,611
  symbols: 3,566

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-27	AAPL	Stock	25.255	25.6425	25.175	25.5325	209476000.0
2014-08-27	MSFT	Stock	44.9	45.0	44.76	44.87	21287900.0
2014-08-27	NVDA	Stock	0.4832	0.487	0.48	0.4808	182972000.0
2014-08-27	AMZN	Stock	17.1045	17.3335	17.067	17.159	59232000.0
2014-08-27	GOOGL	Stock	29.3905	29.4685	29.045	29.15	27375320.0
2014-08-27	META	Stock	75.27	75.49	74.46	74.63	36323000.0
2014-08-27	TSLA	Stock	17.5667	17.616	17.3527	17.55	44776500.0
2014-08-27	TLT	Stock	117.7	118.409	117.4	118.35	7266000.0
2014-08-27	ES	Stock	45.06	45.34	44.99	45.34	1502100.0
2014-08-27	CL	Stock	64.79	64.93	64.58	64.83	2084400.0
2014-08-27	A	Stock	41.4878	41.4878	40.98	41.0443	1667814.0
2014-08-27	AABA-DELISTED	Stock	38.29	38.715	37.8325	38.17	23441687.0
2014-08-27	AACG	Stock	4.52	4.69	4.52	4.64	12800.0
2014-08-27	AAIC-DELISTED	Stock	28.25	28.33	28.1502	28.19	137520.0
2014-08-27	AAL	Stock	39.36	39.4	38.68	38.99	6457300.0
2014-08-27	AAMC-DELISTED	Stock	208.8206	208.8235	203.3912	207.3529	25432.0
2014-08-27	AAME	Stock	4.13	4.14	4.01	4.01	6600.0
2014-08-27	AAOI	Stock	19.58	21.49	19.56	21.2	668900.0
2014-08-27	AAON	Stock	12.44	12.56	12.3867	12.5	75450.0
2014-08-27	AAP	Stock	136.47	137.53	136.01	137.44	556000.0
2014-08-27	AAT	Stock	34.91	35.14	34.63	34.81	153500.0
2014-08-27	AAU-DELISTED	Stock	1.4199	1.4301	1.39	1.42	28786.0
2014-08-27	AAUAF-DELISTED	Stock	1.4199	1.43	1.39	1.42	29313.0
2014-08-27	AAV-DELISTED	Stock	6.23	6.32	6.11	6.13	439332.0
2014-08-27	AAVL-DELISTED	Stock	29.88	29.92	28.451	29.48	36564.0
2014-08-27	AAWW-DELISTED	Stock	33.6	34.0	33.5	33.74	159601.0
2014-08-27	AAXJ	Stock	66.26	66.26	66.03	66.18	439398.0
2014-08-27	AAXN-DELISTED	Stock	15.79	16.159	15.51	15.95	2044323.0
2014-08-27	AB	Stock	27.37	27.48	27.13	27.25	157800.0
2014-08-27	ABAC-DELISTED	Stock	1.98	1.98	1.87	1.88	26645.0
2014-08-27	ABAX-DELISTED	Stock	47.59	47.9	46.79	47.18	59919.0
2014-08-27	ABB-DELISTED	Stock	23.02	23.03	22.8501	22.89	786677.0
2014-08-27	ABBNY-DELISTED	Stock	23.02	23.03	22.8501	22.88	821141.0
2014-08-27	ABBV	Stock	55.85	55.85	55.4	55.7	11022600.0
2014-08-27	ABC-DELISTED	Stock	76.97	76.97	76.001	76.37	662334.0
2014-08-27	ABCB	Stock	23.77	23.77	23.37	23.47	100500.0
2014-08-27	ABCD-DELISTED	Stock	1.65	1.66	1.63	1.65	15614.0
2014-08-27	ABCO-DELISTED	Stock	49.97	50.4	49.97	50.1	189617.0
2014-08-27	ABDC-DELISTED	Stock	13.63	13.7	13.4	13.42	32675.0
2014-08-27	ABE-DELISTED	Stock	14.7201	14.76	14.7201	14.76	10117.0
2014-08-27	ABEO	Stock	375.0	412.5	375.0	375.0	2.0
2014-08-27	ABEV	Stock	7.28	7.37	7.23	7.33	10786900.0
2014-08-27	ABG	Stock	69.65	70.11	69.56	69.81	141300.0
2014-08-27	ABGB-DELISTED	Stock	28.83	29.1	28.34	28.45	14894.0
2014-08-27	ABM	Stock	26.5	26.58	26.36	26.39	99500.0
2014-08-27	ABMD-DELISTED	Stock	25.9	26.1	25.5628	26.03	209717.0
2014-08-27	ABR	Stock	6.99	7.0	6.94	6.98	56000.0
2014-08-27	ABR.A-DELISTED	Stock	24.75	24.75	24.72	24.75	1902.0
2014-08-27	ABR.B-DELISTED	Stock	24.15	24.15	24.1395	24.1472	6708.0
2014-08-27	ABR.C-DELISTED	Stock	25.13	25.13	25.13	25.13	1000.0

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

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