PREVIEW / stock_daily / 2013-11-14

all stock daily files

  file:    by_date/stock_daily/2013/2013-11-14.parquet
  size:    215 KB
  rows:    6,440
  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-11-14	AAPL	Stock	18.6718	18.9029	18.6382	18.8629	282419200.0
2013-11-14	MSFT	Stock	37.87	38.13	37.72	38.02	46183700.0
2013-11-14	NVDA	Stock	0.4025	0.408	0.4022	0.4055	307980000.0
2013-11-14	AMZN	Stock	17.8695	18.447	17.8215	18.37	83196000.0
2013-11-14	META	Stock	48.7	49.57	48.03	48.99	75117000.0
2013-11-14	TSLA	Stock	9.2613	9.36	8.9407	9.1733	183055500.0
2013-11-14	TLT	Stock	104.31	105.12	104.15	104.52	8895490.0
2013-11-14	ES	Stock	42.33	43.03	42.33	42.76	1372300.0
2013-11-14	CL	Stock	65.33	65.71	65.24	65.6	2673700.0
2013-11-14	A	Stock	36.6237	36.6237	36.0229	36.1516	3963190.0
2013-11-14	AABA-DELISTED	Stock	35.07	35.89	34.76	35.69	21115449.0
2013-11-14	AACG	Stock	4.21	4.27	4.21	4.22	1000.0
2013-11-14	AAIC-DELISTED	Stock	25.15	25.659	25.15	25.57	122340.0
2013-11-14	AAMC-DELISTED	Stock	167.8882	175.8765	167.8882	175.8765	1846.0
2013-11-14	AAME	Stock	4.04	4.07	4.01	4.03	17800.0
2013-11-14	AAMRQ-DELISTED	Stock	12.06	12.16	11.84	11.95	11973943.0
2013-11-14	AAOI	Stock	12.51	12.58	12.21	12.39	20900.0
2013-11-14	AAON	Stock	12.0222	12.3956	11.9333	12.2267	125550.0
2013-11-14	AAP	Stock	99.58	99.95	98.14	98.88	289000.0
2013-11-14	AAT	Stock	32.09	32.44	31.98	32.25	69600.0
2013-11-14	AAU-DELISTED	Stock	1.29	1.3224	1.22	1.22	170581.0
2013-11-14	AAUAF-DELISTED	Stock	1.26	1.29	1.19	1.22	175077.0
2013-11-14	AAV-DELISTED	Stock	3.84	4.0	3.819	3.99	135593.0
2013-11-14	AAWW-DELISTED	Stock	37.93	38.34	37.71	37.91	181656.0
2013-11-14	AAXJ	Stock	58.34	59.1	58.3	59.01	706730.0
2013-11-14	AAXN-DELISTED	Stock	17.75	17.89	17.22	17.31	1309090.0
2013-11-14	AB	Stock	21.4	21.85	21.3	21.54	243500.0
2013-11-14	ABAC-DELISTED	Stock	2.05	2.05	1.8813	1.95	274219.0
2013-11-14	ABAX-DELISTED	Stock	35.33	35.77	34.956	35.31	47443.0
2013-11-14	ABB-DELISTED	Stock	25.08	25.26	25.05	25.25	1330130.0
2013-11-14	ABBNY-DELISTED	Stock	25.08	25.26	25.05	25.26	1409525.0
2013-11-14	ABBV	Stock	47.99	48.47	47.69	48.04	3411800.0
2013-11-14	ABC-DELISTED	Stock	68.34	69.36	68.261	69.21	1357447.0
2013-11-14	ABCB	Stock	19.39	19.41	19.15	19.38	71100.0
2013-11-14	ABCD-DELISTED	Stock	1.34	1.4	1.34	1.389	12780.0
2013-11-14	ABCO-DELISTED	Stock	62.08	62.68	61.56	62.38	110186.0
2013-11-14	ABE-DELISTED	Stock	19.698	19.698	19.42	19.64	3110.0
2013-11-14	ABEO	Stock	400.0	400.0	375.0	400.0	12.0
2013-11-14	ABEV	Stock	7.38	7.56	7.25	7.47	5874600.0
2013-11-14	ABFS-DELISTED	Stock	31.63	31.64	30.88	31.49	452726.0
2013-11-14	ABG	Stock	50.72	50.81	49.43	50.26	202600.0
2013-11-14	ABGB-DELISTED	Stock	11.61	11.84	11.59	11.84	27195.0
2013-11-14	ABM	Stock	27.91	28.0	27.82	27.98	99300.0
2013-11-14	ABMD-DELISTED	Stock	27.59	27.63	27.0501	27.3	144162.0
2013-11-14	ABR	Stock	6.64	6.84	6.64	6.83	160600.0
2013-11-14	ABR.A-DELISTED	Stock	24.59	24.6	24.59	24.59	2000.0
2013-11-14	ABR.B-DELISTED	Stock	22.71	23.1	22.71	22.8499	1140.0
2013-11-14	ABT	Stock	37.89	38.08	37.67	37.76	4353100.0
2013-11-14	ABTL-DELISTED	Stock	10.75	11.47	10.66	11.02	374776.0
2013-11-14	ABUS	Stock	7.75	8.27	7.63	8.08	143700.0

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

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