PREVIEW / stock_daily / 2011-03-31

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-31.parquet
  size:    198 KB
  rows:    6,094
  symbols: 3,549

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-31	AAPL	Stock	12.37	12.4929	12.3593	12.4468	274019200.0
2011-03-31	MSFT	Stock	25.6	25.68	25.34	25.39	63233700.0
2011-03-31	NVDA	Stock	0.462	0.467	0.453	0.4615	655112000.0
2011-03-31	AMZN	Stock	8.9655	9.0785	8.925	9.0065	96530000.0
2011-03-31	TSLA	Stock	1.77	1.914	1.7667	1.85	172767000.0
2011-03-31	TLT	Stock	92.67	92.72	91.61	92.13	9655061.0
2011-03-31	ES	Stock	34.75	34.99	34.57	34.6	1263700.0
2011-03-31	CL	Stock	40.53	40.68	40.31	40.38	4148600.0
2011-03-31	A	Stock	32.1316	32.2031	31.8026	32.0315	3068470.0
2011-03-31	AABA-DELISTED	Stock	16.69	16.88	16.65	16.65	14659808.0
2011-03-31	AACC-DELISTED	Stock	5.33	5.39	5.33	5.38	20989.0
2011-03-31	AACG	Stock	7.99	8.07	7.96	8.0	10300.0
2011-03-31	AAI-DELISTED	Stock	7.39	7.45	7.38	7.4425	1325743.0
2011-03-31	AAIC-DELISTED	Stock	30.01	30.5	29.61	30.44	113133.0
2011-03-31	AAME	Stock	2.17	2.17	2.17	2.17	100.0
2011-03-31	AAON	Stock	6.4217	6.5126	6.3802	6.4988	172125.0
2011-03-31	AAP	Stock	66.03	66.03	64.94	65.62	706700.0
2011-03-31	AAT	Stock	20.92	21.3	20.52	21.27	3116400.0
2011-03-31	AATI-DELISTED	Stock	3.75	3.81	3.72	3.78	93462.0
2011-03-31	AAU-DELISTED	Stock	4.01	4.1	3.98	4.0201	239202.0
2011-03-31	AAUAF-DELISTED	Stock	4.01	4.1	3.98	4.02	239802.0
2011-03-31	AAV-DELISTED	Stock	8.91	9.1	8.89	8.97	618041.0
2011-03-31	AAWW-DELISTED	Stock	68.93	69.88	68.62	69.76	164287.0
2011-03-31	AAXJ	Stock	62.96	63.28	62.85	62.98	635818.0
2011-03-31	AAXN-DELISTED	Stock	4.02	4.1	4.02	4.07	156815.0
2011-03-31	AB	Stock	21.9	21.9	21.75	21.8	229900.0
2011-03-31	ABAC-DELISTED	Stock	4.25	4.25	4.04	4.15	42652.0
2011-03-31	ABAX-DELISTED	Stock	28.8	29.045	28.6	28.83	96382.0
2011-03-31	ABB-DELISTED	Stock	24.18	24.27	24.02	24.2	2123825.0
2011-03-31	ABBC-DELISTED	Stock	12.05	12.27	12.04	12.2101	36095.0
2011-03-31	ABBNY-DELISTED	Stock	24.18	24.27	24.02	24.19	2124600.0
2011-03-31	ABC-DELISTED	Stock	39.38	39.62	39.29	39.53	1509918.0
2011-03-31	ABCB	Stock	10.2	10.2	10.0	10.16	27800.0
2011-03-31	ABCD-DELISTED	Stock	3.32	3.42	3.2998	3.4	40381.0
2011-03-31	ABCO-DELISTED	Stock	25.54	25.78	25.54	25.75	71110.0
2011-03-31	ABCW-DELISTED	Stock	1.0	1.0	0.97	0.99	20800.0
2011-03-31	ABD-DELISTED	Stock	9.22	9.661	9.22	9.54	226700.0
2011-03-31	ABE-DELISTED	Stock	18.76	18.88	18.76	18.78	2908.0
2011-03-31	ABEO	Stock	2775.0	2775.0	2700.0	2762.5	11.0
2011-03-31	ABFS-DELISTED	Stock	25.64	26.1488	25.62	25.92	231322.0
2011-03-31	ABG	Stock	19.08	19.14	18.38	18.49	314300.0
2011-03-31	ABH-DELISTED	Stock	27.0	27.25	26.82	26.89	143564.0
2011-03-31	ABM	Stock	25.45	25.52	25.28	25.39	187800.0
2011-03-31	ABMD-DELISTED	Stock	14.86	15.05	14.51	14.54	178718.0
2011-03-31	ABR	Stock	5.62	5.74	5.61	5.68	23800.0
2011-03-31	ABT	Stock	23.5198	23.7261	23.419	23.5342	20532097.0
2011-03-31	ABTL-DELISTED	Stock	7.25	7.35	7.05	7.05	29234.0
2011-03-31	ABUS	Stock	3.18	3.25	3.06	3.15	10300.0
2011-03-31	ABV-DELISTED	Stock	28.34	28.42	28.18	28.29	3561678.0
2011-03-31	ABVA-DELISTED	Stock	5.56	5.56	5.55	5.55	2500.0

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

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