PREVIEW / stock_daily / 2011-12-19

all stock daily files

  file:    by_date/stock_daily/2011/2011-12-19.parquet
  size:    196 KB
  rows:    6,145
  symbols: 3,549

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-19	AAPL	Stock	13.6596	13.7446	13.5886	13.6504	235530400.0
2011-12-19	MSFT	Stock	26.02	26.12	25.46	25.53	52258300.0
2011-12-19	NVDA	Stock	0.3393	0.3433	0.3278	0.329	463276000.0
2011-12-19	AMZN	Stock	9.1	9.1585	8.95	8.9665	90672000.0
2011-12-19	TSLA	Stock	1.8727	1.9	1.8247	1.85	14805000.0
2011-12-19	TLT	Stock	122.32	124.02	122.26	123.87	7845311.0
2011-12-19	ES	Stock	34.78	35.19	34.46	34.51	1168400.0
2011-12-19	CL	Stock	45.23	45.62	44.865	44.955	3302800.0
2011-12-19	A	Stock	24.0558	24.2847	23.7053	23.7697	4984289.0
2011-12-19	AABA-DELISTED	Stock	14.96	15.0	14.57	14.62	21095075.0
2011-12-19	AACC-DELISTED	Stock	3.67	3.7	3.45	3.6099	13748.0
2011-12-19	AACG	Stock	9.04	9.04	8.98	8.98	300.0
2011-12-19	AAIC-DELISTED	Stock	22.11	22.67	21.08	21.25	77297.0
2011-12-19	AAME	Stock	2.0	2.0	1.98	1.98	2300.0
2011-12-19	AAON	Stock	6.3259	6.3407	6.0444	6.0622	249413.0
2011-12-19	AAP	Stock	68.2	68.5	66.96	66.99	754300.0
2011-12-19	AAT	Stock	20.65	20.82	20.5	20.57	200700.0
2011-12-19	AATI-DELISTED	Stock	5.75	5.76	5.74	5.755	387147.0
2011-12-19	AAU-DELISTED	Stock	2.17	2.22	2.05	2.06	266209.0
2011-12-19	AAUAF-DELISTED	Stock	2.15	2.2	2.03	2.06	270827.0
2011-12-19	AAV-DELISTED	Stock	3.88	3.95	3.74	3.86	393143.0
2011-12-19	AAWW-DELISTED	Stock	38.09	38.19	36.03	36.22	182163.0
2011-12-19	AAXJ	Stock	49.02	49.25	48.22	48.45	1662178.0
2011-12-19	AAXN-DELISTED	Stock	5.7	5.95	5.5	5.53	507589.0
2011-12-19	AB	Stock	13.01	13.3	12.4	13.01	850900.0
2011-12-19	ABAC-DELISTED	Stock	1.35	1.4099	1.27	1.29	24430.0
2011-12-19	ABAX-DELISTED	Stock	27.91	28.21	27.22	27.29	106450.0
2011-12-19	ABB-DELISTED	Stock	17.98	18.02	17.69	17.74	2257517.0
2011-12-19	ABBNY-DELISTED	Stock	17.98	18.02	17.69	17.74	2262111.0
2011-12-19	ABC-DELISTED	Stock	36.67	36.9	36.3	36.45	2704005.0
2011-12-19	ABCB	Stock	10.24	10.3	9.95	9.96	33500.0
2011-12-19	ABCD-DELISTED	Stock	2.95	3.0	2.87	2.91	35259.0
2011-12-19	ABCO-DELISTED	Stock	36.32	36.32	35.46	35.48	127149.0
2011-12-19	ABCW-DELISTED	Stock	0.1807	0.241	0.1807	0.2209	281430.0
2011-12-19	ABD-DELISTED	Stock	9.95	9.96	9.53	9.64	456920.0
2011-12-19	ABE-DELISTED	Stock	16.84	16.93	16.5501	16.91	7699.0
2011-12-19	ABEO	Stock	1712.5	1775.0	1600.0	1725.0	18.0
2011-12-19	ABFS-DELISTED	Stock	17.99	18.38	17.33	17.42	264480.0
2011-12-19	ABG	Stock	20.15	20.15	19.01	19.06	230500.0
2011-12-19	ABH-DELISTED	Stock	14.81	14.92	14.4	14.49	643168.0
2011-12-19	ABM	Stock	20.68	20.93	19.95	20.0	332000.0
2011-12-19	ABMD-DELISTED	Stock	18.36	19.04	18.16	18.26	523892.0
2011-12-19	ABR	Stock	3.49	3.56	3.32	3.36	34300.0
2011-12-19	ABT	Stock	26.3026	26.3554	25.986	26.0771	12914756.0
2011-12-19	ABTL-DELISTED	Stock	3.8461	4.1054	3.8461	3.95	4230.0
2011-12-19	ABUS	Stock	1.59	1.59	1.4	1.55	16400.0
2011-12-19	ABV-DELISTED	Stock	36.0	36.62	35.71	35.76	2502696.0
2011-12-19	ABVA-DELISTED	Stock	3.4	3.599	3.35	3.52	2501.0
2011-12-19	ABVT-DELISTED	Stock	66.03	66.58	64.23	64.35	85151.0
2011-12-19	ABX-DELISTED	Stock	45.09	45.28	44.22	44.61	7603285.0

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

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