PREVIEW / stock_daily / 2013-09-17

all stock daily files

  file:    by_date/stock_daily/2013/2013-09-17.parquet
  size:    213 KB
  rows:    6,397
  symbols: 3,541

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-17	AAPL	Stock	15.9986	16.4182	15.9821	16.2614	399380800.0
2013-09-17	MSFT	Stock	33.42	33.47	32.9	32.93	84716500.0
2013-09-17	NVDA	Stock	0.3968	0.3998	0.395	0.3965	168608000.0
2013-09-17	AMZN	Stock	14.8815	15.2325	14.8005	15.2085	45930000.0
2013-09-17	META	Stock	42.5	45.44	42.43	45.07	91934600.0
2013-09-17	TSLA	Stock	11.0053	11.228	10.8907	11.082	82453500.0
2013-09-17	TLT	Stock	103.37	103.74	102.97	103.71	8795570.0
2013-09-17	ES	Stock	40.42	40.63	40.29	40.52	975200.0
2013-09-17	CL	Stock	59.67	59.99	59.34	59.8	2898000.0
2013-09-17	A	Stock	34.8569	35.279	34.7783	34.9571	2206603.0
2013-09-17	AABA-DELISTED	Stock	29.65	30.0	29.31	30.0	10266805.0
2013-09-17	AACG	Stock	4.84	4.84	4.77	4.78	4300.0
2013-09-17	AAIC-DELISTED	Stock	25.03	25.55	25.03	25.45	134453.0
2013-09-17	AAMC-DELISTED	Stock	102.9412	107.0588	101.4706	105.8824	53006.0
2013-09-17	AAME	Stock	3.93	4.02	3.93	4.01	17500.0
2013-09-17	AAMRQ-DELISTED	Stock	3.83	3.87	3.72	3.77	3966161.0
2013-09-17	AAON	Stock	11.0356	11.2578	10.9378	11.2311	177750.0
2013-09-17	AAP	Stock	79.67	80.15	79.47	79.93	337200.0
2013-09-17	AAT	Stock	30.36	30.68	30.14	30.31	156200.0
2013-09-17	AAU-DELISTED	Stock	1.41	1.44	1.38	1.44	103576.0
2013-09-17	AAUAF-DELISTED	Stock	1.41	1.44	1.38	1.44	106076.0
2013-09-17	AAV-DELISTED	Stock	3.75	3.82	3.73	3.77	90478.0
2013-09-17	AAWW-DELISTED	Stock	46.81	47.36	46.05	46.25	164708.0
2013-09-17	AAXJ	Stock	59.14	59.31	58.98	59.09	325187.0
2013-09-17	AAXN-DELISTED	Stock	13.21	13.3699	13.02	13.258	1157574.0
2013-09-17	AB	Stock	20.31	20.82	20.24	20.73	245500.0
2013-09-17	ABAC-DELISTED	Stock	0.8399	0.8399	0.818	0.82	2900.0
2013-09-17	ABAX-DELISTED	Stock	40.35	40.77	40.1	40.69	136171.0
2013-09-17	ABB-DELISTED	Stock	23.2	23.25	23.14	23.24	565738.0
2013-09-17	ABBNY-DELISTED	Stock	23.19	23.25	23.14	23.24	589746.0
2013-09-17	ABBV	Stock	45.92	47.7	45.86	47.6	7293800.0
2013-09-17	ABC-DELISTED	Stock	61.0	61.59	60.93	61.58	917871.0
2013-09-17	ABCB	Stock	19.1	19.22	18.98	19.16	39100.0
2013-09-17	ABCD-DELISTED	Stock	1.57	1.6399	1.57	1.62	2557.0
2013-09-17	ABCO-DELISTED	Stock	58.02	58.7	57.75	58.62	249868.0
2013-09-17	ABE-DELISTED	Stock	19.54	19.8891	19.5	19.69	15785.0
2013-09-17	ABEO	Stock	500.0	500.0	425.0	437.5	20.0
2013-09-17	ABFS-DELISTED	Stock	25.23	25.66	25.05	25.5	437296.0
2013-09-17	ABG	Stock	53.0	53.62	53.0	53.4	146000.0
2013-09-17	ABM	Stock	25.75	26.0	25.7	25.98	164500.0
2013-09-17	ABMD-DELISTED	Stock	23.42	23.8	23.36	23.62	164983.0
2013-09-17	ABR	Stock	7.21	7.28	7.17	7.26	28000.0
2013-09-17	ABR.A-DELISTED	Stock	24.66	24.66	24.66	24.66	100.0
2013-09-17	ABR.B-DELISTED	Stock	23.7	23.7	23.4	23.4	570.0
2013-09-17	ABT	Stock	35.0	35.02	34.82	34.97	4759700.0
2013-09-17	ABTL-DELISTED	Stock	7.48	7.57	7.41	7.54	34397.0
2013-09-17	ABUS	Stock	6.0	6.18	5.92	6.13	195000.0
2013-09-17	ABV-DELISTED	Stock	37.4	37.65	37.32	37.35	1668669.0
2013-09-17	ABX-DELISTED	Stock	18.45	18.47	17.9354	18.31	13199375.0
2013-09-17	ACAD	Stock	23.26	23.87	22.84	23.76	1898800.0

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

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