PREVIEW / stock_daily / 2013-06-24

all stock daily files

  file:    by_date/stock_daily/2013/2013-06-24.parquet
  size:    210 KB
  rows:    6,372
  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-06-24	AAPL	Stock	14.55	14.595	14.2161	14.3764	480746000.0
2013-06-24	MSFT	Stock	32.94	34.2	32.57	33.72	56109000.0
2013-06-24	NVDA	Stock	0.3553	0.3598	0.3478	0.353	580772000.0
2013-06-24	AMZN	Stock	13.5645	13.658	13.25	13.5305	77276000.0
2013-06-24	META	Stock	23.95	24.11	23.38	23.94	40626000.0
2013-06-24	TSLA	Stock	6.4333	6.858	6.3533	6.766	106797000.0
2013-06-24	TLT	Stock	107.83	109.385	107.76	108.85	24588949.0
2013-06-24	ES	Stock	39.94	40.44	39.51	40.14	1308500.0
2013-06-24	CL	Stock	56.28	56.74	55.47	56.15	4418700.0
2013-06-24	A	Stock	30.3577	30.5794	30.093	30.2647	4013938.0
2013-06-24	AABA-DELISTED	Stock	24.98	25.085	23.82	24.06	34430062.0
2013-06-24	AACG	Stock	4.17	4.43	4.17	4.4	11000.0
2013-06-24	AAIC-DELISTED	Stock	27.2	27.2	25.5	26.11	528619.0
2013-06-24	AAMC-DELISTED	Stock	76.1765	76.1765	71.4706	73.5294	19411.0
2013-06-24	AAME	Stock	3.83	3.96	3.82	3.96	6700.0
2013-06-24	AAMRQ-DELISTED	Stock	3.84	4.21	3.5	3.9	10294537.0
2013-06-24	AAON	Stock	9.2356	9.5526	8.9719	9.4578	239288.0
2013-06-24	AAP	Stock	79.85	80.87	79.49	80.22	706000.0
2013-06-24	AAT	Stock	29.27	29.78	28.66	29.28	127400.0
2013-06-24	AAU-DELISTED	Stock	1.25	1.25	1.13	1.21	263633.0
2013-06-24	AAUAF-DELISTED	Stock	1.25	1.25	1.13	1.21	272873.0
2013-06-24	AAV-DELISTED	Stock	3.97	4.01	3.91	3.97	240139.0
2013-06-24	AAWW-DELISTED	Stock	44.12	44.22	43.34	43.61	298726.0
2013-06-24	AAXJ	Stock	52.25	52.57	51.6038	52.16	655507.0
2013-06-24	AAXN-DELISTED	Stock	8.8	9.03	8.69	8.79	313803.0
2013-06-24	AB	Stock	21.46	21.5	20.05	20.28	1038000.0
2013-06-24	ABAC-DELISTED	Stock	0.6	0.6	0.55	0.5511	55814.0
2013-06-24	ABAX-DELISTED	Stock	45.53	46.92	44.852	46.43	81766.0
2013-06-24	ABB-DELISTED	Stock	20.67	21.01	20.65	20.88	3796842.0
2013-06-24	ABBNY-DELISTED	Stock	20.67	21.01	20.65	20.89	3910024.0
2013-06-24	ABBV	Stock	42.07	42.4	41.32	41.89	6042400.0
2013-06-24	ABC-DELISTED	Stock	54.02	54.31	53.25	53.6	2902512.0
2013-06-24	ABCB	Stock	15.84	16.25	15.74	16.11	66200.0
2013-06-24	ABCD-DELISTED	Stock	1.29	1.3	1.28	1.28	5974.0
2013-06-24	ABCO-DELISTED	Stock	53.23	54.13	52.45	53.72	139266.0
2013-06-24	ABCW-DELISTED	Stock	0.56	0.6	0.56	0.6	11781.0
2013-06-24	ABE-DELISTED	Stock	18.96	18.98	18.58	18.8	16444.0
2013-06-24	ABEO	Stock	550.0	550.0	537.5	537.5	7.0
2013-06-24	ABFS-DELISTED	Stock	18.66	19.07	18.095	18.33	246604.0
2013-06-24	ABG	Stock	37.62	37.99	36.61	37.49	231600.0
2013-06-24	ABM	Stock	23.86	24.02	23.75	23.85	169700.0
2013-06-24	ABMD-DELISTED	Stock	20.97	21.15	20.19	20.56	370012.0
2013-06-24	ABR	Stock	6.06	6.1	5.78	5.87	334100.0
2013-06-24	ABR.A-DELISTED	Stock	24.42	24.6	24.4	24.522	5850.0
2013-06-24	ABR.B-DELISTED	Stock	24.18	24.18	23.7	23.9	1780.0
2013-06-24	ABT	Stock	35.29	35.38	34.69	34.97	7535800.0
2013-06-24	ABTL-DELISTED	Stock	4.79	4.79	4.65	4.745	18610.0
2013-06-24	ABUS	Stock	4.66	4.67	4.61	4.64	76100.0
2013-06-24	ABV-DELISTED	Stock	33.9	35.065	33.83	34.52	5491753.0
2013-06-24	ABX-DELISTED	Stock	16.53	17.21	15.71	16.57	30964289.0

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

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