PREVIEW / stock_daily / 2011-06-28

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-28.parquet
  size:    198 KB
  rows:    6,135
  symbols: 3,560

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-06-28	AAPL	Stock	11.9161	12.025	11.9086	11.9736	294299600.0
2011-06-28	MSFT	Stock	25.3	25.92	25.16	25.8	81032100.0
2011-06-28	NVDA	Stock	0.3853	0.392	0.3825	0.3875	692200000.0
2011-06-28	AMZN	Stock	10.096	10.144	10.03	10.1175	76506000.0
2011-06-28	TSLA	Stock	1.8527	1.8833	1.8447	1.874	13338000.0
2011-06-28	TLT	Stock	95.48	95.68	94.72	94.88	12634249.0
2011-06-28	ES	Stock	35.1	35.38	35.03	35.23	1258000.0
2011-06-28	CL	Stock	42.895	42.98	42.77	42.91	3188600.0
2011-06-28	A	Stock	35.0715	36.2732	34.8712	36.1087	4629337.0
2011-06-28	AABA-DELISTED	Stock	14.95	15.18	14.88	14.95	15891092.0
2011-06-28	AACC-DELISTED	Stock	3.88	3.914	3.72	3.84	74004.0
2011-06-28	AACG	Stock	9.0	9.4	9.0	9.36	14800.0
2011-06-28	AAIC-DELISTED	Stock	32.63	32.63	32.18	32.26	96048.0
2011-06-28	AAME	Stock	2.05	2.08	1.95	2.01	16300.0
2011-06-28	AAON	Stock	6.5333	6.5896	6.5096	6.5719	159300.0
2011-06-28	AAP	Stock	58.2	58.54	57.81	58.15	869300.0
2011-06-28	AAT	Stock	22.36	22.52	21.94	22.19	85500.0
2011-06-28	AATI-DELISTED	Stock	6.05	6.05	6.04	6.05	253785.0
2011-06-28	AAU-DELISTED	Stock	3.19	3.25	3.18	3.2	143385.0
2011-06-28	AAUAF-DELISTED	Stock	3.19	3.25	3.18	3.2	143985.0
2011-06-28	AAV-DELISTED	Stock	7.84	7.94	7.7201	7.78	202188.0
2011-06-28	AAWW-DELISTED	Stock	59.14	59.7	58.9	59.6	100631.0
2011-06-28	AAXJ	Stock	60.21	60.67	59.99	60.64	135760.0
2011-06-28	AAXN-DELISTED	Stock	4.4	4.53	4.3006	4.49	320334.0
2011-06-28	AB	Stock	18.91	19.12	18.79	19.0	245800.0
2011-06-28	ABAC-DELISTED	Stock	2.34	2.43	2.26	2.3	22200.0
2011-06-28	ABAX-DELISTED	Stock	27.95	28.3	27.75	28.3	62583.0
2011-06-28	ABB-DELISTED	Stock	24.98	25.14	24.94	25.07	3190873.0
2011-06-28	ABBC-DELISTED	Stock	10.23	10.23	9.96	10.12	21421.0
2011-06-28	ABBNY-DELISTED	Stock	24.99	25.14	24.94	25.06	3191818.0
2011-06-28	ABC-DELISTED	Stock	40.69	41.45	40.69	41.4	1731890.0
2011-06-28	ABCB	Stock	8.82	8.92	8.75	8.84	51300.0
2011-06-28	ABCD-DELISTED	Stock	3.35	3.36	3.27	3.35	34250.0
2011-06-28	ABCO-DELISTED	Stock	28.26	28.86	28.01	28.8	118768.0
2011-06-28	ABCW-DELISTED	Stock	0.7	0.75	0.7	0.73	24470.0
2011-06-28	ABD-DELISTED	Stock	7.425	7.615	7.425	7.585	164810.0
2011-06-28	ABE-DELISTED	Stock	18.44	18.58	18.44	18.54	25200.0
2011-06-28	ABEO	Stock	2212.5	2375.0	2212.5	2350.0	12.0
2011-06-28	ABFS-DELISTED	Stock	23.18	23.43	23.0	23.39	245533.0
2011-06-28	ABG	Stock	18.05	18.56	17.9	18.55	391000.0
2011-06-28	ABH-DELISTED	Stock	21.6	21.69	20.25	20.39	2811319.0
2011-06-28	ABM	Stock	23.04	23.18	22.87	23.16	184600.0
2011-06-28	ABMD-DELISTED	Stock	15.95	15.95	15.26	15.57	1534405.0
2011-06-28	ABR	Stock	4.61	4.86	4.61	4.67	49900.0
2011-06-28	ABT	Stock	25.0264	25.1223	24.9592	25.0696	10601292.0
2011-06-28	ABTL-DELISTED	Stock	5.199	5.3519	5.0971	5.25	11889.0
2011-06-28	ABUS	Stock	2.6	2.6	2.44	2.5	9200.0
2011-06-28	ABV-DELISTED	Stock	32.49	33.1	32.43	33.06	1505237.0
2011-06-28	ABVA-DELISTED	Stock	4.85	4.85	4.8	4.8	1700.0
2011-06-28	ABVT-DELISTED	Stock	70.0	70.04	69.27	69.38	173820.0

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

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