PREVIEW / stock_daily / 2012-02-27

all stock daily files

  file:    by_date/stock_daily/2012/2012-02-27.parquet
  size:    199 KB
  rows:    6,184
  symbols: 3,559

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-27	AAPL	Stock	18.6182	18.875	18.4386	18.7771	547582000.0
2012-02-27	MSFT	Stock	31.24	31.5	31.1	31.35	34568400.0
2012-02-27	NVDA	Stock	0.3898	0.3915	0.3813	0.3868	745268000.0
2012-02-27	AMZN	Stock	8.877	8.9595	8.825	8.9265	74124000.0
2012-02-27	TSLA	Stock	2.2273	2.2667	2.2	2.2413	9090000.0
2012-02-27	TLT	Stock	118.5	118.85	118.12	118.54	8181453.0
2012-02-27	ES	Stock	35.78	36.04	35.47	35.67	2790200.0
2012-02-27	CL	Stock	46.495	46.605	46.105	46.195	4871200.0
2012-02-27	A	Stock	30.5508	31.1731	30.3648	31.0086	2871352.0
2012-02-27	AABA-DELISTED	Stock	14.74	14.91	14.72	14.86	13001742.0
2012-02-27	AACC-DELISTED	Stock	4.44	4.73	4.44	4.69	27226.0
2012-02-27	AACG	Stock	7.04	7.26	7.0	7.24	8400.0
2012-02-27	AAIC-DELISTED	Stock	23.12	23.14	22.75	22.98	126433.0
2012-02-27	AAME	Stock	2.21	2.27	2.21	2.22	16700.0
2012-02-27	AAMRQ-DELISTED	Stock	0.5106	0.53	0.51	0.5107	1287373.0
2012-02-27	AAON	Stock	5.7363	5.8133	5.6474	5.7778	76275.0
2012-02-27	AAP	Stock	84.46	84.74	84.06	84.17	1104100.0
2012-02-27	AAT	Stock	22.29	22.29	21.91	22.2	57400.0
2012-02-27	AAU-DELISTED	Stock	2.85	2.87	2.81	2.83	135266.0
2012-02-27	AAUAF-DELISTED	Stock	2.85	2.87	2.81	2.83	136866.0
2012-02-27	AAV-DELISTED	Stock	3.96	4.01	3.88	3.98	265009.0
2012-02-27	AAWW-DELISTED	Stock	41.8	43.0	40.94	42.89	364258.0
2012-02-27	AAXJ	Stock	56.85	57.22	56.63	57.0	348746.0
2012-02-27	AAXN-DELISTED	Stock	4.15	4.16	3.99	4.05	704820.0
2012-02-27	AB	Stock	13.81	14.08	13.51	14.0	349900.0
2012-02-27	ABAC-DELISTED	Stock	1.63	1.74	1.6	1.67	13580.0
2012-02-27	ABAX-DELISTED	Stock	26.53	26.92	26.33	26.76	43345.0
2012-02-27	ABB-DELISTED	Stock	20.51	20.87	20.48	20.79	2213171.0
2012-02-27	ABBNY-DELISTED	Stock	20.51	20.87	20.48	20.8	2215264.0
2012-02-27	ABC-DELISTED	Stock	37.47	37.84	37.45	37.73	2281034.0
2012-02-27	ABCB	Stock	11.39	11.7	11.35	11.64	168600.0
2012-02-27	ABCD-DELISTED	Stock	2.99	3.0	2.93	2.98	9966.0
2012-02-27	ABCO-DELISTED	Stock	39.18	40.78	39.07	40.59	380943.0
2012-02-27	ABCW-DELISTED	Stock	0.4317	0.4317	0.3815	0.3815	2930.0
2012-02-27	ABD-DELISTED	Stock	12.21	12.29	11.88	12.27	158760.0
2012-02-27	ABE-DELISTED	Stock	18.77	18.86	18.612	18.85	27631.0
2012-02-27	ABEO	Stock	1625.0	1675.0	1600.0	1662.5	25.0
2012-02-27	ABFS-DELISTED	Stock	18.22	18.59	18.03	18.04	246358.0
2012-02-27	ABG	Stock	25.45	25.71	25.1	25.65	385300.0
2012-02-27	ABH-DELISTED	Stock	15.12	15.36	14.92	15.16	181388.0
2012-02-27	ABM	Stock	23.31	23.75	23.0	23.61	257000.0
2012-02-27	ABMD-DELISTED	Stock	21.81	22.17	21.32	21.9	225970.0
2012-02-27	ABR	Stock	4.78	4.78	4.68	4.73	32100.0
2012-02-27	ABT	Stock	27.0511	27.2286	26.9264	27.1567	9876615.0
2012-02-27	ABTL-DELISTED	Stock	5.1061	5.1061	4.914	5.05	11341.0
2012-02-27	ABUS	Stock	2.45	2.45	2.45	2.45	300.0
2012-02-27	ABV-DELISTED	Stock	39.38	40.2473	39.23	39.99	2158380.0
2012-02-27	ABVT-DELISTED	Stock	70.94	72.84	70.38	72.74	157961.0
2012-02-27	ABX-DELISTED	Stock	49.0	49.11	48.33	48.51	5156221.0
2012-02-27	ACAD	Stock	1.78	1.79	1.74	1.76	98700.0

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

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