PREVIEW / stock_daily / 2011-03-16

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-16.parquet
  size:    197 KB
  rows:    6,045
  symbols: 3,529

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-16	AAPL	Stock	12.2143	12.25	11.6521	11.7861	1162011200.0
2011-03-16	MSFT	Stock	25.22	25.28	24.68	24.79	100725400.0
2011-03-16	NVDA	Stock	0.4375	0.4588	0.4325	0.4382	1476520000.0
2011-03-16	AMZN	Stock	8.235	8.407	8.1435	8.235	104162000.0
2011-03-16	TSLA	Stock	1.524	1.55	1.5127	1.5213	17545500.0
2011-03-16	TLT	Stock	93.37	94.94	93.08	93.93	24313025.0
2011-03-16	ES	Stock	33.77	33.79	32.84	33.2	2586100.0
2011-03-16	CL	Stock	38.535	38.545	38.3	38.33	7681000.0
2011-03-16	A	Stock	31.1803	31.3019	29.9428	30.279	7049695.0
2011-03-16	AABA-DELISTED	Stock	16.33	16.48	15.85	15.9	38023987.0
2011-03-16	AACC-DELISTED	Stock	5.41	5.52	5.4	5.41	19560.0
2011-03-16	AACG	Stock	7.71	8.25	7.69	8.1	158900.0
2011-03-16	AAI-DELISTED	Stock	7.38	7.42	7.29	7.33	2024318.0
2011-03-16	AAIC-DELISTED	Stock	27.57	27.88	27.01	27.31	54624.0
2011-03-16	AAME	Stock	2.06	2.07	2.05	2.05	2100.0
2011-03-16	AAON	Stock	5.6395	5.7877	5.5941	5.6988	223256.0
2011-03-16	AAP	Stock	65.16	65.51	64.56	64.93	1199000.0
2011-03-16	AAT	Stock	20.99	21.2	20.78	20.85	241300.0
2011-03-16	AATI-DELISTED	Stock	3.72	3.74	3.62	3.65	92231.0
2011-03-16	AAU-DELISTED	Stock	3.53	3.65	3.36	3.4	289764.0
2011-03-16	AAUAF-DELISTED	Stock	3.53	3.65	3.36	3.4	290114.0
2011-03-16	AAV-DELISTED	Stock	7.89	8.15	7.76	7.83	751684.0
2011-03-16	AAWW-DELISTED	Stock	62.96	63.225	61.63	61.67	197967.0
2011-03-16	AAXJ	Stock	59.85	59.85	58.29	58.77	987675.0
2011-03-16	AAXN-DELISTED	Stock	3.94	3.96	3.84	3.85	686677.0
2011-03-16	AB	Stock	21.01	21.19	20.72	20.9	867700.0
2011-03-16	ABAC-DELISTED	Stock	4.41	4.5899	4.24	4.32	65391.0
2011-03-16	ABAX-DELISTED	Stock	27.41	27.51	26.67	27.17	115545.0
2011-03-16	ABB-DELISTED	Stock	22.43	22.505	21.82	22.07	3561904.0
2011-03-16	ABBC-DELISTED	Stock	11.73	11.9	11.48	11.51	70384.0
2011-03-16	ABBNY-DELISTED	Stock	22.41	22.505	21.82	22.08	3562204.0
2011-03-16	ABC-DELISTED	Stock	36.28	36.92	35.95	36.59	4567857.0
2011-03-16	ABCB	Stock	9.28	9.4	9.2	9.37	70000.0
2011-03-16	ABCD-DELISTED	Stock	3.28	3.31	3.2	3.28	77205.0
2011-03-16	ABCO-DELISTED	Stock	23.87	23.88	23.54	23.6	111184.0
2011-03-16	ABCW-DELISTED	Stock	1.0304	1.1285	1.0304	1.05	153190.0
2011-03-16	ABD-DELISTED	Stock	8.76	9.0	8.7	8.8	298380.0
2011-03-16	ABE-DELISTED	Stock	17.76	17.78	17.4415	17.5	63850.0
2011-03-16	ABEO	Stock	2487.5	2487.5	2337.5	2487.5	5.0
2011-03-16	ABFS-DELISTED	Stock	23.87	24.79	23.68	23.93	1449168.0
2011-03-16	ABG	Stock	17.28	17.3	16.9	17.14	676900.0
2011-03-16	ABH-DELISTED	Stock	26.75	26.75	25.93	26.0	700230.0
2011-03-16	ABM	Stock	24.54	24.61	24.21	24.24	280000.0
2011-03-16	ABMD-DELISTED	Stock	13.69	13.83	13.54	13.59	383475.0
2011-03-16	ABR	Stock	5.7	5.82	5.58	5.59	68700.0
2011-03-16	ABT	Stock	22.8001	22.8097	22.3107	22.4115	21944560.0
2011-03-16	ABTL-DELISTED	Stock	5.6002	6.0003	5.6002	5.6998	59829.0
2011-03-16	ABUS	Stock	4.45	4.66	4.0	4.29	17400.0
2011-03-16	ABV-DELISTED	Stock	27.35	27.35	26.25	26.49	2910577.0
2011-03-16	ABVA-DELISTED	Stock	4.96	4.98	4.949	4.95	2000.0

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

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