PREVIEW / stock_daily / 2011-01-14

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-14.parquet
  size:    197 KB
  rows:    6,068
  symbols: 3,544

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-01-14	AAPL	Stock	12.3532	12.4457	12.3014	12.4457	308840000.0
2011-01-14	MSFT	Stock	28.08	28.38	27.91	28.3	62688400.0
2011-01-14	NVDA	Stock	0.5748	0.5995	0.5712	0.5898	1595352000.0
2011-01-14	AMZN	Stock	9.275	9.447	9.246	9.4375	73256000.0
2011-01-14	TSLA	Stock	1.7433	1.772	1.7073	1.7167	17880000.0
2011-01-14	TLT	Stock	92.78	92.9	91.76	91.835	8960673.0
2011-01-14	ES	Stock	31.7	32.01	31.61	32.01	1535900.0
2011-01-14	CL	Stock	39.075	39.155	38.91	39.155	4035800.0
2011-01-14	A	Stock	30.608	31.0229	30.5866	30.9442	3097549.0
2011-01-14	AABA-DELISTED	Stock	16.66	16.83	16.6	16.8	13549259.0
2011-01-14	AACC-DELISTED	Stock	6.42	6.51	6.42	6.45	11574.0
2011-01-14	AACG	Stock	3.96	3.98	3.96	3.98	2700.0
2011-01-14	AAI-DELISTED	Stock	7.49	7.5	7.48	7.49	1587267.0
2011-01-14	AAIC-DELISTED	Stock	24.09	24.37	23.91	24.31	23482.0
2011-01-14	AAME	Stock	1.84	2.24	1.84	2.19	1500.0
2011-01-14	AAON	Stock	5.4736	5.4993	5.4222	5.4933	301219.0
2011-01-14	AAP	Stock	62.92	63.53	62.8	63.18	624900.0
2011-01-14	AAT	Stock	21.16	21.45	21.16	21.31	1304800.0
2011-01-14	AATI-DELISTED	Stock	4.53	4.69	4.4693	4.6	165593.0
2011-01-14	AAU-DELISTED	Stock	4.23	4.3399	3.68	3.92	2037231.0
2011-01-14	AAUAF-DELISTED	Stock	4.23	4.3399	3.68	3.91	2039331.0
2011-01-14	AAV-DELISTED	Stock	7.03	7.25	7.02	7.23	436242.0
2011-01-14	AAWW-DELISTED	Stock	51.3	51.92	50.92	51.52	409513.0
2011-01-14	AAXJ	Stock	63.94	64.2	63.73	64.11	1636354.0
2011-01-14	AAXN-DELISTED	Stock	4.73	4.81	4.7	4.81	302785.0
2011-01-14	AB	Stock	23.49	23.64	22.95	23.3	1152700.0
2011-01-14	ABAC-DELISTED	Stock	5.85	5.9699	5.75	5.83	70481.0
2011-01-14	ABAX-DELISTED	Stock	25.58	26.24	25.36	26.23	66146.0
2011-01-14	ABB-DELISTED	Stock	23.29	23.615	23.28	23.56	1876921.0
2011-01-14	ABBC-DELISTED	Stock	11.51	11.9	11.51	11.88	43638.0
2011-01-14	ABBNY-DELISTED	Stock	23.29	23.615	23.28	23.55	1896256.0
2011-01-14	ABC-DELISTED	Stock	35.28	35.45	34.94	35.45	2515260.0
2011-01-14	ABCB	Stock	10.99	11.07	10.91	10.98	31300.0
2011-01-14	ABCD-DELISTED	Stock	3.41	3.49	3.33	3.38	36497.0
2011-01-14	ABCO-DELISTED	Stock	23.75	24.49	23.75	24.32	137540.0
2011-01-14	ABCW-DELISTED	Stock	1.3708	1.4194	1.3319	1.4	177670.0
2011-01-14	ABD-DELISTED	Stock	8.55	8.66	8.42	8.5	243510.0
2011-01-14	ABE-DELISTED	Stock	19.12	19.42	19.06	19.14	20685.0
2011-01-14	ABEO	Stock	3000.0	3087.5	3000.0	3062.5	50.0
2011-01-14	ABFS-DELISTED	Stock	25.45	26.235	25.35	26.15	153849.0
2011-01-14	ABG	Stock	18.54	18.61	18.36	18.56	205000.0
2011-01-14	ABH-DELISTED	Stock	25.7	25.78	25.05	25.35	811551.0
2011-01-14	ABM	Stock	26.25	26.51	26.0	26.51	149600.0
2011-01-14	ABMD-DELISTED	Stock	10.3	10.45	10.16	10.21	509168.0
2011-01-14	ABR	Stock	5.91	6.0	5.8	5.99	30000.0
2011-01-14	ABT	Stock	22.7185	22.7713	22.445	22.4978	23048979.0
2011-01-14	ABTL-DELISTED	Stock	5.2	5.35	4.9	5.05	21397.0
2011-01-14	ABUS	Stock	5.99	6.15	5.85	6.01	32200.0
2011-01-14	ABV-DELISTED	Stock	29.1	29.1	28.05	28.06	6202102.0
2011-01-14	ABVA-DELISTED	Stock	4.9	4.9	4.862	4.9	1160.0

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

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