PREVIEW / stock_daily / 2014-03-28

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-28.parquet
  size:    217 KB
  rows:    6,506
  symbols: 3,553

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-03-28	AAPL	Stock	19.2257	19.2479	19.0804	19.1736	200564000.0
2014-03-28	MSFT	Stock	39.79	40.64	39.68	40.3	43472700.0
2014-03-28	NVDA	Stock	0.444	0.4502	0.4428	0.4475	398820000.0
2014-03-28	AMZN	Stock	17.0025	17.35	16.804	16.9145	79736000.0
2014-03-28	META	Stock	61.34	61.95	59.34	60.01	67052000.0
2014-03-28	TSLA	Stock	14.1867	14.448	14.018	14.158	145272000.0
2014-03-28	TLT	Stock	109.86	109.892	109.02	109.37	6027026.0
2014-03-28	ES	Stock	44.93	45.08	44.74	44.95	1292300.0
2014-03-28	CL	Stock	64.04	64.6	63.72	64.1	2857600.0
2014-03-28	A	Stock	39.2346	39.5207	38.927	39.1202	2805646.0
2014-03-28	AABA-DELISTED	Stock	35.75	36.73	35.53	35.89	17273215.0
2014-03-28	AACG	Stock	4.0	4.03	4.0	4.03	10800.0
2014-03-28	AAIC-DELISTED	Stock	25.79	26.17	25.79	25.9	499497.0
2014-03-28	AAL	Stock	35.77	36.5	35.35	35.39	6792700.0
2014-03-28	AAMC-DELISTED	Stock	316.7647	324.2647	308.8206	308.8206	60653.0
2014-03-28	AAME	Stock	3.66	3.7	3.64	3.66	30500.0
2014-03-28	AAOI	Stock	25.0	25.35	24.06	24.96	274700.0
2014-03-28	AAON	Stock	12.3378	12.5733	12.1867	12.2044	122850.0
2014-03-28	AAP	Stock	124.61	124.9	123.51	124.65	656400.0
2014-03-28	AAT	Stock	33.1	33.67	33.09	33.6	133700.0
2014-03-28	AAU-DELISTED	Stock	1.32	1.38	1.32	1.37	48397.0
2014-03-28	AAUAF-DELISTED	Stock	1.32	1.37	1.32	1.37	49072.0
2014-03-28	AAV-DELISTED	Stock	4.7	4.9499	4.66	4.86	514615.0
2014-03-28	AAWW-DELISTED	Stock	34.19	34.76	33.84	34.37	164354.0
2014-03-28	AAXJ	Stock	58.6	59.24	58.38	58.89	246235.0
2014-03-28	AAXN-DELISTED	Stock	18.26	18.63	18.15	18.31	456778.0
2014-03-28	AB	Stock	25.22	25.99	25.0	25.26	301600.0
2014-03-28	ABAC-DELISTED	Stock	1.87	1.9	1.78	1.83	11353.0
2014-03-28	ABAX-DELISTED	Stock	37.89	38.93	37.245	37.88	164924.0
2014-03-28	ABB-DELISTED	Stock	25.49	25.66	25.45	25.57	1184800.0
2014-03-28	ABBNY-DELISTED	Stock	25.49	25.66	25.45	25.58	1227258.0
2014-03-28	ABBV	Stock	51.83	52.13	50.89	50.98	4208300.0
2014-03-28	ABC-DELISTED	Stock	64.25	65.03	64.2	64.81	1520371.0
2014-03-28	ABCB	Stock	23.35	23.75	23.03	23.1	91400.0
2014-03-28	ABCD-DELISTED	Stock	2.11	2.16	2.1	2.13	28229.0
2014-03-28	ABCO-DELISTED	Stock	62.83	63.998	62.08	63.07	277812.0
2014-03-28	ABE-DELISTED	Stock	13.14	13.17	13.08	13.11	4363.0
2014-03-28	ABEO	Stock	712.5	712.5	625.0	650.0	27.0
2014-03-28	ABEV	Stock	7.46	7.58	7.42	7.46	7968300.0
2014-03-28	ABFS-DELISTED	Stock	35.06	35.8	34.481	35.27	199183.0
2014-03-28	ABG	Stock	54.09	55.35	53.53	54.13	544000.0
2014-03-28	ABGB-DELISTED	Stock	22.72	23.18	22.6	23.18	52228.0
2014-03-28	ABM	Stock	28.25	28.43	28.03	28.14	268300.0
2014-03-28	ABMD-DELISTED	Stock	25.78	26.32	25.41	25.7	346852.0
2014-03-28	ABR	Stock	6.79	6.89	6.78	6.83	126700.0
2014-03-28	ABR.A-DELISTED	Stock	24.62	24.72	24.54	24.65	3800.0
2014-03-28	ABR.B-DELISTED	Stock	22.78	22.9	22.78	22.88	15335.0
2014-03-28	ABR.C-DELISTED	Stock	24.6	24.72	24.55	24.7	7340.0
2014-03-28	ABT	Stock	38.58	38.99	38.21	38.31	6251400.0
2014-03-28	ABTL-DELISTED	Stock	11.94	12.38	11.76	12.03	130726.0

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

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