PREVIEW / stock_daily / 2014-04-08

all stock daily files

  file:    by_date/stock_daily/2014/2014-04-08.parquet
  size:    219 KB
  rows:    6,530
  symbols: 3,557

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-04-08	AAPL	Stock	18.7568	18.79	18.525	18.6943	243888400.0
2014-04-08	MSFT	Stock	39.75	39.93	39.2	39.82	35918600.0
2014-04-08	NVDA	Stock	0.4552	0.4728	0.4545	0.4715	470692000.0
2014-04-08	AMZN	Stock	16.094	16.4	15.922	16.3535	131552000.0
2014-04-08	GOOGL	Stock	27.2525	27.994	27.235	27.8755	69775360.0
2014-04-08	META	Stock	57.68	58.71	57.17	58.19	78836000.0
2014-04-08	TSLA	Stock	14.0033	14.4327	13.7613	14.364	103339500.0
2014-04-08	TLT	Stock	109.03	109.47	108.72	109.37	4213806.0
2014-04-08	ES	Stock	44.99	45.63	44.7	45.52	1642800.0
2014-04-08	CL	Stock	64.84	65.67	64.74	65.63	4400900.0
2014-04-08	A	Stock	38.7768	39.3419	38.4979	39.0987	2575815.0
2014-04-08	AABA-DELISTED	Stock	33.1	34.43	33.02	33.83	33895544.0
2014-04-08	AACG	Stock	4.05	4.1	4.03	4.09	14600.0
2014-04-08	AAIC-DELISTED	Stock	25.58	25.8085	25.5	25.68	177012.0
2014-04-08	AAL	Stock	36.0	36.22	33.62	35.98	17409200.0
2014-04-08	AAMC-DELISTED	Stock	310.7059	314.1088	304.4118	308.5265	59106.0
2014-04-08	AAME	Stock	3.61	3.66	3.58	3.59	18800.0
2014-04-08	AAOI	Stock	20.07	22.14	20.0	21.99	396900.0
2014-04-08	AAON	Stock	11.4933	11.7867	11.4089	11.6133	183825.0
2014-04-08	AAP	Stock	118.07	119.46	117.39	119.16	700200.0
2014-04-08	AAT	Stock	33.69	33.77	33.45	33.64	158600.0
2014-04-08	AAU-DELISTED	Stock	1.43	1.5	1.42	1.5	105618.0
2014-04-08	AAUAF-DELISTED	Stock	1.43	1.5	1.42	1.5	106787.0
2014-04-08	AAV-DELISTED	Stock	5.13	5.19	5.11	5.13	297340.0
2014-04-08	AAWW-DELISTED	Stock	34.9	35.6	34.76	34.85	201297.0
2014-04-08	AAXJ	Stock	60.34	60.7	60.27	60.42	301431.0
2014-04-08	AAXN-DELISTED	Stock	17.0	17.28	16.6268	17.04	795176.0
2014-04-08	AB	Stock	25.12	25.3	24.89	25.12	526900.0
2014-04-08	ABAC-DELISTED	Stock	1.8	1.82	1.8	1.8	15364.0
2014-04-08	ABAX-DELISTED	Stock	39.58	40.74	38.92	40.61	142372.0
2014-04-08	ABB-DELISTED	Stock	25.8	25.96	25.69	25.9	1873282.0
2014-04-08	ABBNY-DELISTED	Stock	25.8	25.96	25.69	25.91	1933738.0
2014-04-08	ABBV	Stock	50.35	50.87	48.93	49.1	8246900.0
2014-04-08	ABC-DELISTED	Stock	64.14	64.48	63.4	64.18	1717481.0
2014-04-08	ABCB	Stock	23.04	23.68	23.0	23.11	56200.0
2014-04-08	ABCD-DELISTED	Stock	2.1899	2.2	2.11	2.19	64740.0
2014-04-08	ABCO-DELISTED	Stock	60.5	61.92	59.94	61.48	116453.0
2014-04-08	ABE-DELISTED	Stock	13.35	13.5	13.35	13.46	11335.0
2014-04-08	ABEO	Stock	612.5	637.5	587.5	625.0	26.0
2014-04-08	ABEV	Stock	7.6	7.63	7.5	7.56	16607500.0
2014-04-08	ABFS-DELISTED	Stock	35.5	36.16	35.285	35.87	177051.0
2014-04-08	ABG	Stock	55.27	56.5	55.27	55.58	280700.0
2014-04-08	ABGB-DELISTED	Stock	23.82	24.769	23.43	24.7576	11853.0
2014-04-08	ABIL-DELISTED	Stock	9.65	9.65	9.64	9.64	525.0
2014-04-08	ABM	Stock	28.16	28.8	28.07	28.57	170400.0
2014-04-08	ABMD-DELISTED	Stock	24.7	24.7	23.56	23.8	451846.0
2014-04-08	ABR	Stock	7.26	7.28	7.03	7.04	119800.0
2014-04-08	ABR.A-DELISTED	Stock	24.989	24.989	24.76	24.9	7799.0
2014-04-08	ABR.B-DELISTED	Stock	22.99	23.0	22.99	23.0	9935.0
2014-04-08	ABR.C-DELISTED	Stock	24.85	24.9	24.844	24.85	10550.0

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

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