PREVIEW / stock_daily / 2011-04-28

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-28.parquet
  size:    199 KB
  rows:    6,137
  symbols: 3,583

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-28	AAPL	Stock	12.3639	12.4911	12.34	12.3839	360959200.0
2011-04-28	MSFT	Stock	26.46	26.87	26.4	26.71	80200000.0
2011-04-28	NVDA	Stock	0.4825	0.4975	0.477	0.4878	684000000.0
2011-04-28	AMZN	Stock	9.798	9.8395	9.6135	9.7535	146000000.0
2011-04-28	TSLA	Stock	1.8047	1.846	1.7813	1.844	24000000.0
2011-04-28	TLT	Stock	93.22	93.6	92.97	93.6	8110154.0
2011-04-28	ES	Stock	35.1	35.51	35.09	35.38	833100.0
2011-04-28	CL	Stock	40.385	41.625	40.0	41.485	9176000.0
2011-04-28	A	Stock	35.6509	36.1516	35.515	35.9943	3151511.0
2011-04-28	AABA-DELISTED	Stock	17.22	17.53	17.17	17.52	14269384.0
2011-04-28	AACC-DELISTED	Stock	5.88	5.9	5.61	5.89	7169.0
2011-04-28	AACG	Stock	7.8	7.98	7.8	7.91	9000.0
2011-04-28	AAI-DELISTED	Stock	7.52	7.55	7.48	7.54	3651905.0
2011-04-28	AAIC-DELISTED	Stock	30.85	31.272	30.55	30.62	83481.0
2011-04-28	AAME	Stock	2.12	2.12	1.91	2.09	6600.0
2011-04-28	AAON	Stock	6.5264	6.7022	6.5106	6.5402	496125.0
2011-04-28	AAP	Stock	66.07	66.23	65.11	66.18	910100.0
2011-04-28	AAT	Stock	22.0	22.12	21.94	22.05	134700.0
2011-04-28	AATI-DELISTED	Stock	4.29	4.32	4.25	4.27	72454.0
2011-04-28	AAU-DELISTED	Stock	5.07	5.35	4.77	4.84	1825805.0
2011-04-28	AAUAF-DELISTED	Stock	5.07	5.35	4.77	4.82	1826705.0
2011-04-28	AAV-DELISTED	Stock	8.48	8.52	8.37	8.47	236532.0
2011-04-28	AAWW-DELISTED	Stock	66.83	68.04	66.61	67.75	96684.0
2011-04-28	AAXJ	Stock	64.6	64.7	64.3	64.58	268174.0
2011-04-28	AAXN-DELISTED	Stock	4.4	4.47	4.39	4.45	532696.0
2011-04-28	AB	Stock	22.19	22.22	22.02	22.08	170900.0
2011-04-28	ABAC-DELISTED	Stock	3.37	3.44	3.07	3.2	57953.0
2011-04-28	ABAX-DELISTED	Stock	29.0	29.48	28.79	29.31	68169.0
2011-04-28	ABB-DELISTED	Stock	27.26	27.35	27.1	27.27	3023462.0
2011-04-28	ABBC-DELISTED	Stock	12.25	12.33	12.01	12.27	17398.0
2011-04-28	ABBNY-DELISTED	Stock	27.25	27.35	27.1	27.26	3073762.0
2011-04-28	ABC-DELISTED	Stock	42.18	42.5	40.23	40.97	5864736.0
2011-04-28	ABCB	Stock	9.93	9.97	9.85	9.92	18000.0
2011-04-28	ABCD-DELISTED	Stock	3.38	3.45	3.38	3.45	22688.0
2011-04-28	ABCO-DELISTED	Stock	23.14	23.28	23.11	23.26	54116.0
2011-04-28	ABCW-DELISTED	Stock	0.85	0.88	0.84	0.84	18800.0
2011-04-28	ABD-DELISTED	Stock	9.87	9.89	9.65	9.81	216900.0
2011-04-28	ABE-DELISTED	Stock	19.25	19.25	19.08	19.11	25250.0
2011-04-28	ABEO	Stock	2625.0	2912.5	2625.0	2875.0	19.0
2011-04-28	ABFS-DELISTED	Stock	22.69	23.21	22.58	23.03	335210.0
2011-04-28	ABG	Stock	16.54	17.19	16.54	17.14	601200.0
2011-04-28	ABH-DELISTED	Stock	26.17	27.46	26.17	27.09	781956.0
2011-04-28	ABM	Stock	24.08	24.37	23.98	24.31	126800.0
2011-04-28	ABMD-DELISTED	Stock	16.45	16.619	16.32	16.55	116914.0
2011-04-28	ABR	Stock	5.31	5.4	5.28	5.36	18800.0
2011-04-28	ABT	Stock	24.9736	25.1175	24.916	25.0887	12604627.0
2011-04-28	ABTL-DELISTED	Stock	7.35	7.75	7.15	7.3	130927.0
2011-04-28	ABUS	Stock	2.99	3.11	2.92	2.97	10600.0
2011-04-28	ABV-DELISTED	Stock	31.84	32.32	31.81	32.26	3673341.0
2011-04-28	ABVA-DELISTED	Stock	6.65	6.71	6.6	6.71	5550.0

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

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