PREVIEW / stock_daily / 2011-04-14

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-14.parquet
  size:    196 KB
  rows:    6,036
  symbols: 3,530

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-14	AAPL	Stock	11.9571	12.0	11.8593	11.8721	301800800.0
2011-04-14	MSFT	Stock	25.42	25.44	25.09	25.42	55239900.0
2011-04-14	NVDA	Stock	0.44	0.463	0.4375	0.4628	1254704000.0
2011-04-14	AMZN	Stock	9.0695	9.104	8.968	9.091	71764000.0
2011-04-14	TSLA	Stock	1.658	1.6853	1.6133	1.676	14751000.0
2011-04-14	TLT	Stock	91.54	91.77	91.22	91.43	7610371.0
2011-04-14	ES	Stock	33.74	33.83	33.57	33.77	2565500.0
2011-04-14	CL	Stock	40.72	41.075	40.63	40.92	6710000.0
2011-04-14	A	Stock	33.0973	33.4192	32.6252	33.3548	6499582.0
2011-04-14	AABA-DELISTED	Stock	16.55	16.82	16.4318	16.7	16077328.0
2011-04-14	AACC-DELISTED	Stock	5.18	5.29	5.18	5.29	7422.0
2011-04-14	AACG	Stock	7.93	8.0	7.91	7.92	53500.0
2011-04-14	AAI-DELISTED	Stock	7.36	7.38	7.33	7.35	7211244.0
2011-04-14	AAIC-DELISTED	Stock	28.61	29.3599	28.36	29.09	20021.0
2011-04-14	AAME	Stock	2.05	2.1	1.94	2.04	8500.0
2011-04-14	AAON	Stock	6.157	6.236	6.1432	6.1827	271856.0
2011-04-14	AAP	Stock	63.67	64.24	63.33	63.97	878100.0
2011-04-14	AAT	Stock	21.25	21.63	21.1	21.4	130100.0
2011-04-14	AATI-DELISTED	Stock	3.88	4.1	3.88	4.1	193996.0
2011-04-14	AAU-DELISTED	Stock	4.47	4.66	4.37	4.39	461142.0
2011-04-14	AAUAF-DELISTED	Stock	4.47	4.66	4.37	4.39	461342.0
2011-04-14	AAV-DELISTED	Stock	8.34	8.48	8.29	8.32	362214.0
2011-04-14	AAWW-DELISTED	Stock	62.85	64.53	62.38	64.32	215251.0
2011-04-14	AAXJ	Stock	63.69	64.17	63.69	64.17	176821.0
2011-04-14	AAXN-DELISTED	Stock	3.83	3.91	3.79	3.9	364746.0
2011-04-14	AB	Stock	21.19	21.81	21.11	21.71	455300.0
2011-04-14	ABAC-DELISTED	Stock	3.43	3.53	3.341	3.5	31032.0
2011-04-14	ABAX-DELISTED	Stock	28.4	29.29	28.4	29.29	117878.0
2011-04-14	ABB-DELISTED	Stock	24.15	24.24	24.05	24.2	1375023.0
2011-04-14	ABBC-DELISTED	Stock	12.01	12.1099	11.87	12.08	22512.0
2011-04-14	ABBNY-DELISTED	Stock	24.15	24.24	24.05	24.19	1379558.0
2011-04-14	ABC-DELISTED	Stock	39.48	39.74	39.15	39.66	2012727.0
2011-04-14	ABCB	Stock	9.64	9.78	9.56	9.78	25600.0
2011-04-14	ABCD-DELISTED	Stock	3.3	3.32	3.15	3.3	282934.0
2011-04-14	ABCO-DELISTED	Stock	24.25	24.41	24.2	24.27	83567.0
2011-04-14	ABCW-DELISTED	Stock	0.91	0.9101	0.88	0.91	10440.0
2011-04-14	ABD-DELISTED	Stock	9.23	9.44	9.23	9.43	374850.0
2011-04-14	ABE-DELISTED	Stock	18.7	18.824	18.66	18.82	8984.0
2011-04-14	ABEO	Stock	2625.0	2687.5	2562.5	2687.5	4.0
2011-04-14	ABFS-DELISTED	Stock	24.8	25.3	24.7	25.14	174753.0
2011-04-14	ABG	Stock	17.44	17.49	17.11	17.27	259700.0
2011-04-14	ABH-DELISTED	Stock	25.8	26.15	25.7	26.08	234515.0
2011-04-14	ABM	Stock	23.91	24.39	23.86	24.36	215000.0
2011-04-14	ABMD-DELISTED	Stock	15.62	15.62	14.06	15.12	3387007.0
2011-04-14	ABR	Stock	5.3	5.32	5.27	5.32	26100.0
2011-04-14	ABT	Stock	24.1963	24.5418	24.1243	24.4698	16117549.0
2011-04-14	ABTL-DELISTED	Stock	6.35	6.7	6.25	6.7	47439.0
2011-04-14	ABUS	Stock	3.1	3.1	2.95	2.97	21400.0
2011-04-14	ABV-DELISTED	Stock	28.88	29.84	28.8708	29.81	2227034.0
2011-04-14	ABVT-DELISTED	Stock	64.66	65.62	64.01	65.56	57362.0

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

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