PREVIEW / stock_daily / 2011-03-17

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-17.parquet
  size:    197 KB
  rows:    6,061
  symbols: 3,532

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-03-17	AAPL	Stock	12.0296	12.1289	11.8093	11.9514	659422400.0
2011-03-17	MSFT	Stock	25.06	25.22	24.75	24.78	62497000.0
2011-03-17	NVDA	Stock	0.45	0.4508	0.43	0.4465	1238516000.0
2011-03-17	AMZN	Stock	8.2955	8.315	8.039	8.0485	129428000.0
2011-03-17	TSLA	Stock	1.5493	1.562	1.5093	1.5207	13839000.0
2011-03-17	TLT	Stock	93.24	93.61	92.76	93.21	10531038.0
2011-03-17	ES	Stock	33.58	33.61	32.93	33.5	1520500.0
2011-03-17	CL	Stock	38.675	38.78	38.265	38.35	6285000.0
2011-03-17	A	Stock	30.8512	31.1016	29.9714	30.3648	6082838.0
2011-03-17	AABA-DELISTED	Stock	16.16	16.42	15.81	15.86	37389307.0
2011-03-17	AACC-DELISTED	Stock	5.56	5.56	5.45	5.465	12060.0
2011-03-17	AACG	Stock	8.41	8.6	7.84	8.09	49200.0
2011-03-17	AAI-DELISTED	Stock	7.38	7.39	7.27	7.28	3478942.0
2011-03-17	AAIC-DELISTED	Stock	27.61	27.72	27.02	27.16	59045.0
2011-03-17	AAME	Stock	2.08	2.1	2.05	2.05	800.0
2011-03-17	AAON	Stock	5.7956	5.8963	5.756	5.764	220219.0
2011-03-17	AAP	Stock	65.63	65.63	64.3	64.48	940800.0
2011-03-17	AAT	Stock	21.08	21.24	20.85	20.93	167400.0
2011-03-17	AATI-DELISTED	Stock	3.72	3.73	3.43	3.49	797434.0
2011-03-17	AAU-DELISTED	Stock	3.44	3.55	3.42	3.495	249698.0
2011-03-17	AAUAF-DELISTED	Stock	3.43	3.56	3.42	3.5	250054.0
2011-03-17	AAV-DELISTED	Stock	7.99	8.0885	7.85	8.04	584165.0
2011-03-17	AAWW-DELISTED	Stock	63.44	64.96	62.53	63.3	357798.0
2011-03-17	AAXJ	Stock	59.31	59.4	58.74	59.1	222248.0
2011-03-17	AAXN-DELISTED	Stock	3.89	3.91	3.76	3.77	581477.0
2011-03-17	AB	Stock	21.17	21.32	20.89	20.96	549900.0
2011-03-17	ABAC-DELISTED	Stock	4.25	4.8799	4.25	4.8799	85082.0
2011-03-17	ABAX-DELISTED	Stock	27.62	27.64	26.96	27.53	78535.0
2011-03-17	ABB-DELISTED	Stock	22.91	22.98	22.76	22.89	3026334.0
2011-03-17	ABBC-DELISTED	Stock	11.63	11.76	11.46	11.58	49132.0
2011-03-17	ABBNY-DELISTED	Stock	22.91	22.98	22.76	22.87	3277091.0
2011-03-17	ABC-DELISTED	Stock	36.96	37.12	36.52	36.61	2336584.0
2011-03-17	ABCB	Stock	9.55	9.72	9.39	9.56	48000.0
2011-03-17	ABCD-DELISTED	Stock	3.35	3.35	3.26	3.3	21416.0
2011-03-17	ABCO-DELISTED	Stock	23.81	23.95	23.38	23.52	178710.0
2011-03-17	ABCW-DELISTED	Stock	1.1	1.12	1.04	1.04	61230.0
2011-03-17	ABD-DELISTED	Stock	9.0	9.02	8.59	8.66	334960.0
2011-03-17	ABE-DELISTED	Stock	17.8	17.8	17.56	17.68	17171.0
2011-03-17	ABEO	Stock	2487.5	2500.0	2387.5	2500.0	3.0
2011-03-17	ABFS-DELISTED	Stock	24.62	24.73	23.77	23.92	399141.0
2011-03-17	ABG	Stock	17.54	17.73	17.1	17.46	378500.0
2011-03-17	ABH-DELISTED	Stock	26.52	26.91	25.78	25.83	1529672.0
2011-03-17	ABM	Stock	24.62	24.66	24.17	24.24	208900.0
2011-03-17	ABMD-DELISTED	Stock	13.87	13.94	13.68	13.76	195030.0
2011-03-17	ABR	Stock	5.68	5.74	5.51	5.63	87000.0
2011-03-17	ABT	Stock	22.6418	22.6945	22.4306	22.6753	18798249.0
2011-03-17	ABTL-DELISTED	Stock	5.9	5.9	5.6525	5.7	34969.0
2011-03-17	ABUS	Stock	4.2	4.22	3.67	3.94	33500.0
2011-03-17	ABV-DELISTED	Stock	26.77	27.01	26.12	26.31	2472100.0
2011-03-17	ABVA-DELISTED	Stock	4.91	4.96	4.91	4.95	828.0

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

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