PREVIEW / stock_daily / 2014-02-18

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-18.parquet
  size:    219 KB
  rows:    6,523
  symbols: 3,571

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-18	AAPL	Stock	19.5	19.6854	19.4861	19.4996	260251600.0
2014-02-18	MSFT	Stock	37.63	37.78	37.41	37.42	32834000.0
2014-02-18	NVDA	Stock	0.448	0.4495	0.4438	0.4475	428988000.0
2014-02-18	AMZN	Stock	17.764	17.7865	17.4725	17.6825	99960000.0
2014-02-18	META	Stock	66.94	67.54	66.07	67.3	43809900.0
2014-02-18	TSLA	Stock	13.6827	13.7333	13.424	13.58	139992000.0
2014-02-18	TLT	Stock	106.66	107.2	106.62	106.82	4855814.0
2014-02-18	ES	Stock	45.08	45.31	44.85	44.91	1721100.0
2014-02-18	CL	Stock	62.86	62.86	62.0	62.39	2951100.0
2014-02-18	A	Stock	39.6137	40.0858	39.3133	39.4492	9161513.0
2014-02-18	AABA-DELISTED	Stock	38.31	38.59	38.09	38.3	11432880.0
2014-02-18	AACG	Stock	3.99	4.09	3.99	4.0	3400.0
2014-02-18	AAIC-DELISTED	Stock	25.62	26.076	25.62	25.89	156480.0
2014-02-18	AAL	Stock	34.73	34.95	34.2	34.31	7087200.0
2014-02-18	AAMC-DELISTED	Stock	294.1176	297.0588	291.7647	294.1176	40766.0
2014-02-18	AAME	Stock	3.94	3.97	3.93	3.95	26200.0
2014-02-18	AAOI	Stock	14.1	14.11	13.61	13.66	109100.0
2014-02-18	AAON	Stock	12.92	13.1467	12.7778	13.0711	263250.0
2014-02-18	AAP	Stock	127.18	128.32	126.09	126.79	1020300.0
2014-02-18	AAT	Stock	33.32	33.69	33.01	33.44	146600.0
2014-02-18	AAU-DELISTED	Stock	1.89	1.94	1.78	1.8	208954.0
2014-02-18	AAUAF-DELISTED	Stock	1.89	1.94	1.78	1.8	214174.0
2014-02-18	AAV-DELISTED	Stock	3.9	3.96	3.85	3.93	103875.0
2014-02-18	AAWW-DELISTED	Stock	32.9	33.13	32.24	32.32	196800.0
2014-02-18	AAXJ	Stock	57.65	57.8901	57.49	57.51	649620.0
2014-02-18	AAXN-DELISTED	Stock	17.11	18.48	17.01	18.07	1963620.0
2014-02-18	AB	Stock	24.05	25.0	23.94	24.8	801900.0
2014-02-18	ABAC-DELISTED	Stock	1.77	1.84	1.7	1.73	17000.0
2014-02-18	ABAX-DELISTED	Stock	38.7	39.18	38.62	38.98	143655.0
2014-02-18	ABB-DELISTED	Stock	25.15	25.34	25.1001	25.3	2160739.0
2014-02-18	ABBNY-DELISTED	Stock	25.15	25.34	25.1001	25.31	2284794.0
2014-02-18	ABBV	Stock	50.64	51.56	50.56	51.46	4984900.0
2014-02-18	ABC-DELISTED	Stock	68.06	68.96	67.99	68.5	1425883.0
2014-02-18	ABCB	Stock	20.14	20.63	20.09	20.34	61300.0
2014-02-18	ABCD-DELISTED	Stock	1.88	1.9188	1.7518	1.9	15547.0
2014-02-18	ABCO-DELISTED	Stock	61.54	63.09	61.38	62.79	491031.0
2014-02-18	ABE-DELISTED	Stock	12.4	12.56	12.4	12.5	22473.0
2014-02-18	ABEO	Stock	412.5	487.5	412.5	475.0	24.0
2014-02-18	ABEV	Stock	6.83	6.91	6.7	6.72	9122500.0
2014-02-18	ABFS-DELISTED	Stock	32.19	32.475	31.58	32.23	310820.0
2014-02-18	ABG	Stock	49.35	49.35	48.43	49.03	238000.0
2014-02-18	ABGB-DELISTED	Stock	20.38	20.38	20.06	20.0888	3995.0
2014-02-18	ABIL-DELISTED	Stock	9.61	9.64	9.55	9.55	1482.0
2014-02-18	ABM	Stock	27.4	27.69	27.1	27.6	207300.0
2014-02-18	ABMD-DELISTED	Stock	28.18	28.98	28.018	28.76	412410.0
2014-02-18	ABR	Stock	7.01	7.26	7.0	7.23	201700.0
2014-02-18	ABR.A-DELISTED	Stock	24.2	24.3	24.2	24.3	2000.0
2014-02-18	ABR.B-DELISTED	Stock	23.0	23.0	22.9801	23.0	7663.0
2014-02-18	ABT	Stock	38.96	39.19	38.8	38.93	6794100.0
2014-02-18	ABTL-DELISTED	Stock	18.41	18.41	17.5	17.84	260355.0

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

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