PREVIEW / stock_daily / 2013-09-04

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-04.parquet
  size:    212 KB
  rows:    6,365
  symbols: 3,523

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-04	AAPL	Stock	17.8414	17.9371	17.7243	17.8104	345032800.0
2013-09-04	MSFT	Stock	31.39	31.47	31.11	31.2	142320600.0
2013-09-04	NVDA	Stock	0.369	0.3748	0.3685	0.3725	222080000.0
2013-09-04	AMZN	Stock	14.4165	14.7615	14.379	14.682	48772000.0
2013-09-04	META	Stock	42.01	42.17	41.44	41.78	42581900.0
2013-09-04	TSLA	Stock	11.318	11.4413	11.0373	11.3747	172135500.0
2013-09-04	TLT	Stock	104.45	104.65	103.95	103.99	4579633.0
2013-09-04	ES	Stock	40.35	40.62	40.08	40.51	1938100.0
2013-09-04	CL	Stock	57.45	58.19	57.26	57.8	2797900.0
2013-09-04	A	Stock	33.5694	34.3062	33.4335	34.2418	3525756.0
2013-09-04	AABA-DELISTED	Stock	27.66	28.12	27.6	28.07	8777897.0
2013-09-04	AACG	Stock	4.64	5.0	4.51	4.67	8800.0
2013-09-04	AAIC-DELISTED	Stock	23.1	23.35	23.0715	23.31	155902.0
2013-09-04	AAMC-DELISTED	Stock	95.5882	95.8824	94.1912	94.1912	4216.0
2013-09-04	AAME	Stock	3.9	3.94	3.79	3.93	14400.0
2013-09-04	AAMRQ-DELISTED	Stock	3.53	3.57	3.43	3.45	4327635.0
2013-09-04	AAON	Stock	10.8089	10.8889	10.6889	10.8444	951075.0
2013-09-04	AAP	Stock	79.85	80.04	79.35	79.78	854600.0
2013-09-04	AAT	Stock	29.2	29.46	28.85	29.46	132900.0
2013-09-04	AAU-DELISTED	Stock	1.73	1.78	1.6899	1.73	74311.0
2013-09-04	AAUAF-DELISTED	Stock	1.73	1.78	1.6899	1.73	74811.0
2013-09-04	AAV-DELISTED	Stock	3.56	3.72	3.56	3.7	65588.0
2013-09-04	AAWW-DELISTED	Stock	47.0	47.49	46.81	47.44	140808.0
2013-09-04	AAXJ	Stock	55.65	56.23	55.645	56.17	687723.0
2013-09-04	AAXN-DELISTED	Stock	12.0	12.68	12.0	12.37	1912782.0
2013-09-04	AB	Stock	19.87	20.05	19.73	19.91	297300.0
2013-09-04	ABAC-DELISTED	Stock	0.7997	0.9	0.78	0.9	11141.0
2013-09-04	ABAX-DELISTED	Stock	39.27	40.73	39.27	40.11	65689.0
2013-09-04	ABB-DELISTED	Stock	21.86	22.05	21.8	22.01	1285164.0
2013-09-04	ABBNY-DELISTED	Stock	21.85	22.05	21.8	22.0	1312802.0
2013-09-04	ABBV	Stock	42.6	43.14	42.59	43.13	3190700.0
2013-09-04	ABC-DELISTED	Stock	57.63	58.3	57.592	58.15	970488.0
2013-09-04	ABCB	Stock	19.23	19.39	18.97	19.03	40000.0
2013-09-04	ABCD-DELISTED	Stock	1.61	1.61	1.53	1.61	22885.0
2013-09-04	ABCO-DELISTED	Stock	53.64	56.89	53.64	56.49	68371.0
2013-09-04	ABE-DELISTED	Stock	18.3	18.74	18.3	18.61	13297.0
2013-09-04	ABEO	Stock	450.0	462.5	425.0	462.5	45.0
2013-09-04	ABFS-DELISTED	Stock	24.96	26.29	24.77	25.64	516726.0
2013-09-04	ABG	Stock	50.35	50.47	49.54	50.29	446800.0
2013-09-04	ABM	Stock	25.01	25.67	24.49	25.56	348700.0
2013-09-04	ABMD-DELISTED	Stock	24.11	24.48	23.96	24.07	323424.0
2013-09-04	ABR	Stock	7.04	7.05	6.94	7.0	112900.0
2013-09-04	ABR.A-DELISTED	Stock	24.7799	24.7799	24.5	24.7099	1090.0
2013-09-04	ABR.B-DELISTED	Stock	23.94	23.94	23.94	23.94	400.0
2013-09-04	ABT	Stock	33.01	33.78	32.94	33.46	11838000.0
2013-09-04	ABTL-DELISTED	Stock	6.05	6.35	6.05	6.26	38959.0
2013-09-04	ABUS	Stock	5.59	5.64	5.4	5.53	49500.0
2013-09-04	ABV-DELISTED	Stock	34.08	34.47	34.0	34.33	2863125.0
2013-09-04	ABX-DELISTED	Stock	19.2	19.436	19.1	19.4084	15277510.0
2013-09-04	ACAD	Stock	20.04	20.5	20.01	20.49	1318100.0

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

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