PREVIEW / stock_daily / 2011-01-18

all stock daily files

  file:    by_date/stock_daily/2011/2011-01-18.parquet
  size:    198 KB
  rows:    6,088
  symbols: 3,560

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-18	AAPL	Stock	11.7686	12.3129	11.6429	12.1661	1880998000.0
2011-01-18	MSFT	Stock	28.16	28.74	28.14	28.66	53322700.0
2011-01-18	NVDA	Stock	0.5818	0.5858	0.5618	0.576	1813348000.0
2011-01-18	AMZN	Stock	9.433	9.58	9.4125	9.5625	77924000.0
2011-01-18	TSLA	Stock	1.6987	1.7093	1.65	1.7093	24325500.0
2011-01-18	TLT	Stock	91.29	91.71	90.73	91.41	10663684.0
2011-01-18	ES	Stock	32.11	32.69	31.98	32.58	2413800.0
2011-01-18	CL	Stock	39.175	39.485	39.08	39.2	5760800.0
2011-01-18	A	Stock	31.0229	31.7954	30.9871	31.7239	4168277.0
2011-01-18	AABA-DELISTED	Stock	16.57	16.68	16.415	16.49	21046499.0
2011-01-18	AACC-DELISTED	Stock	6.42	6.46	5.971	6.43	15958.0
2011-01-18	AACG	Stock	4.0	4.15	3.95	3.95	24100.0
2011-01-18	AAI-DELISTED	Stock	7.49	7.55	7.46	7.5	2311373.0
2011-01-18	AAIC-DELISTED	Stock	24.3	24.495	24.2	24.38	32832.0
2011-01-18	AAME	Stock	2.25	2.25	2.02	2.02	4300.0
2011-01-18	AAON	Stock	5.4637	5.5151	5.4123	5.4894	91125.0
2011-01-18	AAP	Stock	63.2	63.62	62.36	62.91	1133200.0
2011-01-18	AAT	Stock	21.3	21.45	21.2	21.37	124800.0
2011-01-18	AATI-DELISTED	Stock	4.61	4.639	4.51	4.54	74847.0
2011-01-18	AAU-DELISTED	Stock	3.99	4.08	3.84	3.92	875839.0
2011-01-18	AAUAF-DELISTED	Stock	4.01	4.1	3.85	3.9	882705.0
2011-01-18	AAV-DELISTED	Stock	7.26	7.39	7.145	7.27	430790.0
2011-01-18	AAWW-DELISTED	Stock	51.2	51.62	50.82	51.03	260034.0
2011-01-18	AAXJ	Stock	64.08	64.179	63.82	63.93	1182690.0
2011-01-18	AAXN-DELISTED	Stock	4.77	4.8385	4.71	4.77	343115.0
2011-01-18	AB	Stock	22.55	22.95	21.5	22.13	1785000.0
2011-01-18	ABAC-DELISTED	Stock	5.97	5.97	5.82	5.84	43343.0
2011-01-18	ABAX-DELISTED	Stock	26.13	26.83	26.13	26.76	99313.0
2011-01-18	ABB-DELISTED	Stock	23.73	23.88	23.6	23.76	1298060.0
2011-01-18	ABBC-DELISTED	Stock	11.81	11.86	11.7	11.8	33244.0
2011-01-18	ABBNY-DELISTED	Stock	23.73	23.88	23.6	23.78	1299925.0
2011-01-18	ABC-DELISTED	Stock	35.47	36.26	35.4	36.19	4818060.0
2011-01-18	ABCB	Stock	11.0	11.0	10.82	10.83	50800.0
2011-01-18	ABCD-DELISTED	Stock	3.37	3.42	3.31	3.38	25577.0
2011-01-18	ABCO-DELISTED	Stock	24.17	24.6	23.95	24.4	94402.0
2011-01-18	ABCW-DELISTED	Stock	1.44	1.45	1.33	1.43	148620.0
2011-01-18	ABD-DELISTED	Stock	8.47	8.587	8.4	8.49	232740.0
2011-01-18	ABE-DELISTED	Stock	19.05	19.29	19.03	19.24	29283.0
2011-01-18	ABEO	Stock	3012.5	3087.5	3000.0	3062.5	59.0
2011-01-18	ABFS-DELISTED	Stock	25.98	26.56	25.98	26.31	189963.0
2011-01-18	ABG	Stock	18.54	18.54	18.15	18.39	130600.0
2011-01-18	ABH-DELISTED	Stock	26.45	26.99	25.68	26.66	1464993.0
2011-01-18	ABM	Stock	26.42	26.5	26.25	26.47	209200.0
2011-01-18	ABMD-DELISTED	Stock	10.19	10.2	9.94	9.98	192095.0
2011-01-18	ABR	Stock	5.95	6.01	5.93	5.98	41500.0
2011-01-18	ABT	Stock	22.4786	22.6801	22.3731	22.6466	23327845.0
2011-01-18	ABTL-DELISTED	Stock	4.85	5.1	4.6	5.0	49935.0
2011-01-18	ABUS	Stock	7.28	7.49	6.31	6.85	84900.0
2011-01-18	ABV-DELISTED	Stock	28.3	28.4671	27.6	27.8	7790405.0
2011-01-18	ABVA-DELISTED	Stock	5.02	5.17	4.75	5.0	2750.0

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

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