PREVIEW / stock_daily / 2013-11-06

all stock daily files

  file:    by_date/stock_daily/2013/2013-11-06.parquet
  size:    214 KB
  rows:    6,423
  symbols: 3,533

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-06	AAPL	Stock	18.7196	18.745	18.5071	18.6043	223375600.0
2013-11-06	MSFT	Stock	37.24	38.22	37.06	38.18	88948800.0
2013-11-06	NVDA	Stock	0.37	0.3728	0.3662	0.3725	198044000.0
2013-11-06	AMZN	Stock	18.0225	18.1435	17.725	17.809	45646000.0
2013-11-06	META	Stock	50.26	50.45	48.71	49.12	67889000.0
2013-11-06	TSLA	Stock	10.3207	10.7153	9.7567	10.0773	466075500.0
2013-11-06	TLT	Stock	104.94	105.14	104.69	105.07	5643041.0
2013-11-06	ES	Stock	42.5	43.16	42.43	42.95	1352100.0
2013-11-06	CL	Stock	65.61	66.05	65.39	66.01	2523600.0
2013-11-06	A	Stock	36.6166	36.7096	36.3376	36.5093	1997323.0
2013-11-06	AABA-DELISTED	Stock	33.05	33.3	32.71	32.885	10760490.0
2013-11-06	AACG	Stock	4.12	4.2	4.11	4.13	7600.0
2013-11-06	AAIC-DELISTED	Stock	24.71	24.92	24.648	24.9	109047.0
2013-11-06	AAMC-DELISTED	Stock	188.2353	196.0059	188.2353	188.2353	7075.0
2013-11-06	AAME	Stock	4.04	4.05	3.97	4.04	10000.0
2013-11-06	AAMRQ-DELISTED	Stock	9.5	9.8	8.88	9.22	22932733.0
2013-11-06	AAOI	Stock	12.5	13.31	12.5	13.12	99900.0
2013-11-06	AAON	Stock	12.7822	12.9156	12.6133	12.7733	179550.0
2013-11-06	AAP	Stock	100.0	100.02	98.14	98.51	684000.0
2013-11-06	AAT	Stock	33.7	34.16	32.5	32.75	184200.0
2013-11-06	AAU-DELISTED	Stock	1.28	1.32	1.28	1.3	58005.0
2013-11-06	AAUAF-DELISTED	Stock	1.28	1.32	1.28	1.3	58205.0
2013-11-06	AAV-DELISTED	Stock	3.91	3.92	3.79	3.79	251748.0
2013-11-06	AAWW-DELISTED	Stock	38.53	39.03	38.28	38.37	351261.0
2013-11-06	AAXJ	Stock	60.13	60.15	59.86	59.9	196850.0
2013-11-06	AAXN-DELISTED	Stock	17.73	17.89	16.92	17.18	1010248.0
2013-11-06	AB	Stock	22.27	22.6	22.16	22.19	340800.0
2013-11-06	ABAC-DELISTED	Stock	1.62	1.84	1.61	1.8	200660.0
2013-11-06	ABAX-DELISTED	Stock	35.51	35.72	34.99	34.99	84563.0
2013-11-06	ABB-DELISTED	Stock	25.42	25.49	25.35	25.47	1228830.0
2013-11-06	ABBNY-DELISTED	Stock	25.42	25.49	25.35	25.48	1264303.0
2013-11-06	ABBV	Stock	48.5	48.74	48.0	48.05	4308100.0
2013-11-06	ABC-DELISTED	Stock	67.17	67.4	66.56	67.17	1354050.0
2013-11-06	ABCB	Stock	18.48	18.89	17.99	18.78	45200.0
2013-11-06	ABCD-DELISTED	Stock	1.3131	1.35	1.3131	1.35	753.0
2013-11-06	ABCO-DELISTED	Stock	64.67	65.67	59.56	59.865	522129.0
2013-11-06	ABE-DELISTED	Stock	20.22	20.22	19.82	19.918	11688.0
2013-11-06	ABEO	Stock	387.5	412.5	375.0	412.5	63.0
2013-11-06	ABFS-DELISTED	Stock	28.14	28.14	26.29	26.54	308954.0
2013-11-06	ABG	Stock	49.9	49.9	48.29	48.47	241300.0
2013-11-06	ABGB-DELISTED	Stock	11.58	11.81	11.58	11.62	184511.0
2013-11-06	ABM	Stock	27.84	27.94	27.52	27.61	121400.0
2013-11-06	ABMD-DELISTED	Stock	24.62	26.48	24.315	25.82	1325209.0
2013-11-06	ABR	Stock	6.58	6.7	6.54	6.57	82300.0
2013-11-06	ABR.A-DELISTED	Stock	25.01	25.0399	24.8575	25.0399	2305.0
2013-11-06	ABR.B-DELISTED	Stock	23.5	23.5	23.47	23.5	1825.0
2013-11-06	ABT	Stock	37.45	37.8	37.04	37.56	7082400.0
2013-11-06	ABTL-DELISTED	Stock	8.33	8.5	7.81	8.13	112038.0
2013-11-06	ABUS	Stock	8.81	8.88	8.2	8.25	289700.0
2013-11-06	ABV-DELISTED	Stock	36.52	37.03	36.5	36.8	2263277.0

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

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