PREVIEW / stock_daily / 2012-05-04

all stock daily files

  file:    by_date/stock_daily/2012/2012-05-04.parquet
  size:    199 KB
  rows:    6,170
  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
2012-05-04	AAPL	Stock	20.61	20.6557	20.1846	20.1875	529992400.0
2012-05-04	MSFT	Stock	31.45	31.57	30.92	30.98	57927200.0
2012-05-04	NVDA	Stock	0.3138	0.3155	0.3065	0.3065	545092000.0
2012-05-04	AMZN	Stock	11.39	11.486	11.187	11.1995	91704000.0
2012-05-04	TSLA	Stock	2.1547	2.164	2.0933	2.122	18712500.0
2012-05-04	TLT	Stock	117.48	118.19	117.4	118.14	6367227.0
2012-05-04	ES	Stock	35.8	36.28	35.8	36.06	2809200.0
2012-05-04	CL	Stock	50.08	50.08	49.55	49.565	3420400.0
2012-05-04	A	Stock	30.1502	30.2504	29.299	29.3348	3070288.0
2012-05-04	AABA-DELISTED	Stock	15.28	15.29	15.09	15.14	13559689.0
2012-05-04	AACC-DELISTED	Stock	5.5	5.57	5.43	5.5	53229.0
2012-05-04	AAIC-DELISTED	Stock	23.18	23.27	23.05	23.1	58798.0
2012-05-04	AAME	Stock	2.82	2.89	2.78	2.89	1700.0
2012-05-04	AAMRQ-DELISTED	Stock	0.551	0.562	0.542	0.55	767058.0
2012-05-04	AAON	Stock	5.6948	5.7511	5.6237	5.7037	223763.0
2012-05-04	AAP	Stock	91.44	91.72	90.35	90.36	588600.0
2012-05-04	AAT	Stock	23.87	24.2	23.46	23.53	196700.0
2012-05-04	AAU-DELISTED	Stock	2.08	2.19	2.06	2.15	127042.0
2012-05-04	AAUAF-DELISTED	Stock	2.08	2.19	2.06	2.15	127642.0
2012-05-04	AAV-DELISTED	Stock	3.24	3.24	3.14	3.22	119848.0
2012-05-04	AAWW-DELISTED	Stock	52.6	52.8	51.6	51.98	485802.0
2012-05-04	AAXJ	Stock	55.99	56.01	55.461	55.54	118590.0
2012-05-04	AAXN-DELISTED	Stock	4.89	4.92	4.75	4.76	517169.0
2012-05-04	AB	Stock	14.04	14.17	13.64	14.08	196100.0
2012-05-04	ABAC-DELISTED	Stock	1.63	1.69	1.625	1.63	12560.0
2012-05-04	ABAX-DELISTED	Stock	34.62	34.62	34.01	34.08	72224.0
2012-05-04	ABB-DELISTED	Stock	17.89	17.96	17.64	17.7	2355927.0
2012-05-04	ABBNY-DELISTED	Stock	17.89	17.96	17.64	17.68	2357786.0
2012-05-04	ABC-DELISTED	Stock	36.54	36.62	36.145	36.18	2111375.0
2012-05-04	ABCB	Stock	12.08	12.11	11.77	11.91	59600.0
2012-05-04	ABCD-DELISTED	Stock	2.16	2.2	2.012	2.03	50993.0
2012-05-04	ABCO-DELISTED	Stock	48.27	48.27	46.89	46.96	325659.0
2012-05-04	ABCW-DELISTED	Stock	0.6627	0.753	0.6024	0.753	34360.0
2012-05-04	ABE-DELISTED	Stock	19.4	19.45	19.35	19.35	2157.0
2012-05-04	ABEO	Stock	1162.5	1225.0	1150.0	1187.5	18.0
2012-05-04	ABFS-DELISTED	Stock	15.31	15.41	14.65	14.68	367335.0
2012-05-04	ABG	Stock	27.51	27.9	26.76	26.83	521600.0
2012-05-04	ABH-DELISTED	Stock	12.46	12.59	12.35	12.42	347766.0
2012-05-04	ABM	Stock	22.48	22.48	22.27	22.4	242600.0
2012-05-04	ABMD-DELISTED	Stock	23.54	23.54	23.18	23.21	397461.0
2012-05-04	ABR	Stock	5.95	6.02	5.49	5.83	191000.0
2012-05-04	ABT	Stock	30.1602	30.1986	29.7716	29.9443	17540225.0
2012-05-04	ABTL-DELISTED	Stock	4.458	4.5604	3.9988	4.15	101096.0
2012-05-04	ABUS	Stock	2.48	2.48	2.29	2.39	800.0
2012-05-04	ABV-DELISTED	Stock	41.8	42.16	40.82	40.91	3747936.0
2012-05-04	ABVA-DELISTED	Stock	4.5	4.78	4.39	4.514	84197.0
2012-05-04	ABVT-DELISTED	Stock	83.13	83.22	83.12	83.14	271184.0
2012-05-04	ABX-DELISTED	Stock	37.96	38.5	37.84	37.89	7159199.0
2012-05-04	ACAD	Stock	1.54	1.55	1.49	1.5	874100.0
2012-05-04	ACAS-DELISTED	Stock	9.63	9.68	9.57	9.64	2581003.0

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

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