PREVIEW / stock_daily / 2011-03-10

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-10.parquet
  size:    197 KB
  rows:    6,064
  symbols: 3,537

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-03-10	AAPL	Stock	12.4686	12.4918	12.3179	12.3811	507539200.0
2011-03-10	MSFT	Stock	25.62	25.71	25.35	25.41	66549500.0
2011-03-10	NVDA	Stock	0.4675	0.471	0.4475	0.448	1722736000.0
2011-03-10	AMZN	Stock	8.3535	8.4235	8.241	8.307	119968000.0
2011-03-10	TSLA	Stock	1.6293	1.6327	1.582	1.6007	15255000.0
2011-03-10	TLT	Stock	90.87	92.1	90.64	92.075	13389860.0
2011-03-10	ES	Stock	34.83	34.85	34.4	34.48	1246400.0
2011-03-10	CL	Stock	39.345	39.65	39.21	39.49	5688800.0
2011-03-10	A	Stock	32.4464	32.6967	31.9886	32.103	6788269.0
2011-03-10	AABA-DELISTED	Stock	17.31	17.39	16.93	17.065	25523991.0
2011-03-10	AACC-DELISTED	Stock	5.65	5.71	5.63	5.66	36491.0
2011-03-10	AACG	Stock	7.69	7.7	7.5	7.7	31000.0
2011-03-10	AAI-DELISTED	Stock	7.36	7.45	7.34	7.39	1805561.0
2011-03-10	AAIC-DELISTED	Stock	27.9	28.46	27.72	27.99	67666.0
2011-03-10	AAME	Stock	2.02	2.02	1.92	2.0	2000.0
2011-03-10	AAON	Stock	6.0365	6.1235	5.8311	5.839	338175.0
2011-03-10	AAP	Stock	63.9	65.61	63.75	64.89	1230700.0
2011-03-10	AAT	Stock	21.0	21.11	20.72	20.77	162500.0
2011-03-10	AATI-DELISTED	Stock	4.02	4.03	3.7778	3.85	281974.0
2011-03-10	AAU-DELISTED	Stock	3.74	3.74	3.54	3.62	456142.0
2011-03-10	AAUAF-DELISTED	Stock	3.74	3.74	3.54	3.62	456742.0
2011-03-10	AAV-DELISTED	Stock	8.04	8.0663	7.75	7.97	1070856.0
2011-03-10	AAWW-DELISTED	Stock	66.61	67.305	65.37	65.45	284765.0
2011-03-10	AAXJ	Stock	61.21	61.33	60.5901	60.69	415236.0
2011-03-10	AAXN-DELISTED	Stock	4.1	4.18	4.04	4.09	459274.0
2011-03-10	AB	Stock	22.53	22.65	22.08	22.21	794100.0
2011-03-10	ABAC-DELISTED	Stock	5.09	5.09	4.76	4.92	65172.0
2011-03-10	ABAX-DELISTED	Stock	28.69	28.97	27.56	28.14	148199.0
2011-03-10	ABB-DELISTED	Stock	23.49	23.53	23.29	23.34	1902291.0
2011-03-10	ABBC-DELISTED	Stock	12.48	12.48	12.04	12.09	57282.0
2011-03-10	ABBNY-DELISTED	Stock	23.49	23.53	23.29	23.31	1903491.0
2011-03-10	ABC-DELISTED	Stock	38.13	38.13	37.47	37.55	1562201.0
2011-03-10	ABCB	Stock	9.86	9.86	9.56	9.69	73100.0
2011-03-10	ABCD-DELISTED	Stock	3.59	3.6	3.39	3.39	29609.0
2011-03-10	ABCO-DELISTED	Stock	24.67	24.85	24.1	24.28	130696.0
2011-03-10	ABCW-DELISTED	Stock	1.02	1.0201	1.0	1.02	43790.0
2011-03-10	ABD-DELISTED	Stock	9.27	9.27	8.9	9.03	410610.0
2011-03-10	ABE-DELISTED	Stock	17.84	18.0	17.72	17.77	9304.0
2011-03-10	ABEO	Stock	2400.0	2625.0	2387.5	2625.0	9.0
2011-03-10	ABFS-DELISTED	Stock	24.71	25.34	24.51	24.6	173047.0
2011-03-10	ABG	Stock	19.43	19.43	18.65	18.92	359200.0
2011-03-10	ABH-DELISTED	Stock	27.83	27.88	26.35	26.83	363365.0
2011-03-10	ABM	Stock	25.19	25.26	24.78	24.83	441900.0
2011-03-10	ABMD-DELISTED	Stock	13.93	14.08	13.49	14.02	254423.0
2011-03-10	ABR	Stock	5.86	5.86	5.67	5.8	94700.0
2011-03-10	ABT	Stock	23.419	23.4814	23.2223	23.2703	19423510.0
2011-03-10	ABTL-DELISTED	Stock	6.0974	6.147	5.4034	5.8	105987.0
2011-03-10	ABUS	Stock	4.71	4.75	4.64	4.75	300.0
2011-03-10	ABV-DELISTED	Stock	27.18	27.59	26.86	27.45	2141976.0
2011-03-10	ABVA-DELISTED	Stock	4.7	4.92	4.7	4.9	1610.0

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

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