PREVIEW / stock_daily / 2013-10-23

all stock daily files

  file:    by_date/stock_daily/2013/2013-10-23.parquet
  size:    215 KB
  rows:    6,413
  symbols: 3,540

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-23	AAPL	Stock	18.5357	18.7739	18.5357	18.7486	313723200.0
2013-10-23	MSFT	Stock	34.35	34.49	33.67	33.76	58600500.0
2013-10-23	NVDA	Stock	0.3935	0.3935	0.3862	0.3875	252216000.0
2013-10-23	AMZN	Stock	16.542	16.586	16.203	16.338	56364000.0
2013-10-23	META	Stock	51.75	52.25	51.13	51.9	57207000.0
2013-10-23	TSLA	Stock	11.2607	11.454	10.6767	10.9667	199806000.0
2013-10-23	TLT	Stock	108.07	108.73	108.035	108.31	9165579.0
2013-10-23	ES	Stock	42.4	43.19	42.4	42.91	2430800.0
2013-10-23	CL	Stock	63.19	63.76	63.08	63.47	4075600.0
2013-10-23	A	Stock	36.309	36.3948	35.98	36.2303	3283343.0
2013-10-23	AABA-DELISTED	Stock	33.71	33.84	33.02	33.091	15138218.0
2013-10-23	AACG	Stock	4.72	4.9	4.7	4.88	5500.0
2013-10-23	AAIC-DELISTED	Stock	25.25	25.5465	25.22	25.43	115478.0
2013-10-23	AAMC-DELISTED	Stock	176.4706	187.0382	174.9706	182.3676	6729.0
2013-10-23	AAME	Stock	4.04	4.06	4.04	4.06	2900.0
2013-10-23	AAMRQ-DELISTED	Stock	6.195	6.31	6.06	6.3	7637772.0
2013-10-23	AAOI	Stock	12.99	13.41	12.9	13.11	65000.0
2013-10-23	AAON	Stock	12.0444	12.2933	11.7867	12.2578	107550.0
2013-10-23	AAP	Stock	98.73	99.84	98.3	99.77	498800.0
2013-10-23	AAT	Stock	33.36	33.9	33.29	33.81	140600.0
2013-10-23	AAU-DELISTED	Stock	1.43	1.4609	1.39	1.39	72332.0
2013-10-23	AAUAF-DELISTED	Stock	1.41	1.4399	1.37	1.39	73985.0
2013-10-23	AAV-DELISTED	Stock	4.0	4.0001	3.86	3.915	148193.0
2013-10-23	AAWW-DELISTED	Stock	46.52	47.74	45.96	47.4	311928.0
2013-10-23	AAXJ	Stock	60.57	60.57	60.13	60.16	598817.0
2013-10-23	AAXN-DELISTED	Stock	15.47	15.61	15.24	15.36	796538.0
2013-10-23	AB	Stock	21.5	21.61	21.0	21.17	509400.0
2013-10-23	ABAC-DELISTED	Stock	1.7	1.77	1.65	1.67	225082.0
2013-10-23	ABAX-DELISTED	Stock	35.33	35.75	32.11	32.29	1441742.0
2013-10-23	ABB-DELISTED	Stock	24.54	24.68	24.47	24.58	1703853.0
2013-10-23	ABBNY-DELISTED	Stock	24.54	24.68	24.47	24.6	1752056.0
2013-10-23	ABBV	Stock	48.76	48.86	48.28	48.33	4130300.0
2013-10-23	ABC-DELISTED	Stock	63.63	64.0	63.24	63.84	1173697.0
2013-10-23	ABCB	Stock	17.92	18.0	17.89	17.9	178000.0
2013-10-23	ABCD-DELISTED	Stock	1.32	1.35	1.31	1.34	23498.0
2013-10-23	ABCO-DELISTED	Stock	67.15	68.27	66.82	67.21	98096.0
2013-10-23	ABE-DELISTED	Stock	20.5	20.511	20.23	20.374	5592.0
2013-10-23	ABEO	Stock	437.5	437.5	412.5	425.0	41.0
2013-10-23	ABFS-DELISTED	Stock	27.0	28.15	27.0	27.21	343797.0
2013-10-23	ABG	Stock	50.45	50.45	46.55	48.31	1707200.0
2013-10-23	ABGB-DELISTED	Stock	12.52	12.58	11.96	12.35	83827.0
2013-10-23	ABM	Stock	28.94	29.2	28.69	28.82	633300.0
2013-10-23	ABMD-DELISTED	Stock	20.14	20.87	20.1	20.6	220225.0
2013-10-23	ABR	Stock	6.97	7.05	6.95	7.0	144100.0
2013-10-23	ABR.A-DELISTED	Stock	24.965	24.989	24.86	24.9858	1300.0
2013-10-23	ABR.B-DELISTED	Stock	23.55	23.55	23.5	23.5	200.0
2013-10-23	ABT	Stock	36.91	37.26	36.81	37.23	7571500.0
2013-10-23	ABTL-DELISTED	Stock	8.57	8.91	8.32	8.46	52295.0
2013-10-23	ABUS	Stock	8.73	8.75	8.48	8.64	152900.0
2013-10-23	ABV-DELISTED	Stock	39.43	39.46	38.46	38.75	2791035.0

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

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