PREVIEW / stock_daily / 2012-03-16

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-16.parquet
  size:    201 KB
  rows:    6,181
  symbols: 3,554

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-03-16	AAPL	Stock	20.8829	21.0429	20.6429	20.9132	825487600.0
2012-03-16	MSFT	Stock	32.91	32.95	32.5	32.6	65626400.0
2012-03-16	NVDA	Stock	0.3648	0.3665	0.3628	0.365	428340000.0
2012-03-16	AMZN	Stock	9.164	9.284	9.1175	9.2525	98680000.0
2012-03-16	TSLA	Stock	2.3267	2.3927	2.322	2.3547	10939500.0
2012-03-16	TLT	Stock	110.5	111.44	110.2	111.43	13427701.0
2012-03-16	ES	Stock	36.52	36.67	36.3	36.43	2143200.0
2012-03-16	CL	Stock	47.74	47.83	47.28	47.395	6149200.0
2012-03-16	A	Stock	32.8541	32.9041	32.4392	32.6323	3186601.0
2012-03-16	AABA-DELISTED	Stock	14.94	15.18	14.92	15.17	27715977.0
2012-03-16	AACC-DELISTED	Stock	4.78	4.88	4.65	4.79	10160.0
2012-03-16	AACG	Stock	6.31	6.56	6.31	6.51	3500.0
2012-03-16	AAIC-DELISTED	Stock	24.25	24.31	23.99	24.01	47654.0
2012-03-16	AAME	Stock	2.98	2.98	2.88	2.97	6800.0
2012-03-16	AAMRQ-DELISTED	Stock	0.504	0.505	0.4905	0.491	1593695.0
2012-03-16	AAON	Stock	6.0	6.0533	5.9111	6.0059	320288.0
2012-03-16	AAP	Stock	89.44	89.5	87.57	88.05	819500.0
2012-03-16	AAT	Stock	22.66	22.69	22.43	22.48	369100.0
2012-03-16	AAU-DELISTED	Stock	2.55	2.58	2.51	2.535	132717.0
2012-03-16	AAUAF-DELISTED	Stock	2.54	2.57	2.51	2.54	133669.0
2012-03-16	AAV-DELISTED	Stock	3.6	3.86	3.6	3.81	690228.0
2012-03-16	AAWW-DELISTED	Stock	47.85	48.75	47.4	47.93	429364.0
2012-03-16	AAXJ	Stock	57.76	57.99	57.55	57.88	2541368.0
2012-03-16	AAXN-DELISTED	Stock	4.08	4.1	4.0	4.04	368628.0
2012-03-16	AB	Stock	14.97	15.1	14.86	15.0	218200.0
2012-03-16	ABAC-DELISTED	Stock	1.69	1.9	1.6899	1.75	46320.0
2012-03-16	ABAX-DELISTED	Stock	27.68	27.86	27.35	27.51	104562.0
2012-03-16	ABB-DELISTED	Stock	21.03	21.11	20.8	20.89	2220726.0
2012-03-16	ABBNY-DELISTED	Stock	21.03	21.11	20.8	20.88	2228046.0
2012-03-16	ABC-DELISTED	Stock	38.06	38.54	38.06	38.33	3014912.0
2012-03-16	ABCB	Stock	12.74	12.84	12.62	12.84	101500.0
2012-03-16	ABCD-DELISTED	Stock	2.98	2.98	2.78	2.78	46230.0
2012-03-16	ABCO-DELISTED	Stock	43.26	43.39	42.62	43.36	233372.0
2012-03-16	ABCW-DELISTED	Stock	0.5522	0.5522	0.4619	0.4619	67340.0
2012-03-16	ABD-DELISTED	Stock	13.005	13.025	12.685	12.705	838000.0
2012-03-16	ABE-DELISTED	Stock	19.3	19.41	19.23	19.4	8798.0
2012-03-16	ABEO	Stock	1362.5	1387.5	1350.0	1362.5	35.0
2012-03-16	ABFS-DELISTED	Stock	19.07	19.075	18.76	18.96	222430.0
2012-03-16	ABG	Stock	27.81	27.81	26.59	26.63	592800.0
2012-03-16	ABH-DELISTED	Stock	15.49	15.55	15.23	15.46	319829.0
2012-03-16	ABM	Stock	23.67	23.75	23.37	23.52	456900.0
2012-03-16	ABMD-DELISTED	Stock	22.0	22.7288	21.91	22.52	667076.0
2012-03-16	ABR	Stock	5.42	5.43	5.26	5.32	129600.0
2012-03-16	ABT	Stock	28.4425	28.6537	28.4234	28.5097	25447061.0
2012-03-16	ABTL-DELISTED	Stock	4.7786	5.02	4.7674	4.95	10996.0
2012-03-16	ABUS	Stock	2.22	2.24	2.15	2.22	38600.0
2012-03-16	ABV-DELISTED	Stock	41.12	41.25	40.76	40.87	2182326.0
2012-03-16	ABVA-DELISTED	Stock	4.1301	4.22	4.1301	4.15	7400.0
2012-03-16	ABVT-DELISTED	Stock	72.89	74.74	72.45	74.25	238179.0
2012-03-16	ABX-DELISTED	Stock	43.5	44.1	43.39	43.97	16656793.0

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

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