PREVIEW / stock_daily / 2011-03-07

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-07.parquet
  size:    197 KB
  rows:    6,079
  symbols: 3,544

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-07	AAPL	Stock	12.9071	12.9168	12.5468	12.6914	546123200.0
2011-03-07	MSFT	Stock	26.13	26.27	25.55	25.72	64980400.0
2011-03-07	NVDA	Stock	0.5228	0.5245	0.4988	0.5118	1019140000.0
2011-03-07	AMZN	Stock	8.596	8.6045	8.312	8.454	118658000.0
2011-03-07	TSLA	Stock	1.662	1.6933	1.6467	1.6627	30504000.0
2011-03-07	TLT	Stock	90.02	90.86	89.852	90.23	7525397.0
2011-03-07	ES	Stock	33.98	34.55	33.93	34.12	2485700.0
2011-03-07	CL	Stock	38.755	38.86	38.55	38.77	5569400.0
2011-03-07	A	Stock	33.0901	33.4764	32.4607	32.8112	10355405.0
2011-03-07	AABA-DELISTED	Stock	17.06	17.15	16.49	16.71	17800837.0
2011-03-07	AACC-DELISTED	Stock	5.6999	5.714	5.65	5.65	28174.0
2011-03-07	AACG	Stock	7.76	7.8	7.51	7.69	33000.0
2011-03-07	AAI-DELISTED	Stock	7.3	7.32	7.27	7.29	1044091.0
2011-03-07	AAIC-DELISTED	Stock	27.07	27.21	25.4	25.69	125128.0
2011-03-07	AAME	Stock	2.1	2.1	2.1	2.1	100.0
2011-03-07	AAON	Stock	6.0444	6.0464	5.8449	5.8983	303244.0
2011-03-07	AAP	Stock	64.09	64.09	62.99	63.05	864200.0
2011-03-07	AAT	Stock	21.5	21.5	20.91	21.03	212400.0
2011-03-07	AATI-DELISTED	Stock	4.22	4.22	3.98	4.18	191209.0
2011-03-07	AAU-DELISTED	Stock	4.18	4.18	3.88	3.9699	448958.0
2011-03-07	AAUAF-DELISTED	Stock	4.18	4.18	3.88	3.97	449472.0
2011-03-07	AAV-DELISTED	Stock	8.34	9.15	8.31	8.63	2422812.0
2011-03-07	AAWW-DELISTED	Stock	68.18	68.18	65.665	67.01	210495.0
2011-03-07	AAXJ	Stock	61.88	61.88	60.768	60.86	451165.0
2011-03-07	AAXN-DELISTED	Stock	4.05	4.07	4.01	4.02	421510.0
2011-03-07	AB	Stock	23.53	23.69	22.96	23.04	481400.0
2011-03-07	ABAC-DELISTED	Stock	4.91	5.25	4.88	5.2499	118421.0
2011-03-07	ABAX-DELISTED	Stock	27.74	27.74	26.72	27.25	65076.0
2011-03-07	ABB-DELISTED	Stock	24.36	24.42	23.86	23.95	2607275.0
2011-03-07	ABBC-DELISTED	Stock	12.36	12.55	12.0	12.25	122883.0
2011-03-07	ABBNY-DELISTED	Stock	24.37	24.42	23.86	23.97	2732345.0
2011-03-07	ABC-DELISTED	Stock	37.82	37.97	37.08	37.3	1887904.0
2011-03-07	ABCB	Stock	9.93	9.93	9.64	9.64	45100.0
2011-03-07	ABCD-DELISTED	Stock	3.5	3.51	3.38	3.4	31409.0
2011-03-07	ABCO-DELISTED	Stock	25.4	25.41	24.6	24.75	63741.0
2011-03-07	ABCW-DELISTED	Stock	1.05	1.06	1.0	1.03	127030.0
2011-03-07	ABD-DELISTED	Stock	8.91	9.051	8.62	8.95	303700.0
2011-03-07	ABE-DELISTED	Stock	17.97	17.97	17.75	17.83	15567.0
2011-03-07	ABEO	Stock	2575.0	2625.0	2450.0	2537.5	23.0
2011-03-07	ABFS-DELISTED	Stock	23.98	24.02	23.28	23.7	184683.0
2011-03-07	ABG	Stock	19.26	20.12	19.18	19.29	512000.0
2011-03-07	ABH-DELISTED	Stock	28.35	28.74	28.24	28.33	371615.0
2011-03-07	ABM	Stock	26.61	26.88	26.08	26.42	231800.0
2011-03-07	ABMD-DELISTED	Stock	13.5	13.5	13.12	13.21	104368.0
2011-03-07	ABR	Stock	6.52	6.52	6.02	6.23	94000.0
2011-03-07	ABT	Stock	23.4622	23.4622	23.1647	23.2703	14466861.0
2011-03-07	ABTL-DELISTED	Stock	5.85	6.15	5.65	5.95	119461.0
2011-03-07	ABUS	Stock	4.87	4.87	4.64	4.68	23400.0
2011-03-07	ABV-DELISTED	Stock	27.97	27.97	27.4	27.76	1520128.0
2011-03-07	ABVA-DELISTED	Stock	4.8	4.98	4.76	4.8001	7230.0

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

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