PREVIEW / stock_daily / 2013-06-21

all stock daily files

  file:    by_date/stock_daily/2013/2013-06-21.parquet
  size:    212 KB
  rows:    6,351
  symbols: 3,527

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-06-21	AAPL	Stock	14.9461	15.0	14.575	14.7679	481118400.0
2013-06-21	MSFT	Stock	33.66	33.73	33.05	33.27	85338500.0
2013-06-21	NVDA	Stock	0.363	0.3642	0.3545	0.3605	714228000.0
2013-06-21	AMZN	Stock	13.7285	13.792	13.4895	13.668	84020000.0
2013-06-21	META	Stock	24.59	24.7	24.05	24.53	45833900.0
2013-06-21	TSLA	Stock	6.9133	6.9133	6.5	6.6367	175779000.0
2013-06-21	TLT	Stock	110.15	110.41	108.37	108.402	19783702.0
2013-06-21	ES	Stock	39.88	40.54	39.35	40.37	2730800.0
2013-06-21	CL	Stock	56.39	57.09	56.01	56.81	6013600.0
2013-06-21	A	Stock	30.4721	30.9227	30.3076	30.7439	5107733.0
2013-06-21	AABA-DELISTED	Stock	25.31	25.43	24.94	25.21	24289710.0
2013-06-21	AACG	Stock	4.25	4.3	4.25	4.25	7100.0
2013-06-21	AAIC-DELISTED	Stock	27.07	27.5398	27.0	27.42	310546.0
2013-06-21	AAMC-DELISTED	Stock	76.7647	77.7941	76.4706	76.7647	14413.0
2013-06-21	AAME	Stock	3.93	3.93	3.8	3.92	6300.0
2013-06-21	AAMRQ-DELISTED	Stock	4.26	4.45	3.7	4.06	13185454.0
2013-06-21	AAON	Stock	9.5081	9.6148	9.0844	9.3511	598388.0
2013-06-21	AAP	Stock	83.02	83.08	80.57	80.74	966500.0
2013-06-21	AAT	Stock	30.03	30.31	29.47	29.62	294300.0
2013-06-21	AAU-DELISTED	Stock	1.35	1.38	1.32	1.33	131689.0
2013-06-21	AAUAF-DELISTED	Stock	1.35	1.38	1.32	1.33	132289.0
2013-06-21	AAV-DELISTED	Stock	4.05	4.09	4.01	4.05	229361.0
2013-06-21	AAWW-DELISTED	Stock	45.21	45.375	43.71	44.54	565700.0
2013-06-21	AAXJ	Stock	53.38	53.57	52.55	53.37	480135.0
2013-06-21	AAXN-DELISTED	Stock	8.88	9.09	8.8	8.91	628979.0
2013-06-21	AB	Stock	22.87	22.87	21.44	21.77	1009200.0
2013-06-21	ABAC-DELISTED	Stock	0.65	0.65	0.6	0.63	41052.0
2013-06-21	ABAX-DELISTED	Stock	45.58	46.61	45.58	46.02	171194.0
2013-06-21	ABB-DELISTED	Stock	21.4	21.45	21.06	21.23	2176895.0
2013-06-21	ABBNY-DELISTED	Stock	21.4	21.45	21.06	21.24	2232410.0
2013-06-21	ABBV	Stock	41.66	42.71	41.2	42.62	9825700.0
2013-06-21	ABC-DELISTED	Stock	54.24	54.93	54.15	54.34	2635302.0
2013-06-21	ABCB	Stock	15.84	16.11	15.57	16.05	102500.0
2013-06-21	ABCD-DELISTED	Stock	1.39	1.39	1.39	1.39	4893.0
2013-06-21	ABCO-DELISTED	Stock	53.25	54.63	53.25	53.62	243134.0
2013-06-21	ABCW-DELISTED	Stock	0.56	0.56	0.56	0.56	549.0
2013-06-21	ABE-DELISTED	Stock	19.16	19.5499	19.07	19.25	9385.0
2013-06-21	ABFS-DELISTED	Stock	18.85	19.09	17.68	18.93	639077.0
2013-06-21	ABG	Stock	38.99	39.16	37.67	38.26	329100.0
2013-06-21	ABM	Stock	24.25	24.25	23.74	24.1	313500.0
2013-06-21	ABMD-DELISTED	Stock	21.62	21.86	21.0	21.23	695454.0
2013-06-21	ABR	Stock	6.24	6.27	5.97	6.21	495100.0
2013-06-21	ABR.A-DELISTED	Stock	24.67	24.6999	24.45	24.5999	3800.0
2013-06-21	ABR.B-DELISTED	Stock	24.22	24.22	23.65	23.89	1530.0
2013-06-21	ABT	Stock	35.4	35.86	35.31	35.58	10122700.0
2013-06-21	ABTL-DELISTED	Stock	4.784	4.79	4.66	4.79	13047.0
2013-06-21	ABUS	Stock	4.65	4.74	4.65	4.67	90500.0
2013-06-21	ABV-DELISTED	Stock	34.46	34.95	33.73	34.84	7401103.0
2013-06-21	ABX-DELISTED	Stock	16.76	16.99	16.16	16.879	24645976.0
2013-06-21	ACAD	Stock	17.77	18.1	17.25	17.98	5412900.0

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

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