PREVIEW / stock_daily / 2013-10-28

all stock daily files

  file:    by_date/stock_daily/2013/2013-10-28.parquet
  size:    214 KB
  rows:    6,407
  symbols: 3,535

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-10-28	AAPL	Stock	18.8943	18.9643	18.6861	18.9243	550440800.0
2013-10-28	MSFT	Stock	35.61	35.73	35.27	35.57	38383600.0
2013-10-28	NVDA	Stock	0.3805	0.3822	0.375	0.3803	394024000.0
2013-10-28	AMZN	Stock	17.996	18.1375	17.86	17.908	72716000.0
2013-10-28	META	Stock	51.54	51.7	49.61	50.23	73472000.0
2013-10-28	TSLA	Stock	11.3453	11.3667	10.8133	10.8573	117625500.0
2013-10-28	TLT	Stock	108.01	108.3801	107.91	107.92	6469344.0
2013-10-28	ES	Stock	43.43	43.66	43.16	43.32	836600.0
2013-10-28	CL	Stock	63.69	64.79	63.66	64.76	4087300.0
2013-10-28	A	Stock	37.0458	37.1817	36.5665	36.8312	2486623.0
2013-10-28	AABA-DELISTED	Stock	32.12	32.7	31.7	32.35	16863624.0
2013-10-28	AACG	Stock	4.34	4.35	4.1	4.1	13500.0
2013-10-28	AAIC-DELISTED	Stock	25.49	25.49	25.13	25.21	134444.0
2013-10-28	AAMC-DELISTED	Stock	183.8412	185.2941	176.4706	176.5441	6290.0
2013-10-28	AAME	Stock	4.03	4.04	4.03	4.04	1200.0
2013-10-28	AAMRQ-DELISTED	Stock	6.355	6.85	6.35	6.54	7789073.0
2013-10-28	AAOI	Stock	12.25	12.38	11.53	11.87	67800.0
2013-10-28	AAON	Stock	12.7422	12.9511	12.1422	12.2356	167400.0
2013-10-28	AAP	Stock	102.67	102.82	100.85	101.0	617900.0
2013-10-28	AAT	Stock	34.07	34.08	33.58	33.8	288400.0
2013-10-28	AAU-DELISTED	Stock	1.44	1.45	1.39	1.4	52652.0
2013-10-28	AAUAF-DELISTED	Stock	1.43	1.44	1.39	1.41	53035.0
2013-10-28	AAV-DELISTED	Stock	4.05	4.05	3.97	3.975	105333.0
2013-10-28	AAWW-DELISTED	Stock	48.44	50.98	48.03	49.61	359506.0
2013-10-28	AAXJ	Stock	60.18	60.37	60.09	60.24	313555.0
2013-10-28	AAXN-DELISTED	Stock	15.04	15.25	14.99	15.25	688767.0
2013-10-28	AB	Stock	21.8	22.76	21.66	22.28	860800.0
2013-10-28	ABAC-DELISTED	Stock	1.6	1.65	1.51	1.54	39005.0
2013-10-28	ABAX-DELISTED	Stock	34.59	35.74	34.59	35.7	243671.0
2013-10-28	ABB-DELISTED	Stock	25.7	25.88	25.64	25.79	1591651.0
2013-10-28	ABBNY-DELISTED	Stock	25.7	25.88	25.64	25.8	1755616.0
2013-10-28	ABBV	Stock	49.13	49.97	48.97	49.42	5555000.0
2013-10-28	ABC-DELISTED	Stock	65.16	65.38	64.525	65.19	1345811.0
2013-10-28	ABCB	Stock	17.9	18.9	17.9	18.75	314800.0
2013-10-28	ABCD-DELISTED	Stock	1.325	1.36	1.31	1.36	21823.0
2013-10-28	ABCO-DELISTED	Stock	69.0	69.9	68.64	69.15	79182.0
2013-10-28	ABE-DELISTED	Stock	20.34	20.5384	20.34	20.5384	5356.0
2013-10-28	ABEO	Stock	400.0	412.5	400.0	412.5	10.0
2013-10-28	ABFS-DELISTED	Stock	27.58	28.3	27.3	27.47	386534.0
2013-10-28	ABG	Stock	48.57	48.66	47.82	48.0	419600.0
2013-10-28	ABGB-DELISTED	Stock	11.86	11.95	11.5	11.94	62091.0
2013-10-28	ABM	Stock	28.52	28.58	28.27	28.4	125700.0
2013-10-28	ABMD-DELISTED	Stock	21.45	21.61	21.14	21.61	243498.0
2013-10-28	ABR	Stock	7.05	7.05	6.94	6.97	153100.0
2013-10-28	ABR.A-DELISTED	Stock	24.98	25.18	24.98	25.16	2000.0
2013-10-28	ABR.B-DELISTED	Stock	23.45	23.5	23.45	23.4999	1300.0
2013-10-28	ABT	Stock	37.33	37.46	37.17	37.28	4799700.0
2013-10-28	ABTL-DELISTED	Stock	8.41	8.57	8.01	8.25	184421.0
2013-10-28	ABUS	Stock	9.64	9.64	8.67	8.96	368900.0
2013-10-28	ABV-DELISTED	Stock	38.72	39.18	38.58	39.1	1565470.0

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

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