PREVIEW / stock_daily / 2013-09-10

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-10.parquet
  size:    214 KB
  rows:    6,401
  symbols: 3,538

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-10	AAPL	Stock	18.0786	18.1232	17.4821	17.6657	743195600.0
2013-09-10	MSFT	Stock	31.9	32.4	31.79	32.39	56881200.0
2013-09-10	NVDA	Stock	0.381	0.3865	0.3793	0.3862	292132000.0
2013-09-10	AMZN	Stock	15.0275	15.05	14.861	15.018	35568000.0
2013-09-10	META	Stock	44.24	44.26	43.23	43.6	54540300.0
2013-09-10	TSLA	Stock	10.7633	11.1667	10.7087	11.0913	134517000.0
2013-09-10	TLT	Stock	102.73	103.34	102.365	102.38	8071190.0
2013-09-10	ES	Stock	40.83	40.96	40.59	40.96	4242800.0
2013-09-10	CL	Stock	58.79	59.09	58.29	58.59	2351100.0
2013-09-10	A	Stock	34.3634	34.814	34.3634	34.7282	2546177.0
2013-09-10	AABA-DELISTED	Stock	29.43	29.63	29.08	29.47	12134075.0
2013-09-10	AACG	Stock	4.58	4.77	4.58	4.76	1600.0
2013-09-10	AAIC-DELISTED	Stock	24.41	24.67	24.4001	24.48	177525.0
2013-09-10	AAMC-DELISTED	Stock	110.2941	110.8824	107.0588	109.7059	6576.0
2013-09-10	AAME	Stock	3.94	3.95	3.89	3.9	12700.0
2013-09-10	AAMRQ-DELISTED	Stock	3.4	3.5	3.35	3.46	6766895.0
2013-09-10	AAON	Stock	11.2222	11.4356	11.2	11.2933	266850.0
2013-09-10	AAP	Stock	79.99	81.26	79.92	81.08	727600.0
2013-09-10	AAT	Stock	29.95	30.53	29.43	29.7	60800.0
2013-09-10	AAU-DELISTED	Stock	1.641	1.721	1.57	1.6	200220.0
2013-09-10	AAUAF-DELISTED	Stock	1.62	1.699	1.55	1.6	205368.0
2013-09-10	AAV-DELISTED	Stock	3.89	3.99	3.86	3.96	173605.0
2013-09-10	AAWW-DELISTED	Stock	47.75	48.38	47.44	48.33	120527.0
2013-09-10	AAXJ	Stock	58.75	58.98	58.59	58.8	4354394.0
2013-09-10	AAXN-DELISTED	Stock	12.21	12.49	12.16	12.29	815931.0
2013-09-10	AB	Stock	20.58	20.68	20.18	20.2	265700.0
2013-09-10	ABAC-DELISTED	Stock	0.859	0.86	0.762	0.762	46600.0
2013-09-10	ABAX-DELISTED	Stock	40.97	41.48	40.79	41.43	92422.0
2013-09-10	ABB-DELISTED	Stock	22.67	22.84	22.65	22.8	1435937.0
2013-09-10	ABBNY-DELISTED	Stock	22.67	22.84	22.65	22.82	1448440.0
2013-09-10	ABBV	Stock	44.58	44.81	44.1	44.78	4282300.0
2013-09-10	ABC-DELISTED	Stock	59.0	59.5	58.89	59.36	1041798.0
2013-09-10	ABCB	Stock	19.5	19.5	19.15	19.26	50500.0
2013-09-10	ABCD-DELISTED	Stock	1.5135	1.58	1.45	1.55	6440.0
2013-09-10	ABCO-DELISTED	Stock	59.09	59.77	58.85	59.66	136265.0
2013-09-10	ABE-DELISTED	Stock	18.89	19.38	18.89	19.08	36310.0
2013-09-10	ABEO	Stock	450.0	475.0	412.5	475.0	50.0
2013-09-10	ABFS-DELISTED	Stock	26.28	26.49	25.8	26.36	481507.0
2013-09-10	ABG	Stock	53.45	54.39	53.23	54.0	185100.0
2013-09-10	ABM	Stock	25.78	25.79	25.5	25.66	167700.0
2013-09-10	ABMD-DELISTED	Stock	23.62	23.85	23.46	23.57	511405.0
2013-09-10	ABR	Stock	7.23	7.26	7.03	7.19	171700.0
2013-09-10	ABR.A-DELISTED	Stock	24.6199	24.62	24.4	24.4459	2050.0
2013-09-10	ABR.B-DELISTED	Stock	23.72	23.737	23.71	23.71	968.0
2013-09-10	ABT	Stock	34.04	34.19	33.98	34.09	7285500.0
2013-09-10	ABTL-DELISTED	Stock	7.38	7.88	7.26	7.27	216213.0
2013-09-10	ABUS	Stock	5.68	5.68	5.47	5.47	35300.0
2013-09-10	ABV-DELISTED	Stock	36.49	36.82	36.22	36.69	3382293.0
2013-09-10	ABX-DELISTED	Stock	18.68	18.86	18.28	18.44	18540326.0
2013-09-10	ACAD	Stock	23.1	23.21	22.3	22.93	1734000.0

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

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