PREVIEW / stock_daily / 2011-01-19

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-19.parquet
  size:    197 KB
  rows:    6,066
  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-19	AAPL	Stock	12.4411	12.45	12.0314	12.1014	1135612800.0
2011-01-19	MSFT	Stock	28.46	28.68	28.27	28.47	50005900.0
2011-01-19	NVDA	Stock	0.5762	0.59	0.559	0.5602	1197896000.0
2011-01-19	AMZN	Stock	9.545	9.55	9.3105	9.3435	77648000.0
2011-01-19	TSLA	Stock	1.6847	1.698	1.5833	1.602	35572500.0
2011-01-19	TLT	Stock	91.41	92.07	91.36	92.07	8888029.0
2011-01-19	ES	Stock	32.63	32.77	32.32	32.37	1067000.0
2011-01-19	CL	Stock	39.295	39.57	39.125	39.5	5880400.0
2011-01-19	A	Stock	31.6309	31.681	30.2361	30.3505	6341747.0
2011-01-19	AABA-DELISTED	Stock	16.49	16.55	16.23	16.31	16581650.0
2011-01-19	AACC-DELISTED	Stock	6.45	6.45	6.23	6.27	25162.0
2011-01-19	AACG	Stock	3.85	4.04	3.85	4.04	1600.0
2011-01-19	AAI-DELISTED	Stock	7.5	7.52	7.46	7.47	1470143.0
2011-01-19	AAIC-DELISTED	Stock	24.31	24.31	23.93	24.04	22917.0
2011-01-19	AAME	Stock	2.07	2.12	2.07	2.12	3400.0
2011-01-19	AAON	Stock	5.4756	5.4756	5.2701	5.278	210094.0
2011-01-19	AAP	Stock	62.64	64.21	62.39	63.46	864500.0
2011-01-19	AAT	Stock	21.42	21.42	20.88	21.25	1010200.0
2011-01-19	AATI-DELISTED	Stock	4.55	4.55	4.41	4.47	189445.0
2011-01-19	AAU-DELISTED	Stock	3.9	3.92	3.53	3.67	1310452.0
2011-01-19	AAUAF-DELISTED	Stock	3.9	3.92	3.53	3.67	1311152.0
2011-01-19	AAV-DELISTED	Stock	7.26	7.26	7.13	7.13	300805.0
2011-01-19	AAWW-DELISTED	Stock	50.86	51.15	49.77	50.06	381314.0
2011-01-19	AAXJ	Stock	64.24	64.3	63.6401	63.81	509263.0
2011-01-19	AAXN-DELISTED	Stock	4.92	4.94	4.76	4.76	628594.0
2011-01-19	AB	Stock	21.88	21.96	21.66	21.84	755700.0
2011-01-19	ABAC-DELISTED	Stock	5.88	6.14	5.75	5.78	116901.0
2011-01-19	ABAX-DELISTED	Stock	27.18	27.47	26.5	26.69	210976.0
2011-01-19	ABB-DELISTED	Stock	23.64	23.68	23.22	23.29	1371701.0
2011-01-19	ABBC-DELISTED	Stock	11.75	11.77	11.03	11.05	72427.0
2011-01-19	ABBNY-DELISTED	Stock	23.64	23.68	23.22	23.31	1374781.0
2011-01-19	ABC-DELISTED	Stock	36.08	36.15	35.39	35.56	2049256.0
2011-01-19	ABCB	Stock	10.79	10.83	10.06	10.41	85000.0
2011-01-19	ABCD-DELISTED	Stock	3.36	3.3604	3.22	3.31	42536.0
2011-01-19	ABCO-DELISTED	Stock	24.35	24.72	24.3	24.46	298690.0
2011-01-19	ABCW-DELISTED	Stock	1.3983	1.3983	1.2914	1.34	194630.0
2011-01-19	ABD-DELISTED	Stock	8.45	8.45	7.94	7.96	284220.0
2011-01-19	ABE-DELISTED	Stock	19.32	19.52	19.011	19.07	4879.0
2011-01-19	ABEO	Stock	3000.0	3062.5	3000.0	3062.5	37.0
2011-01-19	ABFS-DELISTED	Stock	26.38	26.63	25.88	25.97	187518.0
2011-01-19	ABG	Stock	18.36	18.45	18.03	18.16	167500.0
2011-01-19	ABH-DELISTED	Stock	26.8	26.85	26.48	26.72	1423665.0
2011-01-19	ABM	Stock	26.5	26.69	25.8	25.87	245200.0
2011-01-19	ABMD-DELISTED	Stock	9.92	10.02	9.7	9.71	345173.0
2011-01-19	ABR	Stock	5.95	5.97	5.9	5.97	27000.0
2011-01-19	ABT	Stock	22.6801	22.8913	22.6514	22.7089	19433306.0
2011-01-19	ABTL-DELISTED	Stock	4.9005	5.0005	4.7505	4.9995	30320.0
2011-01-19	ABUS	Stock	7.19	7.65	6.85	7.35	163700.0
2011-01-19	ABV-DELISTED	Stock	27.66	27.87	27.44	27.72	5533613.0
2011-01-19	ABVA-DELISTED	Stock	4.75	4.9899	4.3301	4.915	1513.0

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

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