PREVIEW / stock_daily / 2011-11-29

all stock daily files

  file:    by_date/stock_daily/2011/2011-11-29.parquet
  size:    194 KB
  rows:    6,114
  symbols: 3,542

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-11-29	AAPL	Stock	13.4229	13.5296	13.2214	13.3286	375855200.0
2011-11-29	MSFT	Stock	24.82	25.04	24.75	24.84	40917100.0
2011-11-29	NVDA	Stock	0.3703	0.3775	0.3668	0.3728	623440000.0
2011-11-29	AMZN	Stock	9.739	9.775	9.365	9.4195	131502000.0
2011-11-29	TSLA	Stock	2.166	2.2047	2.1087	2.1167	8866500.0
2011-11-29	TLT	Stock	120.03	120.92	119.08	119.75	8952729.0
2011-11-29	ES	Stock	33.53	33.92	33.49	33.7	852500.0
2011-11-29	CL	Stock	44.335	44.945	44.235	44.85	4760600.0
2011-11-29	A	Stock	25.3004	25.4936	24.9285	25.0501	3942640.0
2011-11-29	AABA-DELISTED	Stock	15.6	15.94	15.45	15.7	29137073.0
2011-11-29	AACC-DELISTED	Stock	3.01	3.34	3.01	3.13	29308.0
2011-11-29	AACG	Stock	9.41	9.79	9.41	9.74	2500.0
2011-11-29	AAIC-DELISTED	Stock	19.65	19.8	19.3	19.56	58886.0
2011-11-29	AAME	Stock	2.0	2.0	1.77	1.99	10600.0
2011-11-29	AAON	Stock	6.08	6.08	5.8607	5.917	162338.0
2011-11-29	AAP	Stock	67.3	67.85	67.07	67.52	458900.0
2011-11-29	AAT	Stock	20.36	20.57	20.09	20.31	384000.0
2011-11-29	AATI-DELISTED	Stock	4.33	4.37	4.28	4.33	164521.0
2011-11-29	AAU-DELISTED	Stock	2.59	2.68	2.5732	2.58	74427.0
2011-11-29	AAUAF-DELISTED	Stock	2.59	2.68	2.5732	2.58	75927.0
2011-11-29	AAV-DELISTED	Stock	4.42	4.49	4.35	4.46	246333.0
2011-11-29	AAWW-DELISTED	Stock	36.88	37.26	36.42	36.57	193004.0
2011-11-29	AAXJ	Stock	49.98	50.54	49.87	49.97	262456.0
2011-11-29	AAXN-DELISTED	Stock	5.87	5.95	5.82	5.83	367905.0
2011-11-29	AB	Stock	13.03	13.15	12.82	12.96	366800.0
2011-11-29	ABAC-DELISTED	Stock	1.7	1.75	1.6513	1.7	10817.0
2011-11-29	ABAX-DELISTED	Stock	25.76	26.0	25.39	25.69	43531.0
2011-11-29	ABB-DELISTED	Stock	17.61	17.91	17.55	17.72	2531069.0
2011-11-29	ABBNY-DELISTED	Stock	17.61	17.91	17.55	17.7	2538244.0
2011-11-29	ABC-DELISTED	Stock	36.66	36.74	36.15	36.39	2797325.0
2011-11-29	ABCB	Stock	9.58	9.71	9.48	9.62	35100.0
2011-11-29	ABCD-DELISTED	Stock	2.89	3.08	2.76	3.02	61749.0
2011-11-29	ABCO-DELISTED	Stock	34.87	35.0	34.5	34.98	252511.0
2011-11-29	ABCW-DELISTED	Stock	0.3574	0.3815	0.3514	0.3715	79620.0
2011-11-29	ABD-DELISTED	Stock	8.93	9.12	8.77	8.94	499530.0
2011-11-29	ABE-DELISTED	Stock	17.57	17.63	17.44	17.44	6402.0
2011-11-29	ABEO	Stock	1662.5	1687.5	1575.0	1662.5	7.0
2011-11-29	ABFS-DELISTED	Stock	18.11	18.23	17.67	17.96	443419.0
2011-11-29	ABG	Stock	18.88	19.15	18.6	18.95	291700.0
2011-11-29	ABH-DELISTED	Stock	15.5	15.66	14.53	14.71	670443.0
2011-11-29	ABM	Stock	21.15	21.43	20.99	21.26	542900.0
2011-11-29	ABMD-DELISTED	Stock	18.43	19.17	18.2	18.96	198867.0
2011-11-29	ABR	Stock	3.5	3.5	3.34	3.34	58400.0
2011-11-29	ABT	Stock	25.6357	25.7605	25.4294	25.4534	12504168.0
2011-11-29	ABTL-DELISTED	Stock	4.014	4.0593	3.7434	3.836	12593.0
2011-11-29	ABUS	Stock	1.59	1.67	1.59	1.65	9100.0
2011-11-29	ABV-DELISTED	Stock	32.67	33.2	32.55	33.13	2612254.0
2011-11-29	ABVA-DELISTED	Stock	4.7	4.7	3.55	3.62	77619.0
2011-11-29	ABVT-DELISTED	Stock	56.17	57.42	55.77	57.18	140748.0
2011-11-29	ABX-DELISTED	Stock	49.28	50.28	49.21	49.9	4755057.0

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

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