PREVIEW / stock_daily / 2013-05-16

all stock daily files

  file:    by_date/stock_daily/2013/2013-05-16.parquet
  size:    211 KB
  rows:    6,344
  symbols: 3,530

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-05-16	AAPL	Stock	15.1157	15.6375	14.9607	15.5207	603204000.0
2013-05-16	MSFT	Stock	33.64	34.15	33.55	34.08	59382900.0
2013-05-16	NVDA	Stock	0.367	0.3708	0.3645	0.3658	308368000.0
2013-05-16	AMZN	Stock	13.298	13.4215	13.1925	13.206	32870000.0
2013-05-16	META	Stock	26.48	26.55	25.9	26.13	35499100.0
2013-05-16	TSLA	Stock	6.3133	6.3333	5.9107	6.15	324210000.0
2013-05-16	TLT	Stock	117.97	118.94	117.935	118.56	8460576.0
2013-05-16	ES	Stock	44.38	44.51	44.01	44.11	1180200.0
2013-05-16	CL	Stock	62.31	62.7	61.33	62.38	3077800.0
2013-05-16	A	Stock	32.4964	32.7897	32.1674	32.1817	6837618.0
2013-05-16	AABA-DELISTED	Stock	27.43	27.43	26.57	26.57	18077390.0
2013-05-16	AACC-DELISTED	Stock	6.62	6.66	6.61	6.635	117675.0
2013-05-16	AACG	Stock	4.07	4.07	3.96	3.96	7700.0
2013-05-16	AAIC-DELISTED	Stock	28.08	28.96	28.07	28.88	220698.0
2013-05-16	AAMC-DELISTED	Stock	86.4706	87.6176	86.4706	87.5	14555.0
2013-05-16	AAME	Stock	3.75	3.79	3.5	3.69	8600.0
2013-05-16	AAMRQ-DELISTED	Stock	6.495	6.99	6.28	6.85	11417656.0
2013-05-16	AAON	Stock	9.0993	9.2681	9.0459	9.1852	170775.0
2013-05-16	AAP	Stock	86.32	86.92	85.04	85.42	610600.0
2013-05-16	AAT	Stock	35.18	35.18	34.82	34.98	195800.0
2013-05-16	AAU-DELISTED	Stock	1.53	1.57	1.5	1.55	85167.0
2013-05-16	AAUAF-DELISTED	Stock	1.53	1.57	1.5	1.55	87768.0
2013-05-16	AAV-DELISTED	Stock	3.74	3.86	3.73	3.82	381194.0
2013-05-16	AAWW-DELISTED	Stock	46.12	46.579	45.69	45.88	189071.0
2013-05-16	AAXJ	Stock	60.61	60.87	60.519	60.59	599706.0
2013-05-16	AAXN-DELISTED	Stock	8.95	9.05	8.91	8.97	339695.0
2013-05-16	AB	Stock	24.78	25.5	24.7	25.24	633100.0
2013-05-16	ABAC-DELISTED	Stock	0.7	0.7	0.68	0.7	26889.0
2013-05-16	ABAX-DELISTED	Stock	46.35	46.86	45.15	45.48	158025.0
2013-05-16	ABB-DELISTED	Stock	22.14	22.34	22.01	22.04	2396496.0
2013-05-16	ABBNY-DELISTED	Stock	22.14	22.34	22.01	22.03	2521852.0
2013-05-16	ABBV	Stock	46.06	46.9	46.01	46.21	4605300.0
2013-05-16	ABC-DELISTED	Stock	54.64	55.06	54.29	54.41	1751532.0
2013-05-16	ABCB	Stock	15.96	16.15	15.87	16.13	23000.0
2013-05-16	ABCD-DELISTED	Stock	1.1699	1.18	1.15	1.18	1763.0
2013-05-16	ABCO-DELISTED	Stock	49.62	50.25	49.04	49.09	426653.0
2013-05-16	ABCW-DELISTED	Stock	0.66	0.72	0.64	0.72	49444.0
2013-05-16	ABE-DELISTED	Stock	21.77	21.8	21.75	21.79	10760.0
2013-05-16	ABEO	Stock	512.5	587.5	512.5	587.5	54.0
2013-05-16	ABFS-DELISTED	Stock	17.18	17.759	17.01	17.08	487912.0
2013-05-16	ABG	Stock	42.01	42.65	40.86	41.23	144200.0
2013-05-16	ABM	Stock	22.75	22.94	22.63	22.8	123500.0
2013-05-16	ABMD-DELISTED	Stock	23.11	23.22	22.96	23.1	437842.0
2013-05-16	ABR	Stock	7.09	7.21	7.03	7.05	240200.0
2013-05-16	ABR.A-DELISTED	Stock	25.67	25.67	25.51	25.62	8400.0
2013-05-16	ABR.B-DELISTED	Stock	25.0	25.06	24.9999	25.06	12600.0
2013-05-16	ABT	Stock	37.45	37.47	36.82	36.83	6137600.0
2013-05-16	ABTL-DELISTED	Stock	4.2001	4.29	4.19	4.26	7599.0
2013-05-16	ABUS	Stock	4.72	4.88	4.72	4.74	27600.0
2013-05-16	ABV-DELISTED	Stock	43.62	43.69	43.18	43.21	2684409.0

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

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