PREVIEW / stock_daily / 2013-05-07

all stock daily files

  file:    by_date/stock_daily/2013/2013-05-07.parquet
  size:    209 KB
  rows:    6,331
  symbols: 3,526

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-07	AAPL	Stock	16.6061	16.6339	16.2036	16.3807	483753200.0
2013-05-07	MSFT	Stock	33.65	33.79	33.24	33.31	43078300.0
2013-05-07	NVDA	Stock	0.3458	0.3465	0.338	0.3413	448068000.0
2013-05-07	AMZN	Stock	12.8155	12.987	12.6455	12.8865	62674000.0
2013-05-07	META	Stock	27.55	27.85	26.85	26.89	41259100.0
2013-05-07	TSLA	Stock	4.1333	4.158	3.6747	3.7007	149865000.0
2013-05-07	TLT	Stock	120.19	120.5	120.05	120.16	5050718.0
2013-05-07	ES	Stock	44.71	44.98	44.59	44.98	1173200.0
2013-05-07	CL	Stock	60.185	60.25	59.915	60.165	2657800.0
2013-05-07	A	Stock	30.1717	30.3362	29.9714	30.329	4926692.0
2013-05-07	AABA-DELISTED	Stock	26.01	26.79	25.55	26.07	25328855.0
2013-05-07	AACC-DELISTED	Stock	6.53	6.53	6.49	6.53	306919.0
2013-05-07	AAIC-DELISTED	Stock	27.31	27.68	27.3009	27.68	150925.0
2013-05-07	AAMC-DELISTED	Stock	64.7059	67.6471	64.7059	67.2059	32137.0
2013-05-07	AAME	Stock	3.56	3.56	3.4	3.52	2900.0
2013-05-07	AAMRQ-DELISTED	Stock	4.41	4.53	4.41	4.51	3963231.0
2013-05-07	AAON	Stock	8.3615	8.5215	8.3141	8.4652	125888.0
2013-05-07	AAP	Stock	85.31	85.7	84.61	85.58	429300.0
2013-05-07	AAT	Stock	35.06	35.73	35.05	35.49	195200.0
2013-05-07	AAU-DELISTED	Stock	1.56	1.5748	1.545	1.56	93026.0
2013-05-07	AAUAF-DELISTED	Stock	1.57	1.58	1.55	1.55	96195.0
2013-05-07	AAV-DELISTED	Stock	3.78	3.88	3.76	3.81	312073.0
2013-05-07	AAWW-DELISTED	Stock	44.26	44.34	43.3	43.87	376542.0
2013-05-07	AAXJ	Stock	61.0	61.2	60.86	61.11	451258.0
2013-05-07	AAXN-DELISTED	Stock	9.0	9.1	8.84	9.0	580350.0
2013-05-07	AB	Stock	24.97	25.76	24.88	25.45	573200.0
2013-05-07	ABAC-DELISTED	Stock	0.7	0.72	0.7	0.7	4600.0
2013-05-07	ABAX-DELISTED	Stock	43.69	44.98	43.51	44.95	150787.0
2013-05-07	ABB-DELISTED	Stock	22.84	22.88	22.63	22.75	1485370.0
2013-05-07	ABBNY-DELISTED	Stock	22.84	22.88	22.63	22.76	1532209.0
2013-05-07	ABBV	Stock	44.5	45.0	44.42	44.91	3745600.0
2013-05-07	ABC-DELISTED	Stock	54.59	55.04	54.37	54.98	2041075.0
2013-05-07	ABCB	Stock	15.18	15.65	15.15	15.57	87800.0
2013-05-07	ABCD-DELISTED	Stock	0.9501	0.975	0.9501	0.969	619.0
2013-05-07	ABCO-DELISTED	Stock	46.0	46.0	44.2	44.58	790699.0
2013-05-07	ABCW-DELISTED	Stock	0.649	0.65	0.621	0.621	27483.0
2013-05-07	ABE-DELISTED	Stock	21.88	22.0	21.65	21.65	21462.0
2013-05-07	ABEO	Stock	512.5	575.0	512.5	575.0	2.0
2013-05-07	ABFS-DELISTED	Stock	15.01	15.58	14.43	14.98	1269736.0
2013-05-07	ABG	Stock	41.14	42.41	40.61	42.39	128200.0
2013-05-07	ABM	Stock	22.4	22.55	22.3	22.5	359000.0
2013-05-07	ABMD-DELISTED	Stock	20.05	20.05	19.7	19.87	219570.0
2013-05-07	ABR	Stock	7.61	7.62	7.45	7.59	70100.0
2013-05-07	ABR.A-DELISTED	Stock	26.1	26.129	26.04	26.06	4500.0
2013-05-07	ABT	Stock	35.74	36.08	35.58	36.06	8347700.0
2013-05-07	ABTL-DELISTED	Stock	4.37	4.37	4.29	4.3	19664.0
2013-05-07	ABUS	Stock	4.67	4.73	4.58	4.73	67100.0
2013-05-07	ABV-DELISTED	Stock	41.4	41.75	41.225	41.52	2037802.0
2013-05-07	ABX-DELISTED	Stock	20.06	20.1	19.53	19.73	21253201.0
2013-05-07	ACAD	Stock	12.13	12.25	11.8	12.03	1943600.0

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

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