PREVIEW / stock_daily / 2011-01-28

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-28.parquet
  size:    196 KB
  rows:    6,057
  symbols: 3,538

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-01-28	AAPL	Stock	12.2918	12.3	11.9118	12.0036	592057200.0
2011-01-28	MSFT	Stock	28.9	28.93	27.45	27.75	141249400.0
2011-01-28	NVDA	Stock	0.6133	0.6235	0.58	0.594	1094796000.0
2011-01-28	AMZN	Stock	8.5725	8.6855	8.345	8.557	398164000.0
2011-01-28	TSLA	Stock	1.6587	1.6587	1.5833	1.6007	15726000.0
2011-01-28	TLT	Stock	90.81	92.28	90.77	91.92	11993173.0
2011-01-28	ES	Stock	32.98	33.31	32.68	32.77	3375200.0
2011-01-28	CL	Stock	38.635	38.845	38.415	38.495	6718800.0
2011-01-28	A	Stock	30.4006	30.4149	29.2418	29.3133	5074460.0
2011-01-28	AABA-DELISTED	Stock	16.2	16.21	15.68	15.83	22425773.0
2011-01-28	AACC-DELISTED	Stock	7.06	7.06	5.99	6.08	43738.0
2011-01-28	AACG	Stock	4.09	4.09	3.95	4.04	11100.0
2011-01-28	AAI-DELISTED	Stock	7.45	7.46	7.32	7.37	3943675.0
2011-01-28	AAIC-DELISTED	Stock	24.61	25.1	24.61	25.05	119852.0
2011-01-28	AAON	Stock	5.5328	5.5328	5.1872	5.2227	205031.0
2011-01-28	AAP	Stock	64.37	64.37	63.03	64.09	1187200.0
2011-01-28	AAT	Stock	21.26	21.38	21.26	21.3	475300.0
2011-01-28	AATI-DELISTED	Stock	4.09	4.15	3.98	4.02	214319.0
2011-01-28	AAU-DELISTED	Stock	3.74	3.98	3.66	3.89	428103.0
2011-01-28	AAUAF-DELISTED	Stock	3.74	3.98	3.66	3.89	428403.0
2011-01-28	AAV-DELISTED	Stock	7.38	7.4	7.21	7.27	310604.0
2011-01-28	AAWW-DELISTED	Stock	53.03	53.22	50.51	50.55	214717.0
2011-01-28	AAXJ	Stock	62.65	62.72	61.0105	61.15	691319.0
2011-01-28	AAXN-DELISTED	Stock	4.24	4.27	4.19	4.21	704348.0
2011-01-28	AB	Stock	21.49	21.55	20.94	20.98	663600.0
2011-01-28	ABAC-DELISTED	Stock	5.52	5.6	5.28	5.34	74414.0
2011-01-28	ABAX-DELISTED	Stock	26.96	28.4399	26.43	26.79	346917.0
2011-01-28	ABB-DELISTED	Stock	24.16	24.21	23.64	23.71	2589861.0
2011-01-28	ABBC-DELISTED	Stock	12.41	12.5	12.18	12.45	372277.0
2011-01-28	ABBNY-DELISTED	Stock	24.16	24.21	23.64	23.73	2593866.0
2011-01-28	ABC-DELISTED	Stock	36.9	37.0	35.95	35.98	1877804.0
2011-01-28	ABCB	Stock	10.17	10.23	9.5	9.65	89100.0
2011-01-28	ABCD-DELISTED	Stock	3.35	3.35	3.28	3.3	54595.0
2011-01-28	ABCO-DELISTED	Stock	25.17	25.26	24.6	24.7	138062.0
2011-01-28	ABCW-DELISTED	Stock	1.43	1.43	1.38	1.41	128790.0
2011-01-28	ABD-DELISTED	Stock	8.4	8.43	8.06	8.11	356430.0
2011-01-28	ABE-DELISTED	Stock	18.59	18.6199	17.9	17.95	26511.0
2011-01-28	ABEO	Stock	3062.5	3137.5	3050.0	3112.5	38.0
2011-01-28	ABFS-DELISTED	Stock	26.59	26.75	25.35	25.36	124475.0
2011-01-28	ABG	Stock	19.33	19.44	18.35	18.42	226400.0
2011-01-28	ABH-DELISTED	Stock	28.67	28.67	26.76	27.66	471077.0
2011-01-28	ABM	Stock	26.36	26.38	25.38	25.38	230300.0
2011-01-28	ABMD-DELISTED	Stock	10.0	10.01	9.79	9.81	134769.0
2011-01-28	ABR	Stock	6.19	6.19	5.95	5.96	45600.0
2011-01-28	ABT	Stock	22.2435	22.3107	21.7541	21.8261	36420800.0
2011-01-28	ABTL-DELISTED	Stock	4.55	4.5505	4.2985	4.4	36140.0
2011-01-28	ABUS	Stock	6.73	6.73	6.0	6.07	36000.0
2011-01-28	ABV-DELISTED	Stock	27.8	27.92	26.41	27.05	3877438.0
2011-01-28	ABVT-DELISTED	Stock	59.68	60.69	59.03	59.2	142000.0
2011-01-28	ABX-DELISTED	Stock	46.3	48.42	46.15	47.29	16151597.0

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

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