PREVIEW / stock_daily / 2012-07-10

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-10.parquet
  size:    198 KB
  rows:    6,152
  symbols: 3,516

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-07-10	AAPL	Stock	22.0704	22.1382	21.6182	21.7218	511957600.0
2012-07-10	MSFT	Stock	30.08	30.22	29.51	29.74	37534100.0
2012-07-10	NVDA	Stock	0.327	0.3368	0.318	0.3205	512028000.0
2012-07-10	AMZN	Stock	11.3125	11.357	10.914	10.975	59642000.0
2012-07-10	META	Stock	32.43	32.48	31.16	31.47	14269500.0
2012-07-10	TSLA	Stock	2.1027	2.1653	2.0593	2.0847	11376000.0
2012-07-10	TLT	Stock	127.86	128.74	127.72	128.44	4288087.0
2012-07-10	ES	Stock	38.73	38.97	38.61	38.72	1591000.0
2012-07-10	CL	Stock	52.24	52.255	51.85	51.95	2585400.0
2012-07-10	A	Stock	27.3033	27.6037	26.5451	26.8169	3077837.0
2012-07-10	AABA-DELISTED	Stock	15.87	15.98	15.71	15.83	15756727.0
2012-07-10	AACC-DELISTED	Stock	7.14	7.3999	6.97	7.07	89772.0
2012-07-10	AACG	Stock	4.15	4.5	4.15	4.22	6700.0
2012-07-10	AAIC-DELISTED	Stock	22.46	22.46	22.15	22.25	37035.0
2012-07-10	AAME	Stock	2.78	2.78	2.78	2.78	200.0
2012-07-10	AAMRQ-DELISTED	Stock	0.487	0.5	0.4811	0.4811	1014156.0
2012-07-10	AAON	Stock	5.9852	6.003	5.84	5.8548	84038.0
2012-07-10	AAP	Stock	70.54	70.8	69.74	70.65	1622600.0
2012-07-10	AAT	Stock	25.11	25.2	24.81	24.95	71500.0
2012-07-10	AAU-DELISTED	Stock	2.03	2.03	1.96	1.98	79420.0
2012-07-10	AAUAF-DELISTED	Stock	2.03	2.03	1.96	1.99	79720.0
2012-07-10	AAV-DELISTED	Stock	3.32	3.38	3.19	3.21	215802.0
2012-07-10	AAWW-DELISTED	Stock	44.9	45.235	43.4	43.65	138366.0
2012-07-10	AAXJ	Stock	52.5	52.55	51.54	51.74	194377.0
2012-07-10	AAXN-DELISTED	Stock	5.35	5.39	5.15	5.16	159223.0
2012-07-10	AB	Stock	12.7	12.89	12.58	12.7	165200.0
2012-07-10	ABAC-DELISTED	Stock	1.16	1.23	1.12	1.12	17706.0
2012-07-10	ABAX-DELISTED	Stock	39.37	39.44	38.64	38.83	85521.0
2012-07-10	ABB-DELISTED	Stock	16.22	16.25	15.755	15.84	2721557.0
2012-07-10	ABBNY-DELISTED	Stock	16.22	16.25	15.755	15.82	3191445.0
2012-07-10	ABC-DELISTED	Stock	39.19	39.22	38.715	38.95	2237531.0
2012-07-10	ABCB	Stock	12.7	12.8	12.59	12.75	23000.0
2012-07-10	ABCD-DELISTED	Stock	1.07	1.12	0.96	0.98	65278.0
2012-07-10	ABCO-DELISTED	Stock	50.89	51.46	50.33	50.4	119444.0
2012-07-10	ABCW-DELISTED	Stock	0.46	0.46	0.4	0.4	76065.0
2012-07-10	ABE-DELISTED	Stock	19.01	19.01	18.8001	18.8101	1820.0
2012-07-10	ABEO	Stock	762.5	762.5	700.0	700.0	41.0
2012-07-10	ABFS-DELISTED	Stock	12.26	12.4024	11.47	11.65	507019.0
2012-07-10	ABG	Stock	25.54	25.79	25.15	25.3	216800.0
2012-07-10	ABM	Stock	18.73	18.86	18.07	18.41	665000.0
2012-07-10	ABMD-DELISTED	Stock	23.77	23.84	23.5	23.72	301492.0
2012-07-10	ABR	Stock	5.4	5.4	5.29	5.33	61300.0
2012-07-10	ABT	Stock	31.5181	31.8107	31.3885	31.5085	22907253.0
2012-07-10	ABTL-DELISTED	Stock	3.9054	3.9054	3.8446	3.8446	5341.0
2012-07-10	ABUS	Stock	2.15	2.19	2.15	2.15	2500.0
2012-07-10	ABV-DELISTED	Stock	37.68	37.84	37.07	37.27	1403328.0
2012-07-10	ABVA-DELISTED	Stock	4.38	4.41	4.36	4.37	1056.0
2012-07-10	ABX-DELISTED	Stock	36.84	37.05	35.37	35.62	7491360.0
2012-07-10	ACAD	Stock	1.89	1.94	1.83	1.84	246800.0
2012-07-10	ACAS-DELISTED	Stock	10.11	10.14	9.87	9.95	1352505.0

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

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