PREVIEW / stock_daily / 2011-10-26

all stock daily files

  file:    by_date/stock_daily/2011/2011-10-26.parquet
  size:    194 KB
  rows:    6,059
  symbols: 3,505

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-10-26	AAPL	Stock	14.3486	14.3768	14.0411	14.3071	456304800.0
2011-10-26	MSFT	Stock	27.03	27.06	26.1	26.59	63029900.0
2011-10-26	NVDA	Stock	0.3682	0.3703	0.355	0.3655	503116000.0
2011-10-26	AMZN	Stock	10.1845	10.379	9.8255	9.92	482684000.0
2011-10-26	TSLA	Stock	1.8793	1.8913	1.8267	1.8653	7657500.0
2011-10-26	TLT	Stock	115.39	116.21	114.07	114.17	12746920.0
2011-10-26	ES	Stock	33.82	33.99	33.4	33.92	1990000.0
2011-10-26	CL	Stock	45.4	45.635	44.37	45.27	7540800.0
2011-10-26	A	Stock	25.7368	25.794	24.9142	25.6009	8705206.0
2011-10-26	AABA-DELISTED	Stock	16.33	16.435	15.86	16.29	21858105.0
2011-10-26	AACC-DELISTED	Stock	3.08	3.165	3.03	3.1	7064.0
2011-10-26	AACG	Stock	9.5	9.5	9.05	9.05	800.0
2011-10-26	AAIC-DELISTED	Stock	25.07	25.21	24.34	24.69	63926.0
2011-10-26	AAME	Stock	1.82	1.88	1.79	1.88	2700.0
2011-10-26	AAON	Stock	5.7422	5.9407	5.5496	5.8726	169425.0
2011-10-26	AAP	Stock	63.84	64.0	62.63	63.34	727800.0
2011-10-26	AAT	Stock	19.89	20.2	19.31	19.94	108300.0
2011-10-26	AATI-DELISTED	Stock	4.44	4.46	4.345	4.39	244248.0
2011-10-26	AAU-DELISTED	Stock	2.54	2.85	2.54	2.85	345424.0
2011-10-26	AAUAF-DELISTED	Stock	2.54	2.85	2.54	2.85	346924.0
2011-10-26	AAV-DELISTED	Stock	5.1	5.2	4.96	5.15	411667.0
2011-10-26	AAWW-DELISTED	Stock	38.36	39.62	37.25	39.26	189813.0
2011-10-26	AAXJ	Stock	53.06	53.21	52.19	52.9	348114.0
2011-10-26	AAXN-DELISTED	Stock	4.89	4.92	4.77	4.92	339531.0
2011-10-26	AB	Stock	14.54	14.78	13.62	14.1	602700.0
2011-10-26	ABAC-DELISTED	Stock	1.36	1.49	1.27	1.49	26704.0
2011-10-26	ABAX-DELISTED	Stock	24.91	29.91	24.86	28.4	598378.0
2011-10-26	ABB-DELISTED	Stock	19.86	19.92	19.2999	19.61	2313172.0
2011-10-26	ABBNY-DELISTED	Stock	19.86	19.92	19.2999	19.59	2313672.0
2011-10-26	ABC-DELISTED	Stock	40.25	41.12	40.25	40.87	3722272.0
2011-10-26	ABCB	Stock	9.75	10.03	9.53	9.98	56900.0
2011-10-26	ABCD-DELISTED	Stock	3.25	3.25	3.1	3.18	56166.0
2011-10-26	ABCO-DELISTED	Stock	31.01	31.01	29.97	30.74	145910.0
2011-10-26	ABCW-DELISTED	Stock	0.55	0.55	0.49	0.53	14380.0
2011-10-26	ABD-DELISTED	Stock	6.4	6.96	6.4	6.65	1056120.0
2011-10-26	ABE-DELISTED	Stock	17.66	17.8	17.4	17.8	4525.0
2011-10-26	ABEO	Stock	2125.0	2187.5	2062.5	2175.0	3.0
2011-10-26	ABFS-DELISTED	Stock	19.22	19.92	18.82	19.78	872243.0
2011-10-26	ABG	Stock	20.55	20.72	18.52	19.11	802200.0
2011-10-26	ABH-DELISTED	Stock	16.29	16.46	15.82	16.04	159811.0
2011-10-26	ABM	Stock	19.91	20.41	19.38	20.26	264300.0
2011-10-26	ABMD-DELISTED	Stock	12.91	13.95	12.708	13.76	376080.0
2011-10-26	ABR	Stock	3.6	3.6	3.51	3.57	49800.0
2011-10-26	ABT	Stock	25.6597	25.7892	25.463	25.7413	17623385.0
2011-10-26	ABTL-DELISTED	Stock	4.187	4.563	4.187	4.563	7400.0
2011-10-26	ABUS	Stock	1.7	1.7	1.7	1.7	1200.0
2011-10-26	ABV-DELISTED	Stock	34.0	34.19	33.36	33.78	2621618.0
2011-10-26	ABVA-DELISTED	Stock	5.2	5.3	5.2	5.3	39702.0
2011-10-26	ABVT-DELISTED	Stock	57.35	58.59	55.72	58.15	88974.0
2011-10-26	ABX-DELISTED	Stock	47.89	48.35	47.09	47.85	9228365.0

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

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