PREVIEW / stock_daily / 2012-05-07

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-07.parquet
  size:    197 KB
  rows:    6,178
  symbols: 3,542

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
2012-05-07	AAPL	Stock	20.0536	20.4561	20.0439	20.3386	460118400.0
2012-05-07	MSFT	Stock	30.7	30.86	30.57	30.65	48641400.0
2012-05-07	NVDA	Stock	0.312	0.3173	0.3093	0.3118	604440000.0
2012-05-07	AMZN	Stock	11.118	11.3435	11.1145	11.258	66286000.0
2012-05-07	TSLA	Stock	2.1307	2.172	2.1073	2.1647	17370000.0
2012-05-07	TLT	Stock	118.32	118.46	118.02	118.16	3228158.0
2012-05-07	ES	Stock	35.94	36.09	35.76	35.89	2037900.0
2012-05-07	CL	Stock	49.62	49.895	49.5	49.8	3400600.0
2012-05-07	A	Stock	29.0916	29.392	28.8054	29.2275	3658007.0
2012-05-07	AABA-DELISTED	Stock	15.35	15.49	15.1625	15.35	13440025.0
2012-05-07	AACC-DELISTED	Stock	5.49	5.68	5.41	5.58	70258.0
2012-05-07	AACG	Stock	6.75	6.75	6.2	6.58	3700.0
2012-05-07	AAIC-DELISTED	Stock	23.07	23.16	23.0	23.13	40216.0
2012-05-07	AAME	Stock	2.85	2.9	2.81	2.89	500.0
2012-05-07	AAMRQ-DELISTED	Stock	0.55	0.57	0.55	0.553	689675.0
2012-05-07	AAON	Stock	5.6919	5.7422	5.6593	5.6948	94500.0
2012-05-07	AAP	Stock	90.25	91.05	90.25	90.67	818000.0
2012-05-07	AAT	Stock	23.48	23.96	23.47	23.91	106000.0
2012-05-07	AAU-DELISTED	Stock	2.14	2.24	2.0903	2.11	248858.0
2012-05-07	AAUAF-DELISTED	Stock	2.16	2.26	2.11	2.11	246819.0
2012-05-07	AAV-DELISTED	Stock	3.19	3.24	3.16	3.24	117088.0
2012-05-07	AAWW-DELISTED	Stock	51.6	52.0	50.71	50.9	399913.0
2012-05-07	AAXJ	Stock	55.3	55.66	55.3	55.55	296043.0
2012-05-07	AAXN-DELISTED	Stock	4.74	4.86	4.67	4.82	410274.0
2012-05-07	AB	Stock	13.98	14.41	13.87	14.32	177000.0
2012-05-07	ABAC-DELISTED	Stock	1.63	1.78	1.63	1.76	5430.0
2012-05-07	ABAX-DELISTED	Stock	34.02	35.12	33.76	34.85	62767.0
2012-05-07	ABB-DELISTED	Stock	17.81	17.84	17.68	17.73	3149826.0
2012-05-07	ABBNY-DELISTED	Stock	17.81	17.84	17.68	17.73	3149941.0
2012-05-07	ABC-DELISTED	Stock	36.11	36.31	35.89	35.94	3590266.0
2012-05-07	ABCB	Stock	11.84	12.13	11.84	12.02	111000.0
2012-05-07	ABCD-DELISTED	Stock	2.03	2.22	2.03	2.13	16372.0
2012-05-07	ABCO-DELISTED	Stock	45.84	47.11	45.84	46.64	312106.0
2012-05-07	ABCW-DELISTED	Stock	0.743	0.743	0.743	0.743	3990.0
2012-05-07	ABE-DELISTED	Stock	19.18	19.47	19.18	19.414	1175.0
2012-05-07	ABEO	Stock	1062.5	1187.5	1062.5	1187.5	31.0
2012-05-07	ABFS-DELISTED	Stock	14.63	14.825	14.48	14.6	423206.0
2012-05-07	ABG	Stock	26.76	27.07	26.5	26.7	235000.0
2012-05-07	ABH-DELISTED	Stock	12.44	12.48	12.34	12.42	206330.0
2012-05-07	ABM	Stock	22.3	22.55	22.24	22.47	158000.0
2012-05-07	ABMD-DELISTED	Stock	23.06	23.75	22.98	23.5	500590.0
2012-05-07	ABR	Stock	5.87	6.28	5.87	6.25	306000.0
2012-05-07	ABT	Stock	29.6996	30.1027	29.6996	29.9923	19780742.0
2012-05-07	ABTL-DELISTED	Stock	4.2012	4.2012	3.9988	4.1	16819.0
2012-05-07	ABUS	Stock	2.35	2.35	2.32	2.32	1000.0
2012-05-07	ABV-DELISTED	Stock	40.96	41.84	40.93	41.78	2296200.0
2012-05-07	ABVA-DELISTED	Stock	4.55	4.55	4.53	4.53	22503.0
2012-05-07	ABVT-DELISTED	Stock	83.13	83.19	83.13	83.16	154658.0
2012-05-07	ABX-DELISTED	Stock	38.05	38.28	37.33	37.91	6723857.0
2012-05-07	ACAD	Stock	1.5	1.51	1.47	1.5	246700.0

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

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