PREVIEW / stock_daily / 2011-03-03

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-03.parquet
  size:    198 KB
  rows:    6,085
  symbols: 3,550

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-03	AAPL	Stock	12.7568	12.8496	12.7114	12.8414	500788400.0
2011-03-03	MSFT	Stock	26.26	26.4	26.18	26.2	68271500.0
2011-03-03	NVDA	Stock	0.5308	0.5338	0.506	0.5218	1593704000.0
2011-03-03	AMZN	Stock	8.6855	8.723	8.6025	8.6395	82764000.0
2011-03-03	TSLA	Stock	1.632	1.6527	1.604	1.624	9603000.0
2011-03-03	TLT	Stock	90.53	90.7801	89.98	90.06	10608010.0
2011-03-03	ES	Stock	34.16	34.39	34.07	34.19	1164800.0
2011-03-03	CL	Stock	38.895	39.18	38.75	39.035	5616600.0
2011-03-03	A	Stock	30.1288	30.8584	30.1288	30.6295	6092484.0
2011-03-03	AABA-DELISTED	Stock	16.85	17.045	16.76	16.85	34833208.0
2011-03-03	AACC-DELISTED	Stock	5.77	5.86	5.7349	5.83	15374.0
2011-03-03	AACG	Stock	7.9	8.02	7.84	7.88	28600.0
2011-03-03	AAI-DELISTED	Stock	7.3	7.35	7.28	7.29	3495892.0
2011-03-03	AAIC-DELISTED	Stock	26.94	27.94	26.94	27.72	32572.0
2011-03-03	AAME	Stock	2.1	2.12	2.1	2.12	500.0
2011-03-03	AAON	Stock	6.1077	6.1373	5.9852	6.0109	286031.0
2011-03-03	AAP	Stock	63.24	64.53	62.96	64.46	1088800.0
2011-03-03	AAT	Stock	21.18	21.51	21.06	21.49	53700.0
2011-03-03	AATI-DELISTED	Stock	4.26	4.2901	4.2	4.22	90272.0
2011-03-03	AAU-DELISTED	Stock	4.11	4.15	3.99	4.09	198299.0
2011-03-03	AAUAF-DELISTED	Stock	4.11	4.15	3.99	4.09	200399.0
2011-03-03	AAV-DELISTED	Stock	8.12	8.19	8.05	8.19	716106.0
2011-03-03	AAWW-DELISTED	Stock	68.33	70.0	68.31	69.84	205048.0
2011-03-03	AAXJ	Stock	61.17	61.62	60.92	61.5	591268.0
2011-03-03	AAXN-DELISTED	Stock	4.0	4.1	3.91	4.09	697429.0
2011-03-03	AB	Stock	22.74	23.5	22.71	23.29	526100.0
2011-03-03	ABAC-DELISTED	Stock	4.91	4.91	4.83	4.83	22205.0
2011-03-03	ABAX-DELISTED	Stock	27.15	27.87	27.15	27.6	90117.0
2011-03-03	ABB-DELISTED	Stock	24.44	24.57	24.33	24.47	2871465.0
2011-03-03	ABBC-DELISTED	Stock	12.36	12.81	12.36	12.56	113251.0
2011-03-03	ABBNY-DELISTED	Stock	24.44	24.57	24.33	24.46	2872025.0
2011-03-03	ABC-DELISTED	Stock	37.48	37.78	37.29	37.59	2149028.0
2011-03-03	ABCB	Stock	10.04	10.15	10.0	10.04	48300.0
2011-03-03	ABCD-DELISTED	Stock	3.69	3.7	3.58	3.68	28795.0
2011-03-03	ABCO-DELISTED	Stock	24.72	25.25	24.62	25.21	201376.0
2011-03-03	ABCW-DELISTED	Stock	1.04	1.08	1.04	1.08	50800.0
2011-03-03	ABD-DELISTED	Stock	8.73	9.001	8.73	8.87	287800.0
2011-03-03	ABE-DELISTED	Stock	17.86	18.1	17.86	18.0301	3296.0
2011-03-03	ABEO	Stock	2687.5	2687.5	2637.5	2687.5	2.0
2011-03-03	ABFS-DELISTED	Stock	23.91	24.68	23.91	24.44	136214.0
2011-03-03	ABG	Stock	18.88	19.44	18.68	19.1	227900.0
2011-03-03	ABH-DELISTED	Stock	28.03	28.5	27.56	28.41	421446.0
2011-03-03	ABM	Stock	26.36	26.86	26.21	26.5	318600.0
2011-03-03	ABMD-DELISTED	Stock	13.28	13.61	13.24	13.6	132325.0
2011-03-03	ABR	Stock	6.7	7.03	6.43	6.87	122600.0
2011-03-03	ABT	Stock	22.992	23.2223	22.9536	23.1983	17471655.0
2011-03-03	ABTL-DELISTED	Stock	5.55	5.8	5.4	5.75	119691.0
2011-03-03	ABUS	Stock	4.64	4.9	4.64	4.85	6600.0
2011-03-03	ABV-DELISTED	Stock	28.35	28.48	27.75	28.2	3169627.0
2011-03-03	ABVT-DELISTED	Stock	63.74	64.42	63.52	63.82	175404.0

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

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