PREVIEW / stock_daily / 2011-06-21

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-21.parquet
  size:    198 KB
  rows:    6,152
  symbols: 3,575

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
2011-06-21	AAPL	Stock	11.31	11.6357	11.2571	11.6179	493382400.0
2011-06-21	MSFT	Stock	24.52	24.86	24.4	24.76	49708700.0
2011-06-21	NVDA	Stock	0.392	0.402	0.3882	0.399	704276000.0
2011-06-21	AMZN	Stock	9.415	9.75	9.356	9.7115	83652000.0
2011-06-21	TSLA	Stock	1.7493	1.8487	1.7333	1.8353	22440000.0
2011-06-21	TLT	Stock	96.7	97.03	96.27	96.59	7898711.0
2011-06-21	ES	Stock	35.17	35.45	34.92	35.21	1436300.0
2011-06-21	CL	Stock	44.68	44.68	44.135	44.46	6509800.0
2011-06-21	A	Stock	34.8355	35.9943	34.814	35.6366	4937736.0
2011-06-21	AABA-DELISTED	Stock	15.03	15.38	14.91	15.36	17489701.0
2011-06-21	AACC-DELISTED	Stock	3.57	3.78	3.27	3.73	45022.0
2011-06-21	AACG	Stock	10.31	10.33	10.0	10.26	36100.0
2011-06-21	AAIC-DELISTED	Stock	30.47	30.82	30.07	30.46	68453.0
2011-06-21	AAME	Stock	2.02	2.05	1.97	2.05	1400.0
2011-06-21	AAON	Stock	6.7348	6.7674	6.6222	6.723	456975.0
2011-06-21	AAP	Stock	59.04	59.26	58.25	58.89	1077600.0
2011-06-21	AAT	Stock	21.93	22.5	21.85	22.11	198300.0
2011-06-21	AATI-DELISTED	Stock	6.05	6.06	6.03	6.03	803177.0
2011-06-21	AAU-DELISTED	Stock	3.08	3.29	3.071	3.28	250838.0
2011-06-21	AAUAF-DELISTED	Stock	3.09	3.3	3.081	3.27	251758.0
2011-06-21	AAV-DELISTED	Stock	7.64	7.79	7.63	7.69	236699.0
2011-06-21	AAWW-DELISTED	Stock	56.77	58.47	56.01	58.39	171582.0
2011-06-21	AAXJ	Stock	60.19	60.9	60.11	60.76	867706.0
2011-06-21	AAXN-DELISTED	Stock	4.26	4.32	4.21	4.24	411565.0
2011-06-21	AB	Stock	19.02	19.49	19.02	19.41	408700.0
2011-06-21	ABAC-DELISTED	Stock	2.05	2.14	2.05	2.1	40740.0
2011-06-21	ABAX-DELISTED	Stock	27.69	28.59	27.68	28.55	75311.0
2011-06-21	ABB-DELISTED	Stock	25.11	25.78	25.045	25.68	4252555.0
2011-06-21	ABBC-DELISTED	Stock	10.46	10.58	9.8	10.09	141361.0
2011-06-21	ABBNY-DELISTED	Stock	25.11	25.78	25.045	25.68	4402318.0
2011-06-21	ABC-DELISTED	Stock	41.4	41.72	41.37	41.58	1617126.0
2011-06-21	ABCB	Stock	9.13	9.17	9.01	9.16	40700.0
2011-06-21	ABCD-DELISTED	Stock	3.19	3.27	3.04	3.24	12366.0
2011-06-21	ABCO-DELISTED	Stock	26.31	26.88	26.0	26.7	89674.0
2011-06-21	ABCW-DELISTED	Stock	0.69	0.75	0.69	0.73	6010.0
2011-06-21	ABD-DELISTED	Stock	7.71	7.99	7.68	7.93	185980.0
2011-06-21	ABE-DELISTED	Stock	18.35	18.54	18.35	18.51	10339.0
2011-06-21	ABEO	Stock	2437.5	2437.5	2087.5	2412.5	6.0
2011-06-21	ABFS-DELISTED	Stock	22.11	22.49	22.01	22.43	304697.0
2011-06-21	ABG	Stock	17.16	17.76	17.13	17.65	418800.0
2011-06-21	ABH-DELISTED	Stock	21.95	22.18	21.59	21.96	365466.0
2011-06-21	ABM	Stock	23.14	23.34	22.85	22.93	340000.0
2011-06-21	ABMD-DELISTED	Stock	16.93	17.17	16.62	16.7	152980.0
2011-06-21	ABR	Stock	4.4	4.48	4.37	4.46	24500.0
2011-06-21	ABT	Stock	25.0552	25.1799	24.9736	25.0743	11158816.0
2011-06-21	ABTL-DELISTED	Stock	4.851	4.95	4.851	4.95	10175.0
2011-06-21	ABUS	Stock	2.6	2.7	2.6	2.63	17800.0
2011-06-21	ABV-DELISTED	Stock	31.98	32.56	31.906	32.36	1914332.0
2011-06-21	ABVA-DELISTED	Stock	4.59	4.979	4.56	4.58	2400.0
2011-06-21	ABVT-DELISTED	Stock	70.91	71.54	70.58	70.79	169766.0

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

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