PREVIEW / stock_daily / 2011-04-18

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-18.parquet
  size:    197 KB
  rows:    6,078
  symbols: 3,548

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-04-18	AAPL	Stock	11.6464	11.8654	11.4343	11.8518	609898800.0
2011-04-18	MSFT	Stock	25.1	25.28	24.72	25.08	58045100.0
2011-04-18	NVDA	Stock	0.4568	0.4598	0.445	0.4522	743584000.0
2011-04-18	AMZN	Stock	8.919	8.9455	8.7685	8.917	92330000.0
2011-04-18	TSLA	Stock	1.6753	1.708	1.624	1.6687	15508500.0
2011-04-18	TLT	Stock	91.99	93.1	91.45	92.88	12038393.0
2011-04-18	ES	Stock	33.67	33.74	33.31	33.48	1952500.0
2011-04-18	CL	Stock	40.7	40.845	40.545	40.675	4185000.0
2011-04-18	A	Stock	33.5122	33.5122	32.4177	33.319	6401023.0
2011-04-18	AABA-DELISTED	Stock	16.35	16.44	16.06	16.34	20941502.0
2011-04-18	AACC-DELISTED	Stock	5.31	5.33	5.2	5.32	12331.0
2011-04-18	AACG	Stock	7.99	7.99	7.66	7.87	4900.0
2011-04-18	AAI-DELISTED	Stock	7.34	7.38	7.34	7.35	1511610.0
2011-04-18	AAIC-DELISTED	Stock	29.17	29.36	28.73	29.24	35799.0
2011-04-18	AAME	Stock	2.05	2.05	2.04	2.05	300.0
2011-04-18	AAON	Stock	6.0681	6.2242	6.0286	6.2104	174656.0
2011-04-18	AAP	Stock	63.55	64.7	63.34	64.5	1030100.0
2011-04-18	AAT	Stock	21.34	21.54	21.16	21.26	100000.0
2011-04-18	AATI-DELISTED	Stock	4.15	4.31	4.08	4.3	247619.0
2011-04-18	AAU-DELISTED	Stock	4.47	4.47	4.03	4.37	566010.0
2011-04-18	AAUAF-DELISTED	Stock	4.47	4.47	4.03	4.37	567010.0
2011-04-18	AAV-DELISTED	Stock	8.41	8.47	8.21	8.3	352473.0
2011-04-18	AAWW-DELISTED	Stock	64.14	64.14	61.79	63.08	272225.0
2011-04-18	AAXJ	Stock	62.64	62.9	62.29	62.85	603365.0
2011-04-18	AAXN-DELISTED	Stock	3.85	3.87	3.84	3.85	294928.0
2011-04-18	AB	Stock	21.64	21.64	21.29	21.55	442500.0
2011-04-18	ABAC-DELISTED	Stock	3.39	3.48	3.35	3.43	16385.0
2011-04-18	ABAX-DELISTED	Stock	28.65	28.79	27.94	28.47	79942.0
2011-04-18	ABB-DELISTED	Stock	24.06	24.12	23.69	23.93	2932419.0
2011-04-18	ABBC-DELISTED	Stock	12.14	12.19	11.91	12.1	28680.0
2011-04-18	ABBNY-DELISTED	Stock	24.06	24.12	23.69	23.94	3138095.0
2011-04-18	ABC-DELISTED	Stock	39.31	39.75	38.86	39.49	2472716.0
2011-04-18	ABCB	Stock	9.55	9.69	9.51	9.61	37500.0
2011-04-18	ABCD-DELISTED	Stock	3.26	3.29	3.2	3.28	23874.0
2011-04-18	ABCO-DELISTED	Stock	23.89	23.89	23.57	23.67	81432.0
2011-04-18	ABCW-DELISTED	Stock	0.89	0.9092	0.8599	0.86	62650.0
2011-04-18	ABD-DELISTED	Stock	9.315	9.445	9.135	9.435	159150.0
2011-04-18	ABE-DELISTED	Stock	18.66	18.7	18.525	18.58	8474.0
2011-04-18	ABEO	Stock	2825.0	2937.5	2687.5	2875.0	13.0
2011-04-18	ABFS-DELISTED	Stock	25.08	25.34	24.97	25.11	136790.0
2011-04-18	ABG	Stock	16.62	16.8	16.24	16.75	230400.0
2011-04-18	ABH-DELISTED	Stock	25.9	26.02	25.39	25.63	287064.0
2011-04-18	ABM	Stock	24.28	24.41	23.95	24.11	142800.0
2011-04-18	ABMD-DELISTED	Stock	16.94	16.99	16.53	16.61	570119.0
2011-04-18	ABR	Stock	5.28	5.3	5.15	5.2	67100.0
2011-04-18	ABT	Stock	24.7481	24.7529	24.4026	24.6041	21947061.0
2011-04-18	ABTL-DELISTED	Stock	7.444	7.444	6.944	7.0	57611.0
2011-04-18	ABUS	Stock	2.85	2.85	2.69	2.7	6000.0
2011-04-18	ABV-DELISTED	Stock	29.56	29.98	29.41	29.97	2500366.0
2011-04-18	ABVA-DELISTED	Stock	6.3	6.4388	6.0	6.12	66995.0

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

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