PREVIEW / stock_daily / 2014-01-21

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-21.parquet
  size:    218 KB
  rows:    6,493
  symbols: 3,559

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
2014-01-21	AAPL	Stock	19.3211	19.6454	19.3007	19.6096	328526800.0
2014-01-21	MSFT	Stock	36.82	36.82	36.06	36.17	31567300.0
2014-01-21	NVDA	Stock	0.4003	0.4038	0.397	0.4013	246076000.0
2014-01-21	AMZN	Stock	20.15	20.39	20.08	20.3525	62442000.0
2014-01-21	META	Stock	56.6	58.58	56.5	58.51	48669200.0
2014-01-21	TSLA	Stock	11.416	11.8193	11.3873	11.7787	146020500.0
2014-01-21	TLT	Stock	105.45	105.7399	105.4	105.56	6435954.0
2014-01-21	ES	Stock	42.84	43.11	42.65	43.05	2437400.0
2014-01-21	CL	Stock	65.05	65.41	64.29	64.74	2828700.0
2014-01-21	A	Stock	43.412	43.5479	42.8183	43.5265	4205883.0
2014-01-21	AABA-DELISTED	Stock	39.98	40.05	38.86	39.52	20456537.0
2014-01-21	AACG	Stock	3.94	3.99	3.88	3.96	5500.0
2014-01-21	AAIC-DELISTED	Stock	26.46	26.69	26.2711	26.58	130408.0
2014-01-21	AAL	Stock	30.66	30.8	30.2	30.66	10612500.0
2014-01-21	AAMC-DELISTED	Stock	350.2485	351.4706	342.9412	346.4706	86037.0
2014-01-21	AAME	Stock	4.02	4.05	3.94	4.03	12300.0
2014-01-21	AAOI	Stock	14.35	14.48	14.1	14.15	14900.0
2014-01-21	AAON	Stock	14.4533	14.8844	14.3644	14.8578	264600.0
2014-01-21	AAP	Stock	119.73	120.31	117.96	118.0	821500.0
2014-01-21	AAT	Stock	31.81	32.2	31.59	32.15	80500.0
2014-01-21	AAU-DELISTED	Stock	1.54	1.585	1.475	1.54	226554.0
2014-01-21	AAUAF-DELISTED	Stock	1.54	1.59	1.48	1.53	227376.0
2014-01-21	AAV-DELISTED	Stock	4.29	4.37	4.27	4.32	62107.0
2014-01-21	AAWW-DELISTED	Stock	38.08	39.88	38.0401	39.33	849995.0
2014-01-21	AAXJ	Stock	58.45	58.61	57.83	58.03	621761.0
2014-01-21	AAXN-DELISTED	Stock	17.75	18.6	17.6	17.8	1344544.0
2014-01-21	AB	Stock	22.9	23.0	22.4	22.75	283200.0
2014-01-21	ABAC-DELISTED	Stock	2.01	2.14	2.01	2.05	114482.0
2014-01-21	ABAX-DELISTED	Stock	44.9	45.3	44.44	44.98	147895.0
2014-01-21	ABB-DELISTED	Stock	26.78	26.8	26.535	26.68	1416803.0
2014-01-21	ABBNY-DELISTED	Stock	26.78	26.8	26.535	26.68	1487796.0
2014-01-21	ABBV	Stock	50.26	50.92	49.91	50.0	5823000.0
2014-01-21	ABC-DELISTED	Stock	70.88	71.17	70.27	70.53	1203333.0
2014-01-21	ABCB	Stock	20.85	21.23	20.69	21.01	68700.0
2014-01-21	ABCD-DELISTED	Stock	2.01	2.15	1.9301	1.98	17644.0
2014-01-21	ABCO-DELISTED	Stock	62.06	62.45	61.29	62.2	122103.0
2014-01-21	ABE-DELISTED	Stock	13.2	13.2	13.05	13.11	9880.0
2014-01-21	ABEO	Stock	387.5	475.0	362.5	437.5	83.0
2014-01-21	ABEV	Stock	7.14	7.25	7.07	7.17	12422400.0
2014-01-21	ABFS-DELISTED	Stock	34.51	35.5299	34.4701	35.27	246485.0
2014-01-21	ABG	Stock	49.69	49.7	48.84	49.28	288300.0
2014-01-21	ABGB-DELISTED	Stock	17.241	17.241	16.53	16.62	7013.0
2014-01-21	ABM	Stock	27.9	28.19	27.78	27.97	152300.0
2014-01-21	ABMD-DELISTED	Stock	27.98	28.17	27.57	27.69	303422.0
2014-01-21	ABR	Stock	6.92	6.94	6.85	6.87	72100.0
2014-01-21	ABR.A-DELISTED	Stock	24.8301	24.99	24.8301	24.96	1300.0
2014-01-21	ABR.B-DELISTED	Stock	22.8436	22.92	22.8436	22.919	2200.0
2014-01-21	ABT	Stock	39.52	39.57	38.86	39.12	8229600.0
2014-01-21	ABTL-DELISTED	Stock	17.01	18.06	16.6	17.64	338758.0
2014-01-21	ABUS	Stock	12.91	12.92	12.05	12.44	258400.0

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

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