PREVIEW / stock_daily / 2014-02-21

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-21.parquet
  size:    218 KB
  rows:    6,491
  symbols: 3,540

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-21	AAPL	Stock	19.0282	19.0918	18.7357	18.7589	278784800.0
2014-02-21	MSFT	Stock	37.94	38.35	37.86	37.98	38021300.0
2014-02-21	NVDA	Stock	0.4688	0.4748	0.463	0.466	451052000.0
2014-02-21	AMZN	Stock	17.622	17.707	17.3375	17.338	84200000.0
2014-02-21	META	Stock	69.69	69.96	68.45	68.59	70932400.0
2014-02-21	TSLA	Stock	14.1093	14.2653	13.946	13.9733	117282000.0
2014-02-21	TLT	Stock	105.95	106.68	105.95	106.67	5250670.0
2014-02-21	ES	Stock	44.72	45.04	44.62	44.65	1739900.0
2014-02-21	CL	Stock	61.96	62.54	61.53	61.56	3166400.0
2014-02-21	A	Stock	40.9514	41.0587	40.2861	40.3004	3365266.0
2014-02-21	AABA-DELISTED	Stock	37.9	37.96	37.22	37.3	11601657.0
2014-02-21	AACG	Stock	3.95	3.95	3.93	3.93	3200.0
2014-02-21	AAIC-DELISTED	Stock	25.97	26.08	25.83	25.94	111995.0
2014-02-21	AAL	Stock	35.78	36.45	35.75	36.17	7820900.0
2014-02-21	AAMC-DELISTED	Stock	264.7059	279.1115	235.4736	253.65	218175.0
2014-02-21	AAME	Stock	3.94	3.97	3.94	3.95	3600.0
2014-02-21	AAOI	Stock	17.64	20.75	17.64	20.67	358800.0
2014-02-21	AAON	Stock	13.2089	13.2089	12.8622	13.0444	304425.0
2014-02-21	AAP	Stock	127.31	128.48	127.31	127.92	884100.0
2014-02-21	AAT	Stock	33.96	34.04	33.46	33.48	134600.0
2014-02-21	AAU-DELISTED	Stock	1.71	1.72	1.66	1.69	109474.0
2014-02-21	AAUAF-DELISTED	Stock	1.71	1.72	1.66	1.69	110836.0
2014-02-21	AAV-DELISTED	Stock	4.0	4.06	4.0	4.03	96430.0
2014-02-21	AAWW-DELISTED	Stock	32.79	32.79	31.84	32.07	1428649.0
2014-02-21	AAXJ	Stock	57.63	57.91	57.55	57.73	2959639.0
2014-02-21	AAXN-DELISTED	Stock	19.14	19.38	18.61	18.8	1461148.0
2014-02-21	AB	Stock	24.3	24.48	23.75	24.0	429600.0
2014-02-21	ABAC-DELISTED	Stock	1.73	1.73	1.6601	1.6999	2650.0
2014-02-21	ABAX-DELISTED	Stock	39.69	39.69	38.61	39.04	149591.0
2014-02-21	ABB-DELISTED	Stock	25.04	25.14	24.98	25.03	918009.0
2014-02-21	ABBNY-DELISTED	Stock	25.04	25.14	24.98	25.03	1174883.0
2014-02-21	ABBV	Stock	51.82	51.97	51.01	51.04	5842700.0
2014-02-21	ABC-DELISTED	Stock	68.42	69.15	68.16	68.41	1005987.0
2014-02-21	ABCB	Stock	20.34	20.47	20.15	20.2	101300.0
2014-02-21	ABCD-DELISTED	Stock	1.98	2.0	1.91	1.93	10350.0
2014-02-21	ABCO-DELISTED	Stock	64.48	65.54	63.9	64.73	232260.0
2014-02-21	ABE-DELISTED	Stock	12.39	12.58	12.39	12.48	11547.0
2014-02-21	ABEO	Stock	462.5	462.5	425.0	450.0	11.0
2014-02-21	ABEV	Stock	6.97	7.14	6.94	7.01	9182500.0
2014-02-21	ABFS-DELISTED	Stock	32.13	32.77	31.57	32.64	443817.0
2014-02-21	ABG	Stock	49.03	49.03	48.39	48.44	189400.0
2014-02-21	ABGB-DELISTED	Stock	20.87	20.95	20.7	20.78	20261.0
2014-02-21	ABIL-DELISTED	Stock	9.59	9.64	9.59	9.64	5177.0
2014-02-21	ABM	Stock	27.75	27.84	27.43	27.7	338500.0
2014-02-21	ABMD-DELISTED	Stock	28.73	28.894	28.05	28.72	326862.0
2014-02-21	ABR	Stock	6.97	7.02	6.82	6.82	105400.0
2014-02-21	ABR.A-DELISTED	Stock	24.22	24.28	24.12	24.28	16000.0
2014-02-21	ABR.B-DELISTED	Stock	22.74	23.0	22.74	22.9999	9500.0
2014-02-21	ABT	Stock	38.88	39.45	38.79	38.82	8335100.0
2014-02-21	ABTL-DELISTED	Stock	16.76	16.76	14.59	15.5	1013145.0

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

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