PREVIEW / stock_daily / 2011-04-25

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-25.parquet
  size:    199 KB
  rows:    6,131
  symbols: 3,575

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-04-25	AAPL	Stock	12.5121	12.6339	12.5107	12.6075	266546000.0
2011-04-25	MSFT	Stock	25.56	25.62	25.34	25.61	33525100.0
2011-04-25	NVDA	Stock	0.465	0.478	0.4648	0.4702	619612000.0
2011-04-25	AMZN	Stock	9.2825	9.3175	9.1885	9.271	68762000.0
2011-04-25	TSLA	Stock	1.78	1.782	1.7313	1.7593	12013500.0
2011-04-25	TLT	Stock	92.63	92.975	92.5	92.95	3626878.0
2011-04-25	ES	Stock	34.38	34.69	34.34	34.6	1480700.0
2011-04-25	CL	Stock	40.155	40.245	39.9	39.95	4346800.0
2011-04-25	A	Stock	35.1144	35.1788	34.3133	34.4635	4669040.0
2011-04-25	AABA-DELISTED	Stock	17.01	17.305	16.9	17.11	17405642.0
2011-04-25	AACC-DELISTED	Stock	5.5	5.605	5.33	5.6	16833.0
2011-04-25	AACG	Stock	7.12	8.04	7.12	8.0	130200.0
2011-04-25	AAI-DELISTED	Stock	7.34	7.46	7.33	7.43	5403450.0
2011-04-25	AAIC-DELISTED	Stock	29.81	30.31	29.8	30.25	17343.0
2011-04-25	AAME	Stock	2.07	2.16	1.86	2.05	9200.0
2011-04-25	AAON	Stock	6.5185	6.5343	6.4889	6.5086	148331.0
2011-04-25	AAP	Stock	66.32	66.32	64.99	65.73	441300.0
2011-04-25	AAT	Stock	21.59	21.99	21.16	21.68	136900.0
2011-04-25	AATI-DELISTED	Stock	4.15	4.24	4.11	4.19	51869.0
2011-04-25	AAU-DELISTED	Stock	4.59	4.59	4.31	4.43	439504.0
2011-04-25	AAUAF-DELISTED	Stock	4.59	4.59	4.31	4.42	440704.0
2011-04-25	AAV-DELISTED	Stock	8.56	8.56	8.28	8.3	330604.0
2011-04-25	AAWW-DELISTED	Stock	64.43	65.67	63.65	65.19	290126.0
2011-04-25	AAXJ	Stock	64.86	64.9	64.35	64.56	277004.0
2011-04-25	AAXN-DELISTED	Stock	4.18	4.44	4.14	4.44	1253419.0
2011-04-25	AB	Stock	21.79	21.79	21.44	21.59	206900.0
2011-04-25	ABAC-DELISTED	Stock	3.39	3.6	3.34	3.59	35082.0
2011-04-25	ABAX-DELISTED	Stock	28.87	28.93	27.951	28.6	79707.0
2011-04-25	ABB-DELISTED	Stock	25.4	25.46	25.29	25.34	1763801.0
2011-04-25	ABBC-DELISTED	Stock	11.88	12.1	11.88	12.1	13799.0
2011-04-25	ABBNY-DELISTED	Stock	25.4	25.46	25.29	25.33	1768254.0
2011-04-25	ABC-DELISTED	Stock	40.47	40.97	40.15	40.95	2621780.0
2011-04-25	ABCB	Stock	9.54	9.67	9.44	9.66	31600.0
2011-04-25	ABCD-DELISTED	Stock	3.37	3.43	3.37	3.39	20384.0
2011-04-25	ABCO-DELISTED	Stock	23.44	23.6	23.18	23.25	87072.0
2011-04-25	ABCW-DELISTED	Stock	0.8618	0.892	0.8372	0.8382	75260.0
2011-04-25	ABD-DELISTED	Stock	9.9	9.94	9.688	9.72	171810.0
2011-04-25	ABE-DELISTED	Stock	19.11	19.23	19.0801	19.1001	6621.0
2011-04-25	ABEO	Stock	2500.0	2875.0	2487.5	2812.5	24.0
2011-04-25	ABFS-DELISTED	Stock	23.02	23.88	22.3	23.34	1357428.0
2011-04-25	ABG	Stock	17.61	18.34	17.6	17.99	408000.0
2011-04-25	ABH-DELISTED	Stock	25.8	25.93	25.5	25.65	261941.0
2011-04-25	ABM	Stock	24.06	24.15	23.98	24.05	169900.0
2011-04-25	ABMD-DELISTED	Stock	16.44	16.6	16.2	16.34	156418.0
2011-04-25	ABR	Stock	5.1	5.11	5.03	5.07	87800.0
2011-04-25	ABT	Stock	24.7097	24.7913	24.3259	24.6233	16016465.0
2011-04-25	ABTL-DELISTED	Stock	6.8754	7.1245	6.7259	7.0746	37434.0
2011-04-25	ABUS	Stock	3.07	3.25	3.03	3.1	27300.0
2011-04-25	ABV-DELISTED	Stock	31.47	31.71	31.43	31.66	1591555.0
2011-04-25	ABVA-DELISTED	Stock	7.0	7.0	6.51	6.62	48094.0

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

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