PREVIEW / stock_daily / 2013-08-22

all stock daily files

  file:    by_date/stock_daily/2013/2013-08-22.parquet
  size:    211 KB
  rows:    6,360
  symbols: 3,511

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-08-22	AAPL	Stock	18.035	18.0568	17.7929	17.9629	244207600.0
2013-08-22	MSFT	Stock	32.19	32.49	32.1	32.39	31169900.0
2013-08-22	NVDA	Stock	0.3718	0.3775	0.3718	0.374	129016000.0
2013-08-22	AMZN	Stock	14.24	14.4935	14.24	14.4865	28452000.0
2013-08-22	META	Stock	38.37	38.75	38.34	38.55	21931200.0
2013-08-22	TSLA	Stock	9.948	10.4987	9.876	10.4733	158886000.0
2013-08-22	TLT	Stock	102.46	103.23	102.24	103.17	8751942.0
2013-08-22	ES	Stock	41.12	41.4	40.91	41.24	1039800.0
2013-08-22	CL	Stock	58.47	58.59	58.25	58.45	3035500.0
2013-08-22	A	Stock	33.5408	34.5708	33.4764	34.3133	4400904.0
2013-08-22	AABA-DELISTED	Stock	27.51	28.01	27.37	27.9	14148216.0
2013-08-22	AACG	Stock	5.13	5.21	5.13	5.21	500.0
2013-08-22	AAIC-DELISTED	Stock	23.25	23.58	23.25	23.52	62697.0
2013-08-22	AAMC-DELISTED	Stock	88.2353	91.1765	88.2353	91.1765	13291.0
2013-08-22	AAME	Stock	3.8	3.94	3.69	3.82	51700.0
2013-08-22	AAMRQ-DELISTED	Stock	3.095	3.2	3.06	3.07	8241039.0
2013-08-22	AAON	Stock	10.7911	11.1511	10.64	11.0489	153450.0
2013-08-22	AAP	Stock	81.67	82.25	81.53	81.8	382200.0
2013-08-22	AAT	Stock	29.67	30.04	29.47	29.94	221300.0
2013-08-22	AAU-DELISTED	Stock	1.92	1.92	1.9	1.9	67614.0
2013-08-22	AAUAF-DELISTED	Stock	1.92	1.92	1.9	1.9	67914.0
2013-08-22	AAV-DELISTED	Stock	3.63	3.68	3.57	3.61	167420.0
2013-08-22	AAWW-DELISTED	Stock	45.93	47.25	45.75	46.95	147099.0
2013-08-22	AAXJ	Stock	54.36	55.1	54.18	54.51	255513.0
2013-08-22	AAXN-DELISTED	Stock	11.24	11.46	11.03	11.37	1280428.0
2013-08-22	AB	Stock	19.37	19.75	19.3	19.44	301900.0
2013-08-22	ABAC-DELISTED	Stock	0.9	1.14	0.8501	0.95	187509.0
2013-08-22	ABAX-DELISTED	Stock	40.94	41.51	40.94	41.33	42227.0
2013-08-22	ABB-DELISTED	Stock	22.47	22.55	22.42	22.53	767374.0
2013-08-22	ABBNY-DELISTED	Stock	22.47	22.55	22.42	22.54	775702.0
2013-08-22	ABBV	Stock	42.4	43.1	42.29	42.92	4077700.0
2013-08-22	ABC-DELISTED	Stock	57.22	57.66	57.14	57.44	1550806.0
2013-08-22	ABCB	Stock	18.7	19.27	17.8	19.0	64100.0
2013-08-22	ABCD-DELISTED	Stock	1.41	1.45	1.36	1.45	1688340.0
2013-08-22	ABCO-DELISTED	Stock	56.22	56.94	55.92	56.8	47946.0
2013-08-22	ABE-DELISTED	Stock	18.83	19.11	18.83	19.11	2025.0
2013-08-22	ABEO	Stock	425.0	425.0	425.0	425.0	3.0
2013-08-22	ABFS-DELISTED	Stock	24.22	25.19	24.1444	25.12	358775.0
2013-08-22	ABG	Stock	50.15	50.7	49.82	50.13	154900.0
2013-08-22	ABM	Stock	25.19	25.59	25.19	25.41	79600.0
2013-08-22	ABMD-DELISTED	Stock	22.3	22.57	22.22	22.44	102091.0
2013-08-22	ABR	Stock	7.12	7.12	6.81	6.97	55600.0
2013-08-22	ABR.A-DELISTED	Stock	23.5	24.0	23.5	24.0	300.0
2013-08-22	ABR.B-DELISTED	Stock	22.269	22.269	22.14	22.15	2645.0
2013-08-22	ABT	Stock	34.67	34.75	34.43	34.67	4197500.0
2013-08-22	ABTL-DELISTED	Stock	6.03	6.19	5.8	6.02	56179.0
2013-08-22	ABUS	Stock	5.2	5.24	5.2	5.24	3700.0
2013-08-22	ABV-DELISTED	Stock	33.95	34.46	33.73	34.07	3105664.0
2013-08-22	ABX-DELISTED	Stock	19.48	19.85	19.32	19.53	12597978.0
2013-08-22	ACAD	Stock	20.23	20.56	20.2	20.47	757000.0

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

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