PREVIEW / stock_daily / 2013-08-26

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-26.parquet
  size:    213 KB
  rows:    6,394
  symbols: 3,537

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-26	AAPL	Stock	17.8839	18.2214	17.875	17.9632	330965600.0
2013-08-26	MSFT	Stock	34.4	34.67	34.03	34.15	72786800.0
2013-08-26	NVDA	Stock	0.3743	0.3758	0.3733	0.3748	300152000.0
2013-08-26	AMZN	Stock	14.5215	14.5525	14.281	14.3105	34234000.0
2013-08-26	META	Stock	40.9	41.94	40.62	41.34	94162400.0
2013-08-26	TSLA	Stock	11.01	11.5333	10.6833	10.948	362566500.0
2013-08-26	TLT	Stock	104.56	104.89	104.33	104.81	5886443.0
2013-08-26	ES	Stock	41.75	41.87	41.22	41.33	1040400.0
2013-08-26	CL	Stock	59.08	59.25	58.2	58.22	1960700.0
2013-08-26	A	Stock	34.0773	34.4778	33.8984	34.0486	2813056.0
2013-08-26	AABA-DELISTED	Stock	27.99	28.04	27.7	27.7	9485195.0
2013-08-26	AAIC-DELISTED	Stock	23.65	23.94	23.511	23.82	174134.0
2013-08-26	AAMC-DELISTED	Stock	91.1765	91.1765	91.1765	91.1765	391.0
2013-08-26	AAME	Stock	3.93	3.93	3.83	3.92	10200.0
2013-08-26	AAMRQ-DELISTED	Stock	3.135	3.27	3.13	3.19	5045045.0
2013-08-26	AAON	Stock	10.9333	11.16	10.8133	10.8622	179325.0
2013-08-26	AAP	Stock	83.14	83.9	83.02	83.1	266600.0
2013-08-26	AAT	Stock	30.13	30.13	29.78	29.91	123500.0
2013-08-26	AAU-DELISTED	Stock	1.85	1.91	1.73	1.77	219255.0
2013-08-26	AAUAF-DELISTED	Stock	1.87	1.93	1.75	1.77	218103.0
2013-08-26	AAV-DELISTED	Stock	3.71	3.76	3.67	3.72	166553.0
2013-08-26	AAWW-DELISTED	Stock	47.49	48.442	47.395	48.0	138987.0
2013-08-26	AAXJ	Stock	55.07	55.07	54.42	54.51	561079.0
2013-08-26	AAXN-DELISTED	Stock	11.37	11.79	11.22	11.5	1036851.0
2013-08-26	AB	Stock	19.8	19.99	19.63	19.7	174200.0
2013-08-26	ABAC-DELISTED	Stock	1.02	1.04	0.98	0.982	56642.0
2013-08-26	ABAX-DELISTED	Stock	41.3	42.24	41.13	41.26	79824.0
2013-08-26	ABB-DELISTED	Stock	22.6	22.63	22.45	22.51	654599.0
2013-08-26	ABBNY-DELISTED	Stock	22.6	22.63	22.45	22.51	675145.0
2013-08-26	ABBV	Stock	43.43	43.74	43.19	43.45	3493400.0
2013-08-26	ABC-DELISTED	Stock	57.41	57.78	57.32	57.45	817266.0
2013-08-26	ABCB	Stock	19.42	19.68	18.93	19.44	86500.0
2013-08-26	ABCD-DELISTED	Stock	1.54	1.6	1.52	1.57	81432.0
2013-08-26	ABCO-DELISTED	Stock	56.95	58.49	56.57	58.21	211204.0
2013-08-26	ABE-DELISTED	Stock	19.0	19.27	18.966	18.966	4717.0
2013-08-26	ABEO	Stock	412.5	437.5	375.0	412.5	104.0
2013-08-26	ABFS-DELISTED	Stock	26.14	27.48	25.61	27.46	1068044.0
2013-08-26	ABG	Stock	50.02	50.77	49.27	49.53	153800.0
2013-08-26	ABM	Stock	25.8	25.95	25.59	25.62	101500.0
2013-08-26	ABMD-DELISTED	Stock	22.41	23.44	22.26	23.19	256293.0
2013-08-26	ABR	Stock	7.06	7.06	6.98	7.02	39700.0
2013-08-26	ABR.A-DELISTED	Stock	24.27	24.27	24.27	24.27	620.0
2013-08-26	ABR.B-DELISTED	Stock	22.84	23.275	22.84	23.1999	2721.0
2013-08-26	ABT	Stock	34.83	34.9	34.52	34.52	3405700.0
2013-08-26	ABTL-DELISTED	Stock	6.04	6.101	5.8994	6.03	29479.0
2013-08-26	ABUS	Stock	5.3	5.3	5.21	5.25	12200.0
2013-08-26	ABV-DELISTED	Stock	34.81	34.82	33.85	34.0	2440070.0
2013-08-26	ABX-DELISTED	Stock	20.32	20.63	20.07	20.46	16599623.0
2013-08-26	ACAD	Stock	20.58	21.45	20.51	20.9	2105500.0
2013-08-26	ACAS-DELISTED	Stock	13.01	13.13	12.88	12.88	1845797.0

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

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