PREVIEW / stock_daily / 2011-12-27

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-27.parquet
  size:    197 KB
  rows:    6,182
  symbols: 3,572

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-12-27	AAPL	Stock	14.3964	14.6104	14.3936	14.5189	265076000.0
2011-12-27	MSFT	Stock	25.96	26.14	25.93	26.04	21287200.0
2011-12-27	NVDA	Stock	0.3528	0.357	0.3505	0.3515	195712000.0
2011-12-27	AMZN	Stock	8.8865	8.9295	8.808	8.8135	59018000.0
2011-12-27	TSLA	Stock	1.844	1.918	1.8427	1.9047	11662500.0
2011-12-27	TLT	Stock	117.94	118.45	117.62	118.45	4270459.0
2011-12-27	ES	Stock	35.51	35.88	35.37	35.85	666800.0
2011-12-27	CL	Stock	46.545	46.925	46.51	46.67	2254200.0
2011-12-27	A	Stock	25.1717	25.4435	25.1502	25.2146	1954823.0
2011-12-27	AABA-DELISTED	Stock	16.16	16.17	16.01	16.08	9681153.0
2011-12-27	AACC-DELISTED	Stock	3.85	3.9	3.73	3.81	16513.0
2011-12-27	AACG	Stock	8.5	8.5	8.0	8.0	10900.0
2011-12-27	AAIC-DELISTED	Stock	23.34	24.0	23.34	23.93	130140.0
2011-12-27	AAME	Stock	2.01	2.01	1.87	1.89	12700.0
2011-12-27	AAON	Stock	6.5422	6.5481	6.3407	6.3911	310500.0
2011-12-27	AAP	Stock	70.12	71.35	69.97	70.92	547100.0
2011-12-27	AAT	Stock	20.6	20.79	20.53	20.61	110700.0
2011-12-27	AATI-DELISTED	Stock	5.76	5.77	5.76	5.77	360702.0
2011-12-27	AAU-DELISTED	Stock	2.14	2.25	2.09	2.22	119339.0
2011-12-27	AAUAF-DELISTED	Stock	2.14	2.25	2.09	2.22	119539.0
2011-12-27	AAV-DELISTED	Stock	4.03	4.13	4.0	4.03	203798.0
2011-12-27	AAWW-DELISTED	Stock	38.81	39.44	37.99	39.16	166481.0
2011-12-27	AAXJ	Stock	50.09	50.28	49.99	50.0	472359.0
2011-12-27	AAXN-DELISTED	Stock	5.37	5.44	5.27	5.4	661911.0
2011-12-27	AB	Stock	13.45	13.54	13.19	13.23	407700.0
2011-12-27	ABAC-DELISTED	Stock	1.34	1.43	1.26	1.43	38618.0
2011-12-27	ABAX-DELISTED	Stock	27.99	28.15	27.99	28.02	60228.0
2011-12-27	ABB-DELISTED	Stock	18.59	18.72	18.57	18.6601	1595392.0
2011-12-27	ABBNY-DELISTED	Stock	18.59	18.72	18.57	18.66	1641075.0
2011-12-27	ABC-DELISTED	Stock	37.32	37.79	37.25	37.74	878304.0
2011-12-27	ABCB	Stock	10.21	10.35	10.2	10.34	10600.0
2011-12-27	ABCD-DELISTED	Stock	3.18	3.21	3.02	3.21	36546.0
2011-12-27	ABCO-DELISTED	Stock	37.13	37.14	36.88	37.0	86086.0
2011-12-27	ABCW-DELISTED	Stock	0.3263	0.3815	0.3263	0.3414	170500.0
2011-12-27	ABD-DELISTED	Stock	9.81	10.02	9.72	9.96	131020.0
2011-12-27	ABE-DELISTED	Stock	17.47	17.55	17.4	17.44	15844.0
2011-12-27	ABEO	Stock	1575.0	1712.5	1575.0	1687.5	14.0
2011-12-27	ABFS-DELISTED	Stock	18.85	19.35	18.658	19.15	182581.0
2011-12-27	ABG	Stock	20.79	21.05	20.68	21.02	98800.0
2011-12-27	ABH-DELISTED	Stock	14.62	14.7	14.5	14.7	84059.0
2011-12-27	ABM	Stock	20.81	21.14	20.79	20.99	176200.0
2011-12-27	ABMD-DELISTED	Stock	18.38	18.61	18.23	18.36	173789.0
2011-12-27	ABR	Stock	3.54	3.74	3.54	3.71	44100.0
2011-12-27	ABT	Stock	26.7824	27.0319	26.7824	26.9792	7303251.0
2011-12-27	ABTL-DELISTED	Stock	4.0891	4.1363	3.9318	4.0	6333.0
2011-12-27	ABUS	Stock	1.61	1.61	1.53	1.53	5300.0
2011-12-27	ABV-DELISTED	Stock	36.18	36.23	35.84	36.14	1436605.0
2011-12-27	ABVA-DELISTED	Stock	3.54	3.54	3.31	3.31	3543.0
2011-12-27	ABVT-DELISTED	Stock	64.75	65.09	64.69	64.82	106481.0
2011-12-27	ABX-DELISTED	Stock	45.79	46.09	45.33	45.5	2511567.0

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

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