PREVIEW / stock_daily / 2014-02-07

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-07.parquet
  size:    217 KB
  rows:    6,474
  symbols: 3,533

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-02-07	AAPL	Stock	18.6207	18.6761	18.4779	18.56	370280400.0
2014-02-07	MSFT	Stock	36.32	36.59	36.01	36.56	33260500.0
2014-02-07	NVDA	Stock	0.392	0.3973	0.3885	0.3968	157248000.0
2014-02-07	AMZN	Stock	17.949	18.09	17.6245	18.054	86610000.0
2014-02-07	META	Stock	62.27	64.57	62.22	64.32	60704300.0
2014-02-07	TSLA	Stock	12.0673	12.442	11.9733	12.4353	133927500.0
2014-02-07	TLT	Stock	106.46	107.22	106.44	106.79	7092838.0
2014-02-07	ES	Stock	42.97	43.32	42.66	43.3	1796100.0
2014-02-07	CL	Stock	60.78	61.15	60.54	60.86	3651200.0
2014-02-07	A	Stock	41.8169	42.5393	41.5808	42.5036	2749586.0
2014-02-07	AABA-DELISTED	Stock	36.65	37.27	36.24	37.23	15453577.0
2014-02-07	AAIC-DELISTED	Stock	24.9	25.129	24.87	25.0	219503.0
2014-02-07	AAL	Stock	34.81	35.7	34.65	35.67	15404700.0
2014-02-07	AAMC-DELISTED	Stock	258.8324	286.7647	258.8324	282.6324	33534.0
2014-02-07	AAME	Stock	3.94	3.98	3.92	3.93	5500.0
2014-02-07	AAOI	Stock	12.9	13.07	12.38	13.07	49000.0
2014-02-07	AAON	Stock	12.4267	12.4844	12.16	12.3733	292275.0
2014-02-07	AAP	Stock	125.63	128.1	124.56	125.0	1687400.0
2014-02-07	AAT	Stock	31.97	32.13	31.73	32.03	170600.0
2014-02-07	AAU-DELISTED	Stock	1.43	1.54	1.4	1.52	173348.0
2014-02-07	AAUAF-DELISTED	Stock	1.43	1.53	1.4	1.52	175082.0
2014-02-07	AAV-DELISTED	Stock	3.84	3.98	3.84	3.97	220271.0
2014-02-07	AAWW-DELISTED	Stock	34.2	34.98	33.95	34.02	213777.0
2014-02-07	AAXJ	Stock	56.23	56.5	56.09	56.3	1099932.0
2014-02-07	AAXN-DELISTED	Stock	16.76	17.2	16.66	16.78	795620.0
2014-02-07	AB	Stock	21.94	22.24	21.8	22.1	307800.0
2014-02-07	ABAC-DELISTED	Stock	1.861	1.87	1.67	1.685	65158.0
2014-02-07	ABAX-DELISTED	Stock	36.94	37.5	36.74	37.0	194214.0
2014-02-07	ABB-DELISTED	Stock	25.16	25.37	25.11	25.35	1720720.0
2014-02-07	ABBNY-DELISTED	Stock	25.17	25.37	25.11	25.35	1828973.0
2014-02-07	ABBV	Stock	48.0	49.03	47.66	48.89	6979500.0
2014-02-07	ABC-DELISTED	Stock	65.88	66.59	65.7	66.56	1416216.0
2014-02-07	ABCB	Stock	20.15	20.24	19.87	20.0	121600.0
2014-02-07	ABCD-DELISTED	Stock	1.79	1.8	1.73	1.79	9277.0
2014-02-07	ABCO-DELISTED	Stock	58.05	60.0	54.79	58.55	1193420.0
2014-02-07	ABE-DELISTED	Stock	12.58	12.67	12.4	12.45	87480.0
2014-02-07	ABEO	Stock	412.5	437.5	375.0	412.5	29.0
2014-02-07	ABEV	Stock	6.78	6.87	6.66	6.8	20504100.0
2014-02-07	ABFS-DELISTED	Stock	31.23	31.54	30.3	30.96	339405.0
2014-02-07	ABG	Stock	50.3	51.28	50.06	50.13	193800.0
2014-02-07	ABGB-DELISTED	Stock	19.64	19.95	19.58	19.95	5038.0
2014-02-07	ABIL-DELISTED	Stock	9.55	9.8	9.53	9.78	2801.0
2014-02-07	ABM	Stock	26.29	26.54	26.29	26.5	140900.0
2014-02-07	ABMD-DELISTED	Stock	26.56	27.21	26.41	27.09	256144.0
2014-02-07	ABR	Stock	6.95	6.97	6.91	6.95	58400.0
2014-02-07	ABR.A-DELISTED	Stock	25.1399	25.1399	25.03	25.03	500.0
2014-02-07	ABR.B-DELISTED	Stock	23.4999	23.5	23.4999	23.5	2640.0
2014-02-07	ABT	Stock	36.77	37.21	36.65	37.18	12028000.0
2014-02-07	ABTL-DELISTED	Stock	14.02	15.0	14.02	14.78	168807.0
2014-02-07	ABUS	Stock	14.47	14.71	13.66	14.64	171800.0

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

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