PREVIEW / stock_daily / 2013-09-19

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-19.parquet
  size:    213 KB
  rows:    6,390
  symbols: 3,535

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-09-19	AAPL	Stock	16.8107	16.9939	16.7589	16.8679	404541200.0
2013-09-19	MSFT	Stock	33.48	33.68	33.32	33.64	42026600.0
2013-09-19	NVDA	Stock	0.4018	0.4025	0.3965	0.3982	227572000.0
2013-09-19	AMZN	Stock	15.6885	15.727	15.552	15.603	47018000.0
2013-09-19	META	Stock	45.51	46.05	45.23	45.98	63972400.0
2013-09-19	TSLA	Stock	11.3867	12.0313	11.272	11.8613	233919000.0
2013-09-19	TLT	Stock	105.05	105.09	104.16	104.37	11627751.0
2013-09-19	ES	Stock	41.99	42.2	41.6	41.7	1208300.0
2013-09-19	CL	Stock	61.24	61.28	60.8	60.97	3252800.0
2013-09-19	A	Stock	37.8541	38.2475	36.3019	36.4664	25368667.0
2013-09-19	AABA-DELISTED	Stock	30.53	31.05	30.34	31.03	12658878.0
2013-09-19	AACG	Stock	4.5	4.57	4.5	4.53	500.0
2013-09-19	AAIC-DELISTED	Stock	26.09	26.5	25.94	26.05	257625.0
2013-09-19	AAMC-DELISTED	Stock	104.7059	105.8824	104.7059	105.5882	3427.0
2013-09-19	AAME	Stock	4.03	4.03	3.95	4.01	5200.0
2013-09-19	AAMRQ-DELISTED	Stock	3.885	3.98	3.88	3.95	8148198.0
2013-09-19	AAON	Stock	11.4044	11.5911	11.3289	11.5422	90000.0
2013-09-19	AAP	Stock	80.41	81.07	80.4	80.71	733300.0
2013-09-19	AAT	Stock	31.31	31.69	31.26	31.34	51200.0
2013-09-19	AAU-DELISTED	Stock	1.5449	1.635	1.5	1.51	128035.0
2013-09-19	AAUAF-DELISTED	Stock	1.55	1.64	1.5	1.5	129420.0
2013-09-19	AAV-DELISTED	Stock	3.81	3.89	3.7278	3.78	89753.0
2013-09-19	AAWW-DELISTED	Stock	46.98	47.32	46.6201	46.89	140094.0
2013-09-19	AAXJ	Stock	61.02	61.08	60.53	61.0	2027174.0
2013-09-19	AAXN-DELISTED	Stock	14.15	14.42	14.01	14.25	1676588.0
2013-09-19	AB	Stock	21.92	22.18	21.7	21.95	522700.0
2013-09-19	ABAC-DELISTED	Stock	0.79	0.8	0.79	0.791	21323.0
2013-09-19	ABAX-DELISTED	Stock	40.6	41.53	40.2901	41.05	93343.0
2013-09-19	ABB-DELISTED	Stock	23.99	24.08	23.89	24.04	1354041.0
2013-09-19	ABBNY-DELISTED	Stock	23.99	24.08	23.89	24.03	1382272.0
2013-09-19	ABBV	Stock	48.21	48.23	47.31	47.4	5326500.0
2013-09-19	ABC-DELISTED	Stock	61.85	62.44	61.78	62.24	1132608.0
2013-09-19	ABCB	Stock	19.1	19.17	18.64	19.01	32600.0
2013-09-19	ABCD-DELISTED	Stock	1.49	1.5231	1.48	1.51	85021.0
2013-09-19	ABCO-DELISTED	Stock	59.47	60.1	58.18	59.94	63246.0
2013-09-19	ABE-DELISTED	Stock	19.89	20.01	19.89	20.0	4998.0
2013-09-19	ABEO	Stock	475.0	525.0	475.0	512.5	74.0
2013-09-19	ABFS-DELISTED	Stock	25.78	26.4	25.62	25.64	396439.0
2013-09-19	ABG	Stock	53.64	53.88	53.25	53.43	138200.0
2013-09-19	ABM	Stock	26.06	26.13	25.95	26.05	146100.0
2013-09-19	ABMD-DELISTED	Stock	23.17	23.17	22.0	22.04	511821.0
2013-09-19	ABR	Stock	7.41	7.46	7.3	7.46	110700.0
2013-09-19	ABR.A-DELISTED	Stock	24.69	24.69	24.566	24.599	1100.0
2013-09-19	ABR.B-DELISTED	Stock	23.75	23.99	23.75	23.89	1085.0
2013-09-19	ABT	Stock	35.66	35.72	35.29	35.34	6493500.0
2013-09-19	ABTL-DELISTED	Stock	7.62	7.7498	7.34	7.51	46460.0
2013-09-19	ABUS	Stock	6.47	6.47	6.18	6.35	86800.0
2013-09-19	ABV-DELISTED	Stock	38.74	39.26	38.71	39.23	2085773.0
2013-09-19	ABX-DELISTED	Stock	20.11	20.18	19.06	19.45	23224214.0
2013-09-19	ACAD	Stock	23.92	24.5	23.65	24.5	1689500.0

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

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