PREVIEW / stock_daily / 2013-08-20

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-20.parquet
  size:    211 KB
  rows:    6,388
  symbols: 3,541

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
2013-08-20	AAPL	Stock	18.2039	18.2346	17.8864	17.8954	358688400.0
2013-08-20	MSFT	Stock	31.44	31.9	31.37	31.62	22979600.0
2013-08-20	NVDA	Stock	0.3718	0.3763	0.3713	0.3738	234192000.0
2013-08-20	AMZN	Stock	14.294	14.4755	14.287	14.3545	31726000.0
2013-08-20	META	Stock	38.35	38.58	37.69	38.41	57995200.0
2013-08-20	TSLA	Stock	9.91	9.9853	9.8	9.972	96273000.0
2013-08-20	TLT	Stock	102.89	103.36	102.85	103.26	10050089.0
2013-08-20	ES	Stock	41.33	41.79	41.21	41.57	1603500.0
2013-08-20	CL	Stock	59.24	59.62	59.02	59.09	1946300.0
2013-08-20	A	Stock	33.2117	33.8126	33.0258	33.6409	3207431.0
2013-08-20	AABA-DELISTED	Stock	26.92	27.31	26.9	27.128	10277084.0
2013-08-20	AACG	Stock	5.32	5.32	5.01	5.25	3400.0
2013-08-20	AAIC-DELISTED	Stock	22.86	23.5	22.5	23.46	140938.0
2013-08-20	AAME	Stock	3.8	3.8	3.78	3.8	2000.0
2013-08-20	AAMRQ-DELISTED	Stock	2.925	3.15	2.9	3.13	19872702.0
2013-08-20	AAON	Stock	10.7156	10.9156	10.6667	10.7822	148500.0
2013-08-20	AAP	Stock	80.53	82.09	80.32	81.66	602800.0
2013-08-20	AAT	Stock	29.63	30.12	29.55	29.99	440600.0
2013-08-20	AAU-DELISTED	Stock	1.88	1.95	1.84	1.94	99129.0
2013-08-20	AAUAF-DELISTED	Stock	1.88	1.94	1.84	1.94	100401.0
2013-08-20	AAV-DELISTED	Stock	3.68	3.75	3.64	3.72	137118.0
2013-08-20	AAWW-DELISTED	Stock	44.24	46.81	43.901	46.59	343850.0
2013-08-20	AAXJ	Stock	54.85	55.15	54.78	54.91	362109.0
2013-08-20	AAXN-DELISTED	Stock	10.5	10.99	10.38	10.87	1584043.0
2013-08-20	AB	Stock	19.83	20.5	19.79	19.82	257700.0
2013-08-20	ABAC-DELISTED	Stock	0.85	0.85	0.7801	0.82	23592.0
2013-08-20	ABAX-DELISTED	Stock	40.3	41.2	40.2	41.02	91225.0
2013-08-20	ABB-DELISTED	Stock	22.39	22.55	22.36	22.49	735374.0
2013-08-20	ABBNY-DELISTED	Stock	22.39	22.55	22.36	22.47	751341.0
2013-08-20	ABBV	Stock	43.29	43.48	42.85	42.97	2803000.0
2013-08-20	ABC-DELISTED	Stock	56.92	57.61	56.79	57.47	1782696.0
2013-08-20	ABCB	Stock	18.55	19.25	18.55	18.9	34900.0
2013-08-20	ABCD-DELISTED	Stock	1.4799	1.48	1.4315	1.45	5889.0
2013-08-20	ABCO-DELISTED	Stock	55.82	56.99	55.48	56.8	66612.0
2013-08-20	ABE-DELISTED	Stock	19.23	19.3	19.1201	19.25	6736.0
2013-08-20	ABEO	Stock	450.0	450.0	412.5	412.5	2.0
2013-08-20	ABFS-DELISTED	Stock	22.87	23.749	22.6801	23.32	289304.0
2013-08-20	ABG	Stock	49.54	50.49	49.25	50.07	238800.0
2013-08-20	ABM	Stock	25.19	25.58	25.1	25.55	70300.0
2013-08-20	ABMD-DELISTED	Stock	22.53	22.75	22.23	22.38	389990.0
2013-08-20	ABR	Stock	6.74	6.98	6.69	6.9	77800.0
2013-08-20	ABR.A-DELISTED	Stock	23.93	23.93	23.68	23.8699	1625.0
2013-08-20	ABR.B-DELISTED	Stock	21.75	22.2	21.45	21.85	14809.0
2013-08-20	ABT	Stock	34.9	34.95	34.69	34.71	4494900.0
2013-08-20	ABTL-DELISTED	Stock	6.13	6.159	5.81	6.04	88428.0
2013-08-20	ABUS	Stock	5.19	5.27	5.18	5.25	29700.0
2013-08-20	ABV-DELISTED	Stock	35.79	35.84	34.69	34.7	5900857.0
2013-08-20	ABX-DELISTED	Stock	19.11	19.94	19.06	19.78	14245336.0
2013-08-20	ACAD	Stock	19.7	20.17	19.61	19.86	892400.0
2013-08-20	ACAS-DELISTED	Stock	12.53	12.785	12.42	12.74	3169615.0

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

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