PREVIEW / stock_daily / 2012-02-15

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-15.parquet
  size:    199 KB
  rows:    6,165
  symbols: 3,553

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
2012-02-15	AAPL	Stock	18.3664	18.7961	17.7461	17.7739	1506120000.0
2012-02-15	MSFT	Stock	30.33	30.39	30.03	30.05	43311300.0
2012-02-15	NVDA	Stock	0.4098	0.4225	0.4032	0.4043	1110856000.0
2012-02-15	AMZN	Stock	9.5645	9.577	9.163	9.2235	155888000.0
2012-02-15	TSLA	Stock	2.2067	2.294	2.1513	2.24	41427000.0
2012-02-15	TLT	Stock	117.66	118.27	117.49	117.55	6846276.0
2012-02-15	ES	Stock	34.91	35.55	34.72	35.52	3929400.0
2012-02-15	CL	Stock	45.96	46.295	45.88	46.08	3347400.0
2012-02-15	A	Stock	31.8312	31.8312	31.0658	31.216	3490526.0
2012-02-15	AABA-DELISTED	Stock	15.26	15.3	15.08	15.11	22818878.0
2012-02-15	AACC-DELISTED	Stock	4.48	4.689	4.44	4.53	14420.0
2012-02-15	AACG	Stock	6.84	7.14	6.8	7.0	11300.0
2012-02-15	AAIC-DELISTED	Stock	23.02	23.02	22.5	22.57	45077.0
2012-02-15	AAME	Stock	2.25	2.26	2.21	2.24	9100.0
2012-02-15	AAMRQ-DELISTED	Stock	0.554	0.57	0.515	0.5395	5782541.0
2012-02-15	AAON	Stock	5.5674	5.7541	5.4104	5.437	264938.0
2012-02-15	AAP	Stock	79.96	80.22	79.11	79.4	1354300.0
2012-02-15	AAT	Stock	21.67	21.98	21.3	21.62	481300.0
2012-02-15	AAU-DELISTED	Stock	2.61	2.66	2.56	2.58	118284.0
2012-02-15	AAUAF-DELISTED	Stock	2.61	2.66	2.56	2.58	118684.0
2012-02-15	AAV-DELISTED	Stock	3.79	3.82	3.68	3.71	230601.0
2012-02-15	AAWW-DELISTED	Stock	45.08	47.0	44.56	45.07	2505175.0
2012-02-15	AAXJ	Stock	57.52	57.65	57.13	57.31	379295.0
2012-02-15	AAXN-DELISTED	Stock	4.57	4.58	4.44	4.44	470441.0
2012-02-15	AB	Stock	13.86	13.96	13.65	13.66	518200.0
2012-02-15	ABAC-DELISTED	Stock	1.59	1.6	1.58	1.58	48389.0
2012-02-15	ABAX-DELISTED	Stock	27.23	27.23	25.76	25.96	278416.0
2012-02-15	ABB-DELISTED	Stock	21.58	21.68	21.46	21.66	2754639.0
2012-02-15	ABBNY-DELISTED	Stock	21.58	21.68	21.46	21.67	3305790.0
2012-02-15	ABC-DELISTED	Stock	37.58	37.72	36.64	36.74	3647238.0
2012-02-15	ABCB	Stock	10.92	10.93	10.74	10.78	33900.0
2012-02-15	ABCD-DELISTED	Stock	3.18	3.19	3.035	3.05	13570.0
2012-02-15	ABCO-DELISTED	Stock	38.29	38.42	37.82	37.94	211776.0
2012-02-15	ABCW-DELISTED	Stock	0.4066	0.4066	0.4066	0.4066	1490.0
2012-02-15	ABD-DELISTED	Stock	11.14	11.92	10.98	11.57	1289900.0
2012-02-15	ABE-DELISTED	Stock	18.9	19.07	18.83	18.85	61714.0
2012-02-15	ABEO	Stock	1687.5	1737.5	1650.0	1700.0	9.0
2012-02-15	ABFS-DELISTED	Stock	18.72	19.12	18.21	18.79	299050.0
2012-02-15	ABG	Stock	26.6	26.7	25.09	25.42	501100.0
2012-02-15	ABH-DELISTED	Stock	15.18	15.25	14.91	14.99	177195.0
2012-02-15	ABM	Stock	22.69	22.73	22.35	22.47	221000.0
2012-02-15	ABMD-DELISTED	Stock	24.01	24.2492	23.6	23.73	330606.0
2012-02-15	ABR	Stock	4.71	4.85	4.71	4.85	36200.0
2012-02-15	ABT	Stock	26.5329	26.7393	26.3938	26.6097	15083576.0
2012-02-15	ABTL-DELISTED	Stock	4.898	5.2551	4.898	5.0	29443.0
2012-02-15	ABUS	Stock	2.5	2.5	2.32	2.39	13400.0
2012-02-15	ABV-DELISTED	Stock	37.89	37.93	37.02	37.26	2041440.0
2012-02-15	ABVA-DELISTED	Stock	3.49	3.55	3.49	3.55	10248.0
2012-02-15	ABVT-DELISTED	Stock	70.18	70.8	69.15	70.25	72614.0
2012-02-15	ABX-DELISTED	Stock	48.16	48.2101	47.395	47.46	5441042.0

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

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