PREVIEW / stock_daily / 2014-10-13

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-13.parquet
  size:    220 KB
  rows:    6,587
  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-10-13	AAPL	Stock	25.3325	25.445	24.9525	24.9525	214333600.0
2014-10-13	MSFT	Stock	43.82	44.56	43.49	43.65	37100200.0
2014-10-13	NVDA	Stock	0.424	0.4325	0.4192	0.4198	397628000.0
2014-10-13	AMZN	Stock	15.4935	15.66	15.1735	15.3225	87278000.0
2014-10-13	GOOGL	Stock	27.7565	28.0438	27.2215	27.2375	55130160.0
2014-10-13	META	Stock	73.23	74.78	72.52	72.99	43938000.0
2014-10-13	TSLA	Stock	15.9047	15.9307	14.7333	14.9727	169030500.0
2014-10-13	TLT	Stock	120.16	121.17	120.05	120.78	6452384.0
2014-10-13	ES	Stock	46.59	47.34	46.54	46.77	1372600.0
2014-10-13	CL	Stock	65.35	65.35	64.16	64.19	3706800.0
2014-10-13	A	Stock	38.4335	38.7911	37.7182	37.7611	3533165.0
2014-10-13	AA.B-DELISTED	Stock	47.34	48.11	46.68	46.68	51731.0
2014-10-13	AABA-DELISTED	Stock	39.52	40.07	38.29	38.38	37198761.0
2014-10-13	AAC-DELISTED	Stock	18.92	19.1	18.6401	19.0	51797.0
2014-10-13	AACG	Stock	4.31	4.32	4.31	4.31	700.0
2014-10-13	AAIC-DELISTED	Stock	25.51	25.78	25.42	25.47	293009.0
2014-10-13	AAL	Stock	31.07	31.39	28.1	28.58	34532900.0
2014-10-13	AAMC-DELISTED	Stock	194.9206	194.9206	176.4706	183.8235	60863.0
2014-10-13	AAME	Stock	3.99	3.99	3.84	3.84	2500.0
2014-10-13	AAMI	Stock	13.9	14.48	13.71	14.0	817700.0
2014-10-13	AAOI	Stock	13.15	13.51	12.12	12.13	287800.0
2014-10-13	AAON	Stock	11.34	11.7	11.2333	11.46	298350.0
2014-10-13	AAP	Stock	133.41	134.2	130.76	130.88	1283300.0
2014-10-13	AAT	Stock	34.52	35.02	34.32	34.38	162000.0
2014-10-13	AAU-DELISTED	Stock	1.32	1.32	1.27	1.31	39126.0
2014-10-13	AAUAF-DELISTED	Stock	1.32	1.32	1.27	1.31	39326.0
2014-10-13	AAV-DELISTED	Stock	4.36	4.465	4.33	4.38	292380.0
2014-10-13	AAVL-DELISTED	Stock	30.03	31.13	30.0	30.42	62380.0
2014-10-13	AAWW-DELISTED	Stock	31.88	32.34	31.33	31.45	123699.0
2014-10-13	AAXJ	Stock	60.57	61.0	60.27	60.27	627260.0
2014-10-13	AAXN-DELISTED	Stock	14.04	14.2	13.4	13.61	1794862.0
2014-10-13	AB	Stock	24.18	24.3	23.16	23.2	504300.0
2014-10-13	ABAC-DELISTED	Stock	2.0932	2.11	2.0101	2.05	46449.0
2014-10-13	ABAX-DELISTED	Stock	47.55	47.96	47.27	47.42	172742.0
2014-10-13	ABB-DELISTED	Stock	20.77	20.81	20.41	20.42	2375666.0
2014-10-13	ABBNY-DELISTED	Stock	20.77	20.81	20.41	20.41	2492405.0
2014-10-13	ABBV	Stock	54.88	55.15	53.58	53.62	16908200.0
2014-10-13	ABC-DELISTED	Stock	76.94	77.19	75.75	75.83	1297100.0
2014-10-13	ABCB	Stock	22.35	23.0	22.35	22.9	72300.0
2014-10-13	ABCD-DELISTED	Stock	1.55	1.55	1.46	1.53	1200.0
2014-10-13	ABCO-DELISTED	Stock	46.75	48.17	46.55	47.88	219223.0
2014-10-13	ABDC-DELISTED	Stock	12.73	12.85	12.6	12.63	17541.0
2014-10-13	ABE-DELISTED	Stock	13.71	13.956	13.71	13.82	9641.0
2014-10-13	ABEO	Stock	275.0	287.5	275.0	287.5	1.0
2014-10-13	ABEV	Stock	6.72	6.84	6.63	6.68	17807900.0
2014-10-13	ABG	Stock	65.4	65.4	61.32	62.04	1654600.0
2014-10-13	ABGB-DELISTED	Stock	20.33	20.33	19.5108	19.5108	13865.0
2014-10-13	ABM	Stock	25.22	25.49	25.09	25.11	246200.0
2014-10-13	ABMD-DELISTED	Stock	22.23	22.555	21.84	22.43	211903.0
2014-10-13	ABR	Stock	6.5	6.64	6.5	6.53	76400.0

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

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