PREVIEW / stock_daily / 2013-05-23

all stock daily files

  file:    by_date/stock_daily/2013/2013-05-23.parquet
  size:    210 KB
  rows:    6,375
  symbols: 3,547

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-05-23	AAPL	Stock	15.5696	15.9343	15.5639	15.7907	353021200.0
2013-05-23	MSFT	Stock	34.23	34.55	33.9	34.15	51102700.0
2013-05-23	NVDA	Stock	0.3558	0.367	0.3548	0.3658	393884000.0
2013-05-23	AMZN	Stock	13.0245	13.1585	12.9795	13.09	40006000.0
2013-05-23	META	Stock	24.8	25.53	24.77	25.06	37663100.0
2013-05-23	TSLA	Stock	5.654	6.2007	5.5367	6.182	180333000.0
2013-05-23	TLT	Stock	117.15	117.24	115.77	116.64	9207043.0
2013-05-23	ES	Stock	43.69	43.77	42.96	43.53	1011900.0
2013-05-23	CL	Stock	61.07	61.33	60.87	60.97	3159600.0
2013-05-23	A	Stock	32.6896	32.8541	32.3319	32.7182	5280945.0
2013-05-23	AABA-DELISTED	Stock	25.99	26.27	25.7	26.01	21475584.0
2013-05-23	AACC-DELISTED	Stock	6.61	6.69	6.61	6.69	200930.0
2013-05-23	AACG	Stock	4.3	4.8	4.13	4.3	4000.0
2013-05-23	AAIC-DELISTED	Stock	28.02	28.62	27.12	28.48	284112.0
2013-05-23	AAMC-DELISTED	Stock	92.0588	92.0588	85.9559	88.1618	13073.0
2013-05-23	AAME	Stock	3.63	3.7	3.6	3.68	14100.0
2013-05-23	AAMRQ-DELISTED	Stock	5.305	5.86	5.29	5.6	8109020.0
2013-05-23	AAON	Stock	9.7481	9.9822	9.7452	9.7896	382388.0
2013-05-23	AAP	Stock	84.57	85.42	83.22	84.08	1444700.0
2013-05-23	AAT	Stock	34.01	34.66	33.67	34.66	269200.0
2013-05-23	AAU-DELISTED	Stock	1.6	1.65	1.5898	1.65	53319.0
2013-05-23	AAUAF-DELISTED	Stock	1.6	1.65	1.5898	1.65	54864.0
2013-05-23	AAV-DELISTED	Stock	4.24	4.37	4.19	4.35	943731.0
2013-05-23	AAWW-DELISTED	Stock	45.17	45.47	44.54	45.44	184058.0
2013-05-23	AAXJ	Stock	59.47	59.76	59.06	59.74	457606.0
2013-05-23	AAXN-DELISTED	Stock	8.5	9.13	8.45	9.12	757878.0
2013-05-23	AB	Stock	25.87	26.03	25.38	25.74	402100.0
2013-05-23	ABAC-DELISTED	Stock	0.681	0.722	0.662	0.7	15981.0
2013-05-23	ABAX-DELISTED	Stock	43.21	44.07	42.9301	43.52	103539.0
2013-05-23	ABB-DELISTED	Stock	22.03	22.11	21.935	22.07	3584885.0
2013-05-23	ABBNY-DELISTED	Stock	22.03	22.11	21.935	22.08	3835089.0
2013-05-23	ABBV	Stock	46.12	46.95	46.02	46.59	3306200.0
2013-05-23	ABC-DELISTED	Stock	54.32	54.8	54.05	54.57	1749856.0
2013-05-23	ABCB	Stock	15.95	16.14	15.85	16.09	24500.0
2013-05-23	ABCD-DELISTED	Stock	1.2	1.35	1.19	1.34	114437.0
2013-05-23	ABCO-DELISTED	Stock	50.19	50.98	50.02	50.19	208553.0
2013-05-23	ABCW-DELISTED	Stock	0.632	0.64	0.621	0.64	20100.0
2013-05-23	ABE-DELISTED	Stock	21.48	21.56	21.25	21.25	15268.0
2013-05-23	ABEO	Stock	625.0	650.0	562.5	650.0	21.0
2013-05-23	ABFS-DELISTED	Stock	17.78	17.85	16.59	17.64	601868.0
2013-05-23	ABG	Stock	40.4	41.6	40.25	41.16	215900.0
2013-05-23	ABM	Stock	23.13	23.46	22.97	23.4	95000.0
2013-05-23	ABMD-DELISTED	Stock	21.64	21.78	21.39	21.72	609318.0
2013-05-23	ABR	Stock	6.96	7.17	6.87	7.15	202300.0
2013-05-23	ABR.A-DELISTED	Stock	25.57	25.6	25.5001	25.6	5850.0
2013-05-23	ABR.B-DELISTED	Stock	25.15	25.15	25.1	25.14	3600.0
2013-05-23	ABT	Stock	37.49	37.86	37.3	37.48	7067600.0
2013-05-23	ABTL-DELISTED	Stock	4.94	5.0	4.63	4.85	139176.0
2013-05-23	ABUS	Stock	4.67	4.75	4.61	4.75	52700.0
2013-05-23	ABV-DELISTED	Stock	41.17	41.95	41.1	41.9	2593996.0

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

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