PREVIEW / stock_daily / 2011-01-07

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-07.parquet
  size:    196 KB
  rows:    6,043
  symbols: 3,536

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-07	AAPL	Stock	11.9282	12.0125	11.8536	12.0043	311931200.0
2011-01-07	MSFT	Stock	28.64	28.74	28.25	28.6	73762000.0
2011-01-07	NVDA	Stock	0.4778	0.4982	0.467	0.4968	2579984000.0
2011-01-07	AMZN	Stock	9.394	9.4225	9.187	9.2745	104434000.0
2011-01-07	TSLA	Stock	1.8667	1.9053	1.86	1.8827	33718500.0
2011-01-07	TLT	Stock	91.51	92.63	91.03	92.35	12694672.0
2011-01-07	ES	Stock	31.49	31.7	31.34	31.63	1200200.0
2011-01-07	CL	Stock	39.345	39.39	39.0	39.165	6400600.0
2011-01-07	A	Stock	29.6996	29.8999	29.3562	29.7711	3810948.0
2011-01-07	AABA-DELISTED	Stock	17.02	17.17	16.65	16.89	19533320.0
2011-01-07	AACC-DELISTED	Stock	6.22	6.22	5.91	6.08	26378.0
2011-01-07	AACG	Stock	3.8	3.85	3.8	3.85	11500.0
2011-01-07	AAI-DELISTED	Stock	7.46	7.49	7.45	7.46	1559852.0
2011-01-07	AAIC-DELISTED	Stock	24.46	24.56	24.12	24.53	23403.0
2011-01-07	AAME	Stock	2.08	2.11	2.06	2.06	2800.0
2011-01-07	AAON	Stock	5.517	5.517	5.2385	5.2859	268819.0
2011-01-07	AAP	Stock	60.45	62.11	60.3	61.88	1160600.0
2011-01-07	AATI-DELISTED	Stock	3.96	3.97	3.91	3.94	345089.0
2011-01-07	AAU-DELISTED	Stock	4.37	4.44	4.27	4.33	482223.0
2011-01-07	AAUAF-DELISTED	Stock	4.37	4.44	4.27	4.33	487373.0
2011-01-07	AAV-DELISTED	Stock	6.92	6.93	6.82	6.85	238365.0
2011-01-07	AAWW-DELISTED	Stock	53.3	53.53	50.48	52.89	878715.0
2011-01-07	AAXJ	Stock	64.2	64.2	63.43	63.83	790526.0
2011-01-07	AAXN-DELISTED	Stock	4.79	4.88	4.72	4.79	591372.0
2011-01-07	AB	Stock	23.37	23.46	23.12	23.21	519700.0
2011-01-07	ABAC-DELISTED	Stock	5.99	7.3399	5.98	6.07	766676.0
2011-01-07	ABAX-DELISTED	Stock	25.58	25.58	24.5	25.23	156413.0
2011-01-07	ABB-DELISTED	Stock	21.96	22.07	21.84	21.98	2579722.0
2011-01-07	ABBC-DELISTED	Stock	11.81	11.83	11.63	11.79	29589.0
2011-01-07	ABBNY-DELISTED	Stock	21.96	22.07	21.84	22.0	2601616.0
2011-01-07	ABC-DELISTED	Stock	34.72	35.0	34.64	34.91	2681456.0
2011-01-07	ABCB	Stock	11.15	11.15	10.7	10.98	33800.0
2011-01-07	ABCD-DELISTED	Stock	3.43	3.45	3.4	3.44	15484.0
2011-01-07	ABCO-DELISTED	Stock	24.47	24.47	23.56	24.04	53702.0
2011-01-07	ABCW-DELISTED	Stock	1.38	1.44	1.31	1.34	495300.0
2011-01-07	ABD-DELISTED	Stock	8.43	8.69	8.26	8.3	321850.0
2011-01-07	ABE-DELISTED	Stock	18.97	19.31	18.97	19.05	14906.0
2011-01-07	ABEO	Stock	3062.5	3062.5	3000.0	3062.5	15.0
2011-01-07	ABFS-DELISTED	Stock	26.8	26.99	26.12	26.79	169917.0
2011-01-07	ABG	Stock	18.7	18.72	18.37	18.72	186800.0
2011-01-07	ABH-DELISTED	Stock	24.27	24.28	23.65	24.03	830899.0
2011-01-07	ABM	Stock	26.25	26.37	25.52	25.79	145000.0
2011-01-07	ABMD-DELISTED	Stock	10.1	10.23	9.85	9.88	84912.0
2011-01-07	ABR	Stock	5.84	5.89	5.68	5.87	36300.0
2011-01-07	ABT	Stock	23.0976	23.2463	23.0448	23.2079	21604419.0
2011-01-07	ABTL-DELISTED	Stock	4.8	5.4	4.8	5.1	85507.0
2011-01-07	ABUS	Stock	5.07	5.15	5.07	5.15	3300.0
2011-01-07	ABV-DELISTED	Stock	30.72	30.86	29.93	30.1796	2435279.0
2011-01-07	ABVA-DELISTED	Stock	4.59	4.98	4.5	4.67	17434.0
2011-01-07	ABVT-DELISTED	Stock	61.13	61.13	59.2301	60.13	60810.0

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

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